-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSPARQL_query.py
More file actions
75 lines (65 loc) · 2.47 KB
/
SPARQL_query.py
File metadata and controls
75 lines (65 loc) · 2.47 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
from difflib import SequenceMatcher
from SPARQLWrapper import SPARQLWrapper, XML
import re
from bs4 import BeautifulSoup
import requests
def _execute_query(query_string):
sparql = SPARQLWrapper("https://dbpedia.org/sparql")
sparql.setQuery(query_string)
sparql.setReturnFormat(XML)
try:
qres = sparql.query().convert()
except:
return None
results = qres.getElementsByTagName("uri")
if len(results) > 0:
return str(results[0].firstChild.nodeValue)
return None
def query(element):
query_string = "SELECT ?s WHERE {{?s rdfs:label \"" + element + "\"@en ;a owl:Thing .}}"
result = _execute_query(query_string)
if result is not None:
return _check_result(element, result)
else:
query_string = "SELECT ?s WHERE {{?altName rdfs:label \"" + element + "\"@en ;dbo:wikiPageRedirects ?s .}}"
result = _execute_query(query_string)
if result is not None:
return _check_result(element, result)
else:
"SELECT ?s WHERE {{?s rdfs:label \"" + element + "\"@en ;a skos:Concept .}}"
result = _execute_query(query_string)
if result is not None:
return _check_result(element, result)
else:
uri = _search_page(element)
if uri is not None:
return _check_result(element, str(uri))
else:
return None
return None
def _search_page(element):
headers = {
'Access-Control-Allow-Origin': '*',
'Access-Control-Allow-Methods': 'GET',
'Access-Control-Allow-Headers': 'Content-Type',
'Access-Control-Max-Age': '3600',
'User-Agent': 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0'
}
url = "https://dbpedia.org/page/Magical_creatures_in_Harry_Potter"
req = requests.get(url, headers)
soup = BeautifulSoup(req.content, 'lxml')
elements = soup.find_all('a')
exp = ".*:"+element+".*"
for element in elements:
if element.find(string=re.compile(exp)):
return element['href']
return None
def _similar(a, b):
return SequenceMatcher(None, a, b).ratio()
def _check_result(element, result):
sub_result = result.replace("http://dbpedia.org/resource/", "")
sub_result = sub_result.replace("_(Harry_Potter)", "")
if _similar(element, sub_result) >= 0.5:
return result
else:
return result + "#" + str(element).replace(" ", "_")