aboutsummaryrefslogtreecommitdiffhomepage
path: root/org/output_sqlite.org
diff options
context:
space:
mode:
authorRalph Amissah <ralph@amissah.com>2017-09-07 16:54:23 -0400
committerRalph Amissah <ralph@amissah.com>2019-04-10 15:14:14 -0400
commit4ff01a81f048c0b496cc03627324b69b7aebd368 (patch)
treeacc9ff9a86b696b294980ef051de56c95bd9a045 /org/output_sqlite.org
parentsqlite, introduced, far to go (diff)
0.19.0 conf make meta, composite struct, instead of associative array
* remove conf make meta associative arrays, including native doc header (which revisit)
Diffstat (limited to 'org/output_sqlite.org')
-rw-r--r--org/output_sqlite.org151
1 files changed, 75 insertions, 76 deletions
diff --git a/org/output_sqlite.org b/org/output_sqlite.org
index d3f6745..2ae42ef 100644
--- a/org/output_sqlite.org
+++ b/org/output_sqlite.org
@@ -815,82 +815,81 @@ either:
#+name: sqlite_insert_metadata_and_src_text
#+BEGIN_SRC d
-insert_metadata.bind(":title", doc_matters.dochead_meta["title"]["full"]);
-// insert_metadata.bind(":title_main", doc_matters.dochead_meta["title"]["full"]);
-// insert_metadata.bind(":title_sub", doc_matters.dochead_meta["title"][""]);
-// insert_metadata.bind(":title_short", doc_matters.dochead_meta["title"][""]);
-// insert_metadata.bind(":title_edition", doc_matters.dochead_meta["title"][""]);
-// insert_metadata.bind(":title_note", doc_matters.dochead_meta["title"][""]);
-// insert_metadata.bind(":title_language", doc_matters.dochead_meta["title"][""]);
-// insert_metadata.bind(":title_language_char", doc_matters.dochead_meta["title"][""]);
-insert_metadata.bind(":creator_author", doc_matters.dochead_meta["creator"]["author"]);
-// insert_metadata.bind(":creator_author_hon", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_author_nationality", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_editor", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_contributor", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_illustrator", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_photographer", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_translator", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_prepared_by", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_digitized_by", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_audio", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":creator_video", doc_matters.dochead_meta["creator"][""]);
-// insert_metadata.bind(":language_document", doc_matters.dochead_meta["language"][""]);
-// insert_metadata.bind(":language_document_char", doc_matters.dochead_meta["language"][""]);
-// insert_metadata.bind(":language_original", doc_matters.dochead_meta["language"][""]);
-// insert_metadata.bind(":language_original_char", doc_matters.dochead_meta["language"][""]);
-// insert_metadata.bind(":date_added_to_site", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_available", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_created", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_issued", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_modified", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_published", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_valid", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_translated", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_original_publication", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":date_generated", doc_matters.dochead_meta["date"][""]);
-// insert_metadata.bind(":publisher", doc_matters.dochead_meta["publisher"][""]);
-// insert_metadata.bind(":original_publisher", doc_matters.dochead_meta["original"][""]);
-// insert_metadata.bind(":original_language", doc_matters.dochead_meta["original"][""]);
-// insert_metadata.bind(":original_language_char", doc_matters.dochead_meta["original"][""]);
-// insert_metadata.bind(":original_source", doc_matters.dochead_meta["original"][""]);
-// insert_metadata.bind(":original_institution", doc_matters.dochead_meta["original"][""]);
-// insert_metadata.bind(":original_nationality", doc_matters.dochead_meta["original"][""]);
-// insert_metadata.bind(":rights", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_text", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_translation", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_illustrations", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_photographs", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_preparation", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_digitization", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_audio", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_copyright_video", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":rights_license", doc_matters.dochead_meta["rights"][""]);
-// insert_metadata.bind(":identifier_oclc", doc_matters.dochead_meta["identifier"][""]);
-// insert_metadata.bind(":identifier_isbn", doc_matters.dochead_meta["identifier"][""]);
-// insert_metadata.bind(":classify_topic_register", doc_matters.dochead_meta["classify"][""]);
-// insert_metadata.bind(":classify_subject", doc_matters.dochead_meta["classify"][""]);
-// insert_metadata.bind(":classify_loc", doc_matters.dochead_meta["classify"][""]);
-// insert_metadata.bind(":classify_loc", doc_matters.dochead_meta["classify"][""]);
-// insert_metadata.bind(":notes_abstract", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_description", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_comment", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_coverage", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_relation", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_history", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_type", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_format", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_prefix", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_prefix_a", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_prefix_b", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":notes_suffix", doc_matters.dochead_meta["notes"][""]);
-// insert_metadata.bind(":src_filename", doc_matters.dochead_meta["src"][""]);
-// insert_metadata.bind(":src_fingerprint", doc_matters.dochead_meta["src"][""]);
-// insert_metadata.bind(":src_filesize", doc_matters.dochead_meta["src"][""]);
-// insert_metadata.bind(":src_wordcount", doc_matters.dochead_meta["src"][""]);
-// insert_metadata.bind(":src_text", doc_matters.dochead_meta["src"][""]);
-// insert_metadata.bind(":fulltext", doc_matters.dochead_meta["fulltext"][""]);
-// insert_metadata.bind(":links", doc_matters.dochead_meta["links"][""]);
+insert_metadata.bind(":title", doc_matters.conf_make_meta.meta.title_full);
+// insert_metadata.bind(":title_main", doc_matters.conf_make_meta.meta.title_main);
+// insert_metadata.bind(":title_sub", doc_matters.conf_make_meta.meta.title_subtitle);
+// insert_metadata.bind(":title_short", doc_matters.conf_make_meta.meta.title_short); //
+// insert_metadata.bind(":title_edition", doc_matters.conf_make_meta.meta.title_edition);
+// insert_metadata.bind(":title_note", doc_matters.conf_make_meta.meta.title_note);
+// insert_metadata.bind(":title_language", doc_matters.conf_make_meta.meta.title_language);
+// insert_metadata.bind(":title_language_char", doc_matters.conf_make_meta.meta.title_language_char);
+insert_metadata.bind(":creator_author", doc_matters.conf_make_meta.meta.creator_author);
+// insert_metadata.bind(":creator_author_hon", doc_matters.conf_make_meta.meta.creator_author_hon);
+// insert_metadata.bind(":creator_author_nationality", doc_matters.conf_make_meta.meta.creator_author_nationality);
+// insert_metadata.bind(":creator_editor", doc_matters.conf_make_meta.meta.creator_editor);
+// insert_metadata.bind(":creator_contributor", doc_matters.conf_make_meta.meta.creator_contributor);
+// insert_metadata.bind(":creator_illustrator", doc_matters.conf_make_meta.meta.creator_illustrator);
+// insert_metadata.bind(":creator_photographer", doc_matters.conf_make_meta.meta.creator_photographer);
+// insert_metadata.bind(":creator_translator", doc_matters.conf_make_meta.meta.creator_translator);
+// insert_metadata.bind(":creator_prepared_by", doc_matters.conf_make_meta.meta.creator_prepared_by);
+// insert_metadata.bind(":creator_digitized_by", doc_matters.conf_make_meta.meta.creator_digitized_by);
+// insert_metadata.bind(":creator_audio", doc_matters.conf_make_meta.meta.creator_audio);
+// insert_metadata.bind(":creator_video", doc_matters.conf_make_meta.meta.creator_video);
+// insert_metadata.bind(":language_document", doc_matters.conf_make_meta.meta.language_document);
+// insert_metadata.bind(":language_document_char", doc_matters.conf_make_meta.meta.language_document_char);
+// insert_metadata.bind(":language_original", doc_matters.conf_make_meta.meta.language_original);
+// insert_metadata.bind(":language_original_char", doc_matters.conf_make_meta.meta.language_original_char);
+// insert_metadata.bind(":date_added_to_site", doc_matters.conf_make_meta.meta.date_added_to_site);
+// insert_metadata.bind(":date_available", doc_matters.conf_make_meta.meta.date_available);
+// insert_metadata.bind(":date_created", doc_matters.conf_make_meta.meta.date_created);
+// insert_metadata.bind(":date_issued", doc_matters.conf_make_meta.meta.date_issued);
+// insert_metadata.bind(":date_modified", doc_matters.conf_make_meta.meta.date_modified);
+// insert_metadata.bind(":date_published", doc_matters.conf_make_meta.meta.date_published);
+// insert_metadata.bind(":date_valid", doc_matters.conf_make_meta.meta.date_valid);
+// insert_metadata.bind(":date_translated", doc_matters.conf_make_meta.meta.date_translated);
+// insert_metadata.bind(":date_original_publication", doc_matters.conf_make_meta.meta.date_original_publication);
+// insert_metadata.bind(":date_generated", doc_matters.conf_make_meta.meta.date_generated);
+// insert_metadata.bind(":publisher", doc_matters.conf_make_meta.meta.publisher));
+// insert_metadata.bind(":original_publisher", doc_matters.conf_make_meta.meta.original_publisher);
+// insert_metadata.bind(":original_language", doc_matters.conf_make_meta.meta.original_language);
+// insert_metadata.bind(":original_language_char", doc_matters.conf_make_meta.meta.original_language_char);
+// insert_metadata.bind(":original_source", doc_matters.conf_make_meta.meta.original_source);
+// insert_metadata.bind(":original_institution", doc_matters.conf_make_meta.meta.original_institution);
+// insert_metadata.bind(":original_nationality", doc_matters.conf_make_meta.meta.original_nationality);
+// insert_metadata.bind(":rights", doc_matters.conf_make_meta.meta.rights);
+// insert_metadata.bind(":rights_copyright_text", doc_matters.conf_make_meta.meta.rights_copyright_text);
+// insert_metadata.bind(":rights_copyright_translation", doc_matters.conf_make_meta.meta.rights_copyright_translation);
+// insert_metadata.bind(":rights_copyright_illustrations", doc_matters.conf_make_meta.meta.rights_illustrations);
+// insert_metadata.bind(":rights_copyright_photographs", doc_matters.conf_make_meta.meta.rights_photographs);
+// insert_metadata.bind(":rights_copyright_preparation", doc_matters.conf_make_meta.meta.rights_preparation);
+// insert_metadata.bind(":rights_copyright_digitization", doc_matters.conf_make_meta.meta.rights_digitization);
+// insert_metadata.bind(":rights_copyright_audio", doc_matters.conf_make_meta.meta.rights_audio);
+// insert_metadata.bind(":rights_copyright_video", doc_matters.conf_make_meta.meta.rights_video);
+// insert_metadata.bind(":rights_license", doc_matters.conf_make_meta.meta.rights_license);
+// insert_metadata.bind(":identifier_oclc", doc_matters.conf_make_meta.meta.identifier_oclc);
+// insert_metadata.bind(":identifier_isbn", doc_matters.conf_make_meta.meta.identifier_isbn);
+// insert_metadata.bind(":classify_topic_register", doc_matters.conf_make_meta.meta.classify_topic_register);
+// insert_metadata.bind(":classify_subject", doc_matters.conf_make_meta.meta.classify_subject);
+// insert_metadata.bind(":classify_loc", doc_matters.conf_make_meta.meta.classify_loc);
+// insert_metadata.bind(":notes_abstract", doc_matters.conf_make_meta.meta.notes_abstract);
+// insert_metadata.bind(":notes_description", doc_matters.conf_make_meta.meta.notes_description);
+// insert_metadata.bind(":notes_comment", doc_matters.conf_make_meta.meta.notes_comment);
+// insert_metadata.bind(":notes_coverage", doc_matters.conf_make_meta.meta.notes_coverage);
+// insert_metadata.bind(":notes_relation", doc_matters.conf_make_meta.meta.notes_relation);
+// insert_metadata.bind(":notes_history", doc_matters.conf_make_meta.meta.notes_history);
+// insert_metadata.bind(":notes_type", doc_matters.conf_make_meta.meta.notes_type);
+// insert_metadata.bind(":notes_format", doc_matters.conf_make_meta.meta.notes_format);
+// insert_metadata.bind(":notes_prefix", doc_matters.conf_make_meta.meta.notes_prefix);
+// insert_metadata.bind(":notes_prefix_a", doc_matters.conf_make_meta.meta.notes_prefix_a);
+// insert_metadata.bind(":notes_prefix_b", doc_matters.conf_make_meta.meta.notes_prefix_b);
+// insert_metadata.bind(":notes_suffix", doc_matters.conf_make_meta.meta.notes_suffix);
+// insert_metadata.bind(":src_filename", doc_matters.conf_make_meta.meta.src_filename);
+// insert_metadata.bind(":src_fingerprint", doc_matters.conf_make_meta.meta.src_fingerprint);
+// insert_metadata.bind(":src_filesize", doc_matters.conf_make_meta.meta.src_filesize);
+// insert_metadata.bind(":src_wordcount", doc_matters.conf_make_meta.meta.src_wordcount);
+// insert_metadata.bind(":src_text", doc_matters.conf_make_meta.meta.src_text);
+// insert_metadata.bind(":fulltext", doc_matters.conf_make_meta.meta.fulltext);
+// insert_metadata.bind(":links", doc_matters.conf_make_meta.meta.links);
insert_metadata.execute(); insert_metadata.reset();
/+ watch +/
writeln("sql statement executed");