[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: scheduler: show the number of total packages now scheduled in , instead of only new ones

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit 63fd28b70c169d9008ce303794d784659bdcf19f
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Sun Mar 8 00:33:19 2015 +0100

    reproducible: scheduler: show the number of total packages now scheduled in , instead of only new ones
---
 bin/reproducible_scheduler.py | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/bin/reproducible_scheduler.py b/bin/reproducible_scheduler.py
index dbebb7a..024a32f 100755
--- a/bin/reproducible_scheduler.py
+++ b/bin/reproducible_scheduler.py
@@ -257,13 +257,17 @@ def scheduler():
         all_scheduled_pkgs.extend(untested[suite])
         all_scheduled_pkgs.extend(new[suite])
         all_scheduled_pkgs.extend(old[suite])
+        query = 'SELECT count(*) ' + \
+                'FROM schedule AS p JOIN sources AS s ON p.package_id=s.id ' + \
+                'WHERE s.suite="{suite}"'.format(suite=suite)
+        now_queued_here = int(query_db(query)[0][0]) + len(all_scheduled_pkgs)
         # build the final message text
         message = 'Scheduled in ' + suite + ': ' + \
                   str(len(untested[suite])) + ' untested packages, ' + \
                   str(len(new[suite])) + ' packages with new versions and ' + \
                   str(len(old[suite])) + ' with the same version ' + \
                   '(total: ' + str(total) + ' of which ' + \
-                  str(len(all_scheduled_pkgs)) + ' in ' + suite + ')'
+                  str(now_queued_here) + ' in ' + suite + ')'
         kgb = ['kgb-client', '--conf', '/srv/jenkins/kgb/debian-reproducible.conf',
            '--relay-msg']
         kgb.extend(message.split())

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git