[dak/master 4/7] Fix SQL syntax errors
Signed-off-by: Frank Lichtenheld <djpig@debian.org>
---
dak/clean_suites.py | 3 +--
1 files changed, 1 insertions(+), 2 deletions(-)
diff --git a/dak/clean_suites.py b/dak/clean_suites.py
index 49f488d..3bc4229 100755
--- a/dak/clean_suites.py
+++ b/dak/clean_suites.py
@@ -211,8 +211,7 @@ def clean(now_date, delete_date, max_delete, session):
q = session.execute("""
SELECT df.id, s.id, f.filename FROM source s, files f, dsc_files df
WHERE f.last_used <= :deletedate
- AND s.file = f.id AND s.id = df.source
- AND df.id = dsc_files.id)""", {'deletedate': delete_date})
+ AND s.file = f.id AND s.id = df.source""", {'deletedate': delete_date})
for s in q.fetchall():
Logger.log(["delete source", s[2]])
if not Options["No-Action"]:
--
1.6.3.3
Reply to: