Signed-off-by: Michael Casadevall <sonicmctails@gmail.com>
psql --html projectb <<EOF
SELECT uid.uid, uid.name, f.fingerprint
FROM uid LEFT OUTER JOIN fingerprint f ON (uid.id = f.uid)
psql --html projectb <<EOF
SELECT uid.uid, uid.name, f.fingerprint
FROM uid LEFT OUTER JOIN fingerprint f ON (uid.id = f.uid)
- WHERE uid.uid LIKE 'dm:%'
+ WHERE uid.uid LIKE '%@%'
JOIN uid u ON
(m.name LIKE u.name || ' <%>' OR
m.name LIKE '% <' || substring(u.uid FROM 4) || '>')
JOIN uid u ON
(m.name LIKE u.name || ' <%>' OR
m.name LIKE '% <' || substring(u.uid FROM 4) || '>')
- WHERE u.uid LIKE 'dm:%' AND sa.suite = 5
+ WHERE u.uid LIKE '%@%' AND sa.suite = 5
JOIN maintainer m ON (su.maintainer = m.id)
JOIN uid u ON (m.name LIKE u.name || ' <%>' OR
m.name LIKE '% <' || substring(u.uid FROM 4) || '>')
JOIN maintainer m ON (su.maintainer = m.id)
JOIN uid u ON (m.name LIKE u.name || ' <%>' OR
m.name LIKE '% <' || substring(u.uid FROM 4) || '>')
- WHERE u.uid LIKE 'dm:%' AND sa.suite = 5
+ WHERE s.dm_upload_allowed = 't'
ORDER BY u.uid, s.source, s.version;
EOF
ORDER BY u.uid, s.source, s.version;
EOF
SELECT s.source, s.version, s.install_date, u.uid
FROM source s JOIN fingerprint f ON (s.sig_fpr = f.id)
JOIN uid u ON (f.uid = u.id)
SELECT s.source, s.version, s.install_date, u.uid
FROM source s JOIN fingerprint f ON (s.sig_fpr = f.id)
JOIN uid u ON (f.uid = u.id)
- WHERE u.uid LIKE 'dm:%'
ORDER BY u.uid, s.source, s.version;
EOF
ORDER BY u.uid, s.source, s.version;
EOF
FROM binaries b JOIN architecture a ON (b.architecture = a.id)
JOIN fingerprint f ON (b.sig_fpr = f.id)
JOIN uid u ON (f.uid = u.id)
FROM binaries b JOIN architecture a ON (b.architecture = a.id)
JOIN fingerprint f ON (b.sig_fpr = f.id)
JOIN uid u ON (f.uid = u.id)
- WHERE u.uid LIKE 'dm:%'
ORDER BY u.uid, b.package, b.version;
EOF
ORDER BY u.uid, b.package, b.version;
EOF