diff options
Diffstat (limited to 'org/out_ocda_sqlite_db.org')
| -rw-r--r-- | org/out_ocda_sqlite_db.org | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/org/out_ocda_sqlite_db.org b/org/out_ocda_sqlite_db.org index e8c8490..5424ed8 100644 --- a/org/out_ocda_sqlite_db.org +++ b/org/out_ocda_sqlite_db.org @@ -164,6 +164,8 @@ template spineAbstractionDb() { parent_ocn INTEGER DEFAULT 0, parent_lev INTEGER DEFAULT 0, last_descendant_ocn INTEGER DEFAULT 0, + ocn_range_first INTEGER DEFAULT 0, + ocn_range_last INTEGER DEFAULT 0, children TEXT CHECK(children IS NULL OR json_valid(children)), ancestors TEXT @@ -418,7 +420,7 @@ template spineAbstractionDb() { "INSERT INTO objects (" ~ "doc_id, section, seq, ocn, is_a, is_of_part, is_of_section, is_of_type," ~ "heading_level, heading_lev_collapsed, identifier," - ~ "parent_ocn, parent_lev, last_descendant_ocn," + ~ "parent_ocn, parent_lev, last_descendant_ocn, ocn_range_first, ocn_range_last," ~ "children, ancestors, ancestors_collapsed," ~ "dom_status, dom_status_collapsed," ~ "dummy_heading, object_number_off," @@ -433,7 +435,7 @@ template spineAbstractionDb() { ~ ") VALUES (" ~ ":doc_id, :section, :seq, :ocn, :is_a, :is_of_part, :is_of_section, :is_of_type," ~ ":heading_level, :heading_lev_collapsed, :identifier," - ~ ":parent_ocn, :parent_lev, :last_descendant_ocn," + ~ ":parent_ocn, :parent_lev, :last_descendant_ocn, :ocn_range_first, :ocn_range_last," ~ ":children, :ancestors, :ancestors_collapsed," ~ ":dom_status, :dom_status_collapsed," ~ ":dummy_heading, :object_number_off," @@ -542,6 +544,8 @@ template spineAbstractionDb() { obj_stmt.bind(":parent_ocn", obj.metainfo.parent_ocn); obj_stmt.bind(":parent_lev", obj.metainfo.parent_lev_markup); obj_stmt.bind(":last_descendant_ocn", obj.metainfo.last_descendant_ocn); + obj_stmt.bind(":ocn_range_first", obj.metainfo.ocn_range_first); + obj_stmt.bind(":ocn_range_last", obj.metainfo.ocn_range_last); bindJsonInts(":children", obj.metainfo.children_headings); bindJsonInts(":ancestors", obj.metainfo.markedup_ancestors); |