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

<a style=color:f60; text-decoration:underline; href="https://www.php.cn/zt/15730.html" target="_blank">python</a>3 -V && pip3 -V

pip3 install pipenv 本文来自zvvq

pipenv shell zvvq

def create_app(): 内容来自samhan

app = Flask(__name__) copyright zvvq

导入config中的配置文件 copyright zvvq

app.config.from_object(&39;app.config.setting&39;)

app.config.from_object(&39;app.config.secure&39;)

return app 本文来自zvvq

from app.app import create_app zvvq好，好zvvq

app = create_app()

本文来自zvvq

if __name__ == &39;__main__&39;:

内容来自samhan

app.run(debug =True,port=81,host= &39;0.0.0.0&39;) zvvq.cn

from flask import Blueprint

login = Blueprint(&39;login&39;, __name__)

内容来自zvvq

@login.route(&39;/login&39;) zvvq

def loginIndex():

内容来自zvvq，别采集哟

return "login Hello" 内容来自zvvq

from flask import Flask zvvq好，好zvvq

def create_app():

app = Flask(__name__)

导入config中的配置文件 copyright zvvq

app.config.from_object(&39;app.config.setting&39;) 内容来自zvvq

app.config.from_object(&39;app.config.secure&39;) 内容来自samhan

注册并导入蓝图

register_blue(app) zvvq.cn

return app zvvq好，好zvvq

def register_blue(app): 本文来自zvvq

from app.api.login import login

app.register_blueprint(login) 内容来自samhan

class BaseRoutes: zvvq好，好zvvq

def __init__(self, name):

内容来自zvvq

self.name = name 内容来自zvvq

self.loader = [] zvvq好，好zvvq

def route(self, rule, options):

zvvq好，好zvvq

def decorator(f):

self.loader.append((f, rule, options))

return f

return decorator 内容来自samhan

def register(self, bp, url_prefix=&39;&39;):

依次注册蓝图

copyright zvvq

for f, rule, options in self.loader:

endpoint = options.pop("endpoint", f.__name__)

内容来自zvvq，别采集哟

bp.add_url_rule(url_prefix + rule, endpoint, f, options) 本文来自zvvq

from app.libs.BaseRoutes import BaseRoutes

api = BaseRoutes(&39;login&39;)

copyright zvvq

@api.route(&39;/login/loginHandle&39;, methods=[&39;GET&39;, &39;POST&39;]) zvvq.cn

def loginHandle():

内容来自zvvq

return "login Hello" zvvq.cn

from flask_sqlalchemy import SQLAlchemy 内容来自samhan

db = SQLAlchemy() zvvq

class Base(db.Model): 本文来自zvvq

忽略基类的主键

__abstract__ = True

from app.models.base import Base

zvvq.cn

class User(Base): 内容来自samhan666

__tablename__ = &39;user&39; zvvq

id = Column(Integer, primary_key=True, autoincrement=True)

name = Column(String(50), nullable=False, default="")

email = Column(String(120), nullable=False, default="")

copyright zvvq

_password = Column(&39;password&39;,String(64))

zvvq好，好zvvq

@property

zvvq.cn

def password(self): 内容来自zvvq

return self._password

@password.setter 内容来自zvvq，别采集哟

def password(self, raw):

self._password = generate_password_hash(raw) copyright zvvq

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

内容来自zvvq

def create_app():

app = Flask(__name__) 内容来自zvvq，别采集哟

app.config.from_object(&39;app.config.secure&39;)

zvvq

初始化数据库 内容来自zvvq，别采集哟

db.init_app(app) 内容来自zvvq

with app.app_context(): 本文来自zvvq

db.create_all() 内容来自zvvq

return app 内容来自zvvq，别采集哟

from sqlalchemy import Column, Integer, String, SmallInteger

copyright zvvq

from app.models.base import Base, db zvvq.cn

class tp_manager(Base):

内容来自zvvq，别采集哟

STATUS_NORMAL = 1 本文来自zvvq

STATUS_STOP = 0 内容来自samhan666

