60 lines
4.8 KiB
Markdown
60 lines
4.8 KiB
Markdown
# CONTRACT: V1-1.2 Clients data (M2) + M1 closure, owner brief 2026-10-25 « Validation V1-1.1 et autorisation V1-1.2 Données clients »
|
|
|
|
- branch `feature/v1-1-clients-animals`, base 6bf6978 (V1-1.1 validated); commits 08abe42 (sandbox tool + M1 suite),
|
|
5ed1f01 (DEV procedure docs), 2c0531d (memory), 4adbfcb (M2 code), f8bd1b6 (docs)
|
|
- diff under review: `git diff 6bf6978..f8bd1b6 -- scripts supabase packages package.json docs`
|
|
- functional contract `docs/development/V1-1_OWNERS_ANIMALS.md` §5, §5.1, §8.2, §9, §10, §12, §13.2
|
|
- isolated stack: `pnpm db:sandbox` (scripts/db-sandbox.sh, SUPABASE.md §5.1) is UP (upgrade mode, M1+M2 applied over
|
|
older data). Allowed: `pnpm db:sandbox test-db`, `pnpm db:sandbox types --check`, `pnpm db:sandbox test`,
|
|
`echo "<read-only SQL>" | pnpm db:sandbox sql`. The DEV stack (`supabase_*_faunosteo`) must not be touched except
|
|
`pnpm supabase migration list --local` (read-only).
|
|
|
|
## Clauses
|
|
|
|
C1. **Scope.** M2 only: `supabase/migrations/20261025110000_clients.sql`. No M3 object (animals, relations, species
|
|
rows, animal enums), no React screen or route, no V1-1.3 tooling (Playwright, Dialog), no change to crates/, no edit of an
|
|
existing migration, no change to existing tables' grants or policies except the N9 condition on `audit_logs_select_admin`.
|
|
|
|
C2. **M1 closure.** The committed `database.types.ts` equals the official generator's output (`supabase gen types
|
|
typescript --schema public`, through Prettier) against an isolated database holding the migrations; no hand edit; types
|
|
cover exactly the public schema objects of M1 and M2.
|
|
|
|
C3. **Sandbox tool.** `scripts/db-sandbox.sh`: rootless Docker, ports on 127.0.0.1 only and distinct from DEV, no volume
|
|
created or removed, cleanup by literal `faunosteo_dbsandbox_*` names only, secrets generated outside the repository and
|
|
never printed or committed, image versions pinned and documented, fresh and upgrade modes, every Supabase CLI call with
|
|
an explicit sandbox `--db-url` (none can reach DEV).
|
|
|
|
C4. **DEV procedure (doc only).** SUPABASE.md §3.3: target check, migration history, only V1-1 migrations pending,
|
|
accounts count, backup including auth data stored outside Git and checked, application without reset and without
|
|
`db push`, `migration repair` or destructive command, `db:test` shown non-destructive, post-checks (history, workspaces,
|
|
duplicates, privileges, types, e2e:avatar), stop conditions, no secret printed. Claude applied nothing to DEV.
|
|
|
|
C5. **Clients model.** person | organization; `display_name` required, no first/last name, no notes; optional contacts;
|
|
no default country; workspace FK `on delete restrict`; text rules and bounds as contract §5/§5.1; no sensitive extra
|
|
field; `field-limits.ts` constants proven equal to the SQL CHECKs by a behavioural parity test (bounds, code points,
|
|
control ranges, patterns; TypeScript never accepts what SQL refuses).
|
|
|
|
C6. **RPCs.** `create_client`, `update_client`, `set_client_archived` (definer) and `search_clients` (invoker): identity
|
|
from `auth.uid()` only via `writable_workspace_ids` / RLS (active profile, confirmed email); same whole error for a
|
|
foreign and an unknown id; parse errors and constraint violations → `invalid_input` without echo; idempotent create,
|
|
divergent replay → `request_conflict`; stale revision → `conflict`; archived read-only (`archived` before `conflict`);
|
|
restore allowed; no-op writes nothing; EXECUTE only for authenticated; search_path empty; owner postgres; audit rows
|
|
ids only (`{workspace_id}`), hidden from platform staff (N9).
|
|
|
|
C7. **Budget and caps.** Transactional counter per workspace (owner §9): UTC hour/day windows documented (zone, reset,
|
|
boundaries); 1 000/h, 5 000/day, 20 000 clients; increment and write in one transaction; refused, replayed and no-op
|
|
calls not counted; concurrency-safe; stable lock order documented (workspace, animal, client, budget last); lock scope
|
|
per workspace, measured.
|
|
|
|
C8. **Search.** POST RPC, 25 default / 100 max page, ≤ 100-character term, deterministic order `(name_key, id)` with
|
|
keyset, LIKE wildcards escaped, phone search, no leak of another workspace through rows, counts or pages; index exists;
|
|
20 000-client timing recorded.
|
|
|
|
C9. **Tests.** pgTAP `013_clients.sql` + `001` census green on PGlite and on the isolated real image (fresh and upgrade);
|
|
sandbox suite: real authenticated sessions per role (A, B, anon key, service key, deactivated, unconfirmed), concurrent
|
|
creates, replays, divergent replay race, stale revision race, archive/restore race, budget at the limit under
|
|
concurrency, no deadlock; M1 regression (workspaces, backfill, auth/profile). `pnpm test:run` green.
|
|
|
|
C10. **Docs and limits.** Contract §8.2 as built + deviations, SUPABASE.md §3.4/§5.1, TEST_STRATEGY, BDR-075, LRN-080/081
|
|
(scoped, no duplicate). No merge, main and release/0.2.0 untouched, no deploy, fixtures fictitious.
|