CODEWITHSUNDEEP
cakephp
bibliofilo bibliofilo
bibliofilo bibliofilo

Reputation: 69

Log database updates with CakePHP

How to log all database updates, inserts or deletes in CakePHP made using pure SQL?

example:

$this->Car->query('update cars set color = "red" ');

Upvotes: 1

Views: 1096

Answers (1)

Arun Jain
Arun Jain

Reputation: 5464

Extend whatever datasource you're using and override the _execute() method to log and pass back to the parent.

For example, let's assume you're currently using dbo_mysql. That means your db config is something like this:

class DATABASE_CONFIG {

    var $default = array(
            'driver' => 'mysql',
            // ...
    )
}

so change 'driver' to 'mysql_with_log', and create the file app/model/ datasources/dbo/mysql_with_log.php :

<?php
require (LIBS . 'model' . DS . 'datasources' . DS . 'dbo' . DS .'dbo_mysql.php');
class DboMysqlWithLog extends DboMysql {
   function _execute($sql) {
         $this->log($sql);
         return parent::_execute($sql);
   }
}
?>

Here is the Reference link.

You can also use Cake debug kit.

This plugin will also help you to save SQL Logs. Here is the link to download Debug Kit.

Upvotes: 1

Related Questions