sqlite document db discrete & collection, started

- discrete document , drop & recreate document
  --sqlite-disctrete
- document collection
  - create tables
    --sqlite-create
  - populate db with specified document
    --sqlite-update

1 files changed, 33 insertions, 0 deletions

diff --git a/org/default_paths.org b/org/default_paths.org
index 49a43b7..ebb50bc 100644
--- a/org/default_paths.org
+++ b/org/default_paths.org
@@ -451,6 +451,39 @@ template SiSUpathsEPUB() {
 #+END_SRC
 
 ** _sqlite_                                                           :sqlite:
+*** discrete
+
+#+name: template_paths_sqlite
+#+BEGIN_SRC d
+template SiSUpathsSQLiteDiscrete() {
+  mixin SiSUrgxInit;
+  static auto rgx = Rgx();
+  auto SiSUpathsSQLiteDiscrete(Ps,Lng)(
+    Ps  src_pth_info,
+    Lng lng,
+  ) {
+    auto out_pth = SiSUoutPaths!()(src_pth_info, lng);
+    string base_dir = "sqlite";
+    struct _PathsStruct {
+      string base_filename(string fn_src) {
+        return fn_src.baseName.stripExtension;
+      }
+      string base() {
+        return (out_pth.output_base).chainPath(base_dir).array;
+      }
+      string seg(string fn_src) {
+        return base.chainPath(base_filename(fn_src)).array;
+      }
+      string sqlite_file(string fn_src) {
+        return base.chainPath(base_filename(fn_src) ~ ".sqlite").array;
+      }
+    }
+    return _PathsStruct();
+  }
+}
+#+END_SRC
+
+*** TODO collection
 
 #+name: template_paths_sqlite
 #+BEGIN_SRC d