The "echo" flag always had to do some ugly things in order to work with Python
logging, so it was always the case that "echo" usage couldn't really be shared
with explicit logging. In 0.7 we got help from the Python logging maintainer
directly so things should be working much better now.
On Sep 15, 2011, at 8:25 AM, Torsten Landschoff wrote:
> Hi *,
>
> just figured that other people may be running into the same problem.
>
> I just finally got my sqlalchemy engine to accept a new log level at
> runtime. I followed the documentation and passed "echo=False" when
> creating the engine.
>
> Beforehand I had configured logging by
>
> import logging
> logging.basicConfig(logging.DEBUG)
> logging.getLogger("sqlalchemy.engine").setLevel(logging.DEBUG)
>
> But echo=False is not the default as stated in the create_engine
> documentation at
>
> http://www.sqlalchemy.org/docs/06/core/engines.html?highlight=create_engine#sqlalchemy.create_engine
>
> At commit 1adbbfddc979 in rel_0_6, the default in fact comes from
> sqlalchemy/lib/sqlalchemy/engine/base.py class Engine:
>
> def __init__(self, pool, dialect, url,
> logging_name=None, echo=None, proxy=None,
> execution_options=None
> ):
>
> which triggers this code in log.py:
>
> if echoflag is not None:
> l = logging.getLogger(name)
> ...
> elif echoflag is False:
> l.setLevel(logging.WARN)
> else:
> l = logging.getLogger(name)
>
> So this overwrites the log level I had set via logger.setLevel. This
> seems to be fixed in 0.7 (where False and None are equivalent according
> to a short glance).
>
> So this will not give any output:
>
> import logging
> from sqlalchemy import *
>
> logging.basicConfig(level=logging.DEBUG)
> logging.getLogger("sqlalchemy.engine").setLevel(logging.DEBUG)
>
> engine = create_engine("sqlite:///", echo=False)
> engine.execute("select 1")
>
> Changing "echo=False" in the create_engine call to "echo=None" (or
> removing echo=False altogether) will fix this. Uargh!
>
> Greetings, Torsten
>
> PS: Just checked, in SQLAlchemy 0.7.3 there is no difference between
> passing "echo=None" and "echo=False".
>
> --
> DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
> Torsten Landschoff
>
> Office Dresden
> Tel: +49-(0)351-4519587
> Fax: +49-(0)351-4519561
>
> mailto:[email protected]
> http://www.dynamore.de
>
> Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
> Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
