diff options
author | Munyoki Kilyungi | 2023-08-02 14:06:04 +0300 |
---|---|---|
committer | Munyoki Kilyungi | 2023-08-02 14:06:04 +0300 |
commit | 55d6f8d6f88758c20c83c2627412aa84fbd84ef0 (patch) | |
tree | dc891a34df2af1fc37abe213e2f7c86db43d86bd | |
parent | b125ad1083abf10adf0cde035638bd81397bd4db (diff) | |
download | gn-gemtext-55d6f8d6f88758c20c83c2627412aa84fbd84ef0.tar.gz |
Update virtuoso upload steps
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rw-r--r-- | topics/systems/virtuoso.gmi | 17 |
1 files changed, 11 insertions, 6 deletions
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: |