flask 与 flask_migrate的使用

flask 与 flask_migrate的使用

一、安装

pip install flask-migrate

二、简单使用

# 文件：manage.py

from flask_migrate import migrate
from flask_sqlalchemy import sqlalchemy
from flask import flask

dbuser = "root"
dbpwd = "root"
dbname = "flask_db_1"
dbhost = "127.0.0.1"
dbport = 3306

database_url = 'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format(
    dbuser, dbpwd, dbhost, dbport, dbname)

app = flask(__name__)

app.config["sqlalchemy_database_uri"] = database_url
app.config["sqlalchemy_track_modifications"] = false

db = sqlalchemy()
migrate = migrate()

migrate.init_app(app=app, db=db)
db.init_app(app)


class user(db.model):
    id = db.column(db.integer, autoincrement=true, primary_key=true)
    name = db.column(db.string(32))


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

三、通过终端进行数据库迁移操作

首先进入该文件的目录下

相应执行下面的命令

set flask_app=manage.py
flask db init
flask db migrate
flask db upgrade

执行完毕之后，你再去数据库中查看，新建加了一些表，其中就是user表