summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2016-12-01 17:12:03 +0100
committerHolger Levsen <holger@layer-acht.org>2016-12-01 17:12:03 +0100
commit30a59f686d4962b7937da5d48e2295e299ccca9a (patch)
tree933850adc8a2b42877c391f4b7fc6ac9e77d90e9
parentf05eaf4b777119cde7c9cdc2bbbfe7f9be1974ae (diff)
downloadjenkins.debian.net-30a59f686d4962b7937da5d48e2295e299ccca9a.tar.xz
reproducible Debian: correctly count reproducible packages in the last 24+48h
Signed-off-by: Holger Levsen <holger@layer-acht.org>
-rwxr-xr-xbin/reproducible_html_indexes.py14
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(