Adding db event

I want to add logging for my db queries and follow the example from the docs:

It works for $db->query() but not $db->execute(). Can I extend the existing db events?


Or is this a possible bug? Should this fire the before and afterQuery event?



It must work, there is unit-tests for it:

Follow this example:

$connection = new Mysql(array(
    "host"     => 'localhost',
    "username" => 'root',
    "password" => 'pass',
    "dbname"   => 'test'

$eventsManager = new Phalcon\Events\Manager();

$logger = new \Phalcon\Logger\Adapter\File(APP_PATH . "/app/logs/db.log");

//Listen all the database events
$eventsManager->attach('db', function($event, $connection) use ($logger) {
   if ($event->getType() == 'beforeQuery') {
        $sqlVariables = $connection->getSQLVariables();
        if (count($sqlVariables)) {
            $logger->log($connection->getSQLStatement() . ' ' . join(', ', $sqlVariables), Logger::INFO);
        } else {
            $logger->log($connection->getSQLStatement(), Logger::INFO);

//Assign the eventsManager to the db adapter instance