From ae968985ebc6799f4fa08d671fbe52118bf9af0e Mon Sep 17 00:00:00 2001
From: Ralph Amissah <ralph.amissah@gmail.com>
Date: Sat, 11 Apr 2020 20:54:48 -0400
Subject: trust more, else minor

---
 org/out_sqlite.org | 30 +++++++++++++-----------------
 1 file changed, 13 insertions(+), 17 deletions(-)

(limited to 'org/out_sqlite.org')

diff --git a/org/out_sqlite.org b/org/out_sqlite.org
index b5c2532..77172e2 100644
--- a/org/out_sqlite.org
+++ b/org/out_sqlite.org
@@ -147,10 +147,6 @@ template SQLiteDbRun() {
         db_statement ~
         "\nCOMMIT;\n"
       );
-      if (!(opt_action.sqlite_discrete)
-        && !(opt_action.sqlite_db_create)
-      ) {
-      }
     } catch (ErrnoException ex) {
       writeln("ERROR SQLite : ", ex);
     } catch (Exception ex) {
@@ -363,8 +359,8 @@ template SQLiteDbDrop() {
 #+NAME: sqlite_db_statement_composite_collection
 #+BEGIN_SRC d
 {
-  string _db_statement;
   {
+    string _db_statement;
     if ((doc_matters.opt.action.sqlite_db_create)) {
       auto pth_sqlite = spinePathsSQLite!()(doc_matters.sqlite.filename, doc_matters.output_path);
       pth_sqlite.base.mkdirRecurse;
@@ -394,8 +390,8 @@ template SQLiteDbDrop() {
 #+NAME: sqlite_db_statement_composite_discrete
 #+BEGIN_SRC d
 {
-  string _db_statement;
   {
+    string _db_statement;
     _db_statement ~= SQLiteTablesReCreate!()();
     _db_statement ~= SQLiteInsertMetadata!()(doc_matters);
     _db_statement ~= doc_abstraction.SQLiteInsertDocObjectsLoop!()(doc_matters);
@@ -1059,7 +1055,7 @@ string html_table(M,O)(
   _txt = t[0];
   string _note = t[1];
   string o = format(q"┃<p class="%s">
-    <table summary="normal text css" width="95%%" border="0" bgcolor="white" cellpadding="2" align="center">
+    <table summary="normal text css" width="95%%" border="0" cellpadding="2" align="center">
       %s
     </table>
     %s
@@ -1105,7 +1101,7 @@ string sqlite_statement(O)(
         string     _html,
 ) {
   void _sql_exe(O)(
-    string                   _sql,
+    string _sql,
   ) {
     writeln(_html);
     writeln(_sql);
@@ -1716,16 +1712,16 @@ CREATE TABLE doc_objects (
 
 #+NAME: sqlite_statement_create_index
 #+BEGIN_SRC sql
-CREATE INDEX idx_ocn ON doc_objects(ocn);
+CREATE INDEX idx_ocn          ON doc_objects(ocn);
 CREATE INDEX idx_digest_clean ON doc_objects(digest_clean);
-CREATE INDEX idx_digest_all ON doc_objects(digest_all);
-CREATE INDEX idx_clean ON doc_objects(clean);
-CREATE INDEX idx_title ON metadata_and_text(title);
-CREATE INDEX idx_author ON metadata_and_text(creator_author_last_first);
-CREATE INDEX idx_uid ON metadata_and_text(uid);
-CREATE INDEX idx_filename ON metadata_and_text(src_filename_base);
-CREATE INDEX idx_language ON metadata_and_text(language_document_char);
-CREATE INDEX idx_topics ON metadata_and_text(classify_topic_register);
+CREATE INDEX idx_digest_all   ON doc_objects(digest_all);
+CREATE INDEX idx_clean        ON doc_objects(clean);
+CREATE INDEX idx_title        ON metadata_and_text(title);
+CREATE INDEX idx_author       ON metadata_and_text(creator_author_last_first);
+CREATE INDEX idx_uid          ON metadata_and_text(uid);
+CREATE INDEX idx_filename     ON metadata_and_text(src_filename_base);
+CREATE INDEX idx_language     ON metadata_and_text(language_document_char);
+CREATE INDEX idx_topics       ON metadata_and_text(classify_topic_register);
 #+END_SRC
 
 *** TODO local site link & info
-- 
cgit v1.2.3