5.Flask-Migrate

DB_URI = "mysql+pymysql://root:123456@127.0.0.1:3306/flask_migrate?charset=utf8"

SQLALCHEMY_DATABASE_URI = DB_URI

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

from exts import db

class User(db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    username = db.Column(db.String(50),nullable=False)

from flask import Flask
from exts import db
import config

app = Flask(__name__)
app.config.from_object(config)
db.init_app(db)

@app.route('/')
def hello_world():
    return 'Hello World!'


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

pip install flask-migrate

from flask_script import Manager
from flask_migrate_demo import app
from exts import db
import models   #这个一定要导入
from flask_migrate import Migrate,MigrateCommand

manager = Manager(app)
Migrate(app,db)
manager.add_command("db",MigrateCommand)   #把所有命令放到db里面

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

python manage.py db init

python manage.py db migrate -m '第一次提交'

python manage.py db upgrade