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_common.sh | 1 + bin/reproducible_create_meta_pkg_sets.sh | 10 ++++++++++ 2 files changed, 11 insertions(+) diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index 4b059ed2..91625cf4 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -149,6 +149,7 @@ META_PKGSET[5]="build-depends_gnome" META_PKGSET[6]="tails" META_PKGSET[7]="build-depends_tails" META_PKGSET[8]="maint_pkg-perl-maintainers" +META_PKGSET[9]="popcon_top1337-installed-sources" init_html() { SUITE=sid 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-70-g09d2