diff options
| author | lltommy | 2020-11-13 18:41:08 +0100 |
|---|---|---|
| committer | lltommy | 2020-11-13 18:41:08 +0100 |
| commit | bff4b4af7014fbf325b36e5ee149debe8e5dfd47 (patch) | |
| tree | 67b8396a71850fa42870cbb091c0e4a0b47febf2 /bh20simplewebuploader/static | |
| parent | 87ec8e1d6c5b3ca5375afd4a114f73fad3aa0b68 (diff) | |
| download | bh20-seq-resource-bff4b4af7014fbf325b36e5ee149debe8e5dfd47.tar.gz bh20-seq-resource-bff4b4af7014fbf325b36e5ee149debe8e5dfd47.tar.lz bh20-seq-resource-bff4b4af7014fbf325b36e5ee149debe8e5dfd47.zip | |
Initial commit: SPARQL playground, which replaces the demo page. Some queries have to be adjusted once changed metadata schema is live
Diffstat (limited to 'bh20simplewebuploader/static')
| -rw-r--r-- | bh20simplewebuploader/static/main.css | 18 | ||||
| -rw-r--r-- | bh20simplewebuploader/static/main.js | 84 |
2 files changed, 99 insertions, 3 deletions
diff --git a/bh20simplewebuploader/static/main.css b/bh20simplewebuploader/static/main.css index 76a1755..36c1a33 100644 --- a/bh20simplewebuploader/static/main.css +++ b/bh20simplewebuploader/static/main.css @@ -533,3 +533,21 @@ div.status { border-bottom: 2px solid white; padding-bottom: 20px; } + + + +/* SPARQL playground CSS*/ +#playground { +margin-left: 20px; +} + +#playground table{ +border: 1px solid black; +min-height: 400px; +} + +#playground td{ +border: 1px solid black; +padding-left:10px; +padding-right:10px; +} diff --git a/bh20simplewebuploader/static/main.js b/bh20simplewebuploader/static/main.js index 6cc0d9f..0e642c1 100644 --- a/bh20simplewebuploader/static/main.js +++ b/bh20simplewebuploader/static/main.js @@ -83,6 +83,48 @@ function fetchHTMLTable(apiEndPoint) { }); } + + +// changing access for Demo page +function demofetchHTMLTable(apiEndPoint) { + fetch(scriptRoot + apiEndPoint) + .then(response => { + return response.json(); + }) + .then(data => { + htmlString="<h3>Description</h3><p>"+data[0][0]["description"]+"</p>" + prefix=data[0][1]["prefix"].replaceAll("<","<") + htmlString+="<h4>Namespace</h4><pre>"+prefix+"</pre>"//prefix to construct correct query @data[0][1]["prefix"] + htmlString+="<h3>SPARQL query</h3><pre>"+data[0][2]["query"]+"</pre>" + htmlString+="<h3>SPARQL results table</h3><table>" + + keys=Object.keys(data[1][0]) + // Add keys as table headers + htmlString+="<tr>" + for (var j=0; j<keys.length;j++){ + htmlString+="<td style='font-weight: bold;'>"+keys[j]+"</bold></td>" + } + + //Go through the results set given the keys and fill the tail of the table + for (var i=0; i<data[1].length;i++) { + htmlString+="</tr><tr>" + for (var j=0; j<keys.length;j++){ + htmlString+="<td>"+data[1][i][keys[j]]+"</td>" + } + htmlString+="</tr>" + } + htmlString=htmlString+"</table>" + + //Something like this would be nice, hm + //htmlString+="Execute this query <a href='http://sparql.genenetwork.org/sparql?query='"+encodeURIComponent(encodeURIComponent(data[0][1]["prefix"]+data[0][2]["query"]))+"'>here</a>" + + document.getElementById("playground").innerHTML = htmlString + }); +} + + + + /* Fetch record info using a 'global search'. Returns for example [ @@ -122,14 +164,50 @@ let fetchCountDB = () => { fetchAPI("/api/getCountDB"); } -let fetchSEQCountBySpecimen = () => { - fetchHTMLTable("/api/getSEQCountbySpecimenSource"); + +//****** SPARQL playground functions // keep old functionality as comments for now, might be transfered elsewhere +let fetchSEQCountBySpecimen = (toHTML) => { + //fetchHTMLTable("/api/getSEQCountbySpecimenSource"); + demofetchHTMLTable("/api/demoGetSEQCountbySpecimenSource") } let fetchSEQCountByLocation = () => { - fetchHTMLTable("/api/getSEQCountbyLocation"); + //fetchHTMLTable("/api/getSEQCountbyLocation"); + demofetchHTMLTable("/api/demoGetSEQCountbyLocation") +} + +//Get authors and there country/contitent where they come from +let fetchAuthors = () => { + demofetchHTMLTable("/api/demoGetAuthors") +} + +// Fetch all institutes/originating labs and their associeted publications +let fetchInstitutesPublications = () => { + demofetchHTMLTable("/api/demoInstitutesPublications") +} + +//Fetch seqeenctechnologies used by continent +let demoGetSEQCountbytechContinent = () => { + demofetchHTMLTable("/api/demoGetSEQCountbytechContinent") +} + +let demoGetSEQCountbytech = () => { + demofetchHTMLTable("/api/demoGetSEQCountbytech") +} + +let demoGetSequencePerDate = () => { + demofetchHTMLTable('/api/demoGetSequencePerDate') +} + +let demoLocationGps = () => { + demofetchHTMLTable("/api/demoLocationGps") +} + +let getNYsamples = () => { + demofetchHTMLTable("/api/getNYsamples") } +//old/unused functions let fetchSEQCountByTech = () => { fetchHTMLTable("/api/getSEQCountbytech"); } |