try running this program:
from sqlalchemy import create_engine
import logging
logging.basicConfig()
logging.getLogger("sqlalchemy.engine").setLevel(logging.DEBUG)
engine = create_engine('sqlite://')
engine.execute("select 1").fetchall()
assuming it works for you as it does for me, figure out whats different
about this program versus yours.
Marcin Krol wrote:
>
> Michael Bayer wrote:
>>> logging.basicConfig(filename=globalpath + os.sep + 'sql.log')
>>> logging.getLogger('sqlalchemy.engine').setLevel(logging.DEBUG)
>>> logging.getLogger('sqlalchemy.orm.unitofwork').setLevel(logging.DEBUG)
>>
>> the logging configuration is not working. You should see DEBUG lines in
>> your log output, and at the very least you'd see empty result sets after
>> a
>> SELECT. Make sure nothing else is changing the log level later on,
>
> Nothing does. I browsed my entire source code and nothing is changing it
> after setup.
>
> I configure logging like above in the 'sqla setup module' that gets
> imported in the main app.
>
>> including "echo=True" which should never be used with explicit logging
>> (yes this is documented as well).
>
> I turned it off in create_engine:
>
> eng = create_engine('postgres://%s:%...@%s:%s/%s' % (postgresuser,
> postgrespassword, postgreshost, postgresport, postgresdbname))
>
> But now nothing gets logged at all.
>
> I moved the code from the sqla setup module to the beginning of app
> code, but nothing gets logged at all either.
>
> Regards,
> mk
>
>
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
