docker-compose.yml

version: '3.8'

services:
  bharat-api:
    build: .
    container_name: bharat-api
    ports:
      - "3000:3000"
    environment:
      - NODE_ENV=production
      - PORT=3000
      - DB_CLIENT=sqlite3
      - DB_FILENAME=/app/data/production.db
    volumes:
      - ./data:/app/data
      - ./india-pincodes.csv:/app/data/india-pincodes.csv
    restart: unless-stopped
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:3000/health"]
      interval: 30s
      timeout: 10s
      retries: 3
      start_period: 40s
    command: >
      sh -c "
        npm run migrate &&
        npm run import-csv /app/data/india-pincodes.csv &&
        npm start
      "

  # Optional: PostgreSQL service for future migration
  # postgres:
  #   image: postgres:15-alpine
  #   container_name: bharat-api-postgres
  #   environment:
  #     POSTGRES_DB: bharat_api
  #     POSTGRES_USER: bharat_user
  #     POSTGRES_PASSWORD: bharat_password
  #   volumes:
  #     - postgres_data:/var/lib/postgresql/data
  #   ports:
  #     - "5432:5432"
  #   restart: unless-stopped

# volumes:
#   postgres_data: