undefined | Better HN

0 pointsbootsmann2y ago0 comments

There is certainly an API to inspect your query, you can just call print() on the object iirc.

0 comments

The problem is with using `session.add(obj)` instead of `session.scalars(insert(TheClass).returning(TheClass), data)`. If there's a way to get generated SQL from an AsyncSession, please do let me know.

camgunz2y ago

I think you have a couple options [0], I currently have a project that uses 'echo' in debug mode.

[0]: https://stackoverflow.com/questions/27748053/how-to-log-sql-...

nerdponx2y ago

Yep, that's the same output that's emitted in the sqlalchemy.engine logger. If you use the logger you can use Pytest caplog to capture it.

perlgeek2y ago

This is a very blunt tool, but `engine.echo = True` prints all SQL going to the DB.

(I don't have any experience with AsyncSession, so cannot contribute something more specific)

j / k navigate · click thread line to collapse

0 comments

nerdponx2y ago

camgunz2y ago

I think you have a couple options [0], I currently have a project that uses 'echo' in debug mode.

[0]: https://stackoverflow.com/questions/27748053/how-to-log-sql-...

nerdponx2y ago

Yep, that's the same output that's emitted in the sqlalchemy.engine logger. If you use the logger you can use Pytest caplog to capture it.

perlgeek2y ago

This is a very blunt tool, but `engine.echo = True` prints all SQL going to the DB.

(I don't have any experience with AsyncSession, so cannot contribute something more specific)

j / k navigate · click thread line to collapse