3 Flask Web--在flask_sqlalchemy中记录慢查询

最新推荐文章于 2024-07-03 22:47:10 发布

github_38596081

最新推荐文章于 2024-07-03 22:47:10 发布

阅读量549

点赞数

分类专栏： python web开发实战

本文链接：https://blog.csdn.net/github_38596081/article/details/99703707

版权

python web开发实战专栏收录该内容

20 篇文章 0 订阅

订阅专栏

config.py:

class Config(object):
    ...
    DATABASE_QUERY_TIMEOUT = 0.0001 ##记录执行时间超过 0.0001秒的
    SQLALCHEMY_RECORD_QUERIES = True

wsgi.py:

from flask import abort, request, _app_ctx_stack, jsonify
from app import create_app
from app.ik_global import ik_global
from app.ikdb.model.models import User
from flask_sqlalchemy import get_debug_queries


app = vpp_agent = create_app("production")

login_manager = flask_login.LoginManager()
login_manager.init_app(app)

@app.after_request
def after_request(response):
    ik_global.Logger.info("after_request: {}".format(request.url))
    for query in get_debug_queries():
        if query.duration >= app.config["DATABASE_QUERY_TIMEOUT"]:
            ik_global.Logger.info("Context:{}\n SLOW query: {}\n Params: {}\n Duration: {} ms\n".format(query.context, query.statement, query.parameters, query.duration*1000))
    # some stuff here
    return response