Help
Difference between revisions of "SPARQL/test"
< Help:SPARQLThis page is a temporary demo showcasting new support for Wikidata Query Service.
(→Issue) |
|||
| Line 95: | Line 95: | ||
According to [[:commons:Commons:SPARQL_query_service#Release_notes]] : | According to [[:commons:Commons:SPARQL_query_service#Release_notes]] : | ||
:''OAuth is currently not working. See https://stackoverflow.com/questions/65303450/how-to-authenticate-to-wikimedia-commons-query-service-using-oauth-in-python#comment115828158_65424900. This is so that we can contact abusive bots and/or users and block them selectively as a last resort if needed.'' | :''OAuth is currently not working. See https://stackoverflow.com/questions/65303450/how-to-authenticate-to-wikimedia-commons-query-service-using-oauth-in-python#comment115828158_65424900. This is so that we can contact abusive bots and/or users and block them selectively as a last resort if needed.'' | ||
| + | |||
| + | See also [[:phab:T297995]]. | ||
== References == | == References == | ||
Revision as of 12:51, 22 March 2023
Lingualibre
#defaultEndpoint:Lingualibre
SELECT
(COUNT(DISTINCT ?speaker) AS ?speakers)
(COUNT(DISTINCT ?record) AS ?records)
WHERE {
?record prop:P2 entity:Q2 .
?record prop:P6 ?date .
?record prop:P5 ?speaker .
# Filters:
FILTER(?date >= "2018-07-01T00:00:00Z"^^xsd:dateTime)
FILTER(?date < "2019-01-01T00:00:00Z"^^xsd:dateTime)
}
|
|
Wikidata
To run on WDQS.[1]
#defaultEndpoint:Wikidata
SELECT DISTINCT ?item ?itemLabel
WHERE {
?item p:P31 ?statement0.
?statement0 (ps:P31/(wdt:P279*)) wd:Q34228.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
|
|
Commons
To run on WCQS.[2]
#defaultEndpoint:Commons
SELECT ?item
WHERE {
?item wdt:P31 wd:Q108167708 . # Filter: P31 'instance of' Q108167708 'record'
?item wdt:P407 wd:Q1860 . # Filter: P407 'language' is Q1860 'English'
?item wdt:P9533 "apple"@en. # Filter: P9533 'transcription' is "apple"
}
|
|
Issue
Wikimedia Commons Query Service's end point rejects external queries :
- Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://commons.wikimedia.org/wiki/Special:OAuth/authenticate?oauth_token=b0685605ac44eb315c2571d1a0fb43db. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 302.
According to commons:Commons:SPARQL_query_service#Release_notes :
- OAuth is currently not working. See https://stackoverflow.com/questions/65303450/how-to-authenticate-to-wikimedia-commons-query-service-using-oauth-in-python#comment115828158_65424900. This is so that we can contact abusive bots and/or users and block them selectively as a last resort if needed.
See also phab:T297995.