from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
HOST = "localhost"
PORT = 3306
DATA_BASE = 'flask_migrate'
USER = "root"
PWD = "root"
DB_URI = f'mysql+pymysql://{USER}:{PWD}@{HOST}:{PORT}/{DATA_BASE}'
app.config['SQLALCHEMY_DATABASE_URI'] = DB_URI
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
class User(db.Model):
__tablename = 't_user'
id = db.Column(db.Integer, primary_key = True, autoincrement=True)
name = db.Column(db.String(32))
age = db.Column(db.Integer)
ti = db.Column(db.Integer)
ti2 = db.Column(db.Integer)
def __repr__(self) -> str:
return f'<User id={self.id} name={self.name}>'
# Flask-Migrate 就是对Alembic进行一个封装,不用再设置参数了
from flask_migrate import Migrate
Migrate(app,db)
# 创建migrations文件夹
# flask db init
# 生成脚本文件
# flask db migrate (-m '') # 给版本号取名
# 更新数据库
# flask db upgrade
# 返回以前版本
# flask db downgrade version_
115.Flask-Migrate
最新推荐文章于 2024-06-18 08:51:43 发布