add primary key

[dak.git] / dak / rm.py

diff --git a/dak/rm.py b/dak/rm.py
index dcca4b6beb26d15aa79a2076987583daa418aeb5..0583755b3b6bc4c048af6d395b51f599edcf3bec 100755 (executable)
--- a/dak/rm.py
+++ b/dak/rm.py
@@ -127,15 +127,15 @@ def reverse_depends_check(removals, suite, arches=None, session=None):
 
         statement = '''
             create temp table suite_binaries (
-                id integer,
+                id integer primary key,
                 package text,
                 source integer,
                 file integer);
             insert into suite_binaries
                 select b.id, b.package, b.source, b.file
                     from binaries b WHERE b.id in
-                        (SELECT bin FROM bin_associations WHERE suite = 5)
-                        AND b.architecture in (16, 2);
+                        (SELECT bin FROM bin_associations WHERE suite = :suite_id)
+                        AND b.architecture in (:arch_id, :arch_all_id);
             SELECT b.id, b.package, s.source, c.name as component,
                 bmd.value as depends, bmp.value as provides
                 FROM suite_binaries b