docker-compose-mysql.yml

services:
  server:
    build: .
    ports:
      - 8000:8000
    volumes:
      - ./dailynotes-volume:/app/config
    environment:
      API_SECRET_KEY: ${API_SECRET_KEY:-CHANGE_THIS_WITH_SECURE_PASSWORD}
      DB_ENCRYPTION_KEY: ${DB_ENCRYPTION_KEY:-CHANGE_THIS_WITH_SECURE_PASSWORD}
      DATABASE_URI: mysql+pymysql://dailynotes:dailynotes@mysql:3306/dailynotes?charset=utf8mb4
    depends_on:
      mysql:
        condition: service_healthy
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:8000/health"]
      interval: 30s
      timeout: 10s
      retries: 3
      start_period: 60s

  mysql:
    image: mysql:8.0
    environment:
      MYSQL_ROOT_PASSWORD: rootpassword
      MYSQL_DATABASE: dailynotes
      MYSQL_USER: dailynotes
      MYSQL_PASSWORD: dailynotes
    volumes:
      - mysql-data:/var/lib/mysql
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-u", "root", "-prootpassword"]
      interval: 10s
      timeout: 5s
      retries: 5
      start_period: 30s
    # Uncomment to expose MySQL port for direct access
    # ports:
    #   - 3306:3306

volumes:
  mysql-data: