docker-compose.yml

services:
  db:
    image: postgres:16-alpine@sha256:57c72fd2a128e416c7fcc499958864df5301e940bca0a56f58fddf30ffc07777
    environment:
      # Development defaults. Override all four database settings together.
      POSTGRES_USER: ${POSTGRES_USER:-talkwithdata}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-talkwithdata}
      POSTGRES_DB: ${POSTGRES_DB:-talkwithdata}
    volumes:
      - postgres_data:/var/lib/postgresql/data
    healthcheck:
      test:
        - CMD-SHELL
        - pg_isready -U "$${POSTGRES_USER}" -d "$${POSTGRES_DB}"
      interval: 2s
      timeout: 3s
      retries: 15
      start_period: 10s
    restart: unless-stopped

  migrate:
    build:
      context: .
      dockerfile: app/Dockerfile
      target: migrator
    environment:
      DATABASE_URL: ${COMPOSE_DATABASE_URL:-postgresql://talkwithdata:talkwithdata@db:5432/talkwithdata}
    depends_on:
      db:
        condition: service_healthy
    restart: "no"
    command:
      - sh
      - -c
      - echo 'TWD migration run' && exec ./node_modules/.bin/prisma migrate deploy

  app:
    build:
      context: .
      dockerfile: app/Dockerfile
    # Cloud Run expects PORT=8080
    ports:
      - "${TWD_APP_PORT:-3000}:8080"
    env_file:
      - ${TWD_ENV_FILE:-./app/.env}
    environment:
      # LOCAL_STORAGE_ROOT is used when STORAGE_PROVIDER=local in the env file.
      # The named volume keeps dashboard files across container replacements.
      DATABASE_URL: ${COMPOSE_DATABASE_URL:-postgresql://talkwithdata:talkwithdata@db:5432/talkwithdata}
      LOCAL_STORAGE_ROOT: /data/uploads
      PORT: 8080
    depends_on:
      migrate:
        condition: service_completed_successfully
    volumes:
      - app_data:/data
    restart: unless-stopped
    # Liveness probe for observability (docker compose ps, depends_on gating).
    # Compose does not restart unhealthy containers, and /api/health does not
    # check the database, so healthy means the app is serving, not DB-ready.
    healthcheck:
      test: ["CMD", "wget", "-qO-", "http://127.0.0.1:8080/api/health"]
      interval: 30s
      timeout: 5s
      retries: 3
      start_period: 15s

volumes:
  app_data:
  postgres_data: