From 2f5401c6ac414b3047e4862f1bccdc2a1a90bc32 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Tue, 6 Jan 2015 18:17:17 +0100 Subject: reproducible: track another package set: popcon top 1337 installed sources --- bin/reproducible_create_meta_pkg_sets.sh | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'bin/reproducible_create_meta_pkg_sets.sh') diff --git a/bin/reproducible_create_meta_pkg_sets.sh b/bin/reproducible_create_meta_pkg_sets.sh index 780e93cb..f861eae3 100755 --- a/bin/reproducible_create_meta_pkg_sets.sh +++ b/bin/reproducible_create_meta_pkg_sets.sh @@ -102,6 +102,16 @@ grep-dctrl -sPackage -n -FMaintainer pkg-perl-maintainers@lists.alioth.debian.or convert_into_source_packages_only update_if_similar ${META_PKGSET[8]}.pkgset +# popcon top 1337 installed sources +SQL_QUERY="SELECT popcon_src.source FROM popcon_src ORDER BY popcon_src.insts DESC LIMIT 1337;" +PGPASSWORD=public-udd-mirror \ + psql -U public-udd-mirror \ + -h public-udd-mirror.xvm.mit.edu -p 5432 \ + -t \ + udd -c"${SQL_QUERY}" > $TMPFILE +update_if_similar ${META_PKGSET[9]}.pkgset + + # finally echo "All meta package sets created successfully." -- cgit v1.2.3-54-g00ecf