docker-compose.yml

services:
  app:
    build: .
    ports:
      - "3000:3000"
    environment:
      - DATABASE_URL=postgresql://crewsplit:crewsplit@db:5432/crewsplit
      - SESSION_SECRET=docker-dev-secret-change-in-production-please-1234567890abcdef
    depends_on:
      db:
        condition: service_healthy
    volumes:
      - ./src:/app/src
      - ./public:/app/public
    command: npm run dev

  db:
    image: postgres:16-alpine
    environment:
      POSTGRES_DB: crewsplit
      POSTGRES_USER: crewsplit
      POSTGRES_PASSWORD: crewsplit
    ports:
      - "5432:5432"
    volumes:
      - ./scripts/schema.sql:/docker-entrypoint-initdb.d/01_schema.sql
      - ./scripts/seed.sql:/docker-entrypoint-initdb.d/02_seed.sql
      - crewsplit_pgdata:/var/lib/postgresql/data
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U crewsplit -d crewsplit"]
      interval: 5s
      timeout: 5s
      retries: 5

volumes:
  crewsplit_pgdata: