数据库迁移

数据库迁移

这里用到flask-migrate

pip install flask-migrate

第一种

数据库实例化

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_migrate import Migrate

app = Flask(__name__)
db = SQLAlchemy(app)
migrate = Migrate(app, db)

进入虚拟环境交互模式进行初始化

flask db init

数据库迁移

flask db migrate -m “注释”

数据库更新

flask db upgrade

第二种

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_script import Manager
from flask_mirgrate import Migrate, MigrateCommand

app = Flask(__name__)
db = SQLAlchemy(app)
manager = Manager(app)
Migrate(app, db)
manager.add_command("mc", MigrateCommand)

if __name__ = "__main__"
    manager.run()

进入虚拟环境交互模式进行初始化

python 入口函数 mc init

数据库迁移

python 入口函数 mc migrate -m “注释”

数据库更新

python 入口函数 mc upgrade