tburschka/zf2-doctrine-sql-logger

Logs Doctrine DBAL queries with a Zend Log.

ZF2DoctrineSQLLogger

Logs Doctrine DBAL queries as plain SQL with a Zend\Log\Logger., _(*1)

Usage

1. Add to require list in composer.json file (and of cause execute composer.phar update), _(*2)

   "tburschka/zf2-doctrine-sql-logger": "~1.0"

2. Add to modules list in application.config.php, _(*3)

   'ZF2DoctrineSQLLogger'

3. Create a new Zend\Log\Logger or use an existing one, _(*4)

   [...]
   'service_manager' => array(
       'factories' => array(
           'doctrine.sql_logger' => function () {
               $writer = new Zend\Log\Writer\Stream('data/logger_doctrine_sql.log');
               $logger = new Zend\Log\Logger();
               $logger->addWriter($writer);
               return $logger;
           },
       ),
   ),
   [...]

4. Configure the Z2fDoctrineSQLLogger, _(*5)

   [...]
   'ZF2DoctrineSQLLogger' => array(
       'entitymanager'     => 'doctrine.entitymanager.orm_default',
       'logger'            => 'doctrine.sql_logger',
       'priority'          => Zend\Log\Logger::NOTICE,
       'log_executiontime' => false,
   ),
   [...]

5. Enable logger for doctrine, _(*6)

   [...]
   'doctrine' => array(
       'configuration' => array(
           'orm_default' => array(
               'sql_logger' => 'ZF2DoctrineSQLLogger',
           ),
       ),
   ),
   [...]