docker-compose.yml

services:

  ##########################################################################################################
  # ClickHouse single node (CH driver + Metabase tests)
  ##########################################################################################################

  clickhouse:
    image: 'clickhouse/clickhouse-server:24.7-alpine'
    container_name: 'metabase-driver-clickhouse-server'
    hostname: clickhouse
    ports:
      - '8123:8123'
      - '9000:9000'
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    volumes:
      - './.docker/clickhouse/single_node/config.xml:/etc/clickhouse-server/config.xml'
      - './.docker/clickhouse/single_node/users.xml:/etc/clickhouse-server/users.xml'

  ##########################################################################################################
  # ClickHouse single node (CH driver TLS tests only)
  ##########################################################################################################

  clickhouse_tls:
    build:
      context: ./
      dockerfile: .docker/clickhouse/single_node_tls/Dockerfile
    container_name: 'metabase-driver-clickhouse-server-tls'
    ports:
      - '8443:8443'
      - '9440:9440'
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    volumes:
      - './.docker/clickhouse/single_node_tls/config.xml:/etc/clickhouse-server/config.xml'
      - './.docker/clickhouse/single_node_tls/users.xml:/etc/clickhouse-server/users.xml'
    hostname: server.clickhouseconnect.test

  ##########################################################################################################
  # Older ClickHouse version (CH driver tests only)
  # For testing pre-23.8 string functions switch between UTF8 and non-UTF8 versions (see clickhouse_qp.clj)
  ##########################################################################################################

  clickhouse_older_version:
    image: 'clickhouse/clickhouse-server:23.3-alpine'
    container_name: 'metabase-driver-clickhouse-server-older-version'
    hostname: clickhouse.older
    ports:
      - '8124:8123'
      - '9001:9000'
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    volumes:
      - './.docker/clickhouse/single_node/config.xml:/etc/clickhouse-server/config.xml'
      - './.docker/clickhouse/single_node/users.xml:/etc/clickhouse-server/users.xml'

  ##########################################################################################################
  # ClickHouse cluster (CH driver SET ROLE tests only)
  # See test/metabase/driver/clickhouse_set_role.clj
  ##########################################################################################################

  clickhouse_cluster_node1:
    image: 'clickhouse/clickhouse-server:${CLICKHOUSE_VERSION-24.7-alpine}'
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    hostname: clickhouse1
    container_name: metabase-driver-clickhouse-cluster-node-1
    ports:
      - '8125:8123'
      - '9002:9000'
      - '9181:9181'
    volumes:
      - './.docker/clickhouse/cluster/server1_config.xml:/etc/clickhouse-server/config.xml'
      - './.docker/clickhouse/cluster/server1_macros.xml:/etc/clickhouse-server/config.d/macros.xml'
      - './.docker/clickhouse/users.xml:/etc/clickhouse-server/users.xml'

  clickhouse_cluster_node2:
    image: 'clickhouse/clickhouse-server:${CLICKHOUSE_VERSION-24.7-alpine}'
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    hostname: clickhouse2
    container_name: metabase-driver-clickhouse-cluster-node-2
    ports:
      - '8126:8123'
      - '9003:9000'
      - '9182:9181'
    volumes:
      - './.docker/clickhouse/cluster/server2_config.xml:/etc/clickhouse-server/config.xml'
      - './.docker/clickhouse/cluster/server2_macros.xml:/etc/clickhouse-server/config.d/macros.xml'
      - './.docker/clickhouse/users.xml:/etc/clickhouse-server/users.xml'

  # Using Nginx as a cluster entrypoint and a round-robin load balancer for HTTP requests
  # See .docker/nginx/local.conf for the configuration
  nginx:
    image: 'nginx:1.23.1-alpine'
    hostname: nginx
    ports:
      - '8127:8123'
    volumes:
      - './.docker/nginx/local.conf:/etc/nginx/conf.d/local.conf'
    container_name: metabase-nginx

  ##########################################################################################################
  # Metabase
  ##########################################################################################################

  metabase:
    image: metabase/metabase-enterprise:v1.51.1.2
    container_name: metabase-with-clickhouse-driver
    hostname: metabase
    environment:
      'MB_HTTP_TIMEOUT': '5000'
      'JAVA_TIMEZONE':   'UTC'
    ports:
      - '3000:3000'
    volumes:
      - '../../../resources/modules/clickhouse.metabase-driver.jar:/plugins/clickhouse.jar'
      - './.docker/clickhouse/single_node_tls/certificates/ca.crt:/certs/ca.crt'
    healthcheck:
      test: curl --fail -X GET -I http://localhost:3000/api/health || exit 1
      interval: 15s
      timeout: 5s
      retries: 10

  setup:
    build: .docker/setup/.
    container_name: metabase-clickhouse-setup
    volumes:
      - .docker/setup/setup.py:/app/setup.py
    depends_on:
      metabase:
        condition: service_healthy
    command: python /app/setup.py
    environment:
      host: http://metabase
      port: 3000
      admin_email: 'admin@example.com'
      user_email: 'user@example.com'
      password: 'metabot1'