The following commit has been merged in the master branch:
commit 22a6f4dd7c33416163c857879e4da57e4c651fa2
Author: Andreas Tille <[email protected]>
Date: Fri Feb 5 14:42:09 2016 +0100
Add doi
diff --git a/misc/sql/edam.sh b/misc/sql/edam.sh
index b8af897..d52b0c6 100755
--- a/misc/sql/edam.sh
+++ b/misc/sql/edam.sh
@@ -38,7 +38,8 @@ $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, use.tags AS use
+ interface.tags AS interface, biology.tags AS biology, field.tags AS
fields, use.tags AS use,
+ bibdoi.value as doi
FROM (
SELECT DISTINCT
package, distribution, release, component,
strip_binary_upload(version) AS version,
@@ -100,6 +101,7 @@ $JSONBEGIN
WHERE tag LIKE 'use::%'
GROUP BY package
) use ON use.package = p.package
+ LEFT OUTER JOIN bibref bibdoi ON p.source = bibdoi.source AND
bibdoi.rank = 0 AND bibdoi.key = 'doi' AND bibdoi.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
