tburschka/zf2-doctrine-sql-logger

Logs Doctrine DBAL queries with a Zend Log.

1.0.1 2018-02-28 06:42 UTC

Requires

• php: >=5.3.23
• doctrine/doctrine-orm-module: *
• zendframework/zend-servicemanager: ~2.3

MIT

• Torsten Burschka

• log
• sql
• zf2
• doctrine

README

Logs Doctrine DBAL queries as plain SQL with a Zend\Log\Logger.

Usage

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

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

2. Add to modules list in application.config.php

    'ZF2DoctrineSQLLogger'
   

3. Create a new Zend\Log\Logger or use an existing one

    [...]
    '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

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

5. Enable logger for doctrine

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