A handy SQL debug function for Flask-SQLAlchemy

debug_stuff.py

from . import app
from flask.sqlalchemy import get_debug_queries

if app.debug:
    app.after_request(sql_debug)


def sql_debug(response):
    queries = list(get_debug_queries())
    query_str = ''
    total_duration = 0.0
    for q in queries:
        total_duration += q.duration
        stmt = str(q.statement % q.parameters).replace('\n', '\n       ')
        query_str += 'Query: {0}\nDuration: {1}ms\n\n'.format(stmt, round(q.duration * 1000, 2))

    print('=' * 80)
    print(' SQL Queries - {0} Queries Executed in {1}ms'.format(len(queries), round(total_duration * 1000, 2)))
    print('=' * 80)
    print(query_str.rstrip('\n'))
    print('=' * 80 + '\n')

    return response

output.md

Thanks.

Also, I replaced

stmt = str(q.statement % q.parameters).replace('\n', '\n       ')

with

statement = str(q.statement).replace( '?', '%s' )
stmt = str( statement % q.parameters ).replace('\n', '\n       ')

Thank you for that useful function

Have you already make this functional?
I have a problem,everytime I go to roo URL nothing is incremented.
Also based on debugging, I found that there is no output list in get_debug_queries()
I already set app.config[ 'SQLALCHEMY_RECORD_QUERIES' ] = True

2023-01-30 18:30:22,460 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2023-01-30 18:30:22,472 INFO sqlalchemy.engine.Engine SELECT user.id AS user_id, user.name AS user_name
FROM user
WHERE user.id = ?
LIMIT ? OFFSET ?
2023-01-30 18:30:22,472 INFO sqlalchemy.engine.Engine [generated in 0.00121s] (3, 1, 0)
2023-01-30 18:30:22,475 INFO sqlalchemy.engine.Engine ROLLBACK

SQL Queries - 0 Queries Executed in 0.0ms