The following commit has been merged in the master branch: commit 521a1f185d8e4e3b6842ff44b00207b48179674f Author: Andreas Tille <ti...@debian.org> Date: Wed Dec 18 13:51:09 2013 +0100
Also check teams for aging packages diff --git a/misc/sql/aging_packages_of_blend b/misc/sql/aging_packages_of_blend index 3d44fc9..3436706 100755 --- a/misc/sql/aging_packages_of_blend +++ b/misc/sql/aging_packages_of_blend @@ -1,6 +1,5 @@ #!/bin/sh -# seek for packages uploaded a very long time ago -# join MAX(version) +# seek for packages uploaded a very long time ago by a Blend SERVICE="service=udd" #if there is a local UDD clone just use this diff --git a/misc/sql/aging_packages_of_blend b/misc/sql/aging_packages_of_team similarity index 76% copy from misc/sql/aging_packages_of_blend copy to misc/sql/aging_packages_of_team index 3d44fc9..3eebafe 100755 --- a/misc/sql/aging_packages_of_blend +++ b/misc/sql/aging_packages_of_team @@ -1,6 +1,5 @@ #!/bin/sh -# seek for packages uploaded a very long time ago -# join MAX(version) +# seek for packages uploaded a very long time ago by a certain team SERVICE="service=udd" #if there is a local UDD clone just use this @@ -12,10 +11,9 @@ psql $SERVICE >$1.out <<EOT SELECT u.source, u.version, cast(u.date as date) AS date, s.release, u.distribution, u.maintainer_name, u.changed_by_name, u.signed_by_name FROM ( SELECT source, r.release, strip_binary_upload(MAX(version)) AS version, row_number() OVER (PARTITION BY source ORDER BY r.sort DESC) - FROM blends_dependencies b - JOIN packages p ON p.package = b.package + FROM packages p JOIN releases r ON p.release = r.release - WHERE blend = '$1' AND b.dependency != 'i' GROUP BY source, r.release, r.sort + WHERE maintainer_email = '$1' GROUP BY source, r.release, r.sort ) s JOIN upload_history u ON s.source = u.source AND s.version = u.version WHERE row_number = 1 AND @@ -23,3 +21,4 @@ psql $SERVICE >$1.out <<EOT ORDER BY date, source ; EOT + -- Static and dynamic websites for Debian Pure Blends _______________________________________________ Blends-commit mailing list Blends-commit@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit