adba/docker-compose.testing.yml at master · joneldiablo/adba · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
version: '3.8'

services:
  # MariaDB (MySQL compatible) - puerto 3307 para no afectar el 3306
  mariadb:
    image: mariadb:10.11
    container_name: adba-mariadb-test
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
      MYSQL_DATABASE: adba_test
      MYSQL_USER: adba_user
      MYSQL_PASSWORD: ${DB_MYSQL_PASSWORD}
    ports:
      - "3307:3306"
    healthcheck:
      test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
      interval: 10s
      timeout: 5s
      retries: 5
    volumes:
      - mariadb_data:/var/lib/mysql
    restart: "no"

  # PostgreSQL - puerto 5433 para no afectar el 5432
  postgres:
    image: postgres:16-alpine
    container_name: adba-postgres-test
    environment:
      POSTGRES_USER: adba_user
      POSTGRES_PASSWORD: ${DB_POSTGRES_PASSWORD}
      POSTGRES_DB: adba_test
    ports:
      - "5433:5432"
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U adba_user -d adba_test"]
      interval: 10s
      timeout: 5s
      retries: 5
    volumes:
      - postgres_data:/var/lib/postgresql/data
    restart: "no"

  # MSSQL - puerto 1434 para no afectar el 1433
  mssql:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: adba-mssql-test
    environment:
      ACCEPT_EULA: Y
      SA_PASSWORD: ${DB_MSSQL_PASSWORD}
      MSSQL_PID: Developer
    ports:
      - "1434:1433"
    healthcheck:
      test: /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P "${DB_MSSQL_PASSWORD}" -Q "SELECT 1" -C || exit 1
      interval: 10s
      timeout: 10s
      retries: 10
      start_period: 30s
    volumes:
      - mssql_data:/var/opt/mssql
    restart: "no"

volumes:
  mariadb_data:
  postgres_data:
  mssql_data: