# HG changeset patch # User ymh # Date 1380144149 -7200 # Node ID d33a072d974b4ba65a753fb7f6127d2bbc7ea262 # Parent 0a4e7d6ebe80d98e41dda5307c5f69735a4002fd Remove unecessary spaces in sparql queries diff -r 0a4e7d6ebe80 -r d33a072d974b src/p4l/settings.py --- a/src/p4l/settings.py Wed Sep 25 22:14:51 2013 +0200 +++ b/src/p4l/settings.py Wed Sep 25 23:22:29 2013 +0200 @@ -439,341 +439,341 @@ SPARQL_REF_QUERIES = { 'subjects': { 'url' : SPARQL_QUERY_ENDPOINT, - 'filter' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept. - ?uri skos:inScheme . - ?uri skos:prefLabel ?label. - FILTER (lang(?label) = {lang}). - ?uri skos:prefLabel ?lab. - FILTER regex (str(?lab), ?reg, 'i'). - FILTER (lang (?lab) = {lang}). - BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). - BIND (STRLEN(STR(?lab)) AS ?len) - }} - ORDER BY ?place ?len ?lab - """, - "root" : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?type - WHERE {{ - ?uri a skos:Collection ; - skos:inScheme ; - skos:prefLabel|rdfs:label ?label ; - rdf:type ?type . - FILTER (lang(?label) = {lang}). - FILTER NOT EXISTS {{ [skos:member ?uri] }}. - }} - ORDER BY ?label - """, - "childs" : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?type - WHERE {{ - ?uri skos:inScheme . - {{ ?uri a ?type - FILTER (?type = skos:Collection || ?type = skos:Concept) }}. - ?root skos:narrower|skos:member ?uri. - ?uri skos:prefLabel|rdfs:label ?label. - FILTER (lang(?label) = {lang}). - }} - ORDER BY ?label - """, - "child-count" : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT (COUNT(?uri) as ?nb) - WHERE {{ - ?uri skos:inScheme . - ?root skos:narrower|skos:member ?uri. - }} - """ + 'filter' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept. " + "?uri skos:inScheme . " + "?uri skos:prefLabel ?label. " + "FILTER (lang(?label) = {lang}). " + "?uri skos:prefLabel ?lab. " + "FILTER regex (str(?lab), ?reg, 'i'). " + "FILTER (lang (?lab) = {lang}). " + "BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). " + "BIND (STRLEN(STR(?lab)) AS ?len) " + "}} " + "ORDER BY ?place ?len ?lab" + ), + "root" : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?type " + "WHERE {{ " + "?uri a skos:Collection ; " + "skos:inScheme ; " + "skos:prefLabel|rdfs:label ?label ; " + "rdf:type ?type . " + "FILTER (lang(?label) = {lang}). " + "FILTER NOT EXISTS {{ [skos:member ?uri] }}. " + "}} " + "ORDER BY ?label" + ), + "childs" : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?type " + "WHERE {{ " + "?uri skos:inScheme . " + "{{ ?uri a ?type " + "FILTER (?type = skos:Collection || ?type = skos:Concept) }}. " + "?root skos:narrower|skos:member ?uri. " + "?uri skos:prefLabel|rdfs:label ?label. " + "FILTER (lang(?label) = {lang}). " + "}} " + "ORDER BY ?label" + ), + "child-count" : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT (COUNT(?uri) as ?nb) " + "WHERE {{ " + "?uri skos:inScheme . " + "?root skos:narrower|skos:member ?uri. " + "}}" + ) }, 'themes': { 'url' : SPARQL_QUERY_ENDPOINT, - 'filter' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept. - ?uri skos:inScheme . - ?uri skos:prefLabel ?label. - FILTER (lang(?label) = {lang}). - ?uri skos:prefLabel ?lab. - FILTER regex (str(?lab), ?reg, 'i'). - FILTER (lang (?lab) = {lang}). - BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). - BIND (STRLEN(STR(?lab)) AS ?len) - }} - ORDER BY ?place ?len ?lab - """, - 'root' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?type - WHERE {{ - ?uri a skos:Collection ; - skos:inScheme ; - skos:prefLabel|rdfs:label ?label ; - rdf:type ?type . - FILTER (lang(?label) = {lang}). - FILTER NOT EXISTS {{ [skos:member ?uri] }} - }} - ORDER BY ?label - """, - 'childs' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?type - WHERE {{ - ?uri skos:inScheme . - {{ ?uri a ?type - FILTER (?type = skos:Collection || ?type = skos:Concept) }}. - ?root skos:narrower|skos:member ?uri. - ?uri skos:prefLabel|rdfs:label ?label. - FILTER (lang(?label) = {lang}). - }} - ORDER BY ?label - """, - 'child-count' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT (COUNT(?uri) as ?nb) - WHERE {{ - ?uri skos:inScheme . - ?root skos:narrower|skos:member ?uri. - }} - """ + 'filter' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept. " + "?uri skos:inScheme . " + "?uri skos:prefLabel ?label. " + "FILTER (lang(?label) = {lang}). " + "?uri skos:prefLabel ?lab. " + "FILTER regex (str(?lab), ?reg, 'i'). " + "FILTER (lang (?lab) = {lang}). " + "BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). " + "BIND (STRLEN(STR(?lab)) AS ?len) " + "}} " + "ORDER BY ?place ?len ?lab" + ), + 'root' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?type " + "WHERE {{ " + "?uri a skos:Collection ; " + "skos:inScheme ; " + "skos:prefLabel|rdfs:label ?label ; " + "rdf:type ?type . " + "FILTER (lang(?label) = {lang}). " + "FILTER NOT EXISTS {{ [skos:member ?uri] }} " + "}} " + "ORDER BY ?label" + ), + 'childs' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?type " + "WHERE {{ " + "?uri skos:inScheme . " + "{{ ?uri a ?type " + "FILTER (?type = skos:Collection || ?type = skos:Concept) }}. " + "?root skos:narrower|skos:member ?uri. " + "?uri skos:prefLabel|rdfs:label ?label. " + "FILTER (lang(?label) = {lang}). " + "}} " + "ORDER BY ?label " + ), + 'child-count' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT (COUNT(?uri) as ?nb) " + "WHERE {{ " + "?uri skos:inScheme . " + "?root skos:narrower|skos:member ?uri. " + "}} " + ) }, 'countries': { 'url' : SPARQL_QUERY_ENDPOINT, - 'filter' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept. - ?uri skos:inScheme . - ?uri skos:prefLabel ?label. - FILTER (lang(?label) = {lang}). - ?uri skos:prefLabel ?lab. - FILTER regex (str(?lab), ?reg, 'i'). - FILTER (lang (?lab) = {lang}). - BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). - BIND (STRLEN(STR(?lab)) AS ?len) - }} - ORDER BY ?place ?len ?lab - """, - 'root' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept ; - skos:inScheme ; - skos:prefLabel ?label . - FILTER (lang(?label) = {lang}). - FILTER NOT EXISTS {{ [skos:narrower ?uri] }} - }} - ORDER BY ?label - """, - 'childs' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri skos:inScheme . - {{ ?uri a ?type - FILTER (?type = skos:Collection || ?type = skos:Concept) }}. - ?root skos:narrower|skos:member ?uri. - ?uri skos:prefLabel|rdfs:label ?label. - FILTER (lang(?label) = {lang}). - }} - ORDER BY ?label - """, - 'child-count' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT (COUNT(?uri) as ?nb) - WHERE {{ - ?uri skos:inScheme . - ?root skos:narrower|skos:member ?uri. - }} - """ + 'filter' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept. " + "?uri skos:inScheme . " + "?uri skos:prefLabel ?label. " + "FILTER (lang(?label) = {lang}). " + "?uri skos:prefLabel ?lab. " + "FILTER regex (str(?lab), ?reg, 'i'). " + "FILTER (lang (?lab) = {lang}). " + "BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). " + "BIND (STRLEN(STR(?lab)) AS ?len) " + "}} " + "ORDER BY ?place ?len ?lab" + ), + 'root' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept ; " + "skos:inScheme ; " + "skos:prefLabel ?label . " + "FILTER (lang(?label) = {lang}). " + "FILTER NOT EXISTS {{ [skos:narrower ?uri] }} " + "}} " + "ORDER BY ?label " + ), + 'childs' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri skos:inScheme . " + "{{ ?uri a ?type " + "FILTER (?type = skos:Collection || ?type = skos:Concept) }}. " + "?root skos:narrower|skos:member ?uri. " + "?uri skos:prefLabel|rdfs:label ?label. " + "FILTER (lang(?label) = {lang}). " + "}} " + "ORDER BY ?label" + ), + 'child-count' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT (COUNT(?uri) as ?nb) " + "WHERE {{ " + "?uri skos:inScheme . " + "?root skos:narrower|skos:member ?uri. " + "}}" + ) }, 'languages': { 'url' : SPARQL_QUERY_ENDPOINT, - 'filter' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept. - ?uri skos:inScheme . - ?uri skos:prefLabel ?label. - FILTER (lang(?label) = {lang}). - ?uri skos:prefLabel ?lab. - FILTER regex (str(?lab), ?reg, 'i'). - FILTER (lang (?lab) = {lang}). - BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). - BIND (STRLEN(STR(?lab)) AS ?len) - }} - ORDER BY ?place ?len ?lab - """, - 'root' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept ; - skos:inScheme ; - skos:prefLabel ?label . - FILTER (lang(?label) = {lang}). - FILTER NOT EXISTS {{ [skos:narrower ?uri] }} - }} - ORDER BY ?label - """ + 'filter' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept. " + "?uri skos:inScheme . " + "?uri skos:prefLabel ?label. " + "FILTER (lang(?label) = {lang}). " + "?uri skos:prefLabel ?lab. " + "FILTER regex (str(?lab), ?reg, 'i'). " + "FILTER (lang (?lab) = {lang}). " + "BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). " + "BIND (STRLEN(STR(?lab)) AS ?len) " + "}} " + "ORDER BY ?place ?len ?lab" + ), + 'root' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept ; " + "skos:inScheme ; " + "skos:prefLabel ?label . " + "FILTER (lang(?label) = {lang}). " + "FILTER NOT EXISTS {{ [skos:narrower ?uri] }} " + "}} " + "ORDER BY ?label" + ) }, 'projects': { 'url' : SPARQL_QUERY_ENDPOINT, - 'filter' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?acro - WHERE {{ - ?uri a skos:Concept. - ?uri skos:inScheme . - ?uri skos:prefLabel ?label. - ?uri skos:prefLabel ?lab. - OPTIONAL {{ ?uri skos:altLabel ?acro }}. - FILTER regex (str(?lab), ?reg, 'i'). - BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). - BIND (STRLEN(STR(?lab)) AS ?len) - }} - ORDER BY ?place ?len ?lab - """, - 'root' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?acro - WHERE {{ - ?uri a skos:Concept ; - skos:inScheme ; - skos:prefLabel ?label . - OPTIONAL {{ ?uri skos:altLabel ?acro }} - }} - ORDER BY ?label - """ + 'filter' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?acro " + "WHERE {{ " + "?uri a skos:Concept. " + "?uri skos:inScheme . " + "?uri skos:prefLabel ?label. " + "?uri skos:prefLabel ?lab. " + "OPTIONAL {{ ?uri skos:altLabel ?acro }}. " + "FILTER regex (str(?lab), ?reg, 'i'). " + "BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). " + "BIND (STRLEN(STR(?lab)) AS ?len) " + "}} " + "ORDER BY ?place ?len ?lab" + ), + 'root' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?acro " + "WHERE {{ " + "?uri a skos:Concept ; " + "skos:inScheme ; " + "skos:prefLabel ?label . " + "OPTIONAL {{ ?uri skos:altLabel ?acro }} " + "}} " + "ORDER BY ?label" + ) }, 'organizations': { 'url' : SPARQL_QUERY_ENDPOINT, - 'filter' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?acro - WHERE {{ - ?uri a skos:Concept. - ?uri skos:inScheme . - ?uri skos:prefLabel ?label. - ?uri skos:prefLabel ?lab. - OPTIONAL {{ ?uri skos:altLabel ?acro }}. - FILTER regex (str(?lab), ?reg, 'i'). - BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). - BIND (STRLEN(STR(?lab)) AS ?len) - }} - ORDER BY ?place ?len ?lab - """, - 'root' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label ?acro - WHERE {{ - ?uri a skos:Concept ; - skos:inScheme ; - skos:prefLabel ?label . - OPTIONAL {{ ?uri skos:altLabel ?acro }} - }} - ORDER BY ?label - """ + 'filter' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?acro " + "WHERE {{ " + "?uri a skos:Concept. " + "?uri skos:inScheme . " + "?uri skos:prefLabel ?label. " + "?uri skos:prefLabel ?lab. " + "OPTIONAL {{ ?uri skos:altLabel ?acro }}. " + "FILTER regex (str(?lab), ?reg, 'i'). " + "BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). " + "BIND (STRLEN(STR(?lab)) AS ?len) " + "}} " + "ORDER BY ?place ?len ?lab" + ), + 'root' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label ?acro " + "WHERE {{ " + "?uri a skos:Concept ; " + "skos:inScheme ; " + "skos:prefLabel ?label . " + "OPTIONAL {{ ?uri skos:altLabel ?acro }} " + "}} " + "ORDER BY ?label" + ) }, 'types': { 'url' : SPARQL_QUERY_ENDPOINT, - 'filter' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept. - ?uri skos:inScheme . - ?uri skos:prefLabel ?label. - FILTER (lang(?label) = {lang}). - ?uri skos:prefLabel ?lab. - FILTER regex (str(?lab), ?reg, 'i'). - FILTER (lang (?lab) = {lang}). - BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). - BIND (STRLEN(STR(?lab)) AS ?len) - }} - ORDER BY ?place ?len ?lab - """, - 'root' : """ - PREFIX skos: - PREFIX rdf: - PREFIX owl: - PREFIX rdfs: - SELECT DISTINCT ?uri ?label - WHERE {{ - ?uri a skos:Concept ; - skos:inScheme ; - skos:prefLabel ?label . - FILTER (lang(?label) = {lang}). - FILTER NOT EXISTS {{ [skos:narrower ?uri] }} - }} - ORDER BY ?label - """ + 'filter' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept. " + "?uri skos:inScheme . " + "?uri skos:prefLabel ?label. " + "FILTER (lang(?label) = {lang}). " + "?uri skos:prefLabel ?lab. " + "FILTER regex (str(?lab), ?reg, 'i'). " + "FILTER (lang (?lab) = {lang}). " + "BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place). " + "BIND (STRLEN(STR(?lab)) AS ?len) " + "}} " + "ORDER BY ?place ?len ?lab" + ), + 'root' : ( + "PREFIX skos: " + "PREFIX rdf: " + "PREFIX owl: " + "PREFIX rdfs: " + "SELECT DISTINCT ?uri ?label " + "WHERE {{ " + "?uri a skos:Concept ; " + "skos:inScheme ; " + "skos:prefLabel ?label . " + "FILTER (lang(?label) = {lang}). " + "FILTER NOT EXISTS {{ [skos:narrower ?uri] }} " + "}} " + "ORDER BY ?label " + ) }, 'audiences': { 'url' : SPARQL_QUERY_ENDPOINT,