reproducible Debian: correctly count reproducible packages in the last 24+48h

Signed-off-by: Holger Levsen <holger@layer-acht.org>

1 files changed, 12 insertions, 2 deletions

diff --git a/bin/reproducible_html_indexes.py b/bin/reproducible_html_indexes.py
index ea586780..f3fcafac 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(