3 echo "Known debian maintainers:"
5 psql --html projectb <<EOF
6 SELECT uid.uid, uid.name, f.fingerprint
7 FROM uid LEFT OUTER JOIN fingerprint f ON (uid.id = f.uid)
8 WHERE uid.uid LIKE 'dm:%'
12 echo "Packages debian maintainers may update:"
14 psql --html projectb <<EOF
15 SELECT s.source, s.version, u.uid
16 FROM src_uploaders su JOIN source s ON (su.source = s.id)
17 JOIN src_associations sa ON (s.id = sa.source)
18 JOIN maintainer m ON (su.maintainer = m.id)
19 JOIN uid u ON (m.name LIKE u.name || ' <%>')
20 WHERE u.uid LIKE 'dm:%' AND sa.suite = 5
21 ORDER BY u.uid, s.source, s.version;
24 echo "Source packages in the pool uploaded by debian maintainers:"
26 psql --html projectb <<EOF
27 SELECT s.source, s.version, s.install_date, u.uid
28 FROM source s JOIN fingerprint f ON (s.sig_fpr = f.id)
29 JOIN uid u ON (f.uid = u.id)
30 WHERE u.uid LIKE 'dm:%'
31 ORDER BY u.uid, s.source, s.version;
34 echo "Binary packages in the pool uploaded by debian maintainers:"
36 psql --html projectb <<EOF
37 SELECT b.package, b.version, a.arch_string AS arch, u.uid
38 FROM binaries b JOIN architecture a ON (b.architecture = a.id)
39 JOIN fingerprint f ON (b.sig_fpr = f.id)
40 JOIN uid u ON (f.uid = u.id)
41 WHERE u.uid LIKE 'dm:%'
42 ORDER BY u.uid, b.package, b.version;
45 echo "Recorded Uploaders:"
47 psql --html projectb <<EOF
48 SELECT s.source, s.version, m.name
49 FROM src_uploaders su JOIN source s ON (su.source = s.id)
50 JOIN maintainer m ON (su.maintainer = m.id)
51 ORDER BY m.name, s.source, s.version;
54 echo "Keys without a recorded uid:"
56 psql --html projectb <<EOF