padelnomics/docker-compose.prod.yml

services:
  # ── Always-on infrastructure ──────────────────────────────

  router:
    image: nginx:alpine
    restart: unless-stopped
    ports:
      - "5000:80"
    volumes:
      - ./router/default.conf:/etc/nginx/conf.d/default.conf:ro
    networks:
      - net
    healthcheck:
      test: ["CMD", "nginx", "-t"]
      interval: 30s
      timeout: 5s
      retries: 3
      start_period: 10s

  litestream:
    image: litestream/litestream:latest
    restart: unless-stopped
    # Auto-restore from R2 if DB file is missing, then start continuous replication.
    # Handles: new server, deleted volume, disaster recovery.
    entrypoint: /bin/sh
    command:
      - -c
      - |
        if [ ! -f /app/data/app.db ]; then
          echo "==> No database found, restoring from R2..."
          litestream restore -config /etc/litestream.yml /app/data/app.db \
            || echo "==> No backup found, starting fresh"
        fi
        if [ ! -f /data/landing/.state.sqlite ]; then
          echo "==> No state DB found, restoring from R2..."
          litestream restore -config /etc/litestream.yml /data/landing/.state.sqlite \
            || echo "==> No state backup found, starting fresh"
        fi
        exec litestream replicate -config /etc/litestream.yml
    env_file: ./.env
    volumes:
      - app-data:/app/data
      - ./litestream.yml:/etc/litestream.yml:ro
      - /data/padelnomics/landing:/data/landing
    healthcheck:
      test: ["CMD-SHELL", "kill -0 1"]
      interval: 5s
      timeout: 5s
      retries: 6
      start_period: 15s

  # ── Blue slot ─────────────────────────────────────────────

  blue-app:
    profiles: ["blue"]
    build:
      context: .
    restart: unless-stopped
    env_file: ./.env
    environment:
      - DATABASE_PATH=/app/data/app.db
      - SERVING_DUCKDB_PATH=/app/data/analytics.duckdb
    volumes:
      - app-data:/app/data
      - /data/padelnomics/analytics.duckdb:/app/data/analytics.duckdb:ro
    networks:
      - net
    healthcheck:
      test: ["CMD", "python", "-c", "import urllib.request; urllib.request.urlopen('http://localhost:5000/health')"]
      interval: 10s
      timeout: 5s
      retries: 3
      start_period: 15s

  blue-worker:
    profiles: ["blue"]
    build:
      context: .
    restart: unless-stopped
    command: python -m padelnomics.worker
    env_file: ./.env
    environment:
      - DATABASE_PATH=/app/data/app.db
      - SERVING_DUCKDB_PATH=/app/data/analytics.duckdb
    volumes:
      - app-data:/app/data
      - /data/padelnomics/analytics.duckdb:/app/data/analytics.duckdb:ro
    networks:
      - net

  blue-scheduler:
    profiles: ["blue"]
    build:
      context: .
    restart: unless-stopped
    command: python -m padelnomics.worker scheduler
    env_file: ./.env
    environment:
      - DATABASE_PATH=/app/data/app.db
      - SERVING_DUCKDB_PATH=/app/data/analytics.duckdb
    volumes:
      - app-data:/app/data
      - /data/padelnomics/analytics.duckdb:/app/data/analytics.duckdb:ro
    networks:
      - net

  # ── Green slot ────────────────────────────────────────────

  green-app:
    profiles: ["green"]
    build:
      context: .
    restart: unless-stopped
    env_file: ./.env
    environment:
      - DATABASE_PATH=/app/data/app.db
      - SERVING_DUCKDB_PATH=/app/data/analytics.duckdb
    volumes:
      - app-data:/app/data
      - /data/padelnomics/analytics.duckdb:/app/data/analytics.duckdb:ro
    networks:
      - net
    healthcheck:
      test: ["CMD", "python", "-c", "import urllib.request; urllib.request.urlopen('http://localhost:5000/health')"]
      interval: 10s
      timeout: 5s
      retries: 3
      start_period: 15s

  green-worker:
    profiles: ["green"]
    build:
      context: .
    restart: unless-stopped
    command: python -m padelnomics.worker
    env_file: ./.env
    environment:
      - DATABASE_PATH=/app/data/app.db
      - SERVING_DUCKDB_PATH=/app/data/analytics.duckdb
    volumes:
      - app-data:/app/data
      - /data/padelnomics/analytics.duckdb:/app/data/analytics.duckdb:ro
    networks:
      - net

  green-scheduler:
    profiles: ["green"]
    build:
      context: .
    restart: unless-stopped
    command: python -m padelnomics.worker scheduler
    env_file: ./.env
    environment:
      - DATABASE_PATH=/app/data/app.db
      - SERVING_DUCKDB_PATH=/app/data/analytics.duckdb
    volumes:
      - app-data:/app/data
      - /data/padelnomics/analytics.duckdb:/app/data/analytics.duckdb:ro
    networks:
      - net

volumes:
  app-data:

networks:
  net: