Skip to content
GitLab
Explore
Sign in
Primary navigation
Search or go to…
Project
A
ArtGuide
Manage
Activity
Members
Labels
Plan
Issues
Issue boards
Milestones
Wiki
Requirements
Code
Merge requests
Repository
Branches
Commits
Tags
Repository graph
Compare revisions
Snippets
Locked files
Build
Pipelines
Jobs
Pipeline schedules
Test cases
Artifacts
Deploy
Releases
Package registry
Container registry
Model registry
Operate
Environments
Terraform modules
Monitor
Incidents
Analyze
Value stream analytics
Contributor analytics
CI/CD analytics
Repository analytics
Code review analytics
Issue analytics
Insights
Model experiments
Help
Help
Support
GitLab documentation
Compare GitLab plans
Community forum
Contribute to GitLab
Provide feedback
Keyboard shortcuts
?
Snippets
Groups
Projects
Show more breadcrumbs
Quentin Ulmer
ArtGuide
Merge requests
!2
- sparql_view implementation
Code
Review changes
Check out branch
Download
Patches
Plain diff
Closed
- sparql_view implementation
4/backend-skeleton
into
Dev
Overview
0
Commits
1
Pipelines
0
Changes
1
Closed
Quentin Ulmer
requested to merge
4/backend-skeleton
into
Dev
11 months ago
Overview
0
Commits
1
Pipelines
0
Changes
1
Expand
updated sparql_views.py
0
0
Merge request reports
Compare
Dev
version 2
7298bfc5
11 months ago
version 1
8e30182e
11 months ago
Dev (base)
and
latest version
latest version
7298bfc5
1 commit,
11 months ago
version 2
7298bfc5
1 commit,
11 months ago
version 1
8e30182e
2 commits,
11 months ago
1 file
+
34
−
42
Side-by-side
Compare changes
Side-by-side
Inline
Show whitespace changes
Show one file at a time
artguide_backend/sparql_views.py
+
34
−
42
Options
@@ -5,46 +5,38 @@ from SPARQLWrapper import SPARQLWrapper, JSON
@@ -5,46 +5,38 @@ from SPARQLWrapper import SPARQLWrapper, JSON
import
os
import
os
import
json
import
json
def
sparql_query
(
request
):
def
sparql_query
(
request
):
"""
"""
This function executes a SPARQL query and returns the results in JSON format.
This function executes a SPARQL query received from the frontend and returns the results in JSON format.
The SPARQL endpoint is read from the environment variables. (set in Docker-compose)
The SPARQL endpoint is read from the environment variables. (set in Docker-compose)
"""
"""
sparql_endpoint
=
'
http://fuseki:3030/data/query
'
sparql_endpoint
=
'
http://fuseki:3030/data/query
'
sparql
=
SPARQLWrapper
(
sparql_endpoint
)
sparql
=
SPARQLWrapper
(
sparql_endpoint
)
sparql
.
setReturnFormat
(
JSON
)
sparql
.
setReturnFormat
(
JSON
)
sparql
.
setQuery
(
"""
try
:
PREFIX : <http://h-da.de/fbi/art/>
# Extract SPARQL query from POST request
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
body
=
json
.
loads
(
request
.
body
)
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
sparql_query
=
body
.
get
(
'
query
'
,
''
)
PREFIX wd: <http://www.wikidata.org/entity/>
if
not
sparql_query
:
SELECT ?g ?db ?dd ?pb ?pd
return
JsonResponse
({
"
error
"
:
"
No query provided
"
},
status
=
400
)
WHERE {
?p a :person ;
sparql
.
setQuery
(
sparql_query
)
rdfs:label
"
Michelangelo
"
;
:gender ?g;
response
=
sparql
.
query
().
convert
()
:date_of_birth ?db;
:date_of_death ?dd ;
# Log the raw response for debugging
:place_of_death ?pd .
if
isinstance
(
response
,
bytes
):
}
raw_response
=
response
.
decode
(
'
utf-8
'
)
"""
)
else
:
raw_response
=
response
try
:
print
(
"
Raw response:
"
,
raw_response
)
# Debugging output
response
=
sparql
.
query
().
convert
()
# Log the raw response for debugging
# Ensure the response is properly decoded
if
isinstance
(
response
,
bytes
):
if
isinstance
(
response
,
bytes
):
raw_response
=
response
.
decode
(
'
utf-8
'
)
response
=
json
.
loads
(
response
.
decode
(
'
utf-8
'
))
else
:
results
=
response
.
get
(
"
results
"
,
{}).
get
(
"
bindings
"
,
[])
raw_response
=
response
return
JsonResponse
(
results
,
safe
=
False
)
print
(
"
Raw response:
"
,
raw_response
)
# Debugging output
except
Exception
as
e
:
return
JsonResponse
({
"
error
"
:
str
(
e
)},
status
=
500
)
# Ensure the response is properly decoded
if
isinstance
(
response
,
bytes
):
response
=
json
.
loads
(
response
.
decode
(
'
utf-8
'
))
results
=
response
.
get
(
"
results
"
,
{}).
get
(
"
bindings
"
,
[])
return
JsonResponse
(
results
,
safe
=
False
)
except
Exception
as
e
:
return
JsonResponse
({
"
error
"
:
str
(
e
)},
status
=
500
)
Loading