docker-compose.yml

services:
  mariadb:
    image: mariadb
    container_name: njord_mariadb
    environment:
      MARIADB_ROOT_PASSWORD: njord_rootpwd
      MARIADB_DATABASE: njord_db
      MARIADB_USER: njord_user
      MARIADB_PASSWORD: njord_password
    ports:
      - "3307:3306"
    volumes:
      - mariadb_data:/var/lib/mysql
      - ./njord_examples/mariadb/init.sql:/docker-entrypoint-initdb.d/init.sql
      - ./njord/db/test/mariadb.sql:/docker-entrypoint-initdb.d/tests.sql

  mysql:
    image: mysql:8.0
    container_name: njord_mysql
    environment:
      MYSQL_ROOT_PASSWORD: njord_rootpwd
      MYSQL_DATABASE: njord_db
      MYSQL_USER: njord_user
      MYSQL_PASSWORD: njord_password
    ports:
      - "3306:3306"
    volumes:
      - mysql_data:/var/lib/mysql
      - ./njord_examples/mysql/init.sql:/docker-entrypoint-initdb.d/init.sql
      - ./njord/db/test/mysql.sql:/docker-entrypoint-initdb.d/tests.sql

  oracle:
    image: gvenzl/oracle-free:latest
    container_name: njord_oracle
    environment:
      ORACLE_PASSWORD: njord_password
      APP_USER: test
      APP_USER_PASSWORD: test
    ports:
      - "1521:1521"
      - "5500:5500"
    volumes:
      - ./njord_examples/oracle/init_scripts:/container-entrypoint-initdb.d
      - ./njord/db/test/oracle:/container-entrypoint-initdb.d
    healthcheck:
      test: ["CMD", "healthcheck.sh"]
      interval: 10s
      timeout: 5s
      retries: 10
      start_period: 5s
      start_interval: 5s

  sqlserver:
    image: mcr.microsoft.com/mssql/server:2019-latest
    container_name: njord_mssql
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_SA_PASSWORD=Njord_passw0rd
      - MSSQL_PID=Developer
    ports:
      - 1433:1433
    volumes:
      - mssql_data:/var/opt/mssql
      - ./njord_examples/mssql/init_scripts:/tmp/init
      - ./njord/db/test/mssql:/tmp/tests
    restart: always
    healthcheck:
      test:
        [
          "CMD-SHELL",
          "/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P Njord_passw0rd -C -i /tmp/init/create_tables.sql && /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P Njord_passw0rd -C -i /tmp/tests/setup.sql || exit 1",
        ]
      interval: 10s
      retries: 10
      start_period: 10s
      timeout: 3s

volumes:
  mysql_data:
  oracle_data:
  mssql_data:
  mariadb_data: