Skip to content

Draft: redirect fra publicationid til ciceroId (tnr)

Petter Goksøyr Åsen requested to merge pubid2tnr into master 
cat > q.sparql <<EOF
PREFIX : <http://data.deichman.no/ontology#>
WITH <https://katalog.deichman.no>
SELECT
    REPLACE(STR(?p), "http://data.deichman.no/publication/", "") AS ?id,
    ?tnr
WHERE {
    ?p a :Publication ;
        :recordId ?tnr
    FILTER NOT EXISTS { ?p :deleted ?deleted }
}
EOF

curl -H "Accept:text/csv" -XPOST  http://virtuoso.local/sparql -F query=@q.sparql > ids.csv

docker cp ids.csv deich2-euler2-1:/data/
docker exec -it deich2-euler2-1 bash
cd /data
sqlite3 deichman.db
sqlite> CREATE TABLE publication (
    id  TEXT PRIMARY KEY,
    tnr TEXT NOT NULL
);
sqlite> .import --csv --skip 1 ids.csv publication
sqlite> SELECT count(*) FROM publication;
311824
sqlite> .quit

Merge request reports