Changeset 4728
- Timestamp:
- 07/27/07 12:42:49 (3 years ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
plugins/sfDoctrinePlugin/lib/sfDoctrineQueryLogger.class.php
r4698 r4728 22 22 public function preExecute(Doctrine_Event $event) 23 23 { 24 $log = '{sfDoctrine Pre-execute} executeQuery : '.$event->getQuery(); 25 if ($params = $event->getParams()) 26 { 27 $log .= ' - ('.implode(', ',$params) . ' )'; 28 } 29 sfContext::getInstance()->getLogger()->log($log); 30 $sqlTimer = sfTimerManager::getTimer('Database (Doctrine)'); 24 $this->sfLogQuery('{sfDoctrine Execute} executeQuery : ', $event); 31 25 } 32 26 33 27 public function postExecute(Doctrine_Event $event) 34 28 { 35 sfTimerManager::getTimer('Database (Doctrine)')->addTime();29 $this->sfAddTime(); 36 30 } 37 31 38 32 public function postPrepare(Doctrine_Event $event) 39 33 { 40 sfTimerManager::getTimer('Database (Doctrine)')->addTime();34 $this->sfAddTime(); 41 35 } 42 36 43 37 public function preStmtExecute(Doctrine_Event $event) 44 38 { 45 $log = '{sfDoctrine Pre-execute} executePreparedQuery : '.$event->getQuery(); 46 if ($params = $event->getParams()) 47 { 48 $log .= ' - ('.implode(', ',$params) . ' )'; 49 } 50 sfContext::getInstance()->getLogger()->log($log); 51 $sqlTimer = sfTimerManager::getTimer('Database (Doctrine)'); 39 $this->sfLogQuery('{sfDoctrine Statement} executeQuery : ', $event); 52 40 } 53 41 54 42 public function postStmtExecute(Doctrine_Event $event) 55 43 { 56 sfTimerManager::getTimer('Database (Doctrine)')->addTime();44 $this->sfAddTime(); 57 45 } 58 46 59 47 public function preQuery(Doctrine_Event $event) 60 48 { 61 sfContext::getInstance()->getLogger()->log('{sfDoctrine Query} executeQuery : '.$event->getQuery()); 49 $this->sfLogQuery('{sfDoctrine Query} executeQuery : ', $event); 50 } 51 52 public function postQuery(Doctrine_Event $event) 53 { 54 $this->sfAddTime(); 55 } 56 57 protected function sfLogQuery($message, $event) 58 { 59 $message .= $event->getQuery(); 60 61 if ($params = $event->getParams()) 62 { 63 $message .= ' - ('.implode(', ', $params) . ' )'; 64 } 65 66 sfContext::getInstance()->getLogger()->log($message); 62 67 $sqlTimer = sfTimerManager::getTimer('Database (Doctrine)'); 63 68 } 64 65 p ublic function postQuery(Doctrine_Event $event)69 70 protected function sfAddTime() 66 71 { 67 72 sfTimerManager::getTimer('Database (Doctrine)')->addTime();
