diff options
author | Holger Levsen <holger@layer-acht.org> | 2014-11-08 14:52:00 +0000 |
---|---|---|
committer | Holger Levsen <holger@layer-acht.org> | 2014-11-08 14:52:00 +0000 |
commit | 346ff8b5368c7f41fdf3ccb750c83723d1efdc17 (patch) | |
tree | a93a83deef1e4c279bfed1059ec4cea0ce563e7f /bin | |
parent | 755eccf255749eaba7e1120ffcaf040a0f67433c (diff) | |
download | jenkins.debian.net-346ff8b5368c7f41fdf3ccb750c83723d1efdc17.tar.xz |
add three new qa.d.o jobs, to detect multi-arch versions skews in wheezy, jessie + sid
Diffstat (limited to 'bin')
-rwxr-xr-x | bin/udd-query.sh | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/bin/udd-query.sh b/bin/udd-query.sh new file mode 100755 index 00000000..2d8247e2 --- /dev/null +++ b/bin/udd-query.sh @@ -0,0 +1,64 @@ +#!/bin/bash + +# Copyright 2012-2014 Holger Levsen <holger@layer-acht.org> +# UDD query by Stuart Prescott <stuart@debian.org> +# released under the GPLv=2 + +DEBUG=false +. /srv/jenkins/bin/common-functions.sh +common_init "$@" + +# +# have all needed params been supplied? +# +if [ -z "$2" ] ; then + echo "Need at two params, distro + query_name..." + exit 1 +fi + +DISTRO=$1 +declare -A SQL_QUERY +QUERY=$2 + +# +# more to come, hopefully +# +if [ "$QUERY" != "multiarch_versionskew" ] ; then + echo "unknown query requested, exiting... please provide patches :)" + exit 1 +fi + +# +# SQL query for detecting multi-arch version skew +# +SQL_QUERY["multiarch_versionskew"]=" + SELECT DISTINCT source FROM + (SELECT DISTINCT source, package, version + FROM packages + WHERE + release='$DISTRO' AND + multi_arch='same' AND + architecture IN ('amd64', 'arm64', 'armel', 'armhf', 'i386', + 'kfreebsd-amd64', 'kfreebsd-i386', 'mips', 'mipsel', + 'powerpc', 'ppc64el', 's390x') + ORDER BY source) AS all_versions + GROUP BY source, package + HAVING count(*) > 1 + ORDER BY source + ; +" + + +# +# Actually query UDD +# +echo "$(date) - querying UDD using ${SQL_QUERY[$QUERY]}" +echo +PGPASSWORD=public-udd-mirror \ + psql -U public-udd-mirror \ + -h public-udd-mirror.xvm.mit.edu -p 5432 \ + -t \ + udd -c"${SQL_QUERY[$QUERY]}" + +# TODO: turn source package names into links +# TODO: show versions (per arch) too |