/
LoggingStatementTest.php
117 lines (111 loc) · 4.08 KB
/
LoggingStatementTest.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<?php
/**
* PHP Version 5.4
*
* CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
* Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
*
* Licensed under The MIT License
* For full copyright and license information, please see the LICENSE.txt
* Redistributions of files must retain the above copyright notice.
*
* @copyright Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
* @link http://cakephp.org CakePHP(tm) Project
* @since CakePHP(tm) v 3.0.0
* @license MIT License (http://www.opensource.org/licenses/mit-license.php)
*/
namespace Cake\Test\TestCase\Model\Datasource\Database\Log;
use Cake\Model\Datasource\Database\Log\LoggingStatement;
use PDOStatement;
/**
* Tests LoggingStatement class
*
**/
class LoggingStatementTest extends \Cake\TestSuite\TestCase {
/**
* Tests that queries are logged when executed without params
*
* @return void
*/
public function testExecuteNoParams() {
$inner = $this->getMock('PDOStatement');
$inner->expects($this->once())->method('rowCount')->will($this->returnValue(3));
$logger = $this->getMock('\Cake\Model\Datasource\Database\Log\QueryLogger');
$logger->expects($this->once())
->method('log')
->with($this->logicalAnd(
$this->isInstanceOf('\Cake\Model\Datasource\Database\Log\LoggedQuery'),
$this->attributeEqualTo('query', 'SELECT bar FROM foo'),
$this->attributeEqualTo('took', 5, 5),
$this->attributeEqualTo('numRows', 3),
$this->attributeEqualTo('params', [])
));
$st = new LoggingStatement($inner);
$st->queryString = 'SELECT bar FROM foo';
$st->logger($logger);
$st->execute();
}
/**
* Tests that queries are logged when executed with params
*
* @return void
*/
public function testExecuteWithParams() {
$inner = $this->getMock('PDOStatement');
$inner->expects($this->once())->method('rowCount')->will($this->returnValue(4));
$logger = $this->getMock('\Cake\Model\Datasource\Database\Log\QueryLogger');
$logger->expects($this->once())
->method('log')
->with($this->logicalAnd(
$this->isInstanceOf('\Cake\Model\Datasource\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' => 2])
));
$st = new LoggingStatement($inner);
$st->queryString = 'SELECT bar FROM foo';
$st->logger($logger);
$st->execute(['a' => 1, 'b' => 2]);
}
/**
* 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\Model\Datasource\Database\Log\QueryLogger');
$logger->expects($this->at(0))
->method('log')
->with($this->logicalAnd(
$this->isInstanceOf('\Cake\Model\Datasource\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\Model\Datasource\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\Model\Datasource\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();
}
}