Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package perl-Minion-Backend-SQLite for 
openSUSE:Factory checked in at 2021-11-20 02:38:42
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/perl-Minion-Backend-SQLite (Old)
 and      /work/SRC/openSUSE:Factory/.perl-Minion-Backend-SQLite.new.1895 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Package is "perl-Minion-Backend-SQLite"

Sat Nov 20 02:38:42 2021 rev:11 rq:931792 version:5.0.6

Changes:
--------
--- 
/work/SRC/openSUSE:Factory/perl-Minion-Backend-SQLite/perl-Minion-Backend-SQLite.changes
    2021-06-19 23:05:05.955861853 +0200
+++ 
/work/SRC/openSUSE:Factory/.perl-Minion-Backend-SQLite.new.1895/perl-Minion-Backend-SQLite.changes
  2021-11-20 02:39:43.476664448 +0100
@@ -1,0 +2,9 @@
+Sat Nov 13 03:06:09 UTC 2021 - Tina M??ller <timueller+p...@suse.de>
+
+- updated to 5.0.6
+   see /usr/share/doc/packages/perl-Minion-Backend-SQLite/Changes
+
+  v5.0.6    2021-11-12 19:39:19 EST
+    - Improve efficiency of stats query (#19, Sebastian Riedel)
+
+-------------------------------------------------------------------

Old:
----
  Minion-Backend-SQLite-v5.0.5.tar.gz

New:
----
  Minion-Backend-SQLite-v5.0.6.tar.gz

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Other differences:
------------------
++++++ perl-Minion-Backend-SQLite.spec ++++++
--- /var/tmp/diff_new_pack.iPjwV4/_old  2021-11-20 02:39:43.912663009 +0100
+++ /var/tmp/diff_new_pack.iPjwV4/_new  2021-11-20 02:39:43.912663009 +0100
@@ -18,7 +18,7 @@
 
 %define cpan_name Minion-Backend-SQLite
 Name:           perl-Minion-Backend-SQLite
-Version:        5.0.5
+Version:        5.0.6
 Release:        0
 Summary:        SQLite backend for Minion job queue
 License:        Artistic-2.0

++++++ Minion-Backend-SQLite-v5.0.5.tar.gz -> 
Minion-Backend-SQLite-v5.0.6.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Minion-Backend-SQLite-v5.0.5/Build.PL 
new/Minion-Backend-SQLite-v5.0.6/Build.PL
--- old/Minion-Backend-SQLite-v5.0.5/Build.PL   2021-06-16 03:18:44.000000000 
+0200
+++ new/Minion-Backend-SQLite-v5.0.6/Build.PL   2021-11-13 01:39:21.000000000 
+0100
@@ -68,7 +68,7 @@
     }
 
 
-    # This section was automatically generated by 
Dist::Zilla::Plugin::ModuleBuild v6.017.
+    # This section was automatically generated by 
Dist::Zilla::Plugin::ModuleBuild v6.022.
     use strict;
     use warnings;
 
@@ -84,7 +84,7 @@
         "Dan Book <dbook\@cpan.org>"
       ],
       "dist_name" => "Minion-Backend-SQLite",
-      "dist_version" => "v5.0.5",
+      "dist_version" => "v5.0.6",
       "license" => "artistic_2",
       "module_name" => "Minion::Backend::SQLite",
       "recursive_test_files" => 1,
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Minion-Backend-SQLite-v5.0.5/Changes 
new/Minion-Backend-SQLite-v5.0.6/Changes
--- old/Minion-Backend-SQLite-v5.0.5/Changes    2021-06-16 03:18:44.000000000 
+0200
+++ new/Minion-Backend-SQLite-v5.0.6/Changes    2021-11-13 01:39:21.000000000 
+0100
@@ -1,3 +1,6 @@
+v5.0.6    2021-11-12 19:39:19 EST
+  - Improve efficiency of stats query (#19, Sebastian Riedel)
+
 v5.0.5    2021-06-15 21:18:41 EDT
   - Support min_priority option in dequeue method.
   - Update IRC metadata to libera.chat
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Minion-Backend-SQLite-v5.0.5/MANIFEST 
new/Minion-Backend-SQLite-v5.0.6/MANIFEST
--- old/Minion-Backend-SQLite-v5.0.5/MANIFEST   2021-06-16 03:18:44.000000000 
+0200
+++ new/Minion-Backend-SQLite-v5.0.6/MANIFEST   2021-11-13 01:39:21.000000000 
+0100
@@ -1,4 +1,4 @@
-# This file was automatically generated by Dist::Zilla::Plugin::Manifest 
v6.017.
+# This file was automatically generated by Dist::Zilla::Plugin::Manifest 
v6.022.
 Build.PL
 CONTRIBUTING.md
 Changes
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Minion-Backend-SQLite-v5.0.5/META.json 
new/Minion-Backend-SQLite-v5.0.6/META.json
--- old/Minion-Backend-SQLite-v5.0.5/META.json  2021-06-16 03:18:44.000000000 
+0200
+++ new/Minion-Backend-SQLite-v5.0.6/META.json  2021-11-13 01:39:21.000000000 
+0100
@@ -4,7 +4,7 @@
       "Dan Book <db...@cpan.org>"
    ],
    "dynamic_config" : 0,
-   "generated_by" : "Dist::Zilla version 6.017, CPAN::Meta::Converter version 
2.150010",
+   "generated_by" : "Dist::Zilla version 6.022, CPAN::Meta::Converter version 
2.150010",
    "license" : [
       "artistic_2"
    ],
