3 # Script from Helmut - check UDD for FTBFS bugs and print some details
6 PGPASSWORD=udd-mirror psql --host=udd-mirror.debian.net --user=udd-mirror udd "$@"
9 udd -c "\\COPY (SELECT id, package, affected_packages, title FROM all_bugs WHERE (EXISTS (SELECT 1 FROM bugs_tags WHERE bugs_tags.id = all_bugs.id AND tag = 'ftbfs') OR (title LIKE '%FTBFS%' AND package LIKE 'src:%')) AND severity IN ('serious', 'critical', 'grave') AND affects_unstable = 't') TO STDOUT WITH CSV DELIMITER '_';" |
10 while IFS='_' read bugnum pkg affects title; do
11 affects="${affects#\"}"
12 affects="${affects%\"}"
16 echo "$source $bugnum $title"
19 echo "$affects" | tr ',' '\n' | while read affected; do
20 test -z "$affected" && continue
21 source=${affected#src:}
22 test "$affected" = "$source" && continue
23 echo "$source $bugnum $title"