From f8aeea1c546391f54878fb305c65d35e17055569 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Fri, 18 Sep 2015 13:24:41 +0200 Subject: reproducible: show previous status and build duration in schedule --- bin/reproducible_html_live_status.py | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py index b60de0f4..fb5ed691 100755 --- a/bin/reproducible_html_live_status.py +++ b/bin/reproducible_html_live_status.py @@ -32,7 +32,8 @@ def generate_schedule(arch): 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 ' + \ - 'FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id ' + \ + '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' text = Template('$tot packages are currently scheduled for testing on $arch:') html = '' @@ -44,12 +45,13 @@ def generate_schedule(arch): html += 'archsource package\n' bugs = get_bugs() for row in rows: - # 0: date_scheduled, 1: suite, 2: arch, 3: pkg name + # 0: date_scheduled, 1: suite, 2: arch, 3: pkg name 4: previous status 5: previous build duration pkg = row[3] + duration = convert_into_hms_string(row[5]) html += tab + ' ' + row[0] + '' html += '' + row[1] + '' + row[2] + '' html += link_package(pkg, row[1], row[2], bugs) - html += '\n' + html += ''+str(row[4])+''+duration+'\n' html += '

\n' destfile = BASE + '/index_' + arch + '_scheduled.html' desturl = REPRODUCIBLE_URL + '/index_' + arch + '_scheduled.html' -- cgit v1.2.3-70-g09d2