如何使用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 zvvq好，好zvvq

pip3 install pipenv zvvq

pipenv shell

def create_app(): 内容来自zvvq，别采集哟

app = Flask(__name__)

导入config中的配置文件 zvvq好，好zvvq

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

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

return app 内容来自zvvq

from app.app import create_app 内容来自zvvq

app = create_app() 内容来自samhan666

if __name__ == &39;__main__&39;: 内容来自samhan

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

from flask import Blueprint 本文来自zvvq

login = Blueprint(&39;login&39;, __name__) 内容来自samhan

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

zvvq.cn

def loginIndex():

内容来自samhan

return "login Hello" zvvq.cn

from flask import Flask 本文来自zvvq

def create_app(): 内容来自zvvq

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

导入config中的配置文件 zvvq

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

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

注册并导入蓝图

内容来自zvvq

register_blue(app)

return app

def register_blue(app):

zvvq

from app.api.login import login zvvq

app.register_blueprint(login) copyright zvvq

class BaseRoutes: zvvq好，好zvvq

def __init__(self, name):

self.name = name

内容来自zvvq

self.loader = []

def route(self, rule, options):

def decorator(f):

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

return f

return decorator zvvq好，好zvvq

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

zvvq好，好zvvq

依次注册蓝图

内容来自samhan

for f, rule, options in self.loader: zvvq

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

zvvq好，好zvvq

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

from app.libs.BaseRoutes import BaseRoutes 内容来自zvvq

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

内容来自zvvq

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

def loginHandle():

return "login Hello"

from flask_sqlalchemy import SQLAlchemy zvvq好，好zvvq

db = SQLAlchemy() 内容来自zvvq，别采集哟

class Base(db.Model):

zvvq.cn

忽略基类的主键 zvvq.cn

__abstract__ = True 本文来自zvvq

from app.models.base import Base zvvq

class User(Base):

zvvq好，好zvvq

__tablename__ = &39;user&39; copyright zvvq

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

内容来自zvvq，别采集哟

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

本文来自zvvq

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

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

@property

copyright zvvq

def password(self): 内容来自samhan666

return self._password 内容来自zvvq，别采集哟

@password.setter zvvq好，好zvvq

def password(self, raw):

zvvq.cn

self._password = generate_password_hash(raw) 内容来自zvvq，别采集哟

SQLALCHEMY_DATABASE_URI = &39;mysql+pymysql://root:123456@127.0.0.1:3306/admin?charset=utf8&39; 内容来自samhan

def create_app():

app = Flask(__name__) 内容来自samhan

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

内容来自zvvq，别采集哟

初始化数据库 本文来自zvvq

db.init_app(app) 内容来自samhan

with app.app_context(): zvvq

db.create_all()

return app

内容来自samhan

from sqlalchemy import Column, Integer, String, SmallInteger zvvq

from app.models.base import Base, db 内容来自samhan

class tp_manager(Base):

zvvq.cn

STATUS_NORMAL = 1

zvvq.cn

STATUS_STOP = 0

zvvq

... copyright zvvq

@classmethod 内容来自zvvq

def get_manager_by_name(cls, username):

zvvq

r = cls.query.filter(cls.username == username, cls.status == cls.STATUS_NORMAL).one() 本文来自zvvq

return r

本文来自zvvq

@classmethod

def get_db(cls):

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

return r

zvvq.cn

from flask import request, session, jsonify

from app.libs.BaseRoutes import BaseRoutes 内容来自samhan666

from app.validators.form.login import LoginForm

内容来自zvvq

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;])

内容来自zvvq

def loginHandle():

内容来自zvvq

form = LoginForm(request.form)

内容来自zvvq

if form.validate():

验证通过的逻辑 本文来自zvvq

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

if r: 本文来自zvvq

msg = &39;操作成功&39; 内容来自zvvq，别采集哟

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

else:

msg = &39;账号和密码错误&39; zvvq

return jsonify({"code": 200, "data": [], "msg": msg})

zvvq好，好zvvq

else: 内容来自zvvq

错误暂时忽略...

return form.errors 内容来自zvvq，别采集哟

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

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

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

内容来自samhan

DOUBLE, DATETIME, TIMESTAMP, DECIMAL

内容来自zvvq

from sqlalchemy import Column, Index, Integer

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

内容来自samhan666

DOUBLE, DATETIME, TIMESTAMP, DECIMAL

from app.models.base import Base, db 内容来自samhan

class wm_user_user(Base):

zvvq好，好zvvq

STATUS_NORMAL = 1

__tablename__ = &39;wm_user_user&39;

copyright zvvq

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

comment="1为正常,0为审核中") copyright zvvq

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

zvvq.cn

添加配置设置编码

__table_args__ = { zvvq

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

&39;mysql_collate&39;: &39;utf8mb4_general_ci&39; zvvq

} 内容来自samhan666

"""Construct a TINYINT.

本文来自zvvq

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

:param unsigned: a boolean, optional.

本文来自zvvq

:param zerofill: Optional. If true, values will be stored as strings

zvvq

left-padded with zeros. Note that this does not effect the values

zvvq

returned by the underlying database API, which continue to be 内容来自samhan

numeric. 本文来自zvvq

"""

__tablename__ = &39;wm_user_user&39;

zvvq

...

本文来自zvvq

__table_args__ = {

内容来自zvvq

&39;mysql_charset&39;: &39;utf8mb4&39;, 内容来自samhan666

&39;mysql_collate&39;: &39;utf8mb4_general_ci&39; 内容来自zvvq

}