summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_html_live_status.py
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-09-11 02:02:20 +0200
committerHolger Levsen <holger@layer-acht.org>2015-09-11 02:02:20 +0200
commit20d37b8d938e8199fa8a0c3b8f8efda31a89b95d (patch)
treecf2cb9586192b8172688e16d142746b617ee0f79 /bin/reproducible_html_live_status.py
parent6085c2835c742fb33f7fe9a05438e72af03a5c50 (diff)
downloadjenkins.debian.net-20d37b8d938e8199fa8a0c3b8f8efda31a89b95d.tar.xz
reproducible: drop previous version from live_status columns
Diffstat (limited to 'bin/reproducible_html_live_status.py')
-rwxr-xr-xbin/reproducible_html_live_status.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py
index 3c9dd63a..b3a664d4 100755
--- a/bin/reproducible_html_live_status.py
+++ b/bin/reproducible_html_live_status.py
@@ -43,7 +43,7 @@ def generate_schedule(arch):
def generate_live_status_table(arch):
query = 'SELECT s.id, s.suite, s.architecture, s.name, s.version, ' + \
'p.scheduler, p.date_build_started, ' + \
- 'r.status, r.version, r.build_duration, p.builder, p.notify ' + \
+ 'r.status, r.build_duration, p.builder, p.notify ' + \
'FROM sources AS s JOIN schedule AS p ON p.package_id=s.id LEFT JOIN results AS r ON s.id=r.package_id ' + \
'WHERE (p.date_build_started != "" OR p.notify != "") AND s.architecture="{arch}" ' + \
'ORDER BY p.date_build_started DESC'
@@ -53,14 +53,14 @@ def generate_live_status_table(arch):
html += '<tr><th>#</th><th>src pkg id</th><th>suite</th><th>arch</th>'
html += '<th>name</th><th>version</th></th><th>scheduled by</th>'
html += '<th>build started</th><th>previous build status</th>'
- html += '<th>version building</th><th>previous build duration</th><th>builder job</th><th>notify</th>'
+ html += '<th>previous build duration</th><th>builder job</th><th>notify</th>'
html += '</tr>\n'
counter = 0
for row in rows:
counter += 1
# the numbers 16 and 7 should really be derived from /var/lib/jenkins/jobs/reproducible_builder_${arch}_* instead of being hard-coded here...
if ( arch == 'amd64' and counter == 16 ) or ( arch == 'armhf' and counter == 7 ):
- html += '<tr><td colspan="13">There are more builds marked as currently building in the database than there are ' + arch + ' build jobs. This does not compute. Please cleanup and please automate cleanup.</td></tr>'
+ html += '<tr><td colspan="12">There are more builds marked as currently building in the database than there are ' + arch + ' build jobs. This does not compute. Please cleanup and please automate cleanup.</td></tr>'
suite = row[1]
arch = row[2]
pkg = row[3]
@@ -68,8 +68,8 @@ def generate_live_status_table(arch):
html += '<td>' + suite + '</td><td>' + arch + '</td>'
html += '<td><code>' + link_package(pkg, suite, arch) + '</code></td>'
html += '<td>' + str(row[4]) + '</td><td>' + str(row[5]) + '</td><td>' + str(row[6]) + '</td>'
- html += '<td>' + str(row[7]) + '</td><td>' + str(row[8]) + '</td><td>' + str(row[9]) + '</td>'
- html += '<td><a href="https://jenkins.debian.net/job/reproducible_builder_' + str(row[10]) + '/console">' + str(row[10]) + '</a></td><td>' + str(row[11]) + '</td>'
+ html += '<td>' + str(row[7]) + '</td><td>' + str(row[8]) + '</td> '
+ html += '<td><a href="https://jenkins.debian.net/job/reproducible_builder_' + str(row[9]) + '/console">' + str(row[9]) + '</a></td><td>' + str(row[10]) + '</td>'
html += '</tr>\n'
html += '</table></p>\n'
return html