The following commit has been merged in the master branch:
commit d7cb9e1bcb67ecd9d739aa1f368ff4060199ccfc
Author: Andreas Tille <[email protected]>
Date: Tue Oct 29 16:06:02 2013 +0100
Add latest release that contains this package while ignoring packages
showing up only in oldstable
diff --git a/misc/sql/0-aging.sh b/misc/sql/0-aging.sh
index 22a7757..20feb91 100755
--- a/misc/sql/0-aging.sh
+++ b/misc/sql/0-aging.sh
@@ -9,12 +9,17 @@ if psql -l 2>/dev/null | grep -qw udd ; then
fi
psql $SERVICE >$1.out <<EOT
- SELECT u.source, u.version, cast(u.date as date) AS date, u.distribution,
u.maintainer_name, u.changed_by_name, u.signed_by_name FROM (
- SELECT source, strip_binary_upload(MAX(version)) AS version FROM
blends_dependencies b
+ 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
- WHERE blend = '$1' GROUP BY source
+ JOIN releases r ON p.release = r.release
+ WHERE blend = '$1' GROUP BY source, r.release, r.sort
) s
JOIN upload_history u ON s.source = u.source AND s.version = u.version
- ORDER BY date
+ WHERE row_number = 1 AND
+ release != 'squeeze' -- only in oldstable, seems to be a removed
package
+ ORDER BY date, source
;
EOT
--
Static and dynamic websites for Debian Pure Blends
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
