summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_html_live_status.py
diff options
context:
space:
mode:
authorMattia Rizzolo <mattia@debian.org>2015-12-09 23:24:25 +0000
committerHolger Levsen <holger@layer-acht.org>2015-12-10 00:25:01 +0100
commitccf0de23178169e5fc37d5cd7ddf569647182edf (patch)
tree79b2fab4e934d57a5ba31c12c38f612a16446208 /bin/reproducible_html_live_status.py
parent35ad1767a81d20422c2e8c52f0fa144a71f03981 (diff)
downloadjenkins.debian.net-ccf0de23178169e5fc37d5cd7ddf569647182edf.tar.xz
reproducible: live_status: another case of = '' => IS NULL
Diffstat (limited to 'bin/reproducible_html_live_status.py')
-rwxr-xr-xbin/reproducible_html_live_status.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py
index b9ac6819..49ab803f 100755
--- a/bin/reproducible_html_live_status.py
+++ b/bin/reproducible_html_live_status.py
@@ -20,7 +20,7 @@ def generate_schedule(arch):
'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) ' + \
'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'
+ 'WHERE sch.date_build_started IS NULL AND s.architecture="{arch}" ORDER BY sch.date_scheduled'
# 'AND h.name=s.name AND h.suite=s.suite AND h.architecture=s.architecture' in this query and the query below is needed due to not using package_id in the stats_build table, which should be fixed...
text = Template('$tot packages are currently scheduled for testing on $arch:')
html = ''