The following commit has been merged in the master branch:
commit d9934361a1db09e639f62b38fa0862a8999f524e
Author: Andreas Tille <[email protected]>
Date: Fri Feb 5 11:53:03 2016 +0100
Aggregate binary packages created from source package
diff --git a/misc/sql/edam.sh b/misc/sql/edam.sh
index c3e24d0..ddfb14e 100755
--- a/misc/sql/edam.sh
+++ b/misc/sql/edam.sh
@@ -31,6 +31,8 @@ team="'[email protected]'"
psql $PORT $OUTPUTFORMAT $SERVICE >edam.$EXT <<EOT
$JSONBEGIN
+ SELECT source, array_agg(package), distribution, release, component, version,
homepage FROM
+ (
SELECT DISTINCT
p.package, p.distribution, p.release, p.component, p.version,
p.source, p.homepage
@@ -72,7 +74,9 @@ $JSONBEGIN
GROUP BY px.package, px.version
) pvar ON pvar.package = p.package AND pvar.version = p.version AND
pvar.release = p.release
- ORDER BY p.source, p.package
+ ) tmp
+ GROUP BY source, distribution, release, component, version, homepage
+ ORDER BY source
$JSONEND
;
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
