- # Check for files not references in either binaries or dsc_files
- used = {};
- q = projectB.query("SELECT file FROM binaries");
- for i in q.getresult():
- used[i[0]] = "";
- q = projectB.query("SELECT file FROM dsc_files");
- for i in q.getresult():
- used[i[0]] = "";
-
- all = {};
- q = projectB.query("SELECT f.id, l.path, f.filename FROM files f, location l WHERE f.location = l.id;");
- for i in q.getresult():
- all[i[0]] = i[1] + i[2];
+ q = projectB.query("""
+SELECT id FROM files f
+ WHERE NOT EXISTS (SELECT id FROM binaries b WHERE b.file = f.id)
+ AND NOT EXISTS (SELECT id FROM dsc_files df WHERE df.file = f.id)""");