Svenska Utegym Wikidata

#Utegym  check
#
from datetime import datetime
import urllib3
import sys
from SPARQLWrapper import SPARQLWrapper, JSON

endpoint_url = "https://query.wikidata.org/sparql"
http = urllib3.PoolManager()

# Check linkroot https://w.wiki/7nVi -->
# SPARQL
query = """SELECT ?wd ?wdLabel  ?oldURL WHERE {
  ?wd wdt:P6104  wd:Q107186275. #  Outdoor gyms
  ?wd wdt:P856 ?oldURL.
  ?wd wdt:P17 wd:Q34. # Sverige
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv". }
} 
"""


def get_results(endpoint_url, query):
    user_agent = "user:salgo60/%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()

''' Check if URLS is ok'''
def check(url,wd, wdLabel):
    try:
        r = http.request('GET', url)
    except Exception as e:
        print("\t\tError\t",str(e))
        return False
    if r.status != 200:
            print("Status: ",r.status, " \t", url, "\tWikidata: ", wd," - ", wdLabel)
            return False
    return True
start_time  = datetime.now()
print("Last run: ", start_time)
results = get_results(endpoint_url, query)
print ("Number records i Wikidata: " + str(len(results["results"]["bindings"])))

ok = 0
notok = 0
for result in results["results"]["bindings"]:
    #print(result)
    try:
        currentURL = result["oldURL"]["value"]
        wd = result["wd"]["value"]
        wdLabel = result["wdLabel"]["value"]
        if check(currentURL,wd, wdLabel):
            ok += 1
        else:
            notok += 1
    except Exception as error:
        print("An error occurred: ", wd, " - ", type(error).__name__) # An error occurred: NameError

procent = notok / (ok + notok) * 100
print("OK: ",ok,"\t not ok",notok,"\t procent problem", procent)

end = datetime.now()
print("Ended: ", end)
print('Time elapsed (hh:mm:ss.ms) {}'.format(datetime.now() - start_time))