[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: live_status: another case of = '' => IS NULL

[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 ccf0de23178169e5fc37d5cd7ddf569647182edf
Author: Mattia Rizzolo <mattia at debian.org>
Date:   Wed Dec 9 23:24:25 2015 +0000

    reproducible: live_status: another case of = '' =>  IS NULL
---
 bin/reproducible_html_live_status.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py
index b9ac681..49ab803 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 = ''

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