如何使用Flask Blueprint和SQLAlchemy编写Python应用程序

python3 -V && pip3 -Vpip3 install pipenv

pipenv shell

def create_app():    app = Flask(__name__)    # 导入config中的配置文件    app.config.from_object('app.config.setting')    app.config.from_object('app.config.secure')    return app

from app.app import create_appapp = create_app()if __name__ == '__main__':    app.run(debug =True,port=81,host= '0.0.0.0')

from flask import Blueprintlogin = Blueprint('login', __name__)@login.route('/login')def loginIndex():    return "login Hello"

from flask import Flaskdef create_app():    app = Flask(__name__)    # 导入config中的配置文件    app.config.from_object('app.config.setting')    app.config.from_object('app.config.secure')    # 注册并导入蓝图    register_blue(app)    return appdef register_blue(app):    from app.api.login import login    app.register_blueprint(login)

class BaseRoutes:    def __init__(self, name):        self.name = name        self.loader = []    def route(self, rule, **options):        def decorator(f):            self.loader.append((f, rule, options))            return f        return decorator    def register(self, bp, url_prefix=''):        # 依次注册蓝图        for f, rule, options in self.loader:            endpoint = options.pop("endpoint", f.__name__)            bp.add_url_rule(url_prefix + rule, endpoint, f, **options)

from app.libs.BaseRoutes import BaseRoutesapi = BaseRoutes('login')@api.route('/login/loginHandle', methods=['GET', 'POST'])def loginHandle():    return "login Hello"

from flask_sqlalchemy import SQLAlchemydb = SQLAlchemy()class Base(db.Model):    # 忽略基类的主键    __abstract__ = True

from app.models.base import Baseclass User(Base):    __tablename__ = 'user'    id = Column(Integer, primary_key=True, autoincrement=True)    name = Column(String(50), nullable=False, default="")    email = Column(String(120), nullable=False, default="")    _password = Column('password',String(64))    @property    def password(self):        return self._password    @password.setter    def password(self, raw):        self._password = generate_password_hash(raw)

SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:123456@127.0.0.1:3306/admin?charset=utf8'

def create_app():    app = Flask(__name__)    app.config.from_object('app.config.secure')    # 初始化数据库    db.init_app(app)    with app.app_context():        db.create_all()    return app

from sqlalchemy import Column, Integer, String, SmallIntegerfrom app.models.base import Base, dbclass tp_manager(Base):    STATUS_NORMAL = 1    STATUS_STOP = 0    # ...    @classmethod    def get_manager_by_name(cls, username):        r = cls.query.filter(cls.username == username, cls.status == cls.STATUS_NORMAL).one()        return r    @classmethod    def get_db(cls):        r = db.session.query(cls).filter(cls.status == cls.STATUS_NORMAL).all()        return r

from flask import request, session, jsonifyfrom app.libs.BaseRoutes import BaseRoutesfrom app.validators.form.login import LoginFormfrom app.models.admin.tp_manager import tp_managerapi = BaseRoutes('login')@api.route('/login/loginHandle', methods=['POST'])def loginHandle():    form = LoginForm(request.form)    if form.validate():        # 验证通过的逻辑        r = tp_manager.get_manager_by_name(form.username.data)        if r:            msg = '操作成功'            session['manager_id'] = r.id        else:            msg = '账号和密码错误'        return jsonify({"code": 200, "data": [], "msg": msg})    else:        # 错误暂时忽略...        return form.errors

SECRET_KEY = '需要加密的key值'

Column(Integer, index=True, nullable=False,  server_default="0",comment="昵称")

from sqlalchemy.dialects.mysql import VARCHAR, TEXT, BIGINT, INTEGER, SMALLINT, TINYINT, DECIMAL, FLOAT,     DOUBLE, DATETIME, TIMESTAMP, DECIMAL

from sqlalchemy import Column, Index, Integerfrom sqlalchemy.dialects.mysql import VARCHAR, TEXT, BIGINT, INTEGER, SMALLINT, TINYINT, DECIMAL, FLOAT,     DOUBLE, DATETIME, TIMESTAMP, DECIMALfrom app.models.base import Base, dbclass wm_user_user(Base):    STATUS_NORMAL = 1    __tablename__ = 'wm_user_user'    user_status = Column(TINYINT(display_width=1,unsigned=True), nullable=False, server_default="1",                         comment="1为正常,0为审核中")    user_nickname = Column(VARCHAR(length=50), index=True, nullable=False, comment="昵称")    # 添加配置设置编码    __table_args__ = {        'mysql_charset': 'utf8mb4',        'mysql_collate': 'utf8mb4_general_ci'    }

"""Construct a TINYINT.:param display_width: Optional, maximum display width for this number.:param unsigned: a boolean, optional.:param zerofill: Optional. If true, values will be stored as strings  left-padded with zeros. Note that this does not effect the values  returned by the underlying database API, which continue to be  numeric."""

__tablename__ = 'wm_user_user'# ...__table_args__ = {    'mysql_charset': 'utf8mb4',    'mysql_collate': 'utf8mb4_general_ci'}