diff options
| author | Ralph Amissah <ralph.amissah@gmail.com> | 2020-04-11 20:54:48 -0400 |
|---|---|---|
| committer | Ralph Amissah <ralph.amissah@gmail.com> | 2020-05-20 11:27:26 -0400 |
| commit | ae968985ebc6799f4fa08d671fbe52118bf9af0e (patch) | |
| tree | b2478a672f99cb1ac4e6ed6040be70e1884bea87 /org/out_sqlite.org | |
| parent | syntax highlighting, start work, based on sisu.rb (diff) | |
trust more, else minor
Diffstat (limited to 'org/out_sqlite.org')
| -rw-r--r-- | org/out_sqlite.org | 30 |
1 files changed, 13 insertions, 17 deletions
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 |