如何使用docker使用peewee和mysql？

my_project/
├── app.py
├── models.py
└── Dockerfile

from peewee import MySQLDatabase, Model, CharField

db = MySQLDatabase('my_database', user='root', password='password', host='mysql')

class BaseModel(Model):
    class Meta:
        database = db

class User(BaseModel):
    username = CharField(unique=True)

db.connect()
db.create_tables([User])

@app.route('/users', methods=['POST'])
def create_user():
    user = User.create(username='testuser')
    return {'id': user.id, 'username': user.username}, 201

from peewee import MySQLDatabase, Model, CharField

db = MySQLDatabase('my_database', user='root', password='password', host='mysql')

class BaseModel(Model):
    class Meta:
        database = db

class User(BaseModel):
    username = CharField(unique=True)

# 使用官方 Python 基础镜像
FROM python:3.9-slim

# 设置工作目录
WORKDIR /app

# 复制项目文件到容器中
COPY . /app

# 安装依赖
RUN pip install peewee flask mysqlclient

# 暴露端口
EXPOSE 5000

# 运行应用程序
CMD ["python", "app.py"]

version: '3'
services:
  web:
    build: .
    ports:
      - "5000:5000"
    depends_on:
      - mysql
  mysql:
    image: "mysql:5.7"
    environment:
      MYSQL_DATABASE: 'my_database'
      MYSQL_USER: 'root'
      MYSQL_PASSWORD: 'password'
      MYSQL_ROOT_PASSWORD: 'root_password'
    ports:
      - "3306:3306"

docker-compose up --build