public
Last active

Li3 database queries logger

  • Download Gist
queries_logger.php
PHP
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
<?php
 
use lithium\analysis\Logger;
use lithium\data\Connections;
use lithium\core\Environment;
use lithium\action\Dispatcher;
 
 
/**
* This filter intercepts the `run()` method of the `Dispatcher`
* and apply filters to `read()` method of the `Connection` to log in a file,
* all the queries passed to the database.
*
* @see lithium\core\Environment
* @see lithium\data\Connections
* @see lithium\analysis\Logger
*/
 
Logger::config(array(
'default' => array(
'production' => array(
'adapter' => 'File',
'file' => function($data, $config) { return "{$data['priority']}.prod.log"; }
)
)));
 
Dispatcher::applyFilter('run', function($self, $params, $chain) {
 
if (Environment::is('production')) {
 
Connections::get('default')->applyFilter('read', function($self, $params, $chain) {
$query = $params['query'];
Logger::debug('Read: ' . $query->source() . ': ' . json_encode($query->conditions()));
 
return $chain->next($self, $params, $chain);
});
 
}
 
return $chain->next($self, $params, $chain);
});
 
?>

I tried putting this file in
/lithium/analysis/QueriesLogger.php

and included in my ImportController.php
use lithium\analysis\QueriesLogger;

It did not show any output on the page.

You should put this code in a file in config/bootstrap directory of your app, then load it in config/bootstrap.php by requiring it (just like other bootstrap files). It will load those filters during Lithium bootsrap

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.