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
14 echo "udeb's in testing that don't (anymore) correspond to any testing source:"
19 (SELECT arch_string from architecture where b.architecture = architecture.id) as arch,
21 FROM bin_associations ba
22 LEFT JOIN binaries b on (ba.bin = b.id)
23 LEFT JOIN source s on (b.source = s.id)
25 AND s.id NOT IN (SELECT source from src_associations WHERE suite = 4)
27 ORDER BY s.source, b.package, b.architecture;
30 echo "udeb's in unstable that should be in testing too:"
35 (SELECT arch_string from architecture where b.architecture = architecture.id) as arch,
37 FROM bin_associations ba
38 LEFT JOIN binaries b on (ba.bin=b.id)
39 LEFT JOIN source s on (b.source=s.id)
41 AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = 4 AND ba2.bin = ba.bin)
42 AND s.id IN (SELECT source from src_associations WHERE suite=4)
44 AND b.architecture NOT IN (4,8,12)
45 ORDER BY s.source, b.package, b.architecture;
48 echo "udeb's in t-p-u that should be in testing too:"
53 (SELECT arch_string from architecture where b.architecture=architecture.id) as arch,
55 FROM bin_associations ba
56 LEFT JOIN binaries b ON ba.bin = b.id
57 LEFT JOIN source s ON b.source = s.id
59 AND NOT EXISTS (SELECT 1 FROM bin_associations ba2 WHERE ba2.suite = 4 AND ba2.bin = ba.bin)
60 AND s.id IN (SELECT source from src_associations WHERE suite = 4)
62 AND b.architecture NOT IN (4,8,12)
63 ORDER BY s.source, b.package, b.architecture;