/
QueryLoggerTest.php
145 lines (129 loc) · 4.72 KB
/
QueryLoggerTest.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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<?php
/**
* 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 3.0.0
* @license http://www.opensource.org/licenses/mit-license.php MIT License
*/
namespace Cake\Test\TestCase\Database\Log;
use Cake\Database\Log\LoggedQuery;
use Cake\Database\Log\QueryLogger;
use Cake\Log\Log;
use Cake\TestSuite\TestCase;
/**
* Tests QueryLogger class
*
*/
class QueryLoggerTest extends TestCase
{
/**
* Set up
*
* @return void
*/
public function setUp()
{
parent::setUp();
Log::reset();
}
/**
* Tear down
*
* @return void
*/
public function tearDown()
{
parent::tearDown();
Log::reset();
}
/**
* Tests that query placeholders are replaced when logged
*
* @return void
*/
public function testStringInterpolation()
{
$logger = $this->getMock('\Cake\Database\Log\QueryLogger', ['_log']);
$query = new LoggedQuery;
$query->query = 'SELECT a FROM b where a = :p1 AND b = :p2 AND c = :p3 AND d = :p4 AND e = :p5 AND f = :p6';
$query->params = ['p1' => 'string', 'p3' => null, 'p2' => 3, 'p4' => true, 'p5' => false, 'p6' => 0];
$logger->expects($this->once())->method('_log')->with($query);
$logger->log($query);
$expected = "duration=0 rows=0 SELECT a FROM b where a = 'string' AND b = 3 AND c = NULL AND d = 1 AND e = 0 AND f = 0";
$this->assertEquals($expected, (string)$query);
}
/**
* Tests that positional placeholders are replaced when logging a query
*
* @return void
*/
public function testStringInterpolation2()
{
$logger = $this->getMock('\Cake\Database\Log\QueryLogger', ['_log']);
$query = new LoggedQuery;
$query->query = 'SELECT a FROM b where a = ? AND b = ? AND c = ? AND d = ? AND e = ? AND f = ?';
$query->params = ['string', '3', null, true, false, 0];
$logger->expects($this->once())->method('_log')->with($query);
$logger->log($query);
$expected = "duration=0 rows=0 SELECT a FROM b where a = 'string' AND b = '3' AND c = NULL AND d = 1 AND e = 0 AND f = 0";
$this->assertEquals($expected, (string)$query);
}
/**
* Tests that repeated placeholders are correctly replaced
*
* @return void
*/
public function testStringInterpolation3()
{
$logger = $this->getMock('\Cake\Database\Log\QueryLogger', ['_log']);
$query = new LoggedQuery;
$query->query = 'SELECT a FROM b where a = :p1 AND b = :p1 AND c = :p2 AND d = :p2';
$query->params = ['p1' => 'string', 'p2' => 3];
$logger->expects($this->once())->method('_log')->with($query);
$logger->log($query);
$expected = "duration=0 rows=0 SELECT a FROM b where a = 'string' AND b = 'string' AND c = 3 AND d = 3";
$this->assertEquals($expected, (string)$query);
}
/**
* Tests that named placeholders
*
* @return void
*/
public function testStringInterpolationNamed()
{
$logger = $this->getMock('\Cake\Database\Log\QueryLogger', ['_log']);
$query = new LoggedQuery;
$query->query = 'SELECT a FROM b where a = :p1 AND b = :p11 AND c = :p20 AND d = :p2';
$query->params = ['p11' => 'test', 'p1' => 'string', 'p2' => 3, 'p20' => 5];
$logger->expects($this->once())->method('_log')->with($query);
$logger->log($query);
$expected = "duration=0 rows=0 SELECT a FROM b where a = 'string' AND b = 'test' AND c = 5 AND d = 3";
$this->assertEquals($expected, (string)$query);
}
/**
* Tests that the logged query object is passed to the built-in logger using
* the correct scope
*
* @return void
*/
public function testLogFunction()
{
$logger = new QueryLogger;
$query = new LoggedQuery;
$query->query = 'SELECT a FROM b where a = ? AND b = ? AND c = ?';
$query->params = ['string', '3', null];
$engine = $this->getMock('\Cake\Log\Engine\BaseLog', ['log'], ['scopes' => ['queriesLog']]);
Log::engine('queryLoggerTest');
$engine2 = $this->getMock('\Cake\Log\Engine\BaseLog', ['log'], ['scopes' => ['foo']]);
Log::engine('queryLoggerTest2');
$engine2->expects($this->never())->method('log');
$logger->log($query);
}
}