summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_html_live_status.py
diff options
context:
space:
mode:
authorMattia Rizzolo <mattia@debian.org>2015-12-09 23:10:52 +0000
committerHolger Levsen <holger@layer-acht.org>2015-12-10 00:18:37 +0100
commit35ad1767a81d20422c2e8c52f0fa144a71f03981 (patch)
treeb00d8f2ba37c5745e11c79dfb840798fe3aed431 /bin/reproducible_html_live_status.py
parente83a85b678693a3950107c192105620b2fac7bf4 (diff)
downloadjenkins.debian.net-35ad1767a81d20422c2e8c52f0fa144a71f03981.tar.xz
reproducible: build/live_status: check whether sch.date_build_started is NULL instead of ''
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 00eb8e26..b9ac6819 100755
--- a/bin/reproducible_html_live_status.py
+++ b/bin/reproducible_html_live_status.py
@@ -53,7 +53,7 @@ def generate_live_status_table(arch):
'(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.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}" ' + \
+ 'WHERE p.date_build_started IS NOT NULL AND s.architecture="{arch}" ' + \
'ORDER BY p.date_build_started DESC'
html = ''
rows = query_db(query.format(arch=arch))