[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible debian: fix bug in _scheduler queries

[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 f96c629400a6af4a2a7dc69ba7534f083b40673c
Author: Valerie R Young <spectranaut at riseup.net>
Date:   Mon Oct 17 11:03:09 2016 -0400

    reproducible debian: fix bug in _scheduler queries
    
    Signed-off-by: Holger Levsen <holger at layer-acht.org>
---
 bin/reproducible_scheduler.py | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/bin/reproducible_scheduler.py b/bin/reproducible_scheduler.py
index 737e1bb..b266af5 100755
--- a/bin/reproducible_scheduler.py
+++ b/bin/reproducible_scheduler.py
@@ -420,7 +420,7 @@ def query_old_ftbfs_versions(suite, arch, limit):
                 WHERE s.suite='{suite}' AND s.architecture='{arch}'
                 AND r.status='FTBFS'
                 AND ( n.bugs = '[]' OR n.bugs IS NULL )
-                AND r.build_date < {date}
+                AND r.build_date < '{date}'
                 AND s.id NOT IN (SELECT schedule.package_id FROM schedule)
                 ORDER BY r.build_date
                 LIMIT {limit}""".format(suite=suite, arch=arch, limit=limit,
@@ -438,7 +438,7 @@ def query_old_depwait_versions(suite, arch, limit):
                 FROM sources AS s JOIN results AS r ON s.id = r.package_id
                 WHERE s.suite='{suite}' AND s.architecture='{arch}'
                 AND r.status='depwait'
-                AND r.build_date < {date}
+                AND r.build_date < '{date}'
                 AND s.id NOT IN (SELECT schedule.package_id FROM schedule)
                 ORDER BY r.build_date
                 LIMIT {limit}""".format(suite=suite, arch=arch, limit=limit,
@@ -457,7 +457,7 @@ def query_old_versions(suite, arch, limit):
                 FROM sources AS s JOIN results AS r ON s.id = r.package_id
                 WHERE s.suite='{suite}' AND s.architecture='{arch}'
                 AND r.status != 'blacklisted'
-                AND r.build_date < {date}
+                AND r.build_date < '{date}'
                 AND s.id NOT IN (SELECT schedule.package_id FROM schedule)
                 ORDER BY r.build_date
                 LIMIT {limit}""".format(suite=suite, arch=arch,
@@ -474,7 +474,7 @@ def query_404_versions(suite, arch, limit):
                 FROM sources AS s JOIN results AS r ON s.id = r.package_id
                 WHERE s.suite='{suite}' AND s.architecture='{arch}'
                 AND r.status = '404'
-                AND r.build_date < {date}
+                AND r.build_date < '{date}'
                 AND s.id NOT IN (SELECT schedule.package_id FROM schedule)
                 ORDER BY r.build_date
                 LIMIT {limit}""".format(suite=suite, arch=arch, limit=limit,

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