@@ -64,7 +64,7 @@
    "provides" : {
       "Minion::Backend::SQLite" : {
          "file" : "lib/Minion/Backend/SQLite.pm",
-         "version" : "v5.0.5"
+         "version" : "v5.0.6"
       }
    },
    "release_status" : "stable",
@@ -80,9 +80,10 @@
       },
       "x_IRC" : "ircs://irc.libera.chat/#mojo"
    },
-   "version" : "v5.0.5",
+   "version" : "v5.0.6",
    "x_contributors" : [
       "Dan Book <gri...@grinnz.com>",
+      "Sebastian Riedel <s...@kraih.com>",
       "Stefan Adams <s1037...@gmail.com>",
       "yrjustice <43676784+yrjust...@users.noreply.github.com>"
    ],
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/Minion-Backend-SQLite-v5.0.5/META.yml 
new/Minion-Backend-SQLite-v5.0.6/META.yml
--- old/Minion-Backend-SQLite-v5.0.5/META.yml   2021-06-16 03:18:44.000000000 
+0200
+++ new/Minion-Backend-SQLite-v5.0.6/META.yml   2021-11-13 01:39:21.000000000 
+0100
@@ -9,7 +9,7 @@
 configure_requires:
   Module::Build::Tiny: '0.034'
 dynamic_config: 0
-generated_by: 'Dist::Zilla version 6.017, CPAN::Meta::Converter version 
2.150010'
+generated_by: 'Dist::Zilla version 6.022, CPAN::Meta::Converter version 
2.150010'
 license: artistic_2
 meta-spec:
   url: http://module-build.sourceforge.net/META-spec-v1.4.html
@@ -26,7 +26,7 @@
 provides:
   Minion::Backend::SQLite:
     file: lib/Minion/Backend/SQLite.pm
-    version: v5.0.5
+    version: v5.0.6
 requires:
   List::Util: '0'
   Minion: '10.13'
@@ -40,9 +40,10 @@
   bugtracker: https://github.com/Grinnz/Minion-Backend-SQLite/issues
   homepage: https://github.com/Grinnz/Minion-Backend-SQLite
   repository: https://github.com/Grinnz/Minion-Backend-SQLite.git
-version: v5.0.5
+version: v5.0.6
 x_contributors:
   - 'Dan Book <gri...@grinnz.com>'
+  - 'Sebastian Riedel <s...@kraih.com>'
   - 'Stefan Adams <s1037...@gmail.com>'
   - 'yrjustice <43676784+yrjust...@users.noreply.github.com>'
 x_generated_by_perl: v5.34.0
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' 
old/Minion-Backend-SQLite-v5.0.5/lib/Minion/Backend/SQLite.pm 
new/Minion-Backend-SQLite-v5.0.6/lib/Minion/Backend/SQLite.pm
--- old/Minion-Backend-SQLite-v5.0.5/lib/Minion/Backend/SQLite.pm       
2021-06-16 03:18:44.000000000 +0200
+++ new/Minion-Backend-SQLite-v5.0.6/lib/Minion/Backend/SQLite.pm       
2021-11-13 01:39:21.000000000 +0100
@@ -8,7 +8,7 @@
 use Sys::Hostname 'hostname';
 use Time::HiRes 'usleep';
 
-our $VERSION = 'v5.0.5';
+our $VERSION = 'v5.0.6';
 
 has dequeue_interval => 0.5;
 has 'sqlite';
@@ -361,21 +361,18 @@
   my $self = shift;
 
   my $stats = $self->sqlite->db->query(
-    q{select count(case when state = 'inactive' and (expires is null or 
expires > datetime('now'))
-        then 1 end) as inactive_jobs,
-      count(case state when 'active' then 1 end) as active_jobs,
-      count(case state when 'failed' then 1 end) as failed_jobs,
-      count(case state when 'finished' then 1 end) as finished_jobs,
-      count(case when state = 'inactive' and delayed > datetime('now')
-        then 1 end) as delayed_jobs,
-      (select count(*) from minion_locks where expires > datetime('now'))
-        as active_locks,
-      count(distinct case when state = 'active' then worker end)
-        as active_workers,
-      ifnull((select seq from sqlite_sequence where name = 'minion_jobs'), 0)
-        as enqueued_jobs,
-      (select count(*) from minion_workers) as inactive_workers, null as uptime
-      from minion_jobs}
+    q{select
+      (select count(*) from minion_jobs where state = 'inactive' and (expires 
is null or expires > datetime('now')))
+        as inactive_jobs,
+      (select count(*) from minion_jobs where state = 'active') as active_jobs,
+      (select count(*) from minion_jobs where state = 'failed') as failed_jobs,
+      (select count(*) from minion_jobs where state = 'finished') as 
finished_jobs,
+      (select count(*) from minion_jobs where state = 'inactive' and delayed > 
datetime('now')) as delayed_jobs,
+      (select count(*) from minion_locks where expires > datetime('now')) as 
active_locks,
+      (select count(distinct(worker)) from minion_jobs where state = 'active') 
as active_workers,
+      ifnull((select seq from sqlite_sequence where name = 'minion_jobs'), 0) 
as enqueued_jobs,
+      (select count(*) from minion_workers) as inactive_workers,
+      null as uptime}
   )->hash;
   $stats->{inactive_workers} -= $stats->{active_workers};
 

Reply via email to