summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-03-13 14:39:10 +0100
committerHolger Levsen <holger@layer-acht.org>2015-03-13 14:40:31 +0100
commit1ff7243f2cd9886c043803a641eb8b38870fe8f6 (patch)
treef19139334916a284955df346a31af440b542ef99 /bin
parentde741705e69967ffdad078d06c8afd15e23c041c (diff)
downloadjenkins.debian.net-1ff7243f2cd9886c043803a641eb8b38870fe8f6.tar.xz
reproducible: use CSS for numbering the rows
Diffstat (limited to 'bin')
-rwxr-xr-xbin/reproducible_html_indexes.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/bin/reproducible_html_indexes.py b/bin/reproducible_html_indexes.py
index 966bbd64..0a5a084e 100755
--- a/bin/reproducible_html_indexes.py
+++ b/bin/reproducible_html_indexes.py
@@ -44,7 +44,7 @@ section must have at least a `query` defining what to file in.
queries = {
'count_total': 'SELECT COUNT(*) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite="{suite}" AND s.architecture="{arch}"',
- 'scheduled': 'SELECT (select count(*) FROM schedule AS sch_b WHERE sch.date_scheduled >= sch_b.date_scheduled), sch.date_scheduled, s.suite, s.architecture, s.name FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id WHERE sch.date_build_started = "" ORDER BY sch.date_scheduled',
+ 'scheduled': 'SELECT sch.date_scheduled, s.suite, s.architecture, s.name FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id WHERE sch.date_build_started = "" ORDER BY sch.date_scheduled',
'reproducible_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 r.status="reproducible" ORDER BY r.build_date DESC',
'reproducible_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 r.status="reproducible" AND r.build_date > datetime("now", "-24 hours") ORDER BY r.build_date DESC',
'reproducible_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 r.status="reproducible" AND r.build_date > datetime("now", "-48 hours") ORDER BY r.build_date DESC',
@@ -295,14 +295,14 @@ def build_page_section(page, section, suite, arch):
return (html, footnote) # do not output anything on the page.
html += build_leading_text_section(section, rows, suite, arch)
if page == 'scheduled':
- html += '<p><table class="body">\n' + tab + '<tr><th>#</th><th>scheduled at</th><th>suite</th><th>architecture</th><th>source package</th></tr>\n'
+ html += '<p><table class="scheduled">\n' + tab + '<tr><th>#</th><th>scheduled at</th><th>suite</th><th>architecture</th><th>source package</th></tr>\n'
else:
html += '<p>\n' + tab + '<code>\n'
for row in rows:
if page == 'scheduled':
- pkg = row[4]
- url = RB_PKG_URI + '/' + row[2] + '/' + row[3] + '/' + pkg + '.html'
- html += tab + '<tr><td>' + str(row[0]) + '</td><td>' + row[1] + '</td><td>' + row[2] + '</td><td>' + row[3] + '</td><td><code>'
+ pkg = row[3]
+ url = RB_PKG_URI + '/' + row[1] + '/' + row[2] + '/' + pkg + '.html'
+ html += tab + '<tr><td>&nbsp;</td><td>' + row[0] + '</td><td>' + row[1] + '</td><td>' + row[2] + '</td><td><code>'
else:
pkg = row[0]
url = RB_PKG_URI + '/' + suite + '/' + arch + '/' + pkg + '.html'