The following commit has been merged in the master branch:
commit 18574440cc6fd212b0fcbfaab6662fac16a94fa8
Author: Andreas Tille <[email protected]>
Date: Fri Feb 5 14:22:03 2016 +0100
Add use
diff --git a/misc/sql/edam.sh b/misc/sql/edam.sh
index 4f5d602..b8af897 100755
--- a/misc/sql/edam.sh
+++ b/misc/sql/edam.sh
@@ -38,7 +38,7 @@ $JSONBEGIN
regexp_replace(regexp_replace(regexp_replace(p.version, '-[.\d]+$',
''), '\+dfsg.*$', '') , '\+lgpl.*$', '') AS version, -- strip Debian revision
p.source, p.homepage,
en.description AS description, en.long_description AS
long_description,
- interface.tags AS interface, biology.tags AS biology, field.tags AS
fields
+ interface.tags AS interface, biology.tags AS biology, field.tags AS
fields, use.tags AS use
FROM (
SELECT DISTINCT
package, distribution, release, component,
strip_binary_upload(version) AS version,
@@ -94,7 +94,12 @@ $JSONBEGIN
WHERE tag LIKE 'field::%'
GROUP BY package
) field ON field.package = p.package
-
+ LEFT OUTER JOIN (
+ SELECT package, array_agg(regexp_replace(tag, 'use::', '')) AS tags
+ FROM debtags
+ WHERE tag LIKE 'use::%'
+ GROUP BY package
+ ) use ON use.package = p.package
ORDER BY source, package
-- If you want to make the output at source level uncomment this
-- ) tmp
--
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
