From 169ea6885f073af851a6ac2166b81f5068c6ef3e Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Tue, 22 Apr 2025 16:39:13 +0300 Subject: Add function to delete wiki entries by wiki_id. * delete_wiki_entries_by_id: New function. Signed-off-by: Munyoki Kilyungi --- gn3/db/rdf/wiki.py | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'gn3/db/rdf/wiki.py') diff --git a/gn3/db/rdf/wiki.py b/gn3/db/rdf/wiki.py index 18d086d..309da73 100644 --- a/gn3/db/rdf/wiki.py +++ b/gn3/db/rdf/wiki.py @@ -328,3 +328,31 @@ FROM $graph WHERE { ) results["data"] = data return results + + +def delete_wiki_entries_by_id( + wiki_id: int, + sparql_user: str, + sparql_password: str, + sparql_auth_uri: str, + graph: str = "", +) -> str: + """Delete all wiki entries associated with a given ID.""" + query = Template( + """ +$prefix + +DELETE WHERE { + GRAPH $graph { + ?comment dct:identifier \"$wiki_id\"^^xsd:integer . + ?comment ?p ?o . + } +} +""" + ).substitute(prefix=RDF_PREFIXES, graph=graph, wiki_id=wiki_id) + return update_rdf( + query=query, + sparql_user=sparql_user, + sparql_password=sparql_password, + sparql_auth_uri=sparql_auth_uri, + ) -- cgit 1.4.1