summaryrefslogtreecommitdiff
path: root/topics/systems
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-04-05 16:10:48 +0300
committerMunyoki Kilyungi2023-04-05 16:10:48 +0300
commit2311355ad22b008731ab89560366ff29201c1c88 (patch)
treed77cc0a9419e3da7cc08c220149496f957ffc698 /topics/systems
parent9a9455aa7df4bd92583f3caec6afbe2ccbbb7fda (diff)
downloadgn-gemtext-2311355ad22b008731ab89560366ff29201c1c88.tar.gz
Document how to use load-rdf.scm script to upload data
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'topics/systems')
-rw-r--r--topics/systems/virtuoso.gmi16
1 files changed, 15 insertions, 1 deletions
diff --git a/topics/systems/virtuoso.gmi b/topics/systems/virtuoso.gmi
index 953fc26..b85ab86 100644
--- a/topics/systems/virtuoso.gmi
+++ b/topics/systems/virtuoso.gmi
@@ -152,10 +152,24 @@ SQL> DELETE FROM rdf_quad WHERE g = iri_to_id('http://example.org');
When virtuoso has just been started up with a clean state (that is, the virtuoso state directory was empty before virtuoso started), uploading large amounts of data using the SPARQL 1.1 Graph Store HTTP Protocol fails the first time. It succeeds only the second time. It is not clear why. I can only recommend retrying as in this commit:
-=>https://github.com/genenetwork/dump-genenetwork-database/commit/8f60fde7f5499e5ffe352d7ae98a2de34a91b89f
+=> https://github.com/genenetwork/dump-genenetwork-database/commit/8f60fde7f5499e5ffe352d7ae98a2de34a91b89f
Retry uploading to virtuoso (commit from dump-genenetwork-database repo)
formerly (https://git.genenetwork.org/arunisaac/dump-genenetwork-database/commit/8f60fde7f5499e5ffe352d7ae98a2de34a91b89f)
+### Using load-rdf.scm script
+
+You can use the following script to upload data in rdf.
+
+=> https://github.com/genenetwork/dump-genenetwork-database/blob/master/load-rdf.scm load-rdf.scm
+
+This script first clears the database before uploading data. To run it:
+
+```
+guix shell -N virtuoso-ose -m manifest.scm -- ./pre-inst-env ./load-rdf.scm conn.scm dump.ttl
+```
+
+=> https://github.com/genenetwork/dump-genenetwork-database/blob/master/conn.scm Example conn.scm
+
## Dumping to RDF from the GeneNetwork MySQL database
See also