summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
authorValerie R Young <spectranaut@riseup.net>2016-10-17 11:03:09 -0400
committerHolger Levsen <holger@layer-acht.org>2016-10-17 17:11:04 +0200
commitf96c629400a6af4a2a7dc69ba7534f083b40673c (patch)
treeb3235c1186054be054658e47dd2dc5917a83260b /bin
parent05de141d71364afe61cb4fbec936540e1ed1e567 (diff)
downloadjenkins.debian.net-f96c629400a6af4a2a7dc69ba7534f083b40673c.tar.xz
reproducible debian: fix bug in _scheduler queries
Signed-off-by: Holger Levsen <holger@layer-acht.org>
Diffstat (limited to 'bin')
-rwxr-xr-xbin/reproducible_scheduler.py8
1 files changed, 4 insertions, 4 deletions
diff --git a/bin/reproducible_scheduler.py b/bin/reproducible_scheduler.py
index 737e1bb4..b266af5f 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,