# docker-compose.yml
# 一条命令启动整个系统：docker compose up -d --build
# 停止：docker compose down
# 删除数据：docker compose down -v

services:
  mysql:
    image: mysql:8.0
    container_name: sms-mysql
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: 123456
      MYSQL_DATABASE: student_management_system
      TZ: Asia/Shanghai
    command:
      - --character-set-server=utf8mb4
      - --collation-server=utf8mb4_unicode_ci
      - --default-authentication-plugin=mysql_native_password
    # 注意：不把 3306 映射到宿主机，避免和本机已装的 MySQL 冲突
    # （应用容器通过 Docker 内部网络 "mysql" 主机名访问，不需要映射）
    volumes:
      - mysql_data:/var/lib/mysql
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "-uroot", "-p123456"]
      interval: 5s
      timeout: 5s
      retries: 20

  app:
    build: .
    container_name: sms-app
    restart: unless-stopped
    depends_on:
      mysql:
        condition: service_healthy
    environment:
      # 在容器里 mysql 这个 hostname 解析到 mysql 服务
      DATABASE_URL: mysql+pymysql://root:123456@mysql:3306/student_management_system?charset=utf8mb4
    ports:
      - "8005:8005"

volumes:
  mysql_data: