docker-compose.yaml

version: "3.8"

services:
  db:
    build:
        dockerfile: db.Dockerfile
        context: .
    ports:
      - "5432:5432"
    volumes:
      - db-data:/var/lib/postgresql/data
      - ./sqitch:/sqitch
    environment:
        POSTGRES_DB: "${POSTGRES_DB}"
        POSTGRES_PASSWORD: "${POSTGRES_PASSWORD}"
        POSTGRES_STORAGE_USER: "${POSTGRES_STORAGE_USER}"
        POSTGRES_STORAGE_USER_PASSWORD: "${POSTGRES_STORAGE_USER_PASSWORD}"

        SQITCH_CONFIG: "/sqitch/sqitch.conf"
        SQITCH_USERNAME: "${POSTGRES_STORAGE_USER}"
        SQITCH_PASSWORD: "${POSTGRES_STORAGE_USER_PASSWORD}"
        SQITCH_TARGET: "db:pg://${POSTGRES_STORAGE_USER}:${POSTGRES_STORAGE_USER_PASSWORD}@db/${POSTGRES_DB}"

        PGRST_JWT_SECRET: "${PGRST_JWT_SECRET}"

  api:
    image: postgrest/postgrest
    environment:
        PGRST_DB_URI: "postgres://${POSTGRES_STORAGE_USER}:${POSTGRES_STORAGE_USER_PASSWORD}@db:5432/${POSTGRES_DB}"
        PGRST_DB_SCHEMA: api
        PGRST_DB_ANON_ROLE: anonymous
        PGRST_OPENAPI_SERVER_PROXY_URI: http://localhost:3000
        PGRST_JWT_SECRET: "${PGRST_JWT_SECRET}"
    depends_on:
      - db
    ports:
      - "3000:3000"

  schemaspy:
    image: schemaspy/schemaspy
    volumes:
      - ./schemaspy.properties:/schemaspy.properties
      - ./schemaspy-output:/output

volumes:
  db-data: