aboutsummaryrefslogtreecommitdiff
path: root/gn/db/sparql.scm
diff options
context:
space:
mode:
Diffstat (limited to 'gn/db/sparql.scm')
-rw-r--r--gn/db/sparql.scm26
1 files changed, 24 insertions, 2 deletions
diff --git a/gn/db/sparql.scm b/gn/db/sparql.scm
index f03389b..86d163f 100644
--- a/gn/db/sparql.scm
+++ b/gn/db/sparql.scm
@@ -73,7 +73,9 @@ PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
(define (sparql-tsv endpoint-url query)
"Execute raw SPARQL query returning response as a UTF8 string, e.g.
-(tsv->scm (sparql-tsv (wd-sparql-endpoint-url) \"wd:Q158695\"))
+(tsv->scm (sparql-tsv (wd-sparql-endpoint-url) \"wd:Q158695\")).
+
+Note this procedure works for wikidata, but not for gn!
"
; GET /sparql?query=SELECT%20DISTINCT%20%2A%20where%20%7B%0A%20%20wd%3AQ158695%20wdt%3AP225%20%3Fo%20.%0A%7D%20limit%205 HTTP/2
(receive (response-status response-body)
@@ -93,7 +95,9 @@ PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
(unpack "bindings" (unpack "results" response)))
(define (sparql-scm endpoint-url query)
- "Return dual S-exp 'resultset' of varnames and results"
+ "Return dual S-exp 'resultset' of varnames and results.
+
+Note this procedure works for GN, but does not yet work for wikidata"
(let ((response (json-string->scm
(sparql-exec endpoint-url (gn-sparql-prefix query)))))
(values (sparql-names response) (sparql-results response))))
@@ -164,6 +168,24 @@ SELECT DISTINCT ?taxon ?ncbi ?descr where {
(define memo-sparql-wd-species-info
(memoize sparql-wd-species-info))
+(define (sparql-wd-geneids gene-name)
+ "Return a list of expanded wikidata ids, e.g.
+(\"<http://www.wikidata.org/entity/Q14860079>\" \"<http://www.wikidata.org/entity/Q24420953>\")"
+ (receive (type values)
+ (tsv->scm (sparql-tsv (wd-sparql-endpoint-url) (wikidata-query-geneids gene-name)))
+ (map (lambda (item) (car item)) values) ;; flatten list))
+
+(define memo-sparql-wd-geneids
+ (memoize sparql-wd-geneids))
+
+(define (sparql-wd-gene-aliases geneids)
+ (let ([geneid (car geneids)])
+ (receive (type values)
+ (tsv->scm (sparql-tsv (wd-sparql-endpoint-url) (wikidata-query-gene-aliases geneid)))
+ (map (lambda (item) (car item)) values) ;; flatten list))
+ )
+ ))
+
#!
gn:Mus_musculus rdf:type gnc:species .
gn:Mus_musculus gnt:name "Mouse" .