summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
Diffstat (limited to 'bin')
-rwxr-xr-xbin/reproducible_html_indexes.py37
1 files changed, 36 insertions, 1 deletions
diff --git a/bin/reproducible_html_indexes.py b/bin/reproducible_html_indexes.py
index 8d509125..d86a26bb 100755
--- a/bin/reproducible_html_indexes.py
+++ b/bin/reproducible_html_indexes.py
@@ -70,7 +70,8 @@ queries = {
'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',
'notes': 'SELECT s.name FROM sources AS s JOIN notes AS n ON n.package_id=s.id JOIN results AS r ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND r.status="{status}" ORDER BY r.build_date DESC',
- 'no_notes': 'SELECT s.name FROM sources AS s JOIN results AS r ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND r.status="{status}" AND s.id NOT IN (SELECT package_id FROM notes) ORDER BY r.build_date DESC'
+ 'no_notes': 'SELECT s.name FROM sources AS s JOIN results AS r ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND r.status="{status}" AND s.id NOT IN (SELECT package_id FROM notes) ORDER BY r.build_date DESC',
+ 'notification': 'SELECT s.name FROM sources AS s JOIN results AS r ON s.id=r.package_id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND r.status="{status}" AND s.notify_maintainer = 1',
}
pages = {
@@ -322,6 +323,40 @@ pages = {
'text': Template('$tot blacklisted packages in $suite/$arch:')
}
]
+ },
+ 'notify': {
+ 'global': True,
+ 'notes': True,
+ 'nosuite': True,
+ 'title': 'Packages with notification enabled',
+ 'header': '<p>The following {tot} packages with notifications enabled in {suite}/{arch}.<br />When a status change happen (e.g. reproducible → unreproducible) the system sends an email to $srcpackage@packages.debian.org, notifing the maintainer and relevant parties (please subscribe through the PTS o Tracker if you are interested in such emails)<br />Ask us to enable the notification for your package in our IRC channel!</p>',
+ 'header_query': 'SELECT COUNT(*) FROM sources WHERE suite="{suite}" AND architecture="{arch}" AND notify_maintainer = 1',
+ 'body': [
+ {
+ 'icon_status': 'FTBR',
+ 'db_status': 'unreproducible',
+ 'icon_link': '/index_FTBR.html',
+ 'query': 'notification',
+ 'text': Template('$tot unreproducible packages in $suite/$arch'),
+ 'nosuite': True
+ },
+ {
+ 'icon_status': 'FTBFS',
+ 'db_status': 'FTBFS',
+ 'icon_link': '/index_FTBFS.html',
+ 'query': 'notification',
+ 'text': Template('$tot FTBFS packages in $suite/$arch'),
+ 'nosuite': True
+ },
+ {
+ 'icon_status': 'reproducible',
+ 'db_status': 'reproducible',
+ 'icon_link': '/index_reproducible.html',
+ 'query': 'notification',
+ 'text': Template('$tot reproducible packages in $suite/$arch'),
+ 'nosuite': True
+ }
+ ]
}
}