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
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin\Tests\Selenium;
/**
* @coversNothing
*/
#[\PHPUnit\Framework\Attributes\CoversNothing]
class ImportTest extends TestBase
{
/**
* setUp function
*/
protected function setUp(): void
{
parent::setUp();
$this->login();
}
/**
* Test for server level import
*
* @group large
*/
#[\PHPUnit\Framework\Attributes\Group('large-group')]
public function testServerImport(): void
{
$this->doImport('server');
$this->dbQuery(
'SHOW DATABASES LIKE \'test_import%\'',
function (): void {
self::assertEquals('test_import1', $this->getCellByTableClass('table_results', 1, 1));
self::assertEquals('test_import2', $this->getCellByTableClass('table_results', 2, 1));
}
);
// clear db
$this->dbQuery('DROP DATABASE test_import1;DROP DATABASE test_import2;');
}
/**
* Test for db level import
*
* @group large
*/
#[\PHPUnit\Framework\Attributes\Group('large-group')]
public function testDbImport(): void
{
$this->dbQuery('CREATE DATABASE IF NOT EXISTS `' . $this->databaseName . '`');
$this->navigateDatabase($this->databaseName);
$this->doImport('db');
$this->dbQuery(
'USE `' . $this->databaseName . '`;'
. 'SHOW TABLES FROM `' . $this->databaseName . '`',
function (): void {
self::assertTrue($this->isElementPresent('className', 'table_results'));
self::assertEquals('test_table', $this->getCellByTableClass('table_results', 1, 1));
}
);
}
/**
* Test for table level import
*
* @group large
*/
#[\PHPUnit\Framework\Attributes\Group('large-group')]
public function testTableImport(): void
{
// setup the db
$this->dbQuery(
'CREATE DATABASE IF NOT EXISTS `' . $this->databaseName . '`;'
. 'USE `' . $this->databaseName . '`;'
. 'CREATE TABLE IF NOT EXISTS `test_table` (`val` int(11) NOT NULL);'
);
$this->navigateTable('test_table');
$this->doImport('table');
$this->dbQuery(
'SELECT * FROM `' . $this->databaseName . '`.test_table',
function (): void {
self::assertTrue($this->isElementPresent('className', 'table_results'));
self::assertEquals('8', $this->getCellByTableClass('table_results', 1, 1));
self::assertEquals('9', $this->getCellByTableClass('table_results', 2, 1));
}
);
}
/**
* Function that goes to the import page, uploads a file and submit form
*
* @param string $type level: server, db or import
*/
private function doImport(string $type): void
{
$this->waitForElement('partialLinkText', 'Import')->click();
$this->waitAjax();
$this->waitForElement('id', 'localFileTab')->click();
$this->waitForElement('id', 'input_import_file');
$this->selectByValue($this->byName('local_import_file'), $type . '_import.sql');
$this->scrollToBottom();
$this->waitUntilElementIsVisible('id', 'sql_options', 30);
$this->scrollToBottom();
$this->waitUntilElementIsVisible('id', 'buttonGo', 30);
$this->byId('buttonGo')->click();
$this->waitUntilElementIsVisible(
'xpath',
"//div[@class='alert alert-success' and contains(., 'Import has been successfully')]",
30
);
}
}
|
