aboutsummaryrefslogtreecommitdiffhomepage
path: root/test/test-search-cgi.sh
Commit message (Collapse)AuthorAgeFilesLines
* test: fix, a skipped check is not a passRalph Amissah2026-09-091-0/+12
| | | | | | | | | | | | | | | | | | | | | | | fix of a couple of issues with tests. test-search-cgi.sh reported PASS while printing "Schema version gate: skipped, sqlite3 not on PATH", and the values it searches for were the hardcoded fallbacks rather than values read out of the database it had just built. Both halves need sqlite3, both are checks, and a run that leaves them out still exits 0. The other three scripts re-run themselves under nix shell "nixpkgs#sqlite"; this one now does the same. sqlite3 is still not required: with neither sqlite3 nor nix the test runs as before and says what it skipped. test-abstraction-ssp.sh depends on --abstraction for its meaning, and nothing in it said so. --show-abstraction does not appear in spine's parallelise() list, so dropping that one flag turns the current run serial, and the parallel-versus-serial comparison below it then compares a serial run with itself - the guard gone, with nothing failing to report it. That is how the multi-lingual write race survived. A comment at the call now says not to drop it. (assisted by Claude-Code)
* sqlite: schema version, & fail run on writes failRalph Amissah2026-09-091-0/+245
Spine now declares sqlite_db_schema_version and stamps it into the database as PRAGMA user_version when the tables are created, in both the shared and the discrete DDL blocks. On opening an existing database it compares, and says once per run which version it found and which it writes. Failures are now tallied (shared, the output can run in parallel), reported one line each on stderr naming the operation, and main exits 1 without printing "run complete, ok". Two tests under test/, both taking the spine binary as their first argument and building their own database from data/pod unless $SpinePOD says otherwise: test-search-db-schema.sh names: every column the search form uses exists, and spine's declaration, the database's stamp and the search form's expectation all agree test-search-cgi.sh behaviour: the real search binary answers real requests against a fresh database, no web server involved, the probe values read out of whichever database it is given (assisted by Claude-Code)