From 30a59f686d4962b7937da5d48e2295e299ccca9a Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Thu, 1 Dec 2016 17:12:03 +0100 Subject: reproducible Debian: correctly count reproducible packages in the last 24+48h Signed-off-by: Holger Levsen --- 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 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( -- cgit v1.2.3-70-g09d2