From 60212ade3721cc9eebc976d65c973ab6b690bd3e Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Sun, 19 Jul 2020 10:47:07 +0100 Subject: Search table --- bh20simplewebuploader/main.py | 21 ++++++++++++++++++++- 1 file changed, 20 insertions(+), 1 deletion(-) (limited to 'bh20simplewebuploader/main.py') diff --git a/bh20simplewebuploader/main.py b/bh20simplewebuploader/main.py index b88055f..48520fe 100644 --- a/bh20simplewebuploader/main.py +++ b/bh20simplewebuploader/main.py @@ -692,7 +692,26 @@ def getCountDB(): # Execute a 'global search' @app.route('/api/search', methods=['GET']) def search(): - return jsonify(["TESTME"]) + s = request.args.get('s') + query = """ + PREFIX pubseq: + PREFIX sio: + select distinct ?id ?seq + { + ?sample sio:SIO_000115 "%s" . + ?sample sio:SIO_000115 ?id . + ?seq pubseq:sample ?sample . + ?sample ?p ?o . + } + """ % s + payload = {'query': query, 'format': 'json'} + r = requests.get(baseURL, params=payload) + result = r.json()['results']['bindings'] + print(result,file=sys.stderr); + return jsonify([{ + 'id': x['id']['value'], + 'seq': x['seq']['value'], + } for x in result]) @app.route('/api/getAllaccessions', methods=['GET']) def getAllaccessions(): -- cgit v1.2.3