someone know how i log all doctrine queries to log file automatically?

Question

im using Doctrine and want to log all generated sql queries.

i know that i could use $q->getSqlQuery() but i dont want to do that manually each time.

is there a way to do it automatically?

thanks

Answer 1

If you turn logging on all queries shoudl be logged to your application log in the log directory. To do this set logging_enabled to true in your settings.yml.

Answer 2

Take a look at Doctrine Profiler and the source of ZF_Debug & Doctrine.