docker-compose.yaml

version: '3.8'

services:
  db:
    image: mcr.microsoft.com/mssql/server:2022-latest
    environment:
      SA_PASSWORD: "${SA_PASSWORD}"
      ACCEPT_EULA: "Y"
      MSSQL_PID: "Express"
    volumes:
      - sql_data:/var/opt/mssql
    # For production, keep the DB private (no ports). Temporarily expose if you must:
    # ports:
    #   - "1433:1433"
    restart: unless-stopped

  api:
    build:
      context: .
      dockerfile: Dockerfile
    depends_on:
      - db
    environment:
      ASPNETCORE_ENVIRONMENT: "Production"
      ASPNETCORE_URLS: "http://0.0.0.0:8080"
      ConnectionStrings__DefaultConnection: "Server=db,1433;Database=csvNetflixDB;User=sa;Password=${SA_PASSWORD};TrustServerCertificate=True;"
    ports:
      - "5000:8080"
    volumes:
      - "${SECRETS_DIR:-./secrets}:/app/secrets:ro"
    restart: unless-stopped

  frontend:
    image: nginx:alpine
    volumes:
      - ./frontend:/usr/share/nginx/html:ro
    ports:
      - "8080:80"
    depends_on:
      - api
    restart: unless-stopped

volumes:
  sql_data: