Changeset 35116

Timestamp:

2021-04-24T15:12:31+12:00 (3 years ago)

Author:

davidb

Message:

Adding in a 'pick a random song' feature with an underlying SPARQL query

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl (modified) (4 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl

@@ -161 +161 @@
       </p>
 
+      <xsl:variable name="graphURI">https://so-we-must-think.space<xsl:value-of select="$siteURL"/><xsl:value-of select="$library_name"/>/collection/<xsl:value-of select="$collName"/></xsl:variable>    
+
+      <!-- 
+           Kudos to:
+            https://byabbe.se/2020/09/17/getting-random-results-in-sparql
+      -->
+      <div id="select-random-entrant-sparqlquery" style="display: none;">
+PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;
+PREFIX xsd: &lt;http://www.w3.org/2001/XMLSchema#&gt;
+PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
+
+SELECT ?random ?esc_entrant_uri ?country ?year WHERE {
+  GRAPH &lt;<xsl:value-of select="$graphURI"/>&gt;  {
+    ?esc_entrant_uri gsdlextracted:Year ?year.
+    ?esc_entrant_uri gsdlextracted:Country ?country.
+    BIND(SHA512(CONCAT(STR(RAND()), STR(?esc_entrant_uri))) AS ?random).
+  }
+}
+ORDER BY ?random
+      </div>
+      <div id="select-random-entrant-div" style="display: none;">
+        Or how about picking a song ...
+        <ul>
+          <li><a id="select-random-entrant-a">... at random</a></li>
+        </ul>
+      </div>
+      <gsf:script>
+        $(document).ready(function() {
+          var endpoint_url="//sowemustthink.space/greenstone3-lod3/greenstone/query";
+          var sparql_query = $('#select-random-entrant-sparqlquery').text();
+          $.ajax({
+            type: "POST",
+            url: endpoint_url,
+            data: { query: sparql_query, output: "json" },
+            success: function(json_data) {
+          var rand_result = json_data.results.bindings[0];
+          var esc_entrant_uri = rand_result.esc_entrant_uri.value;
+          $('#select-random-entrant-a').attr("href",esc_entrant_uri);
+          $('#select-random-entrant-div').show();
+        },
+            dataType: "json"
+          });
+        });
+      </gsf:script>
 
       <h2>Data Analysis and Visualization</h2>
@@ -180 +224 @@
       </gsf:script>
 
-      <xsl:variable name="graphURI">https://so-we-must-think.space<xsl:value-of select="$siteURL"/><xsl:value-of select="$library_name"/>/collection/<xsl:value-of select="$collName"/></xsl:variable>    
       <div id="sgvizler2-country-count"
            data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod3/greenstone/query"
@@ -528 +571 @@
 
         <p>
-              Despite our best intentions work soley with
+              Despite our best intentions work solely with
               machine-readable data—primarily as you have seen in the
               form of Linked Open Data, but also utilizing a
@@ -570 +613 @@
           in a given year does, however, appear in the
           article page for the contest in that year.  In fact
-          it's in the same table we targetted to extract out
-          draw position and placement.  We therefore
+          it's in the same table we targeted to extract out
+          the draw position and placement.  We therefore
           wrote a further page-scraping program to compare
           the countries in that table with the countries