From 55d6f8d6f88758c20c83c2627412aa84fbd84ef0 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Wed, 2 Aug 2023 14:06:04 +0300 Subject: Update virtuoso upload steps Signed-off-by: Munyoki Kilyungi --- topics/systems/virtuoso.gmi | 17 +++++++++++------ 1 file changed, 11 insertions(+), 6 deletions(-) (limited to 'topics/systems/virtuoso.gmi') diff --git a/topics/systems/virtuoso.gmi b/topics/systems/virtuoso.gmi index 3c95517..2b2526c 100644 --- a/topics/systems/virtuoso.gmi +++ b/topics/systems/virtuoso.gmi @@ -191,23 +191,28 @@ $ isql SQL> DELETE FROM rdf_quad WHERE g = iri_to_id('http://genenetwork.org'); ``` -Use isql to register all the title files: +Also, make sure that the load list is empty before registering your turtle files. ``` -SQL> ld_dir('/var/lib/data', '*.ttl', 'http://genenetwork.org'); +DELETE FROM DB.DBA.load_list; ``` +Use isql to register all the turtle files: -You can check the table DB.DBA.load_list to check the list of datasets registered for loading.: +``` +SQL> ld_dir('/var/lib/data', '*.ttl', 'http://genenetwork.org'); +``` + +Note, for the prior step, you can specify a specific file instead of adding all the files using the wildcard "*". Here's an example of doing this: ``` -SQL> SELECT * FROM DB.DBA.load_list; +SQL> ld_dir('/var/lib/data', 'species.ttl', 'http://genenetwork.org'); ``` -In case you want to empty the list: +Check the table DB.DBA.load_list to see the list of registered files that will be loaded: ``` -DELETE FROM DB.DBA.load_list WHERE ll_file='*.ttl'; +SQL> SELECT * FROM DB.DBA.load_list; ``` Perform the bulk load of all data by running: -- cgit v1.2.3