services:
  postgres:
    image: postgres:16-alpine
    container_name: gyxx-flow-postgres
    restart: unless-stopped
    environment:
      POSTGRES_DB: gyxx_super_data
      POSTGRES_USER: gyxx_flow
      POSTGRES_PASSWORD: ${GYXX_POSTGRES_PASSWORD:?set GYXX_POSTGRES_PASSWORD}
    ports:
      - "127.0.0.1:5432:5432"
    volumes:
      - gyxx_flow_postgres:/var/lib/postgresql/data
      - ../src/gyxx_flow/modules/content_marketing/data/tools/schema_gyxx_super_data.sql:/docker-entrypoint-initdb.d/10-content-marketing.sql:ro
      - ../src/gyxx_flow/modules/product_commerce/db/schema.sql:/docker-entrypoint-initdb.d/20-product-commerce.sql:ro
      - ../src/gyxx_flow/modules/shop_intelligence/db/schema.sql:/docker-entrypoint-initdb.d/30-shop-intelligence.sql:ro
      - ../src/gyxx_flow/modules/supply_chain/orchestrator/sql/001_init.sql:/docker-entrypoint-initdb.d/40-supply-chain.sql:ro
      - ../src/gyxx_flow/modules/supply_chain/orchestrator/sql/002_workflow_v2.sql:/docker-entrypoint-initdb.d/41-supply-chain-v2.sql:ro
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U $${POSTGRES_USER} -d $${POSTGRES_DB}"]
      interval: 5s
      timeout: 5s
      retries: 20

volumes:
  gyxx_flow_postgres: