summaryrefslogtreecommitdiff
path: root/issues/rdf/automate-rdf-generation-and-ingress.gmi
blob: ef4ba9fd767c1615a62e8e02fa9a0cea6912cdf7 (about) (plain)
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
# Update RDF Generation and Ingress to Virtuoso

## Tags

* assigned: bonfacem
* priority: high
* tags: in-progress
* deadline: 2024-10-23 Wed

We need to update Virtuoso in production.  At the moment this is done manually.  For the current set-up, we need to update the recent modified RIF+WIKI models:


```
# Generate the RDF triples
time guix shell guile-dbi guile-hashing -m manifest.scm -- ./pre-inst-env ./examples/generif.scm --settings conf.scm --output /home/bonfacem/ttl-files/generif-metadata-new.ttl --documentation ./docs/generif-metadata.md

# Make sure they are valid
guix shell -m manifest.scm -- rapper --input turtle --count /home/bonfacem/ttl-files/generif-metadata-new.ttl

# Copy the files over to the exposed virtuoso path
cp /home/bonfacem/ttl-files/generif-metadata-new.ttl </some/dir/>

# Get into Virtuoso (with a password)
guix shell virtuoso-ose -- isql <port-number>

# Load the files to be loaded
# Assuming that '/var/lib/data' is where the files are
ld_dir('/var/lib/data', 'generif-metadata-new.ttl', 'http://genenetwork.org');

# Load the files
rdf_loader_run();
CHECKPOINT;
```

Above steps should be automated and tested in CD before roll-out in production.  Key considerations:

- Pick latest important changes from git, so that we can pick what files to run instead of generating all the ttl files all the time.