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
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin\Tests\Navigation;
use PhpMyAdmin\Navigation\NavigationTree;
use PhpMyAdmin\Template;
use PhpMyAdmin\Tests\AbstractTestCase;
/**
* @covers \PhpMyAdmin\Navigation\NavigationTree
*/
class NavigationTreeTest extends AbstractTestCase
{
/** @var NavigationTree */
protected $object;
/**
* Sets up the fixture.
*/
protected function setUp(): void
{
parent::setUp();
parent::setLanguage();
parent::setGlobalConfig();
parent::setTheme();
$GLOBALS['server'] = 1;
$GLOBALS['cfg']['Server']['host'] = 'localhost';
$GLOBALS['cfg']['Server']['user'] = 'user';
$GLOBALS['cfg']['Server']['pmadb'] = '';
$GLOBALS['cfg']['Server']['DisableIS'] = false;
$GLOBALS['cfg']['NavigationTreeEnableGrouping'] = true;
$GLOBALS['cfg']['ShowDatabasesNavigationAsTree'] = true;
$GLOBALS['db'] = 'db';
$GLOBALS['table'] = '';
$GLOBALS['PMA_PHP_SELF'] = '';
$this->object = new NavigationTree(new Template(), $this->dbi);
}
/**
* Tears down the fixture.
*/
protected function tearDown(): void
{
parent::tearDown();
unset($this->object);
}
/**
* Very basic rendering test.
*/
public function testRenderState(): void
{
$result = $this->object->renderState();
$this->assertStringContainsString('pma_quick_warp', $result);
}
/**
* Very basic path rendering test.
*/
public function testRenderPath(): void
{
$result = $this->object->renderPath();
$this->assertIsString($result);
$this->assertStringContainsString('list_container', $result);
}
/**
* Very basic select rendering test.
*/
public function testRenderDbSelect(): void
{
$result = $this->object->renderDbSelect();
$this->assertStringContainsString('pma_navigation_select_database', $result);
}
public function testDatabaseGrouping(): void
{
$GLOBALS['db'] = '';
$GLOBALS['cfg']['NavigationTreeDbSeparator'] = '__';
// phpcs:disable Generic.Files.LineLength.TooLong
$this->dummyDbi->addResult(
'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'__\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'__\'), CONCAT(SCHEMA_NAME, \'__\')) ORDER BY SCHEMA_NAME ASC',
[['functions__a'], ['functions__b']],
['SCHEMA_NAME']
);
$this->dummyDbi->addResult(
'SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'__\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t',
[['2']]
);
$this->dummyDbi->addResult(
'SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'__\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t',
[['2']]
);
// phpcs:enable
$object = new NavigationTree(new Template(), $this->dbi);
$result = $object->renderState();
$this->assertStringContainsString('<li class="first navGroup">', $result);
$this->assertStringContainsString('functions' . "\n", $result);
$this->assertStringContainsString('<div class="list_container" style="display: none;">', $result);
$this->assertStringContainsString('functions__a', $result);
$this->assertStringContainsString('functions__b', $result);
}
}
|
