generate-d-i: Only look at architectures in testing.

[dak.git] / scripts / debian / generate-d-i

diff --git a/scripts/debian/generate-d-i b/scripts/debian/generate-d-i
index 49e93d2978b48a72e1394d7befc871a4b806dc02..391e830860b51053f79d22fe8b45c44cb58c455b 100755 (executable)
--- a/scripts/debian/generate-d-i
+++ b/scripts/debian/generate-d-i
@@ -10,6 +10,9 @@ export PAGER=cat
 
 exec > $webdir/d-i 2>&1
 
+testing_id=$(psql -t -c "SELECT id FROM suite WHERE suite_name='testing'")
+testing_pu_id=$(psql -t -c "SELECT id FROM suite WHERE suite_name='testing-proposed-updates'")
+unstable_id=$(psql -t -c "SELECT id FROM suite WHERE suite_name='unstable'")
 
 echo "udeb's in testing that don't (anymore) correspond to any testing source:"
 psql -c "
@@ -21,8 +24,8 @@ psql -c "
   FROM bin_associations ba
   LEFT JOIN binaries b on (ba.bin = b.id)
   LEFT JOIN source s on (b.source = s.id)
-  WHERE ba.suite = 4
-    AND s.id NOT IN (SELECT source from src_associations WHERE suite = 4)
+  WHERE ba.suite = ${testing_id}
+    AND s.id NOT IN (SELECT source from src_associations WHERE suite = ${testing_id})
     AND b.type = 'udeb'
   ORDER BY s.source, b.package, b.architecture;
   "
@@ -37,11 +40,11 @@ psql -c "
   FROM bin_associations ba
   LEFT JOIN binaries b on (ba.bin=b.id)
   LEFT JOIN source s on (b.source=s.id)
-  WHERE ba.suite=5
-    AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = 4 AND ba2.bin = ba.bin)
-    AND s.id IN (SELECT source from src_associations WHERE suite=4)
+  WHERE ba.suite = ${unstable_id}
+    AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = ${testing_id} AND ba2.bin = ba.bin)
+    AND s.id IN (SELECT source from src_associations WHERE suite = ${testing_id})
     AND b.type = 'udeb'
-    AND b.architecture NOT IN (4,8,12)
+    AND b.architecture IN (SELECT architecture FROM suite_architectures WHERE suite = ${testing_id})
   ORDER BY s.source, b.package, b.architecture;
   "
 
@@ -55,10 +58,10 @@ psql -c "
   FROM bin_associations ba
   LEFT JOIN binaries b ON ba.bin = b.id
   LEFT JOIN source s ON b.source = s.id
-  WHERE ba.suite = 3
-    AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = 4 AND ba2.bin = ba.bin)
-    AND s.id IN (SELECT source from src_associations WHERE suite = 4)
+  WHERE ba.suite = ${testing_pu_id}
+    AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = ${testing_id} AND ba2.bin = ba.bin)
+    AND s.id IN (SELECT source from src_associations WHERE suite = ${testing_id})
     AND b.type = 'udeb'
-    AND b.architecture NOT IN (4,8,12)
+    AND b.architecture IN (SELECT architecture FROM suite_architectures WHERE suite = ${testing_id})
   ORDER BY s.source, b.package, b.architecture;
   "