Files
touchbase/scripts/db-test-truncate.sql
noisedestroyers 9e7d589c22 Verify-suite work (this session):
- M  package.json — added typecheck, test:e2e, verify scripts; added @playwright/test devDep
  - M  pnpm-lock.yaml
  - M  .gitignore — Playwright artifacts
  - M  tsconfig.json — auto-modified by Next.js include path
  - ??  e2e/ — config + fixtures + 3 specs
  - ??  playwright.config.ts
  - ??  scripts/verify.sh, scripts/db-test-truncate.sql
2026-05-10 07:42:46 -04:00

23 lines
575 B
SQL

-- Truncate all Prisma-managed application tables in touchbase_test.
-- Used by `pnpm verify` to give Playwright a clean fixture-only DB state
-- without triggering Prisma's AI-invocation guard on `migrate reset`.
-- pg-boss tables (schema "pgboss") are intentionally left alone.
TRUNCATE TABLE
"AuditLog",
"Notification",
"Payment",
"Booking",
"AvailabilityOverride",
"WorkingHours",
"ServiceTherapist",
"Service",
"RoomBlock",
"RoomTag",
"Room",
"TherapistTag",
"Therapist",
"Customer",
"VerificationToken",
"User"
RESTART IDENTITY CASCADE;