compose.demo.yaml

services:
  postgres:
    image: postgres:15
    restart: unless-stopped
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: rdi
    ports:
      - "5432:5432"
    volumes:
      - ./demo.sql:/docker-entrypoint-initdb.d/01-demo.sql:ro
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres -d rdi"]
      interval: 5s
      timeout: 5s
      retries: 20

  middleware-api:
    image: python:3.12-slim
    container_name: middleware-api-demo
    environment:
      - LOG_LEVEL=INFO
      - LOCAL_UID=${LOCAL_UID:-1000}
      - LOCAL_GID=${LOCAL_GID:-1000}
    ports:
      - "8000:8000"
    volumes:
      - ./demo_output:/data/arcs
      - ./demo_api_main.py:/app/main.py:ro
    command: 
      - /bin/sh
      - -c
      - |
        set -e
        pip install fastapi uvicorn arctrl
        uvicorn main:app --app-dir /app --host 0.0.0.0 --port 8000
    healthcheck:
      test: ["CMD-SHELL", "python -c \"import urllib.request; urllib.request.urlopen('http://localhost:8000/live')\" 2>/dev/null || exit 1"]
      interval: 5s
      timeout: 5s
      retries: 10

  sql_to_arc:
    image: sql_to_arc:latest
    build:
      context: ..
      dockerfile: docker/Dockerfile.sql_to_arc
    depends_on:
      postgres:
        condition: service_healthy
      middleware-api:
        condition: service_healthy
    volumes:
      - ./config.demo.yaml:/etc/sql_to_arc/config.yaml:ro
    environment:
      SQL_TO_ARC_CONNECTION_STRING: "postgresql+psycopg://postgres:postgres@postgres:5432/rdi"