summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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(