docker-compose.yml

version: '3.3'
services:
  sqlpal:
    image: sqlpal:latest
    environment:
      IASQL_ENV: ci
    env_file:
      - .env
    ports:
      - "8088:8088"
    tmpfs:
      - /tmp/indexes
    container_name: sqlpal
    logging:
      options:
        max-size: "10m"
        max-file: "2"
  sqlpal-db:
    # TODO: make this persistent
    container_name: sqlpal_db
    hostname: sqlpal_db
    image: postgres:latest
    ports:
      - "5433:5433"
    expose:
      - "5433"
    command: -p 5433
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: ${POSTGRES_DB}
    logging:
      options:
        max-size: "10m"
        max-file: "2"
  pg:
    # postgresql://sqlpaluser:sqlpass@local_pg:5432/sqlpal
    container_name: sqlpal_db_pg
    hostname: local_pg
    image: postgres:latest
    ports:
      - "5432:5432"
    environment:
      POSTGRES_USER: sqlpaluser
      POSTGRES_PASSWORD: sqlpass
      POSTGRES_DB: sqlpal
    volumes:
      - ./server/fixtures/test_schema_pg.sql:/docker-entrypoint-initdb.d/init.sql
    logging:
      options:
        max-size: "10m"
        max-file: "2"
  mysql:
    # mysql://sqlpaluser:sqlpass@local_mysql:3306/sqlpal
    container_name: sqlpal_db_mysql
    hostname: local_mysql
    image: mysql:latest
    command: ['mysqld', '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci', '--default-authentication-plugin=mysql_native_password']
    ports:
      - "3306:3306"
    environment:
      MYSQL_RANDOM_ROOT_PASSWORD: "yes"
      MYSQL_USER: "sqlpaluser"
      MYSQL_PASSWORD: "sqlpass"
      MYSQL_DATABASE: "sqlpal"
    volumes:
      - ./server/fixtures/test_schema_mysql.sql:/docker-entrypoint-initdb.d/init.sql
    logging:
      options:
        max-size: "10m"
        max-file: "2"
  mssql:
    # mssql://sqlpaluser:sqlpass@local_mssql:1433/sqlpal?TrustServerCertificate=yes
    container_name: sqlpal_db_mssql
    hostname: local_mssql
    image: mcr.microsoft.com/mssql/server:2019-latest
    ports:
      - "1433:1433"
    environment:
      ACCEPT_EULA: Y
      MSSQL_SA_PASSWORD: strongPassword123
      MSSQL_PID: Express
    healthcheck:
      test: ["CMD-SHELL", "/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P strongPassword123 -Q 'SELECT 1' || exit 1"]
      interval: 10s
      retries: 10
      start_period: 10s
      timeout: 3s
    logging:
      options:
        max-size: "10m"
        max-file: "2"
  mssql.configurator:
    image: mcr.microsoft.com/mssql/server:2019-latest
    depends_on:
      mssql:
        condition: service_healthy
    command: >
      bash -c '
      /opt/mssql-tools/bin/sqlcmd -S mssql -U sa -P strongPassword123 -d master -i docker-entrypoint-initdb.d/init.sql;
      echo "All done!";
      '
    volumes:
      - ./server/fixtures/test_schema_mssql.sql:/docker-entrypoint-initdb.d/init.sql
    logging:
      options:
        max-size: "10m"
        max-file: "2"