[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[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: