Add test data seed script #36

Merged
ghost merged 1 commits from feat/test-data-seed into main 2026-03-17 23:37:18 +00:00
ghost commented 2026-03-17 23:36:06 +00:00 (Migrated from github.com)

Summary

  • Adds packages/db/src/seed.ts — a comprehensive seed script that populates the database with realistic test data for development
  • Generates 3 groomers + 3 bathers, 10 services, 500 clients with 1-3 dogs each, ~2500 appointments, invoices with line items/tip splits, and grooming visit logs
  • Adds pnpm db:seed convenience script (requires DATABASE_URL)
  • Adds tsx dev dependency for running the TypeScript seed directly

Test plan

  • Run pnpm db:seed against a fresh database after migrations
  • Verify all tables are populated with expected row counts
  • Confirm foreign key relationships are correct (pets → clients, appointments → staff/pets/services, invoices → appointments)
  • Check that appointment date distribution spans ~12 months with upcoming scheduled appointments

Closes groombook/groombook#32 (Paperclip GRO-32)

🤖 Generated with Claude Code

## Summary - Adds `packages/db/src/seed.ts` — a comprehensive seed script that populates the database with realistic test data for development - Generates 3 groomers + 3 bathers, 10 services, 500 clients with 1-3 dogs each, ~2500 appointments, invoices with line items/tip splits, and grooming visit logs - Adds `pnpm db:seed` convenience script (requires `DATABASE_URL`) - Adds `tsx` dev dependency for running the TypeScript seed directly ## Test plan - [ ] Run `pnpm db:seed` against a fresh database after migrations - [ ] Verify all tables are populated with expected row counts - [ ] Confirm foreign key relationships are correct (pets → clients, appointments → staff/pets/services, invoices → appointments) - [ ] Check that appointment date distribution spans ~12 months with upcoming scheduled appointments Closes groombook/groombook#32 (Paperclip GRO-32) 🤖 Generated with [Claude Code](https://claude.com/claude-code)
This repo is archived. You cannot comment on pull requests.