【无标题】

模型类迁移

1.配置项配置

class DefaultConfig:
    SECRET_KEY = "asdfggfdfffgfdadsdg"
    SQLALCHEMY_DATABASE_URI = ""
    SQLALCHEMY_TRACK_MODIFICATIONS = False
    SQLALCHEMY_ECHO = True
    JSON_AS_ASCII = False

class DevConfig(DefaultConfig):
    SQLALCHEMY_DATABASE_URI = "mysql+pymysql://root:123@127.0.0.1:3306/h2111p7"

2.manage.py文件配置

from flask_script import Manager
from flask_migrate import MigrateCommand,Migrate
from app import app
from models.model import db

manage = Manager(app)
migrate = Migrate(app,db)
manage.add_command("db",MigrateCommand)

if __name__ == '__main__':
    manage.run()

3.蓝图加载配置项

# 加载配置项
    flask_app.config.from_object(config)

4.写模型类

from flask_sqlalchemy import SQLAlchemy
from sqlalchemy.orm import backref

db = SQLAlchemy()

class UserModel(db.Model):
    id = db.Column(db.Integer,primary_key=True,autoincrement=True,comment="ID")
    name = db.Column(db.String(32),comment="用户名")

5.迁移

# 执行迁移命令
python run.py db init  # 初始化，只需要初始化一次
python run.py db migrate  # 生成迁移文件
python run.py db upgrade