From bc8ac7600e01ebf0a02e6349b286b84741591530 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Fri, 11 Sep 2015 00:54:37 +0200 Subject: reproducible: simplify SQL --- bin/reproducible_html_live_status.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'bin') diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py index 7fd09585..434c4096 100755 --- a/bin/reproducible_html_live_status.py +++ b/bin/reproducible_html_live_status.py @@ -14,9 +14,9 @@ def generate_live_status(): """ the schedule pages are very different than others index pages """ log.info('Building live status page...') title = 'Live status of reproducible.debian.net' - query = 'SELECT s.id, s.name, s.version, s.suite, s.architecture AS arch, ' + \ - 'p.scheduler, p.date_scheduled AS "scheduled on", p.date_build_started AS "build started on", ' + \ - 'r.status, r.version, r.build_duration AS duration, p.builder, p.notify ' + \ + query = 'SELECT s.id, s.name, s.version, s.suite, s.architecture, ' + \ + 'p.scheduler, p.date_scheduled, p.date_build_started, ' + \ + 'r.status, r.version, 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 != "" ' + \ 'ORDER BY p.date_build_started DESC' -- cgit v1.2.3-54-g00ecf