sqlite related internal naming

1 files changed, 41 insertions, 3 deletions

diff --git a/.envrc-local_ b/.envrc-local_
index 318d7a7..8d9f54b 100644
--- a/.envrc-local_
+++ b/.envrc-local_
@@ -13,6 +13,7 @@ export SpineDOC=/grotto-ra/repo/git.repo/projects/project-spine/doc-reform-marku
 export SpinePOD=$SpineDOC/markup/pod
 export SpineOUTversioned=/srv/www/spine/$SpineVER
 export SpineOUT=/srv/www/spine
+export SpineDBpath=/var/www/sqlite
 
 echo '-*- mode: org -*-
 
@@ -173,8 +174,8 @@ $SpineBIN/spine -v --html --html-link-search --html-link-curate --curate  --outp
 *** create or re-create sql db (--sqlite-db-create or --sqlite-db-recreate)
 
 #+BEGIN_SRC sh
-$SpineBIN/spine -v --sqlite-db-create --sqlite-db-filename="spine.search.db" --output="$SpineOUT/"
-$SpineBIN/spine -v --sqlite-db-recreate --sqlite-db-filename="spine.search.db" --output="$SpineOUT/"
+$SpineBIN/spine -v --sqlite-db-create --sqlite-db-filename="spine.search.db" --sqlite-db-path="$SpineDBpath"
+$SpineBIN/spine -v --sqlite-db-recreate --sqlite-db-filename="spine.search.db" --sqlite-db-path="$SpineDBpath"
 #+END_SRC
 
 *** populate sqlite db
@@ -186,7 +187,44 @@ $SpineBIN/spine -v --sqlite-update --sqlite-db-filename="spine.search.db" --outp
 *** generate html (linked to search form), sql output, curate COMPOSITE
 
 #+BEGIN_SRC sh
-$SpineBIN/spine -v --html --html-link-search --html-link-curate --curate --sqlite-update --sqlite-db-filename="spine.search.db" --cgi-sqlite-search-filename="spine_search" --output="$SpineOUT" $SpinePOD/*
+$SpineBIN/spine -v --html --html-link-search --html-link-curate --curate --sqlite-update --sqlite-db-filename="spine.search.db" --cgi-sqlite-search-filename="spine_search" --sqlite-db-path="$SpineDBpath" --output="$SpineOUT" $SpinePOD/*
+#+END_SRC
+
+*** generate html (linked to search form), sql output, curate COMPOSITE with resource configuration
+
+if names and paths are configured in resource configuration file, e.g. $SpinePOD/.rc/config_local_site
+
+#+BEGIN_SRC sh
+$SpineBIN/spine -v --html --html-link-search --html-link-curate --curate --sqlite-update $SpinePOD/*
+#+END_SRC
+
+#+BEGIN_SRC yaml
+# sample resource configuration file ( $SpinePOD/.rc/config_local_site )
+output:
+  path:                        "/srv/www/spine"
+default:
+  language:                    "en"
+  papersize:                   "a4"
+  text_wrap:                   "80"
+  digest:                      "sha256"
+webserv:
+  http:                        "http"
+  domain:                      "localhost"
+  data_http:                   "http"
+  data_domain:                 "localhost"
+  data_root_url:               "https://sisudoc.org"
+  data_root_path:              "/srv/www/spine"
+  images_root_part:            "image"
+  cgi_title:                   "≅ SiSU Spine search"
+  cgi_http:                    "https"
+  cgi_domain:                  "sisudoc.org"
+  cgi_bin_url:                 "http://sisudoc.org/cgi-bin"
+  cgi_bin_part:                "cgi-bin"
+  cgi_bin_path:                "/var/www/cgi/cgi-bin"
+  cgi_search_script:           "spine_search"
+  cgi_action:                  "https://sisudoc.org/spine_search"
+  db_sqlite_filename:          "spine.search.db"
+  db_sqlite_path:              "/var/www/sqlite"
 #+END_SRC
 
 *** make search form