joaoh82 / rust_sqlite / 26737133294

69%

push

github

SQLR-10 — honor CREATE TABLE IF NOT EXISTS + make sqlrite_master queryable (#151)

Two engine ergonomics gaps that every embedding SDK consumer hits when
writing idempotent "run my schema on startup" migrations:

1. `CREATE TABLE IF NOT EXISTS` was parsed but ignored — a second create
   of an existing table errored "table already exists", unlike
   `CREATE INDEX IF NOT EXISTS`. Now `CreateQuery` carries the
   `if_not_exists` flag and the executor treats a re-create as a no-op
   (by name only; no schema diff, matching SQLite).

2. The schema catalog wasn't reachable from SQL. Added:
   - `SELECT … FROM sqlrite_master` — synthesizes a read-only in-memory
     catalog table on demand (type/name/sql/rootpage/last_rowid), reusing
     the same SQL synthesis the persistence path uses. Works through the
     normal single-table SELECT path (WHERE/projection/ORDER BY/LIMIT);
     reflects live in-memory state. Writes remain rejected; joins against
     it are out of scope.
   - `PRAGMA table_list` — SQLite-canonical lightweight introspection
     (schema/name/type/ncol/wr/strict) listing tables + sqlrite_master.

Covers the REPL and every SDK (all route through execute_select_rows /
process_command). Docs (supported-sql.md, README) updated; the
go-collector example's now-stale workaround comments refreshed.

Tests: parser flag capture; IF NOT EXISTS idempotency + still-errors
without it + fresh-create; sqlrite_master listing/filtering/SELECT */
write-rejection/save-reopen; PRAGMA table_list listing + value-rejection.

Co-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

170 of 189 new or added lines in 5 files covered. (89.95%)

11357 of 16463 relevant lines covered (68.98%)

1.24 hits per line