From 1129552b2e233fe08b83b3a950546be4e6a1ace6 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Wed, 8 Jul 2015 14:34:00 +0000 Subject: qa.d.o: orphaned_without_o_bug: fix SQL query to really get only orphaned packages --- bin/udd-query.sh | 38 ++++++++++++++------------------------ 1 file changed, 14 insertions(+), 24 deletions(-) (limited to 'bin') diff --git a/bin/udd-query.sh b/bin/udd-query.sh index 7de82308..0240b447 100755 --- a/bin/udd-query.sh +++ b/bin/udd-query.sh @@ -68,43 +68,33 @@ multiarch_versionskew() { orphaned_without_o_bug() { WNPPRM=$(mktemp) SORTED_UDD=$(mktemp) - RES1=$(mktemp) - SQL_QUERY="SELECT DISTINCT source - FROM sources - WHERE maintainer LIKE '%packages@qa.debian.org%' - AND release='sid' - ORDER BY source ; " + SQL_QUERY="SELECT DISTINCT u.source + FROM upload_history AS u + JOIN ( + SELECT s.source, max(u.date) AS date + FROM upload_history AS u + JOIN sources AS s ON s.source=u.source + WHERE s.release = 'sid' OR s.release = 'experimental' + GROUP BY s.source + ) AS foo ON foo.source=u.source AND foo.date=u.date + WHERE maintainer like '%packages@qa.debian.org%';" udd_query cat $UDD | tr -d ' ' | sort | uniq > "$SORTED_UDD" curl --silent https://qa.debian.org/data/bts/wnpp_rm \ | cut -d ' ' -f 1 | tr -d ':' | sort | uniq > "$WNPPRM" - comm -23 "$SORTED_UDD" "$WNPPRM" > "$RES1" - - # $RES1 now contains all packages that have packages@qa.debian.org as the - # maintainer but do not appear on https://qa.debian.org/data/bts/wnpp_rm - # (because they are missing a bug) - # we have to remove all the packages that appear in experimental but do not - # have packages@qa.debian.org as a maintainer (i.e: they found a new one) - SQL_QUERY="SELECT DISTINCT source - FROM sources - WHERE maintainer NOT LIKE '%packages@qa.debian.org%' - AND release='experimental' - ORDER BY source ; " - udd_query - - if [ -s $UDD ] ; then - cat $UDD | tr -d ' ' | sort | uniq > "$SORTED_UDD" + RES=$(comm -23 "$SORTED_UDD" "$WNPPRM") + if [ -n "$RES" ] ; then echo "Warning: The following packages are maintained by packages@qa.debian.org" echo "but are missing a wnpp bug according to https://qa.debian.org/data/bts/wnpp_rm" echo # TODO: turn source package names into links - comm -13 "$SORTED_UDD" "$RES1" + echo $RES fi - rm -f "$UDD" "$WNPPRM" "$RES1" "$SORTED_UDD" + rm -f "$UDD" "$WNPPRM" "$SORTED_UDD" } # -- cgit v1.2.3-54-g00ecf