Skip to content

Instantly share code, notes, and snippets.

Last active January 28, 2024 21:25
Show Gist options
  • Save dhrrgn/6022858 to your computer and use it in GitHub Desktop.
Save dhrrgn/6022858 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:
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
Copy link

awesome stuff

Copy link

Thanks a lot :)

Copy link

flask.ext.sqlalchemy - is deprecated. So using:

from flask_sqlalchemy import get_debug_queries

Copy link

pattoM commented Jun 28, 2018

Please revise for python 3 and above

Copy link

Copy link


Copy link

This is really awesome! THANKS!!!

Copy link

Awesome! Thank a lot!

Copy link

alirezashojaei commented Jan 13, 2022

Thank you for that useful function

I just added an if statement for myself to prevent useless prints

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment