BjyProfiler Database Configuration

pdo.global.php

<?php
return array(
    'service_manager' => array(
        'factories' => array(
            'MyProfilingAdapter' => 'BjyProfiler\Db\Adapter\ProfilingAdapterFactory',
            'Zend\Db\Adapter\Adapter' => function ($sm) {
                $adapter = $sm->get('MyProfilingAdapter');

                if (php_sapi_name() == 'cli') {
                    $logger = new Zend\Log\Logger();
                    // write queries profiling info to stdout in CLI mode
                    $writer = new Zend\Log\Writer\Stream('php://output');
                    $logger->addWriter($writer, Zend\Log\Logger::DEBUG);
                    $adapter->setProfiler(new BjyProfiler\Db\Profiler\LoggingProfiler($logger));
                } else {
                    $adapter->setProfiler(new BjyProfiler\Db\Profiler\Profiler());
                }

                return $adapter;
            },
        ),
    ),
);

pdo.local.php

<?php
return array(
    'db' => array(
        'driver'    => 'pdo',
        'dsn'       => 'mysql:dbname=MY_DATABASE_NAME;host=MY_DATABASE_HOST',
        'username'  => 'myusername',
        'password'  => 'mypassword',
    ),
);