Under SQLAlchemy 0.5, there used to be some logging setting that would show the actual SQL queries that were being made. Alas, I forget the exact invocation. Under SA 0.6, I have not been able to find a way to do this, short of hacking the SA source. Here's the closest that I've been able to come
logging.basicConfig(level=logging.DEBUG) logging.getLogger('sqlalchemy').setLevel(logging.DEBUG) logging.getLogger('sqlalchemy.engine').setLevel(logging.DEBUG) logging.getLogger('sqlalchemy.pool').setLevel(logging.DEBUG) logging.getLogger('sqlalchemy.dialects.mysql').setLevel(logging.DEBUG) logging.getLogger('sqlalchemy.orm').setLevel(logging.DEBUG) logging.getLogger('mysqldb').setLevel(logging.DEBUG) but I see no SELECTs in the output. Obviously, this is useful when we want the server to explain query plans and the like, to understand performance issues. I specifically care about MySQL and SQLite queries. /George Reilly, Seattle -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.