dchaplinsky/print_statement.py

Created November 5, 2014 19:03

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/dchaplinsky/afe42623c7d4007b06f8.js"></script>
Save dchaplinsky/afe42623c7d4007b06f8 to your computer and use it in GitHub Desktop.

Download ZIP

A neat way to print raw SQL for SQLAlchemy statement with dialect specific stuff and all params substituted.

Raw

print_statement.py

	from sqlalchemy.dialects import postgresql
	print(YOUR_SQL.statement.compile(dialect=postgresql.dialect(), compile_kwargs={"literal_binds": True}))

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