From 20d37b8d938e8199fa8a0c3b8f8efda31a89b95d Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Fri, 11 Sep 2015 02:02:20 +0200 Subject: reproducible: drop previous version from live_status columns --- bin/reproducible_html_live_status.py | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'bin') 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 += '#src pkg idsuitearch' html += 'nameversionscheduled by' html += 'build startedprevious build status' - html += 'version buildingprevious build durationbuilder jobnotify' + html += 'previous build durationbuilder jobnotify' html += '\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 += '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.' + html += '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.' suite = row[1] arch = row[2] pkg = row[3] @@ -68,8 +68,8 @@ def generate_live_status_table(arch): html += '' + suite + '' + arch + '' html += '' + link_package(pkg, suite, arch) + '' html += '' + str(row[4]) + '' + str(row[5]) + '' + str(row[6]) + '' - html += '' + str(row[7]) + '' + str(row[8]) + '' + str(row[9]) + '' - html += '' + str(row[10]) + '' + str(row[11]) + '' + html += '' + str(row[7]) + '' + str(row[8]) + ' ' + html += '' + str(row[9]) + '' + str(row[10]) + '' html += '\n' html += '

\n' return html -- cgit v1.2.3-70-g09d2