summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-09-18 13:29:49 +0200
committerHolger Levsen <holger@layer-acht.org>2015-09-18 13:29:49 +0200
commit7042005bbe8e946eaeb0ad976ca1ec35126569f9 (patch)
treebb4ed1823acda8537715361c264304c181dcde01 /bin
parentf8aeea1c546391f54878fb305c65d35e17055569 (diff)
downloadjenkins.debian.net-7042005bbe8e946eaeb0ad976ca1ec35126569f9.tar.xz
reproducible: fixup f8aeea1c5, fix sql and also explain previous status and build duration in schedule table header
Diffstat (limited to 'bin')
-rwxr-xr-xbin/reproducible_html_live_status.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py
index fb5ed691..21d365ac 100755
--- a/bin/reproducible_html_live_status.py
+++ b/bin/reproducible_html_live_status.py
@@ -31,7 +31,7 @@ def generate_schedule(arch):
""" the schedule pages are very different than others index pages """
log.info('Building the schedule index page for ' + arch + '...')
title = 'Packages currently scheduled on ' + arch + ' for testing for build reproducibility'
- query = 'SELECT sch.date_scheduled, s.suite, s.architecture, s.name ' + \
+ query = 'SELECT sch.date_scheduled, s.suite, s.architecture, s.name, ' + \
'r.status, r.build_duration' + \
'FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id LEFT JOIN results AS r ON s.id=r.package_id ' + \
'WHERE sch.date_build_started = "" AND s.architecture="{arch}" ORDER BY sch.date_scheduled'
@@ -42,7 +42,7 @@ def generate_schedule(arch):
html += generate_live_status_table(arch)
html += '<p><table class="scheduled">\n' + tab
html += '<tr><th>#</th><th>scheduled at</th><th>suite</th>'
- html += '<th>arch</th><th>source package</th></tr>\n'
+ html += '<th>arch</th><th>source package</th><th>previous build status</th><th>previous build duration</th></tr>\n'
bugs = get_bugs()
for row in rows:
# 0: date_scheduled, 1: suite, 2: arch, 3: pkg name 4: previous status 5: previous build duration