Flask-Migrate 数据库

安装

pip install Flask-Migrate

初始化

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

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db'

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

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128))

# 单个库
flask db init
# 多个库
flask db init --multidb

修改模型

~/.pyenv/versions/sqlacodegen/bin/sqlacodegen mysql://ITXiaoPang:xxxxxx@127.0.0.1/davinci|pbcopy

显示当前版本和上个版本

flask db show

迁移

flask db migrate -m "Initial migration."

升级

flask db upgrade --sql

flask db upgrade