kiwi/app/db
pyr0ball dd09aa21f4 fix: add FTS5 sync triggers so recipe inserts are indexed immediately
Migration 015 did a one-time rebuild of recipes_fts at creation time but
omitted triggers, so rows inserted after that point were invisible to MATCH
queries. Adds AFTER INSERT/UPDATE/DELETE triggers to 015 (fresh DBs / tests)
and migration 016 to backfill them on existing databases.

Fixes 3 failing tests: test_search_recipes_by_ingredient_names,
test_level1_returns_ranked_suggestions, test_level2_returns_swap_candidates.
2026-04-02 23:14:22 -07:00
..
migrations fix: add FTS5 sync triggers so recipe inserts are indexed immediately 2026-04-02 23:14:22 -07:00
__init__.py chore: initial commit — kiwi Phase 2 complete 2026-03-30 22:20:48 -07:00
base.py chore: initial commit — kiwi Phase 2 complete 2026-03-30 22:20:48 -07:00
models.py chore: initial commit — kiwi Phase 2 complete 2026-03-30 22:20:48 -07:00
session.py chore: initial commit — kiwi Phase 2 complete 2026-03-30 22:20:48 -07:00
store.py feat: recipe engine — assembly templates, prep notes, FTS fixes, texture backfill 2026-04-02 22:12:35 -07:00