烧瓶 - 从蓝图迁移模型

Question

我在使用蓝图使用 Flask 创建模块化应用程序时遇到问题。我不确定如何迁移蓝图中定义的模型。

我的应用如下所示：

- app 
- __init__.py 
- user 
__init__.py 
models.py 

app.__init__.py如下所示：

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from config import Config
from flask_migrate import Migrate
from app.auth import bp as user_bp
db = SQLAlchemy()
app = Flask(__name__)
app.config.from_object(Config)
app.register_blueprint(user_bp, url_prefix='/user')
migrate = Migrate(app, db)
from app.auth.models import User

user/.__init__.py：

from flask import Blueprint
bp = Blueprint('user', __name__)

user/models.py：

from app import db

class User(db.Model):
user_id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(128))
last_name = db.Column(db.String(128))
user_name = db.Column(db.String(120))
password_hash = db.Column(db.String(220))
def __repr__(self):
return '<User {}>'.format(self.email)

尝试运行flask db migrate时...没有检测到任何模型，我认为我有某种循环依赖性。

有人可以解释如何正确执行此操作吗？

Answer 1

用户模型(用户/模型.py(应该导入到应用程序中的某个位置，尝试导入到蓝图文件(user/__init__.py(

from flask import Blueprint
from app.user.models import User
bp = Blueprint('user', __name__)

Answer 2

app.py
from flask import Flask
from flask_restful import Resource, Api
from user import user_blueprint
from flask_cors import CORS
app = Flask(__name__)
api = Api(app)
app.register_blueprint(user_blueprint)
cors = CORS(app, resources={r"/*": {"origins": "*"}})

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

model/user.py
from sqlalchemy import Column, INTEGER, String
class User(Base):
__tablename__ = 'USER'
__table_args__ = {'schema': 'MAPPING'}
ID = Column(INTEGER(11), primary_key=True)
FIRST_NAME = Column(String(255), nullable=False, server_default=text("''"))
LAST_NAME = Column(String(255), nullable=False, server_default=text("''"))
EMAIL = Column(String(255), nullable=False, server_default=text("''"))

route/user_route

from flask import Blueprint, jsonify, request
from flask_restful import Resource, Api
user_blueprint = Blueprint('app/', __name__)
user_api = Api(user_blueprint, prefix='/')
class User(Resource):
def get(self):
db_conn = //db connection Object
results = // your query
db_conn.close()
return jsonify(results)
user_api.add_resource(User, '/user')