rikrdo/mercadodevida
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
mercadodevida/legacy/specs-old/F-002-database-foundation/TASKS.md
chattie d595b4871f feat(ADM-018): completed feature
2026-08-17 22:23:10 +02:00

832 B
Raw Permalink Blame History

TASKS — F-002 Database foundation with module-owned schemas

  • TASK-001 Add deps: pg, node-pg-migrate (+ @types/pg dev); justify in spec/tech.md
  • TASK-002 Add project/docker-compose.yml (postgres:16-alpine + redis:7-alpine, volumes, dev creds) and .env.example
  • TASK-003 Add baseline migration migrations/001_baseline.js (node-pg-migrate; extensions + app_meta via pgm.sql, with down)
  • TASK-004 Add src/infrastructure/db/pool.ts (createPoolFromEnv fail-fast + query helper)
  • TASK-005 Wire npm scripts: db:up, db:down, db:status, docker:up, docker:down, test:integration
  • TASK-006 Integration tests: fresh up / no-op rerun / down rollback / pool helper roundtrip (skipIf no TEST_DATABASE_URL)
  • TASK-007 Document naming convention in project/README.md
  • TASK-008 Run full verification and write implementer evidence