diff options
| -rwxr-xr-x | bin/reproducible_html_live_status.py | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py index 4b4254d1..d73b047d 100755 --- a/bin/reproducible_html_live_status.py +++ b/bin/reproducible_html_live_status.py @@ -42,7 +42,7 @@ def generate_schedule(arch): def generate_live_status_table(arch): query = 'SELECT s.id, s.suite, s.architecture, s.name, s.version, ' + \ - 'p.date_build_started, r.status, r.build_duration, p.builder, p.notify ' + \ + 'p.date_build_started, r.status, r.build_duration, p.builder ' + \ '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' @@ -52,14 +52,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>' html += '<th>build started</th><th>previous build status</th>' - html += '<th>previous build duration</th><th>builder job</th><th>notify</th>' + html += '<th>previous build duration</th><th>builder job</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="11">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="10">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,7 +68,7 @@ def generate_live_status_table(arch): html += '<td><code>' + link_package(pkg, suite, arch) + '</code></td>' html += '<td>' + str(row[4]) + '</td><td>' + str(row[5]) + '</td>' html += '<td>' + str(row[6]) + '</td><td>' + str(row[7]) + '</td> ' - html += '<td><a href="https://jenkins.debian.net/job/reproducible_builder_' + str(row[8]) + '/console">' + str(row[8]) + '</a></td><td>' + str(row[9]) + '</td>' + html += '<td><a href="https://jenkins.debian.net/job/reproducible_builder_' + str(row[8]) + '/console">' + str(row[8]) + '</a></td>' html += '</tr>\n' html += '</table></p>\n' return html |