Flask 系列之 Migration

pip install flask
pip install flask-sqlalchemy
pip install flask-migrate

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

basedir = os.path.abspath(os.path.dirname(__file__))

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + \
    os.path.join(basedir, 'default.sqlite')
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True

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

@app.shell_context_processor
def make_shell_context():
    return dict(app=app, db=db, User=User)

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

set flask_app=manage.py

# 初始化 migration
flask db init

#执行 migration
flask db migrate -m "initialize"

# 更新 migration（注：如果不执行此步，那么我们的变动则无法同步到数据库）
flask db upgrade