/
QueryLoggerTest.php
105 lines (92 loc) · 2.86 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
<?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\Database\Log;
use Cake\Database\Log\LoggedQuery;
use Cake\Database\Log\QueryLogger;
use Cake\Log\Log;
/**
* Tests QueryLogger class
*
*/
class QueryLoggerTest extends \Cake\TestSuite\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 testStingInterpolation() {
$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';
$query->params = ['p1' => 'string', 'p2' => 3, 'p3' => null];
$logger->expects($this->once())->method('_log')->with($query);
$logger->log($query);
$expected = "SELECT a FROM b where a = 'string' AND b = 3 AND c = NULL";
$this->assertEquals($expected, (string)$query);
}
/**
* Tests that positional placeholders are replaced when logging a query
*
* @return void
*/
public function testStingInterpolation2() {
$logger = $this->getMock('\Cake\Database\Log\QueryLogger', ['_log']);
$query = new LoggedQuery;
$query->query = 'SELECT a FROM b where a = ? AND b = ? AND c = ?';
$query->params = ['string', '3', null];
$logger->expects($this->once())->method('_log')->with($query);
$logger->log($query);
$expected = "SELECT a FROM b where a = 'string' AND b = '3' AND c = NULL";
$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', ['write'], ['scopes' => ['queriesLog']]);
Log::engine('queryLoggerTest', $engine);
$engine2 = $this->getMock('\Cake\Log\Engine\BaseLog', ['write'], ['scopes' => ['foo']]);
Log::engine('queryLoggerTest2', $engine2);
$engine2->expects($this->never())->method('write');
$logger->log($query);
}
}