sburns/print_sql.py

Created December 10, 2014 15:07

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sburns/ed1226e3cd3d9d4c76d7.js"></script>
Save sburns/ed1226e3cd3d9d4c76d7 to your computer and use it in GitHub Desktop.

Download ZIP

Print a literal SQLAlchemy statement

Raw

print_sql.py

print(str(select.compile(engine, compile_kwargs={'literal_binds': True}))

Author

sburns commented Dec 10, 2014

This is only useful for testing select statements if, for instance, it's difficult to connect to a database in your development environment. Under no circumstances should you use this in production as you're opening yourself to SQL injection attacks one of the things binding protects against. Here we're directing sqlalchemy to literally bind values during statement compilation.

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