docker-compose.test.yml

version: "3.9"

services:
  mysql:
    image: mysql:8.3
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: example
      MYSQL_DATABASE: orm_test
      MYSQL_ROOT_HOST: "%"
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "127.0.0.1", "-pexample"]
      interval: 5s
      timeout: 3s
      retries: 40
      start_period: 10s

  postgres:
    image: postgres:16
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      POSTGRES_DB: orm_test
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres -d orm_test"]
      interval: 5s
      timeout: 3s
      retries: 40
      start_period: 10s
    networks:
      default:
        aliases:
          - redshift

  questdb:
    image: questdb/questdb:latest
    environment:
      QDB_PG_ENABLED: "true"
      QDB_PG_READONLY_USER_ENABLED: "false"
      QDB_PG_USER: admin
      QDB_PG_PASSWORD: quest

  test-runner:
    image: node:24
    working_dir: /workspace
    volumes:
      - .:/workspace
    environment:
      MYSQL_DB_URL: mysql://root:example@mysql:3306/orm_test
      POSTGRES_DB_URL: postgres://postgres:example@postgres:5432/orm_test
      REDSHIFT_DB_URL: redshift://postgres:example@redshift:5432/orm_test
      QUESTDB_DB_URL: questdb://admin:quest@questdb:8812/qdb
      CI: "1"
    depends_on:
      mysql:
        condition: service_healthy
      postgres:
        condition: service_healthy
      questdb:
        condition: service_started
    command: >-
      bash -lc "npm ci && npm run build && make test"

networks:
  default:
    name: orm3-test-net