docker-compose.yml

version: "3.8"

services:
  db:
    image: mysql:latest
    environment:
      MYSQL_ROOT_PASSWORD: mypassword
      MYSQL_DATABASE: mydatabase
      MYSQL_USER: myusername
      MYSQL_PASSWORD: mypassword
    ports:
      - "3306:3306"
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "myusername", "--password=mypassword"]
      interval: 10s
      timeout: 5s
      retries: 5

  db-loader:
    image: python:3.8
    depends_on:
      - db
    volumes:
      - "./mysql-init:/docker-entrypoint-initdb.d"
    environment:
      MYSQL_USER: myusername
      MYSQL_PASSWORD: mypassword
      MYSQL_DATABASE: mydatabase
    command: [ "/bin/bash", "-c", "pip install -r /docker-entrypoint-initdb.d/requirements.txt && python /docker-entrypoint-initdb.d/load_data.py" ]

  test-db:
    image: mysql:latest
    environment:
      MYSQL_DATABASE: test_db
      MYSQL_USER: testuser
      MYSQL_PASSWORD: testpassword
      MYSQL_ROOT_PASSWORD: rootpassword
    ports:
      - "3308:3306"

  app:
    build: .
    depends_on:
      db:
        condition: service_healthy
    ports:
      - "8080:8080"
    environment:
      SPRING_DATASOURCE_URL: jdbc:mysql://db:3306/mydatabase?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC
      SPRING_DATASOURCE_USERNAME: myusername
      SPRING_DATASOURCE_PASSWORD: mypassword