salgo60/Kulturnav_Wikidata.py

## Kulturnav_Wikidata.py
#Get dataset for Wikidata objects in kulturnav
# pip install sparqlwrapper
# https://rdflib.github.io/sparqlwrapper/
import json,requests
import sys

from SPARQLWrapper import SPARQLWrapper, JSON

endpoint_url = "https://query.wikidata.org/sparql"

query = """
SELECT distinct  ?person ?personLabel ?kulturnav WHERE {
  ?person wdt:P31 wd:Q5;
    wdt:P106 wd:Q33231.
  ?person wdt:P27 wd:Q34.
  {?person p:P1248 ?knavP
  minus {?knavP pq:P972 ?kat}.
  ?person wdt:P1248 ?kulturnav}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sv". }
} """


def get_results(endpoint_url, query):
    user_agent = "KulturnavAgents/%s.%s" % (sys.version_info[0], sys.version_info[1])

    sparql = SPARQLWrapper(endpoint_url, agent=user_agent)
    sparql.setQuery(query)
    sparql.setReturnFormat(JSON)
    return sparql.query().convert()


results = get_results(endpoint_url, query)

for result in results["results"]["bindings"]:
    wd = result["person"]["value"]
    kulturnav = result["kulturnav"]["value"]
    url = "https://kulturnav.org/" + result["kulturnav"]["value"] + ".json"
    try:
        r = requests.get(url=url)
        data = r.json()
        katalog = data["properties"]["entity.dataset"][0]["displayValue"]["sv"]
        print(wd,"|",kulturnav,"|",katalog)
    except:
        print ("Error ",wd)
	#Get dataset for Wikidata objects in kulturnav
	# pip install sparqlwrapper
	# https://rdflib.github.io/sparqlwrapper/
	import json,requests
	import sys

	from SPARQLWrapper import SPARQLWrapper, JSON

	endpoint_url = "https://query.wikidata.org/sparql"

	query = """
	SELECT distinct ?person ?personLabel ?kulturnav WHERE {
	?person wdt:P31 wd:Q5;
	wdt:P106 wd:Q33231.
	?person wdt:P27 wd:Q34.
	{?person p:P1248 ?knavP
	minus {?knavP pq:P972 ?kat}.
	?person wdt:P1248 ?kulturnav}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "sv". }
	} """


	def get_results(endpoint_url, query):
	user_agent = "KulturnavAgents/%s.%s" % (sys.version_info[0], sys.version_info[1])

	sparql = SPARQLWrapper(endpoint_url, agent=user_agent)
	sparql.setQuery(query)
	sparql.setReturnFormat(JSON)
	return sparql.query().convert()


	results = get_results(endpoint_url, query)

	for result in results["results"]["bindings"]:
	wd = result["person"]["value"]
	kulturnav = result["kulturnav"]["value"]
	url = "https://kulturnav.org/" + result["kulturnav"]["value"] + ".json"
	try:
	r = requests.get(url=url)
	data = r.json()
	katalog = data["properties"]["entity.dataset"][0]["displayValue"]["sv"]
	print(wd,"\|",kulturnav,"\|",katalog)
	except:
	print ("Error ",wd)