BE-M0-15 · Vehicles, with status only through its function

ID BE-M0-15 · Level L0 · Pack Pack B · Schema V13, domain by domain · Run order row 19 · Issue #11

Goal

The vehicle tables, with vehicles.status changed only through app.set_vehicle_status(), pass their tests on the local stack; committed.

Before

• BE-M0-14 is Done. You are on the branch supabase/schema-v13 in ~/opleet-v2/opleet, git status --short prints nothing, and the stack is running.

Run

1 · Copy this step's files in

cp -R ~/opleet-v2/packs/be-pack-b/BE-M0-15/. .
git status --short

2 · Rebuild the local database from every migration, then run every test

pnpm supabase db reset
pnpm supabase test db

3 · Commit

git add supabase
git commit -m "feat(supabase): vehicles, with status changed only through its function"

Expect

• Block 1: ?? supabase/migrations/20261006000400_vehicles.sql and ?? supabase/tests/database/15_vehicles.test.sql.
• Block 2: db reset applies 20261006000400_vehicles.sql last and ends with “Finished supabase db reset”; test db ends with “All tests successful.”, “Files=4, Tests=70” and “Result: PASS”.
• Block 3: the commit line with 2 files changed.

Check

pnpm supabase migration list --local
git log --oneline -1

Expect 20261006000400 in both columns as the last row, then “feat(supabase): vehicles, with status changed only through its function”.

If it fails

• db reset stops at a migration: the error names the file and the line. Paste it into the BE chat; don't edit the file.
• test db prints “not ok”: paste every “not ok” line and the lines under it. Don't commit.
• The stack isn't running: pnpm supabase start, then the rebuild and tests again.

Undo

Not committed yet: git clean -fd supabase/migrations supabase/tests, then pnpm supabase db reset. Committed: git reset --hard HEAD~1, then pnpm supabase db reset. Nothing has been pushed; the earlier steps stay.

Runs

Not run yet. Log each run as a comment on #11.