X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fclean_suites.py;h=b08c9444e3889cdff7288c29ba6823a08f78aabe;hb=b56b4a2838abe0b7d48527c8ca0cc051666ec1e7;hp=9713de3447f16825930ad029e018398dfb7b638c;hpb=adcc4dcadd87c31ca52c4ec6b485375b56579e46;p=dak.git diff --git a/dak/clean_suites.py b/dak/clean_suites.py index 9713de34..b08c9444 100755 --- a/dak/clean_suites.py +++ b/dak/clean_suites.py @@ -128,6 +128,7 @@ SELECT s.id, s.file, f.filename (SELECT sa.source FROM src_associations sa) AND s.id NOT IN (SELECT b.source FROM binaries b) + AND s.id NOT IN (SELECT esr.src_id FROM extra_src_references esr) AND f.id NOT IN (SELECT bqf.fileid FROM build_queue_files bqf)""") @@ -171,6 +172,7 @@ SELECT s.id, s.file, f.filename SELECT f.id, f.filename FROM source s, files f, dsc_files df WHERE f.last_used IS NOT NULL AND s.id = df.source AND df.file = f.id AND ((EXISTS (SELECT 1 FROM src_associations sa WHERE sa.source = s.id)) + OR (EXISTS (SELECT 1 FROM extra_src_references esr WHERE esr.src_id = s.id)) OR (EXISTS (SELECT 1 FROM binaries b WHERE b.source = s.id)) OR (EXISTS (SELECT 1 FROM build_queue_files bqf WHERE bqf.fileid = s.file)))""")