In SQLAlchemy how do I preview SQL statements before committing for debugging purposes?

Question

I want to see the SQL code instead of doing an actual db.commit(). This is for a one-off database population script that I want to verify is working as intended before actually making the changes.

Sir, you have the answer?

Sid Brooklyn
– Sid Brooklyn

2021-02-02 17:59:55 +00:00
Commented Feb 2, 2021 at 17:59 — Sid Brooklyn
– Sid Brooklyn, Commented Feb 2, 2021 at 17:59

Community · Accepted Answer · 2017-05-23 11:57:48Z

4

Try calling str() on the query object.

print query_object.str()

From:

How do I get a raw, compiled SQL query from a SQLAlchemy expression?

Other possible solutions:

The newest (as of v0.9) answer is also:

Retrieving ultimate sql query sentence (with the values in place of any '?') (by Mike Bayer)

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Feb 25, 2014 at 17:44

chishaku

4,6633 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

In SQLAlchemy how do I preview SQL statements before committing for debugging purposes?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related