From 993a3f655359f98dc26d3d3222e07792e2ccddf7 Mon Sep 17 00:00:00 2001 From: Ralph Amissah Date: Wed, 30 Sep 2026 16:18:59 -0400 Subject: abstraction 2.1: a poem states its object range - A poem is a container of verse, and stores its range of verse ocn, - its verse are the citable units with ocn. - A note in the last verse of a poem previously was not gathered into the endnotes section, this now is fixed Format 2.0 -> 2.1: the property is an addition, the poem is not a citable object (but contans a range of objects), its verse are (individual citable objects), and every reader checks the major version. A 2.0 database reads as having no ranges. (assisted by Claude-Code) --- org/out_ocda_sqlite_db.org | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'org/out_ocda_sqlite_db.org') 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); -- cgit v1.2.3