cd /Users/mac/repose/learn_pytorch/flask_mysql_sqlalchemy_demo
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

mysql -uroot
CREATE DATABASE flask_sqlalchemy_demo DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

flask --app app db init
flask --app app db migrate -m "create users table"
flask --app app db upgrade
flask --app app run --debug

cd /Users/mac/repose/learn_pytorch/flask_mysql_sqlalchemy_demo
source .venv/bin/activate

# 1. 创建数据库
python scripts/create_database.py

# 2. 根据 models.py 生成迁移文件
flask --app app db migrate -m "create users table"

# 3. 执行迁移创建表
flask --app app db upgrade

CREATE DATABASE IF NOT EXISTS `flask_sqlalchemy_demo`
DEFAULT CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;