The following commit has been merged in the master branch:
commit d6ec7c32289f14b3358328230acbb6a57b83d1cf
Author: Andreas Tille <[email protected]>
Date: Thu Sep 21 09:42:34 2017 +0200
Add registry entries
diff --git a/misc/sql/edam.sh b/misc/sql/edam.sh
index 7edba02..a9a4f9e 100755
--- a/misc/sql/edam.sh
+++ b/misc/sql/edam.sh
@@ -75,7 +75,12 @@ $JSONBEGIN
pop.vote || ' / ' || pop.recent || ' / ' || pop.insts as popcon,
bibdoi.value as doi,
edam.topics as topics,
- edam.scopes as edam_scopes
+ edam.scopes as edam_scopes,
+ biotools.entry as "bio.tools",
+ omictools.entry as "OMICtools",
+ seqwiki as "SEQwiki",
+ scicrunch as "SciCrunch",
+ rrid as "RRID"
FROM (
SELECT * FROM (
SELECT DISTINCT
@@ -168,6 +173,11 @@ $JSONBEGIN
LEFT OUTER JOIN bibref bibdoi ON p.source = bibdoi.source AND
bibdoi.rank = 0 AND bibdoi.key = 'doi' AND bibdoi.package = ''
LEFT OUTER JOIN popcon pop ON p.package = pop.package
LEFT OUTER JOIN edam edam ON p.source = edam.source AND
p.package = edam.package
+ LEFT OUTER JOIN registry biotools ON p.source = biotools.source AND
biotools.name = 'bio.tools'
+ LEFT OUTER JOIN registry omictools ON p.source = omictools.source AND
omictools.name = 'OMICtools'
+ LEFT OUTER JOIN registry seqwiki ON p.source = seqwiki.source AND
seqwiki.name = 'SEQwiki'
+ LEFT OUTER JOIN registry scicrunch ON p.source = scicrunch.source AND
scicrunch.name = 'SciCrunch'
+ LEFT OUTER JOIN registry rrid ON p.source = rrid.source AND
rrid.name = 'RRID'
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
