Skip to content

Instantly share code, notes, and snippets.

@3dln
Forked from dhrrgn/debug_stuff.py
Created May 25, 2019 07:35
Show Gist options
  • Save 3dln/a152fa8901742cb12f9affbf213b927d to your computer and use it in GitHub Desktop.
Save 3dln/a152fa8901742cb12f9affbf213b927d to your computer and use it in GitHub Desktop.
A handy SQL debug function for Flask-SQLAlchemy
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