Changeset 34796

Timestamp:

2021-02-02T12:59:13+13:00 (3 years ago)

Author:

davidb

Message:

More flexible way to determine song -- entrant relationship; getting entrant-label now optional, as if a string, then there is no rdfs:label field

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/fix-problem-entrants--using-errata.sparql (modified) (1 diff)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/fix-problem-entrants--using-errata.sparql

@@ -36 +36 @@
   ?country_in_year dct:source ?entrant_errata.
 
+
+  # Would like to do the following:
+  #  ?song dbp:artist ?entrant.
+  # in the 'dbpedia' graph however, the 'entrant' sitting in 'song' is sometimes a *string* not a URI
+  # =>
   SERVICE <https://dbpedia.demo.openlinksw.com/sparql> {
-    ?song dbp:artist|dbp:as ?entrant.     
+    ?song dbp:artist|dbp:as ?songentrant_from_dbpedia.
   }
+  OPTIONAL {
+    ?song dbp:artist ?songentrant_from_errata.
+  }
+  # If a string, look for a better result in the 'errata' graph
+  BIND(IF(isLITERAL(?songentrant_from_dbpedia),?songentrant_from_errata,?songentrant_from_dbpedia) AS ?entrant2).
+      FILTER (sameTERM(?entrant2,?entrant)).
+
   ?entrant dct:source ?entrant_errata.
 
-  SERVICE <https://dbpedia.demo.openlinksw.com/sparql> {
-    ?entrant rdfs:label ?entrant_label
-      FILTER (lang(?entrant_label) = 'en').
+  OPTIONAL {
+    SERVICE <https://dbpedia.demo.openlinksw.com/sparql> {
+      ?entrant rdfs:label ?entrant_label
+        FILTER (lang(?entrant_label) = 'en').
+    }
   }
 }