BE-M0-17 · Rentals and contracts: no double booking, transfer first

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

Goal

Rentals and contracts, with one live rental per car and per driver and the car in the driver's pool, pass their tests on the local stack; committed.

Before

• BE-M0-16 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-17/. .
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): rentals and contracts, with no double booking"

Expect

• Block 1: ?? supabase/migrations/20261006000600_rentals.sql and ?? supabase/tests/database/17_rentals.test.sql.
• Block 2: db reset applies 20261006000600_rentals.sql last and ends with “Finished supabase db reset”; test db ends with “All tests successful.”, “Files=6, Tests=107” and “Result: PASS”.
• Block 3: the commit line with 2 files changed.

Check

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

Expect 20261006000600 in both columns as the last row, then “feat(supabase): rentals and contracts, with no double booking”.

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.