summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2024-10-15 20:11:28 +0300
committerMunyoki Kilyungi2024-10-15 20:14:33 +0300
commit1308102cdbb37a6a60023904ec9ad315104b3bd5 (patch)
treea888a75a5baf97868e474a15350858525469ce3d
parentbfb5a69703ccba5ca9df43e5a026c0cc79d77262 (diff)
downloadgn-gemtext-1308102cdbb37a6a60023904ec9ad315104b3bd5.tar.gz
Create new issue.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rw-r--r--issues/rdf/automate-rdf-generation-and-ingress.gmi37
-rw-r--r--issues/set-up-gn-guile-in-tux02.gmi1
2 files changed, 38 insertions, 0 deletions
diff --git a/issues/rdf/automate-rdf-generation-and-ingress.gmi b/issues/rdf/automate-rdf-generation-and-ingress.gmi
new file mode 100644
index 0000000..04c7a08
--- /dev/null
+++ b/issues/rdf/automate-rdf-generation-and-ingress.gmi
@@ -0,0 +1,37 @@
+# Update RDF Generation and Ingress to Virtuoso
+
+## Tags
+
+* assigned: bonfacem
+* priority: high
+* tags: in-progress
+* deadline: 2024-10-18 Fri
+
+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.
diff --git a/issues/set-up-gn-guile-in-tux02.gmi b/issues/set-up-gn-guile-in-tux02.gmi
index 2ac0cd6..d302d68 100644
--- a/issues/set-up-gn-guile-in-tux02.gmi
+++ b/issues/set-up-gn-guile-in-tux02.gmi
@@ -5,6 +5,7 @@
* assigned: bonfacem
* priority: high
* status: in-progress
+* deadline: 2024-10-18 Fri
## Tasks