/**
* Implementation of the onEvent() method for Observer interface.
* If a query gets executed this method gets invoked because the
* adapter will send a signal to the attached logger.
*
* @param string $eventName ID of the event (name)
* @param RedBean_DBAdapter $adapter adapter that sends the signal
*
* @return void
*/
public function onEvent($eventName, $adapter)
{
if ($eventName == "sql_exec") {
$sql = $adapter->getSQL();
$this->logs[] = $sql;
}
}
/**
* Implementation of the onEvent() method for Observer interface.
* If a query gets executed this method gets invoked because the
* adapter will send a signal to the attached logger.
*
* @param string $eventName ID of the event (name)
* @param RedBean_DBAdapter $adapter adapter that sends the signal
*
* @return void
*/
public function onEvent($eventName, $adapter)
{
if ($eventName == 'sql_exec') {
$sql = $adapter->getSQL();
$this->logs[] = $sql;
if (strpos($sql, 'ALTER') === 0) {
$write = "-- " . date('Y-m-d H:i') . " | Altering table. \n";
$write .= $sql;
$write .= "\n\n";
}
if (strpos($sql, 'CREATE') === 0) {
$write = "-- " . date('Y-m-d H:i') . " | Creating new table. \n";
$write .= $sql;
$write .= "\n\n";
}
if (isset($write)) {
file_put_contents($this->file, $write, FILE_APPEND);
}
}
}
/**
* Implementation of the onEvent() method for Observer interface.
* If a query gets executed this method gets invoked because the
* adapter will send a signal to the attached logger.
*
* @param string $eventName ID of the event (name)
* @param RedBean_DBAdapter $adapter adapter that sends the signal
*
* @return void
*/
public function onEvent($eventName, $adapter)
{
if ($eventName == 'sql_exec') {
$this->logs[] = $adapter->getSQL();
}
}
