php - ZF2 ZendLog + Doctrine2

Answer

Solution:

May be it's too late to answer this question but better late than never.

I've found a good post which explains how to create a basic for ZF2 and Doctrine.

The approach is pretty simple :

1. Creating {-code-5} class : Create the following class in your{-code-2} folder :

    {-code-3}
Copy code

The{-code-4} function which is called by Doctrine when it finiches sending the query to the database server, is overrided so that it could write the current query to the{-code-5} object.

2. Configuring the {-code-5} : Add the following code in your{-code-6} file, to make the {-code-5} accessible to the{-code-7} using the name{-code-8} :

        'service_manager' => array(
            'factories' => array(
                '{-code-8}' => function($sm) {
                    $log = new \{-code-14}\{-code-5}();
                    $writer = new \{-code-14}\Writer\Stream('./{-code-11}');
                    $log->addWriter($writer);

                    $sqllog = new \Application\Log\Sql{-code-5}($log);
                    return $sqllog;
                },
            )
        ),
        
Copy code

The{-code-5} will write data to the{-code-11} file. So, make sure that{-code-12} folder exists in your application root directory.

3. Configuring Doctrine : Now you need to tell Doctrine to use the created {-code-5}. Just add the following code to your Doctrine configuration :

    return array(  
        'doctrine' => array(
             /*--------Add this code     

Answer

---*/ 'connection' => array( 'orm_default' => array( 'driverClass' => 'Doctrine\DBAL\Driver\PDOMySql\Driver', 'params' => array( 'host' => 'localhost', 'port' => '3306', 'user' => 'username', 'password' => 'password', 'dbname' => 'dbname', ), ), ), ), ); Copy code

With the above configuration of{-code-14} and{-code-15}, you'll get all the query data logged in the{-code-16} file.

Please see this Sql Logger for ZF2 and Doctrine for more details.

Answer

--*/ 'sql_logger_collector' => array( 'orm_default' => array( 'sql_logger' => 'my_sql_logger', ), ), /*

Answer

---*/ 'connection' => array( 'orm_default' => array( 'driverClass' => 'Doctrine\DBAL\Driver\PDOMySql\Driver', 'params' => array( 'host' => 'localhost', 'port' => '3306', 'user' => 'username', 'password' => 'password', 'dbname' => 'dbname', ), ), ), ), );|||Zend\Log|||Doctrine2|||data/log/sql.log