summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-09-11 00:54:37 +0200
committerHolger Levsen <holger@layer-acht.org>2015-09-11 00:54:37 +0200
commitbc8ac7600e01ebf0a02e6349b286b84741591530 (patch)
tree899583a9882ec71d4a6b6092f8d498d1b696eeea
parent4644b5af7d9c212aa1a6dd4dec647fc5c936ea47 (diff)
downloadjenkins.debian.net-bc8ac7600e01ebf0a02e6349b286b84741591530.tar.xz
reproducible: simplify SQL
-rwxr-xr-xbin/reproducible_html_live_status.py6
1 files changed, 3 insertions, 3 deletions
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'