diff options
-rwxr-xr-x | bin/reproducible_html_indexes.py | 14 |
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( |