69 lines
3.5 KiB
Markdown
69 lines
3.5 KiB
Markdown
# Tasks — `@suaveplan/api-db-sqlite-memory`
|
|
|
|
> Every checkbox MUST reflect work actually done in this change.
|
|
|
|
## 0. Pre-flight (non-negotiable)
|
|
|
|
- [ ] 0.1 Confirm clean working tree (`git status` reports nothing) and no in-flight worktrees with uncommitted work (`git worktree list` then `git status` in each)
|
|
- [ ] 0.2 If any worktrees exist under `.claude/worktrees/`, account for each one: still-active agent, work-pending-merge, or stale-and-prune. Stale worktrees MUST be removed (`git worktree remove`) before opening a new one — code that has been lost twice on main is the failure mode this guards against.
|
|
- [ ] 0.3 Confirm the package set in `MANIFEST.md` matches `find packages -maxdepth 3 -name package.json` count. Drift here means a prior change archived without regenerating the manifest.
|
|
|
|
## 1. Spec authoring
|
|
|
|
- [x] 1.1 Read design doc (§13.2, §13.4, §15 Stage 5)
|
|
- [x] 1.2 Read `openspec/changes/api-db-adapter/` for Stage 4 parallel
|
|
- [x] 1.3 Read `openspec/AGENTS.md` Sections 13 and 14
|
|
- [x] 1.4 Draft `proposal.md`
|
|
- [x] 1.5 Draft `specs/api-db-sqlite-memory/spec.md`
|
|
- [x] 1.6 Every requirement carries `**Verified by:**`
|
|
|
|
## 2. Implementation
|
|
|
|
- [ ] 2.1 Scaffold `packages/api/api-db-sqlite-memory/` (deps: api-db, api-types, error, zod)
|
|
- [ ] 2.2 `src/options/sqlite-memory-db-options.ts` — Zod schema
|
|
- [ ] 2.3 `src/factory/create-sqlite-memory-db.ts` — direct surface (admin + scoped)
|
|
- [ ] 2.4 `src/tenant-scoping/tenant-scoping.ts` — read/write injection + rejection
|
|
- [ ] 2.5 `src/migrations/migrations.ts` — runner with `__plugin_migrations` table
|
|
- [ ] 2.6 `src/error-codes.ts` — `DB_SQLITE_MEMORY_*` codes via `defineCodes`
|
|
- [ ] 2.7 `src/index.ts` — explicit named re-exports
|
|
- [ ] 2.8 Register this adapter in `@suaveplan/api-host/testing`'s adapter table under `engine: "sqlite-memory"`
|
|
|
|
## 3. Tests
|
|
|
|
- [ ] 3.1 `src/factory/create-sqlite-memory-db.test.ts`
|
|
- [ ] 3.2 `src/factory/create-sqlite-memory-db.spec-conformance.test.ts` — conformance
|
|
- [ ] 3.3 `src/tenant-scoping/tenant-scoping.test.ts`
|
|
- [ ] 3.4 `src/migrations/migrations.test.ts`
|
|
- [ ] 3.5 `tests/integration/integration.test.ts` — via `createTestHost`
|
|
- [ ] 3.6 Every `it(...)` carries `{ timeout: 5000 }`
|
|
|
|
## 4. Documentation
|
|
|
|
- [ ] 4.1 Sibling `.md` per implementation `.ts`
|
|
- [ ] 4.2 README documents the `:memory:` connection string and the WAL/foreign-keys default pragmas
|
|
|
|
## 5. Pre-archive verification (5-gate triple)
|
|
|
|
- [ ] 5.1 `bun run check` — clean
|
|
- [ ] 5.2 `bunx turbo lint typecheck test --filter=@suaveplan/api-db-sqlite-memory` — green
|
|
- [ ] 5.3 `bunx turbo test:coverage --filter=@suaveplan/api-db-sqlite-memory` — 100/100/100/100
|
|
- [ ] 5.4 `bun scripts/openspec-conformance.ts @suaveplan/api-db-sqlite-memory` — exit 0
|
|
- [ ] 5.5 `bunx turbo build --filter=@suaveplan/api-db-sqlite-memory` — green
|
|
|
|
## 6. Pre-archive 7-row checklist
|
|
|
|
- [ ] 6.1 `expectTypeOf` asserts admin vs scoped surfaces type-distinct (same field name, different type)
|
|
- [ ] 6.2 Zod schema at options + manifest boundaries
|
|
- [ ] 6.3 Every `DB_SQLITE_MEMORY_*` code thrown by at least one production path
|
|
- [ ] 6.4 Strict-mode (`autoInjectInserts` on/off) tested both ways
|
|
- [ ] 6.5 OTel instruments (`api.db.query_duration_ms`, `api.db.migrations_applied_total`) asserted with in-memory `MeterProvider`
|
|
- [ ] 6.6 Migration idempotency tested
|
|
- [ ] 6.7 No retroactive tick
|
|
|
|
## 7. Archive
|
|
|
|
- [ ] 7.1 Fold into `openspec/specs/api-db-sqlite-memory/spec.md`
|
|
- [ ] 7.2 Move to `openspec/archive/<yyyy-mm-dd>-api-db-sqlite-memory/`
|
|
- [ ] 7.3 Tick Stage 5 box in umbrella tasks
|
|
- [ ] 7.4 Refresh `MANIFEST.md`
|