test: cross-check .ssp & ocda db

cross-check .ssp & ocda (abstraction) db against each other

To prevent drift, this compares them directly to detect one writer
gaining a field and the other not (rather than each against a
committed reference, so there is no new fixture to keep current)

For every sample document it generates both artefacts and asserts:

- the same number of objects, and the same number in each of the eight
  sections
- for 32 single valued properties, that the count of the .ssp property
  equals the count of rows where the corresponding column is set
- for the four repeatable properties (.image, .stow_link, .anchor_tag,
  .lev4_subtoc), that the count equals the rows in its table
- that every image the abstraction referred to and found is carried in
  the files table
- that the text of the first and last citable body object is byte
  identical in the two
- that the database says what it is (metadata schema.version)

  SpinePOD=../../markup/sisudoc-spine-samples/markup/pod-samples/pod \
    nix shell "nixpkgs#sqlite" -c ./test/test-abstraction-db.sh ./bin/spine-ldc

A sqlite error on a missing column is reported as a mismatch
rather than aborting the run.

The other half of this step, one shared field description behind
both writers, is not done here: the cross-check gives the same
guarantee without touching either writer, and the question becomes
moot if, as planned, the database comes to be generated from the
.ssp through the loader.

Added with -f: test/ is covered by .gitignore's catch-all, as
test/test-abstraction-ssp.sh was before it.

(assisted by Claude-Code)

0 files changed, 0 insertions, 0 deletions