/** * 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(); } }