[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: _html_indexes: add depwait packages to the last24h and last48h pages

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit 899e0a04ff3753c20280e6f3fa1b6b010c619f22
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Fri Aug 7 12:52:06 2015 +0000

    reproducible: _html_indexes: add depwait packages to the last24h and last48h pages
---
 bin/reproducible_html_indexes.py | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

diff --git a/bin/reproducible_html_indexes.py b/bin/reproducible_html_indexes.py
index 7c61a80..0f665ce 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',

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git