Last active
January 28, 2024 21:25
A handy SQL debug function for Flask-SQLAlchemy
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from . import app | |
from flask.ext.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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Thank you for that useful function
I just added an if statement for myself to prevent useless prints