On Sun, Jun 9, 2019, at 1:33 AM, Zsolt Ero wrote:
> I figured out the keyword is NOTICES.
>
> However this section of the docs doesn't work / didn't had any effect:
> https://docs.sqlalchemy.org/en/13/dialects/postgresql.html#notice-logging
that document assumes one is familiar with logging in general which it probably
should not, so did you also set up logging config? If you call this ahead of
time:
logging.basicConfig()
otherwise the feature is broken
>
> What worked was to manually clear and print
> conn.connection.connection.notices like this:
>
> if notices:
> conn.connection.connection.notices = list()
>
> conn.execute(stmt)
>
> if notices:
> print('----------')
> print('\n'.join(conn.connection.connection.notices))
> print('----------')
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/CAKw-smCqxotj0tSoHjFjNJ4NVCtf3KYE1nakYAdsiXsuv4xmDw%40mail.gmail.com
>
> <https://groups.google.com/d/msgid/sqlalchemy/CAKw-smCqxotj0tSoHjFjNJ4NVCtf3KYE1nakYAdsiXsuv4xmDw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/8a713933-a056-4f97-a8d2-f27983879ac5%40www.fastmail.com.
For more options, visit https://groups.google.com/d/optout.
