X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fclean_suites.py;h=7419b83b5496e9b3ecca15e19d71326b8e449be0;hb=4f6c5e0d8b49025703530a2bcd6c5d6fc114368d;hp=806549e3895a001a5be8cb7dab5f195c380298d9;hpb=27e00376e81d1c37ff327ee0d39670b266418869;p=dak.git diff --git a/dak/clean_suites.py b/dak/clean_suites.py index 806549e3..7419b83b 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)))""")