[dak/master] dm-monitor
fixup the "Packages DM may update" listing a little.
Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
scripts/debian/dm-monitor | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/scripts/debian/dm-monitor b/scripts/debian/dm-monitor
index bf8e34b..93e3647 100755
--- a/scripts/debian/dm-monitor
+++ b/scripts/debian/dm-monitor
@@ -31,13 +31,13 @@ EOF
echo "Packages debian maintainers may update:"
psql --html projectb <<EOF
- SELECT s.source, s.version, u.uid
+ SELECT s.source, space_separated_list(s.version), u.uid
FROM src_uploaders su JOIN source s ON (su.source = s.id)
JOIN src_associations sa ON (s.id = sa.source)
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 s.dm_upload_allowed = 't'
+ m.name LIKE '% <' || substring(u.uid FROM 4) || '>')
+ WHERE s.dm_upload_allowed = 't' GROUP BY s.source, s.version, u.uid
ORDER BY u.uid, s.source, s.version;
EOF
--
1.5.6.5
Reply to: