[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible Debian: correctly count reproducible packages in the last 24+48h

[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 30a59f686d4962b7937da5d48e2295e299ccca9a
Author: Holger Levsen <holger at layer-acht.org>
Date:   Thu Dec 1 17:12:03 2016 +0100

    reproducible Debian: correctly count reproducible packages in the last 24+48h
    
    Signed-off-by: Holger Levsen <holger at layer-acht.org>
---
 bin/reproducible_html_indexes.py | 14 ++++++++++++--
 1 file changed, 12 insertions(+), 2 deletions(-)

diff --git a/bin/reproducible_html_indexes.py b/bin/reproducible_html_indexes.py
index ea58678..f3fcafa 100755
--- a/bin/reproducible_html_indexes.py
+++ b/bin/reproducible_html_indexes.py
@@ -105,11 +105,21 @@ queries = {
         ),
     "reproducible_last24h":
         select_sources.where(
-            results.c.build_date > timespan_date_map[24]
+            and_(
+                results.c.status == 'reproducible',
+                results.c.build_date > timespan_date_map[24],
+            )
+        ).order_by(
+            desc(results.c.build_date)
         ),
     "reproducible_last48h":
         select_sources.where(
-            results.c.build_date > timespan_date_map[48],
+            and_(
+                results.c.status == 'reproducible',
+                results.c.build_date > timespan_date_map[48],
+            )
+        ).order_by(
+            desc(results.c.build_date)
         ),
     "reproducible_all_abc":
         select_sources.where(

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