如何使用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 内容来自samhan666

pip3 install pipenv

zvvq好，好zvvq

pipenv shell

zvvq.cn

def create_app():

zvvq

app = Flask(__name__)

导入config中的配置文件

内容来自samhan

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

app = create_app() zvvq

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

app.run(debug =True,port=81,host= &39;0.0.0.0&39;) 内容来自zvvq

from flask import Blueprint 内容来自samhan666

login = Blueprint(&39;login&39;, __name__) 本文来自zvvq

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

copyright zvvq

def loginIndex(): 内容来自zvvq

return "login Hello" 内容来自samhan666

from flask import Flask 内容来自zvvq

def create_app():

内容来自samhan

app = Flask(__name__) zvvq.cn

导入config中的配置文件 内容来自samhan

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

copyright zvvq

app.config.from_object(&39;app.config.secure&39;) 内容来自zvvq，别采集哟

注册并导入蓝图

register_blue(app) 本文来自zvvq

return app copyright zvvq

def register_blue(app): 内容来自samhan666

from app.api.login import login 本文来自zvvq

app.register_blueprint(login) zvvq.cn

class BaseRoutes:

def __init__(self, name):

zvvq.cn

self.name = name

self.loader = []

def route(self, rule, options):

copyright zvvq

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

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

内容来自zvvq

return f

内容来自samhan

return decorator

copyright zvvq

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

内容来自zvvq

依次注册蓝图 本文来自zvvq

for f, rule, options in self.loader:

copyright zvvq

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

内容来自samhan666

bp.add_url_rule(url_prefix + rule, endpoint, f, options)

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

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

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

def loginHandle():

return "login Hello" zvvq

from flask_sqlalchemy import SQLAlchemy

本文来自zvvq

db = SQLAlchemy() copyright zvvq

class Base(db.Model): 内容来自samhan

忽略基类的主键

内容来自samhan666

__abstract__ = True 内容来自zvvq，别采集哟

from app.models.base import Base

class User(Base): copyright zvvq

__tablename__ = &39;user&39;

内容来自zvvq，别采集哟

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

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

zvvq好，好zvvq

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

_password = Column(&39;password&39;,String(64)) 内容来自samhan666

@property

本文来自zvvq

def password(self):

内容来自zvvq

return self._password

@password.setter 内容来自samhan666

def password(self, raw):

self._password = generate_password_hash(raw)

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

def create_app(): zvvq.cn

app = Flask(__name__) 内容来自zvvq

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

初始化数据库

db.init_app(app) 内容来自zvvq

with app.app_context(): zvvq.cn

db.create_all()

内容来自zvvq

return app zvvq好，好zvvq

from sqlalchemy import Column, Integer, String, SmallInteger

zvvq.cn

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

class tp_manager(Base):

STATUS_NORMAL = 1 copyright zvvq

STATUS_STOP = 0

zvvq

... zvvq.cn

@classmethod

zvvq好，好zvvq

def get_manager_by_name(cls, username):

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

return r 本文来自zvvq

@classmethod

def get_db(cls):

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

return r 内容来自samhan

from flask import request, session, jsonify 本文来自zvvq

from app.libs.BaseRoutes import BaseRoutes 内容来自zvvq，别采集哟

from app.validators.form.login import LoginForm

内容来自samhan666

from app.models.admin.tp_manager import tp_manager

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

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

def loginHandle():

form = LoginForm(request.form) 本文来自zvvq

if form.validate():

内容来自samhan666

验证通过的逻辑 copyright zvvq

r = tp_manager.get_manager_by_name(form.username.data) 内容来自zvvq，别采集哟

if r:

本文来自zvvq

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

zvvq好，好zvvq

session[&39;manager_id&39;] = r.id

else: 内容来自zvvq

msg = &39;账号和密码错误&39; 内容来自samhan

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

else:

错误暂时忽略... zvvq.cn

return form.errors 内容来自samhan666

SECRET_KEY = &39;需要加密的key值&39; 内容来自samhan

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

DOUBLE, DATETIME, TIMESTAMP, DECIMAL

from sqlalchemy import Column, Index, Integer

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

DOUBLE, DATETIME, TIMESTAMP, DECIMAL

内容来自zvvq，别采集哟

from app.models.base import Base, db

内容来自samhan

class wm_user_user(Base): zvvq.cn

STATUS_NORMAL = 1 zvvq

__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为审核中") 内容来自zvvq

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

添加配置设置编码

__table_args__ = { zvvq好，好zvvq

&39;mysql_charset&39;: &39;utf8mb4&39;, zvvq.cn

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

}

zvvq好，好zvvq

"""Construct a TINYINT.

:param display_width: Optional, maximum display width for this number. 内容来自samhan

:param unsigned: a boolean, optional. 本文来自zvvq

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

left-padded with zeros. Note that this does not effect the values 内容来自zvvq，别采集哟

returned by the underlying database API, which continue to be

numeric. 内容来自zvvq

""" copyright zvvq

__tablename__ = &39;wm_user_user&39;

zvvq.cn

...

__table_args__ = {

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

内容来自zvvq

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

内容来自zvvq

}