From fa471ea6d8749f26539faa6a2af7bc58c7318fd3 Mon Sep 17 00:00:00 2001 From: Mark Hymers Date: Sat, 11 Apr 2009 20:45:46 +0100 Subject: [PATCH] src_uploaders deletions now cascade from source Signed-off-by: Mark Hymers --- dak/clean_suites.py | 1 - 1 file changed, 1 deletion(-) diff --git a/dak/clean_suites.py b/dak/clean_suites.py index b5904836..d6a966b5 100755 --- a/dak/clean_suites.py +++ b/dak/clean_suites.py @@ -201,7 +201,6 @@ def clean(): before = time.time() sys.stdout.write("[Deleting from source table... ") projectB.query("DELETE FROM dsc_files WHERE EXISTS (SELECT 1 FROM source s, files f, dsc_files df WHERE f.last_used <= '%s' AND s.file = f.id AND s.id = df.source AND df.id = dsc_files.id)" % (delete_date)) - projectB.query("DELETE FROM src_uploaders WHERE EXISTS (SELECT 1 FROM source s, files f WHERE f.last_used <= '%s' AND s.file = f.id AND s.id = src_uploaders.source)" % (delete_date)) projectB.query("DELETE FROM source WHERE EXISTS (SELECT 1 FROM files WHERE source.file = files.id AND files.last_used <= '%s')" % (delete_date)) sys.stdout.write("done. (%d seconds)]\n" % (int(time.time()-before))) -- 2.39.2