summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMattia Rizzolo <mattia@mapreri.org>2015-08-07 12:52:06 +0000
committerHolger Levsen <holger@layer-acht.org>2015-08-07 15:12:23 +0200
commit899e0a04ff3753c20280e6f3fa1b6b010c619f22 (patch)
treee16e897e2d6fa0e0e967df982dbc9c0dd5de0d02
parentf0aefc2e672eb702096947ab844f51c0b29ac8ee (diff)
downloadjenkins.debian.net-899e0a04ff3753c20280e6f3fa1b6b010c619f22.tar.xz
reproducible: _html_indexes: add depwait packages to the last24h and last48h pages
-rwxr-xr-xbin/reproducible_html_indexes.py20
1 files changed, 20 insertions, 0 deletions
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',
@@ -222,6 +224,15 @@ pages = {
'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',
'query': 'reproducible_last24h',
@@ -254,6 +265,15 @@ pages = {
'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',
'query': 'reproducible_last48h',