From a3722c8457f22264c8d2850925addffb01e40e94 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Thu, 15 Oct 2015 10:43:44 +0000 Subject: reproducible: store in the db also the actual build host in stats_build, and rename the current "builder" field to "job", since it contains the jenkins job name and nummber --- bin/reproducible_html_live_status.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'bin/reproducible_html_live_status.py') diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py index 6d51746d..2f044c67 100755 --- a/bin/reproducible_html_live_status.py +++ b/bin/reproducible_html_live_status.py @@ -51,7 +51,7 @@ 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, ' + \ '(SELECT coalesce(AVG(h.build_duration), 0) FROM stats_build AS h WHERE h.status IN ("reproducible", "unreproducible") AND h.name=s.name AND h.suite=s.suite AND h.architecture=s.architecture) ' + \ - ', p.builder ' + \ + ', p.job ' + \ '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 != "" AND s.architecture="{arch}" ' + \ 'ORDER BY p.date_build_started DESC' -- cgit v1.2.3-70-g09d2