docker-compose.reporting-stack.yml

# =============================================================================
# Reporting Stack Integration Overlay
# =============================================================================
# Configures the OpenLMIS database for CDC and provides a shared network
# for the reporting-stack platform to connect to.
#
# Usage:
#   docker compose -f docker-compose.yml -f docker-compose.reporting-stack.yml up -d
#
# This overlay:
#   1. Creates a 'reporting-shared' network (auto-managed by Compose)
#   2. Attaches the DB to it with alias 'olmis-db'
#   3. Runs a one-shot init container that configures the DB for CDC
# =============================================================================

networks:
  # Shared network for reporting-stack platform connectivity.
  # The reporting-stack's kafka-connect service joins this as external.
  # Using explicit 'name' ensures a stable, project-prefix-free network name.
  reporting-shared:
    name: reporting-shared
    driver: bridge

services:
  db:
    networks:
      default:
      reporting-shared:
        aliases:
          - olmis-db

  # One-shot container that configures the DB for CDC.
  # Must wait for referencedata + requisition to be healthy (Flyway + refresh-db
  # complete) — otherwise refresh-db drops/recreates tables AFTER the publication
  # is set, silently removing them from CDC.
  reporting-stack-init:
    image: postgres:14-alpine
    depends_on:
      db:
        condition: service_started
      referencedata:
        condition: service_healthy
      requisition:
        condition: service_healthy
    networks:
      - default
    environment:
      PGHOST: db
      PGPORT: "5432"
      PGDATABASE: open_lmis
      PGUSER: postgres
      PGPASSWORD: p@ssw0rd
    volumes:
      - ./reporting-stack/init-db.sql:/init-db.sql:ro
      - ./reporting-stack/wait-and-init.sh:/wait-and-init.sh:ro
    entrypoint: ["bash", "/wait-and-init.sh"]
    restart: "no"