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
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin\Tests\Navigation;
use PhpMyAdmin\ConfigStorage\Relation;
use PhpMyAdmin\ConfigStorage\RelationParameters;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Navigation\Navigation;
use PhpMyAdmin\Template;
use PhpMyAdmin\Tests\AbstractTestCase;
use PhpMyAdmin\Url;
/**
* @covers \PhpMyAdmin\Navigation\Navigation
*/
class NavigationTest extends AbstractTestCase
{
/** @var Navigation */
protected $object;
/**
* Sets up the fixture.
*/
protected function setUp(): void
{
parent::setUp();
parent::setLanguage();
$GLOBALS['server'] = 1;
$GLOBALS['db'] = 'db';
$GLOBALS['table'] = '';
$GLOBALS['cfg']['Server']['user'] = 'user';
$GLOBALS['cfg']['Server']['DisableIS'] = false;
$GLOBALS['cfg']['ActionLinksMode'] = 'both';
$relationParameters = RelationParameters::fromArray([
'db' => 'pmadb',
'navwork' => true,
'navigationhiding' => 'navigationhiding',
]);
$_SESSION = ['relation' => [$GLOBALS['server'] => $relationParameters->toArray()]];
$this->object = new Navigation(
new Template(),
new Relation($GLOBALS['dbi']),
$GLOBALS['dbi']
);
}
/**
* Tears down the fixture.
*/
protected function tearDown(): void
{
parent::tearDown();
unset($this->object);
}
/**
* Tests hideNavigationItem() method.
*/
public function testHideNavigationItem(): void
{
$expectedQuery = 'INSERT INTO `pmadb`.`navigationhiding`'
. '(`username`, `item_name`, `item_type`, `db_name`, `table_name`)'
. " VALUES ('user','itemName','itemType','db','')";
$dbi = $this->getMockBuilder(DatabaseInterface::class)
->disableOriginalConstructor()
->getMock();
$dbi->expects($this->once())
->method('tryQueryAsControlUser')
->with($expectedQuery);
$dbi->expects($this->any())->method('escapeString')
->will($this->returnArgument(0));
$GLOBALS['dbi'] = $dbi;
$this->object = new Navigation(new Template(), new Relation($dbi), $dbi);
$this->object->hideNavigationItem('itemName', 'itemType', 'db');
}
/**
* Tests unhideNavigationItem() method.
*/
public function testUnhideNavigationItem(): void
{
$expectedQuery = 'DELETE FROM `pmadb`.`navigationhiding`'
. " WHERE `username`='user' AND `item_name`='itemName'"
. " AND `item_type`='itemType' AND `db_name`='db'";
$dbi = $this->getMockBuilder(DatabaseInterface::class)
->disableOriginalConstructor()
->getMock();
$dbi->expects($this->once())
->method('tryQueryAsControlUser')
->with($expectedQuery);
$dbi->expects($this->any())->method('escapeString')
->will($this->returnArgument(0));
$GLOBALS['dbi'] = $dbi;
$this->object = new Navigation(new Template(), new Relation($dbi), $dbi);
$this->object->unhideNavigationItem('itemName', 'itemType', 'db');
}
/**
* Tests getItemUnhideDialog() method.
*/
public function testGetItemUnhideDialog(): void
{
$html = $this->object->getItemUnhideDialog('db');
$this->assertStringContainsString('<td>tableName</td>', $html);
$this->assertStringContainsString(
'<a class="unhideNavItem ajax" href="' . Url::getFromRoute('/navigation') . '" data-post="'
. 'unhideNavItem=1&itemType=table&'
. 'itemName=tableName&dbName=db&lang=en">',
$html
);
}
}
|