the pool might be trying to emit an info message, not really sure, there is
some complex process by which Python logging either auto-configures itself, or
doesnt. Since Alembic has the env.py call upon fileConfig(), that would be the
logging config here. Add a logging config for it to your alembic.ini:
[logger_sqlalchemy_pool]
level = INFO
handlers =
qualname = sqlalchemy.pool
On Tue, Mar 3, 2020, at 11:12 PM, Ira Fuchs wrote:
> Getting the message “ No handlers could be found for logger
> "sqlalchemy.pool.impl.QueuePool" when I run this script to read from a MSSQL
> dB
> The code runs fine and delivers the data, but produces this error.
>
> from sqlalchemy import *
> import pytds
> import sqlalchemy_pytds
>
> engine = create_engine(params )
> from sqlalchemy import *
> import pytds
> import sqlalchemy_pytds
> import getpass
> p=getpass.getpass()
> engine = create_engine('mssql+pytds://' + params)
>
> con = engine.connect()
>
> q = 'SELECT * from table'
> rs= list(engine.execute(q))
> for a in rs:
> print(a)
>
>
> --
> 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 sqlalchemy+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/fad17b62-5455-4de4-81ba-6d586e92a9ee%40googlegroups.com
>
> <https://groups.google.com/d/msgid/sqlalchemy/fad17b62-5455-4de4-81ba-6d586e92a9ee%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
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 sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/5136895e-305b-415d-8e38-9da1c459d454%40www.fastmail.com.
