/**
  * Tests that queries are logged when executed with bound params
  *
  * @return void
  */
 public function testExecuteWithBinding()
 {
     $inner = $this->getMock('PDOStatement');
     $inner->expects($this->any())->method('rowCount')->will($this->returnValue(4));
     $logger = $this->getMock('\\Cake\\Database\\Log\\QueryLogger');
     $logger->expects($this->at(0))->method('log')->with($this->logicalAnd($this->isInstanceOf('\\Cake\\Database\\Log\\LoggedQuery'), $this->attributeEqualTo('query', 'SELECT bar FROM foo'), $this->attributeEqualTo('took', 5, 5), $this->attributeEqualTo('numRows', 4), $this->attributeEqualTo('params', ['a' => 1, 'b' => '2013-01-01'])));
     $logger->expects($this->at(1))->method('log')->with($this->logicalAnd($this->isInstanceOf('\\Cake\\Database\\Log\\LoggedQuery'), $this->attributeEqualTo('query', 'SELECT bar FROM foo'), $this->attributeEqualTo('took', 5, 5), $this->attributeEqualTo('numRows', 4), $this->attributeEqualTo('params', ['a' => 1, 'b' => '2014-01-01'])));
     $date = new \DateTime('2013-01-01');
     $inner->expects($this->at(0))->method('bindValue')->with('a', 1);
     $inner->expects($this->at(1))->method('bindValue')->with('b', $date);
     $driver = $this->getMock('\\Cake\\Database\\Driver');
     $st = new LoggingStatement($inner, $driver);
     $st->queryString = 'SELECT bar FROM foo';
     $st->logger($logger);
     $st->bindValue('a', 1);
     $st->bindValue('b', $date, 'date');
     $st->execute();
     $st->bindValue('b', new \DateTime('2014-01-01'), 'date');
     $st->execute();
 }
Example #2
0
 /**
  * Returns a new statement object that will log the activity
  * for the passed original statement instance.
  *
  * @param \Cake\Database\StatementInterface $statement the instance to be decorated
  * @return \Cake\Database\Log\LoggingStatement
  */
 protected function _newLogger(StatementInterface $statement)
 {
     $log = new LoggingStatement($statement, $this->driver());
     $log->logger($this->logger());
     return $log;
 }
Example #3
0
 /**
  * Tests that queries are logged despite database errors
  *
  * @expectedException \LogicException
  * @expectedExceptionMessage This is bad
  * @return void
  */
 public function testExecuteWithError()
 {
     $exception = new \LogicException('This is bad');
     $inner = $this->getMockBuilder('PDOStatement')->getMock();
     $inner->expects($this->once())->method('execute')->will($this->throwException($exception));
     $logger = $this->getMockBuilder('\\Cake\\Database\\Log\\QueryLogger')->getMock();
     $logger->expects($this->once())->method('log')->with($this->logicalAnd($this->isInstanceOf('\\Cake\\Database\\Log\\LoggedQuery'), $this->attributeEqualTo('query', 'SELECT bar FROM foo'), $this->attributeEqualTo('took', 5, 200), $this->attributeEqualTo('params', []), $this->attributeEqualTo('error', $exception)));
     $st = new LoggingStatement($inner);
     $st->queryString = 'SELECT bar FROM foo';
     $st->logger($logger);
     $st->execute();
 }