[Qa-jenkins-scm] [jenkins.debian.net] 02/02: reproducible: build/live_status: check whether sch.date_build_started is NULL instead of ''

[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 35ad1767a81d20422c2e8c52f0fa144a71f03981
Author: Mattia Rizzolo <mattia at debian.org>
Date:   Wed Dec 9 23:10:52 2015 +0000

    reproducible: build/live_status: check whether sch.date_build_started is NULL instead of ''
---
 bin/reproducible_build.sh            | 2 +-
 bin/reproducible_html_live_status.py | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh
index 83326c3..0c51a6e 100755
--- a/bin/reproducible_build.sh
+++ b/bin/reproducible_build.sh
@@ -403,7 +403,7 @@ choose_package() {
 	local RESULT=$(sqlite3 -init $INIT ${PACKAGES_DB} "
 		SELECT s.suite, s.id, s.name, sch.date_scheduled, sch.save_artifacts, sch.notify, s.notify_maintainer, sch.message
 		FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id
-		WHERE sch.date_build_started=''
+		WHERE sch.date_build_started is NULL
 		AND s.architecture='$ARCH'
 		ORDER BY date_scheduled LIMIT 5"|sort -R|head -1)
 	if [ -z "$RESULT" ] ; then
diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py
index 00eb8e2..b9ac681 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))

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