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
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
|
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Tests for libraries/TableSearch.class.php with search type replace
*
* @package PhpMyAdmin-test
*/
require_once 'libraries/Util.class.php';
/*
* Include to test.
*/
require_once 'libraries/TableSearch.class.php';
require_once 'libraries/DatabaseInterface.class.php';
require_once 'libraries/php-gettext/gettext.inc';
require_once 'libraries/url_generating.lib.php';
/**
* Tests for libraries/TableSearch.class.php with search type replace
*
* @package PhpMyAdmin-test
*/
class PMA_TableReplaceSearchTest extends PHPUnit_Framework_TestCase
{
/**
* @var PMA_TableSearch
*/
private $_object;
/**
* Sets up the environment for tests
*
* @return void
*/
protected function setup()
{
$this->_object = $this->getMock(
'PMA_TableSearch',
array('_loadTableInfo'),
array(),
'',
false
);
$reflection = new \ReflectionClass('PMA_TableSearch');
// set database, table names
$attrDb = $reflection->getProperty('_db');
$attrDb->setAccessible(true);
$attrDb->setValue($this->_object, 'dbName');
$attrTable = $reflection->getProperty('_table');
$attrTable->setAccessible(true);
$attrTable->setValue($this->_object, 'tableName');
// set column names list
$attrColNames = $reflection->getProperty('_columnNames');
$attrColNames->setAccessible(true);
$columnNames = array('column1');
$attrColNames->setValue($this->_object, $columnNames);
}
/**
* Tests getReplacePreview() method
*
* @return void
* @group medium
*/
public function testGetReplacePreview()
{
//mock DBI
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$find = 'findValue';
$replaceWith = 'replaceWithValue';
$useRegex = false;
$charSet = 'charSetValue';
// set expectations
$dbi->expects($this->once())
->method('fetchResult')
->will(
$this->returnValue(
array(
array('val1', 'replace1', 5),
array('va<2', 'replac<2', 1)
)
)
);
$GLOBALS['dbi'] = $dbi;
$ret = $this->_object->getReplacePreview(
0, $find, $replaceWith, $useRegex, $charSet
);
// assert whether hidden values are properly set
$this->assertContains(
'<input type="hidden" name="replace" value="true" />',
$ret
);
$this->assertContains(
'<input type="hidden" name="columnIndex" value="0" />',
$ret
);
$this->assertContains(
'<input type="hidden" name="findString"' . ' value="' . $find . '" />',
$ret
);
$this->assertContains(
'<input type="hidden" name="replaceWith"' . ' value="'
. $replaceWith . '" />',
$ret
);
// assert values displayed in the preview and escaping
/**
* @todo Find out a better method to test for HTML
*
* $this->assertContains(
* '<td class="right">5</td><td>val1</td><td>replace1</td>',
* $ret
* );
*
* $this->assertContains(
* '<td class="right">1</td><td>va<2</td><td>replac<2</td>',
* $ret
* );
*/
}
/**
* Tests replace() method
*
* @return void
*/
public function testReplace()
{
//mock DBI
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$find = 'findValue';
$replaceWith = 'replaceWithValue';
$useRegex = false;
$charSet = 'charSetValue';
$expectedQuery = "UPDATE `dbName`.`tableName`"
. " SET `column1` = REPLACE(`column1`, '" . $find . "', '" . $replaceWith
. "') WHERE `column1` LIKE '%" . $find . "%' COLLATE "
. $charSet . "_bin";
// set expectations
$dbi->expects($this->once())
->method('query')
->with($expectedQuery);
$GLOBALS['dbi'] = $dbi;
$this->_object->replace(0, $find, $replaceWith, $useRegex, $charSet);
}
}
|
