How can I see the SQL generated by ponyorm?

Question

In this example:

with db_session:
    p = select(_ for _ in Person in _.name == 'John')[:][0]

I need this for debugging purposes as I would like to see the SQL it generates a similar query in other ORMs.

+3

python ponyorm

Games Brainiac 10 oct. 14 at 12:24

source to share

1 answer

Games Brainiac · Accepted Answer · 2014-10-10T12:24:29+0000

You can use pony.orm.sql_debug(True)

. This will show you all the SQL that pony generates whenever you are in a transaction. Debugging SQL in Pony