Project:RedirectionScript: Difference between revisions

From MaRDI portal
Created page with "Test"
 
No edit summary
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
Test
== SPARQL queries ==
 
=== Count number of items that redirect to another item ===
<syntaxhighlight lang="sparql">
SELECT (COUNT (DISTINCT ?o) AS ?count)
WHERE
{
  ?o owl:sameAs ?sa .
}
 
</syntaxhighlight>
 
=== Get mapping of original items to the ones they were redirected to ===
<syntaxhighlight lang="sparql">
SELECT DISTINCT ?o ?sa
WHERE
{
  ?o owl:sameAs ?sa .
}
</syntaxhighlight>
 
=== Get all items that redirect to somewhere else and are still referenced in another item ===
Exclude those without a label to exclude other reference pages<syntaxhighlight lang="sparql">
SELECT DISTINCT ?o
WHERE
{
  ?o owl:sameAs ?sa .
  ?new ?p ?o .
  ?o rdfs:label ?label .
}
</syntaxhighlight>
 
== Script ==
https://github.com/MaRDI4NFDI/docker-importer/blob/main/bot_scripts/reroute.py
 
The script takes as input a csv file with the output of the second sparql query that maps old ids to new ids.

Latest revision as of 10:38, 14 March 2024

SPARQL queries

Count number of items that redirect to another item

SELECT (COUNT (DISTINCT ?o) AS ?count)
WHERE
{
   ?o owl:sameAs ?sa .
}

Get mapping of original items to the ones they were redirected to

SELECT DISTINCT ?o ?sa
WHERE
{
  ?o owl:sameAs ?sa .
}

Get all items that redirect to somewhere else and are still referenced in another item

Exclude those without a label to exclude other reference pages

SELECT DISTINCT ?o 
WHERE
{
  ?o owl:sameAs ?sa .
  ?new ?p ?o .
  ?o rdfs:label ?label .
}

Script

https://github.com/MaRDI4NFDI/docker-importer/blob/main/bot_scripts/reroute.py

The script takes as input a csv file with the output of the second sparql query that maps old ids to new ids.