lsm / neokai / 26606385682

82%

push

github

Add DB schema parity CI check (#2030)

* ci: add db schema parity check

* refactor: share schema parity overrides

* fix: enforce full helper schema parity

Compare helper schemas against production column metadata, constraints, foreign keys, and indexes so test DB drift fails CI.

* fix: include sqlite autoindexes in schema parity

Compare PRAGMA index metadata so UNIQUE constraint autoindexes and stale helper-only tables fail schema parity checks.

* fix: cover missing space helper tables

Add registered Space memory/worktree tables to helper parity and seed session fixtures required by sdk_messages foreign keys.

* fix: broaden schema parity validation

Validate stale helper and scope registrations, scoped columns, virtual table SQL, and triggers so DB drift fails before runtime.

* fix: address schema parity review gaps

Detect SQLite virtual tables from CREATE SQL and seed synthetic sessions in Forge evidence fixtures so helper DB foreign keys stay valid.

* fix: seed conversation analysis sessions

Seed synthetic sessions before conversation analysis fixtures insert sdk_messages so helper DB foreign keys remain valid.

* fix: remove stale helper schema patches in 5-space tests

actor-registry and messaging-adapter tests had alignTestSchema helpers that added custom_prompt and recreated sessions. createSpaceTables() now includes both, causing duplicate column errors and unnecessary table drops. Removed the patch functions and updated messaging-adapter tests to update existing node_executions instead of inserting duplicates that violate the production unique constraint.

9321 of 13718 branches covered (67.95%)

Branch coverage included in aggregate %.

352 of 438 new or added lines in 2 files covered. (80.37%)

80557 of 94255 relevant lines covered (85.47%)

300.55 hits per line