#li3 #lithium #php logging sql queries

logger.php

<?php
if (!Environment::is('production')) {
	// Attach to the `Connections` adapters after dispatch.
	Filters::apply('\lithium\action\Dispatcher', '_callable', function($self, $params, $chain) {

		/**
		 * Loop over all defined `Connections` adapters and tack in our
		 * filter on the `_execute` method.
		 */
		foreach (Connections::get() as $connection) {
			$connection = Connections::get($connection);

			// $connection->applyFilter(['read', 'create', 'update', 'delete'], function($self, $params, $chain) {
			// 	if ($result = $chain->next($self, $params, $chain)) {
			// 		//Profiler::start($response->model());if($)
			// 		if(is_string($params['query'])) {
			// 			$queries[] = $params['query'];
			// 		}
			// 		if(method_exists($result, 'data')) {
			// 			$queries[] = $result->result()->resource()->queryString;
			// 		}
			// 	}
			// 	if (isset($queries) && is_array($queries)) {
			// 		$message = implode("\r\n", $queries);


			// 	}
			// 	return $result;
			// });

			$connection->applyFilter('_execute', function($self, $params, $chain) {
				$message = $params['sql'];
				Logger::debug($message);
				$message = urlencode($message);
				shell_exec('curl "http://localhost:1337/info?title=App&group=1&message=' . $message .'"');
				return $chain->next($self, $params, $chain);
			});
		}

		// Return the controller.
		return $chain->next($self, $params, $chain);
	});
}