[Qa-jenkins-scm] [jenkins.debian.net] 01/05: reproducible: simplify SQL

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit bc8ac7600e01ebf0a02e6349b286b84741591530
Author: Holger Levsen <holger at layer-acht.org>
Date:   Fri Sep 11 00:54:37 2015 +0200

    reproducible: simplify SQL
---
 bin/reproducible_html_live_status.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py
index 7fd0958..434c409 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'

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git