3 # Original written from Jeroen van Wolffelaar <jeroen@debian.org>
6 export SCRIPTVARS=/srv/ftp-master.debian.org/dak/config/debian/vars
11 exec > $webdir/d-i 2>&1
13 testing_id=$(psql -t -c "SELECT id FROM suite WHERE suite_name='testing'")
14 testing_pu_id=$(psql -t -c "SELECT id FROM suite WHERE suite_name='testing-proposed-updates'")
15 unstable_id=$(psql -t -c "SELECT id FROM suite WHERE suite_name='unstable'")
17 echo "udeb's in testing that don't (anymore) correspond to any testing source:"
22 (SELECT arch_string from architecture where b.architecture = architecture.id) as arch,
24 FROM bin_associations ba
25 LEFT JOIN binaries b on (ba.bin = b.id)
26 LEFT JOIN source s on (b.source = s.id)
27 WHERE ba.suite = ${testing_id}
28 AND s.id NOT IN (SELECT source from src_associations WHERE suite = ${testing_id})
30 ORDER BY s.source, b.package, b.architecture;
33 echo "udeb's in unstable that should be in testing too:"
38 (SELECT arch_string from architecture where b.architecture = architecture.id) as arch,
40 FROM bin_associations ba
41 LEFT JOIN binaries b on (ba.bin=b.id)
42 LEFT JOIN source s on (b.source=s.id)
43 WHERE ba.suite = ${unstable_id}
44 AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = ${testing_id} AND ba2.bin = ba.bin)
45 AND s.id IN (SELECT source from src_associations WHERE suite = ${testing_id})
47 AND b.architecture IN (SELECT architecture FROM suite_architectures WHERE suite = ${testing_id})
48 ORDER BY s.source, b.package, b.architecture;
51 echo "udeb's in t-p-u that should be in testing too:"
56 (SELECT arch_string from architecture where b.architecture=architecture.id) as arch,
58 FROM bin_associations ba
59 LEFT JOIN binaries b ON ba.bin = b.id
60 LEFT JOIN source s ON b.source = s.id
61 WHERE ba.suite = ${testing_pu_id}
62 AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = ${testing_id} AND ba2.bin = ba.bin)
63 AND s.id IN (SELECT source from src_associations WHERE suite = ${testing_id})
65 AND b.architecture IN (SELECT architecture FROM suite_architectures WHERE suite = ${testing_id})
66 ORDER BY s.source, b.package, b.architecture;