... 内容来自zvvq

@classmethod 内容来自zvvq，别采集哟

def get_manager_by_name(cls, username):

r = cls.query.filter(cls.username == username, cls.status == cls.STATUS_NORMAL).one() zvvq.cn

return r

内容来自samhan

@classmethod 本文来自zvvq

def get_db(cls): 本文来自zvvq

r = db.session.query(cls).filter(cls.status == cls.STATUS_NORMAL).all()

return r 内容来自zvvq，别采集哟

from flask import request, session, jsonify 内容来自samhan666

from app.libs.BaseRoutes import BaseRoutes zvvq好，好zvvq

from app.validators.form.login import LoginForm 内容来自samhan

from app.models.admin.tp_manager import tp_manager 内容来自samhan

api = BaseRoutes(&39;login&39;) 内容来自zvvq，别采集哟

@api.route(&39;/login/loginHandle&39;, methods=[&39;POST&39;])

内容来自samhan

def loginHandle(): zvvq

form = LoginForm(request.form)

copyright zvvq

if form.validate():

内容来自zvvq，别采集哟

验证通过的逻辑

本文来自zvvq

r = tp_manager.get_manager_by_name(form.username.data)

zvvq.cn

if r: zvvq好，好zvvq

msg = &39;操作成功&39;

内容来自zvvq，别采集哟

session[&39;manager_id&39;] = r.id 本文来自zvvq

else:

内容来自samhan

msg = &39;账号和密码错误&39; 内容来自zvvq，别采集哟

return jsonify({"code": 200, "data": [], "msg": msg}) 本文来自zvvq

else:

错误暂时忽略...

zvvq.cn

return form.errors 内容来自samhan

SECRET_KEY = &39;需要加密的key值&39; zvvq

Column(Integer, index=True, nullable=False,  server_default="0",comment="昵称") 本文来自zvvq

from sqlalchemy.dialects.mysql import VARCHAR, TEXT, BIGINT, INTEGER, SMALLINT, TINYINT, DECIMAL, FLOAT, \

zvvq.cn

DOUBLE, DATETIME, TIMESTAMP, DECIMAL

zvvq好，好zvvq

from sqlalchemy import Column, Index, Integer copyright zvvq

from sqlalchemy.dialects.mysql import VARCHAR, TEXT, BIGINT, INTEGER, SMALLINT, TINYINT, DECIMAL, FLOAT, \ 内容来自samhan

DOUBLE, DATETIME, TIMESTAMP, DECIMAL

from app.models.base import Base, db

本文来自zvvq

class wm_user_user(Base):

copyright zvvq

STATUS_NORMAL = 1 zvvq.cn

__tablename__ = &39;wm_user_user&39; 内容来自samhan

user_status = Column(TINYINT(display_width=1,unsigned=True), nullable=False, server_default="1",

zvvq.cn

comment="1为正常,0为审核中") 内容来自samhan666

user_nickname = Column(VARCHAR(length=50), index=True, nullable=False, comment="昵称")

copyright zvvq

添加配置设置编码 内容来自samhan

__table_args__ = {

zvvq.cn

&39;mysql_charset&39;: &39;utf8mb4&39;, 本文来自zvvq

&39;mysql_collate&39;: &39;utf8mb4_general_ci&39; 内容来自zvvq，别采集哟

}

内容来自samhan666

"""Construct a TINYINT.

:param display_width: Optional, maximum display width for this number.

zvvq

:param unsigned: a boolean, optional.

:param zerofill: Optional. If true, values will be stored as strings 内容来自samhan666

left-padded with zeros. Note that this does not effect the values 本文来自zvvq

returned by the underlying database API, which continue to be 内容来自zvvq，别采集哟

numeric.

""" 内容来自samhan666

__tablename__ = &39;wm_user_user&39;

...

__table_args__ = { copyright zvvq

&39;mysql_charset&39;: &39;utf8mb4&39;,

内容来自zvvq

&39;mysql_collate&39;: &39;utf8mb4_general_ci&39; 本文来自zvvq

} zvvq.cn