Ophir LOJKINE
80 lines
2.3 KiB
YAML
80 lines
2.3 KiB
YAML
# You can easily switch between different databases by changing the value of COMPOSE_PROFILES in the .env file.
|
|
|
|
# possible database connection strings:
|
|
# DATABASE_URL='postgres://root:Password123!@localhost/sqlpage'
|
|
# DATABASE_URL='mssql://root:Password123!@localhost/sqlpage'
|
|
# DATABASE_URL='mysql://root:Password123!@localhost/sqlpage'
|
|
# DATABASE_URL='Driver={/usr/lib64/psqlodbcw.so};Server=127.0.0.1;Port=5432;Database=sqlpage;UID=root;PWD=Password123!'
|
|
# DATABASE_URL='Driver=Oracle 21 ODBC driver;Dbq=//127.0.0.1:1521/FREEPDB1;Uid=root;Pwd=Password123!'
|
|
|
|
# Run for instance:
|
|
# docker compose up postgres
|
|
# and in another terminal:
|
|
# DATABASE_URL='db_url' cargo test
|
|
services:
|
|
web:
|
|
build: { context: "." }
|
|
ports:
|
|
- "8080:8080"
|
|
volumes:
|
|
- .:/var/www
|
|
depends_on:
|
|
# mssql: { condition: service_healthy }
|
|
[ "${COMPOSE_PROFILES-postgres}" ]
|
|
environment:
|
|
DATABASE_URL: ${COMPOSE_PROFILES-postgres}://root:Password123!@${COMPOSE_PROFILES:-postgres}/sqlpage${DATABASE_URL_PARAMS:-}
|
|
RUST_LOG: sqlpage=trace
|
|
postgres:
|
|
profiles: ["postgres"]
|
|
ports: ["5432:5432"]
|
|
build: { context: "db-test-setup/postgres" }
|
|
shm_size: 128mb
|
|
environment:
|
|
POSTGRES_USER: root
|
|
POSTGRES_DB: sqlpage
|
|
POSTGRES_PASSWORD: Password123!
|
|
healthcheck:
|
|
test: pg_isready -U root -d sqlpage
|
|
|
|
mysql:
|
|
profiles: ["mysql"]
|
|
ports: ["3306:3306"]
|
|
image: mysql
|
|
environment:
|
|
MYSQL_ROOT_PASSWORD: Password123!
|
|
MYSQL_DATABASE: sqlpage
|
|
|
|
mssql:
|
|
profiles: ["mssql"]
|
|
ports: ["1433:1433"]
|
|
build: { context: "db-test-setup/mssql" }
|
|
healthcheck:
|
|
test: /opt/mssql-tools18/bin/sqlcmd -S localhost -U root -P "Password123!" -Q "SELECT 1" -b -o /dev/null -No
|
|
interval: 10s
|
|
timeout: 3s
|
|
retries: 10
|
|
start_period: 10s
|
|
|
|
mariadb:
|
|
profiles: ["mariadb"]
|
|
ports: ["3306:3306"]
|
|
image: mariadb
|
|
environment:
|
|
MYSQL_ROOT_PASSWORD: Password123!
|
|
MYSQL_DATABASE: sqlpage
|
|
|
|
oracle:
|
|
profiles: ["oracle"]
|
|
ports: ["1521:1521"]
|
|
image: gvenzl/oracle-free:23.26.2-slim
|
|
environment:
|
|
ORACLE_PASSWORD: Password123!
|
|
APP_USER: root
|
|
APP_USER_PASSWORD: Password123!
|
|
healthcheck:
|
|
test: ["CMD", "healthcheck.sh"]
|
|
interval: 10s
|
|
timeout: 5s
|
|
retries: 10
|
|
start_period: 5s
|