From 899e0a04ff3753c20280e6f3fa1b6b010c619f22 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Fri, 7 Aug 2015 12:52:06 +0000 Subject: reproducible: _html_indexes: add depwait packages to the last24h and last48h pages --- bin/reproducible_html_indexes.py | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'bin') diff --git a/bin/reproducible_html_indexes.py b/bin/reproducible_html_indexes.py index 7c61a801..0f665ce4 100755 --- a/bin/reproducible_html_indexes.py +++ b/bin/reproducible_html_indexes.py @@ -68,6 +68,8 @@ queries = { '404_all_abc': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "404" ORDER BY name', 'depwait_all': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "depwait" ORDER BY build_date DESC', 'depwait_all_abc': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "depwait" ORDER BY name', + 'depwait_last24h': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "depwait" AND build_date > datetime("now", "-24 hours") ORDER BY name', + 'depwait_last48h': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "depwait" AND build_date > datetime("now", "-48 hours") ORDER BY name', 'not_for_us_all': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "not for us" ORDER BY build_date DESC', 'not_for_us_all_abc': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "not for us" ORDER BY name', 'blacklisted_all': 'SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND status = "blacklisted" ORDER BY name', @@ -221,6 +223,15 @@ pages = { 'failed to build from source in total, $tot of them in the last 24h in $suite/$arch:'), 'timely': True }, + { + 'icon_status': 'depwait', + 'icon_link': '/index_depwait.html', + 'query': 'depwait_last24h', + 'query2': 'depwait_all', + 'text': Template('$count packages ($percent% of ${count_total}) ' + + 'failed to satisfy their build-dependencies, $tot of them in the last 24h in $suite/$arch:'), + 'timely': True + }, { 'icon_status': 'reproducible', 'icon_link': '/index_reproducible.html', @@ -253,6 +264,15 @@ pages = { 'failed to build from source in total, $tot of them in the last 48h in $suite/$arch:'), 'timely': True }, + { + 'icon_status': 'depwait', + 'icon_link': '/index_depwait.html', + 'query': 'depwait_last48h', + 'query2': 'depwait_all', + 'text': Template('$count packages ($percent% of ${count_total}) ' + + 'failed to satisfy their build-dependencies, $tot of them in the last 48h in $suite/$arch:'), + 'timely': True + }, { 'icon_status': 'reproducible', 'icon_link': '/index_reproducible.html', -- cgit v1.2.3-54-g00ecf