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
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin\Tests\Query;
use PhpMyAdmin\Query\Generator;
use PhpMyAdmin\Tests\AbstractTestCase;
/**
* @covers \PhpMyAdmin\Query\Generator
*/
#[\PHPUnit\Framework\Attributes\CoversClass(\PhpMyAdmin\Query\Generator::class)]
class GeneratorTest extends AbstractTestCase
{
public function testGetColumnsSql(): void
{
self::assertSame(
'SHOW COLUMNS FROM `mydb`.`mytable`',
Generator::getColumnsSql('mydb', 'mytable')
);
self::assertSame(
'SHOW COLUMNS FROM `mydb`.`mytable` LIKE \'_idcolumn\'',
Generator::getColumnsSql('mydb', 'mytable', '_idcolumn')
);
self::assertSame(
'SHOW FULL COLUMNS FROM `mydb`.`mytable`',
Generator::getColumnsSql('mydb', 'mytable', null, true)
);
self::assertSame(
'SHOW FULL COLUMNS FROM `mydb`.`mytable` LIKE \'_idcolumn\'',
Generator::getColumnsSql('mydb', 'mytable', '_idcolumn', true)
);
}
public function testGetTableIndexesSql(): void
{
self::assertSame(
'SHOW INDEXES FROM `mydb`.`mytable`',
Generator::getTableIndexesSql('mydb', 'mytable')
);
self::assertSame(
'SHOW INDEXES FROM `mydb`.`mytable` WHERE (1)',
Generator::getTableIndexesSql('mydb', 'mytable', '1')
);
}
public function testGetSqlQueryForIndexRename(): void
{
self::assertSame(
'ALTER TABLE `mydb`.`mytable` RENAME INDEX `oldIndexName` TO `newIndexName`;',
Generator::getSqlQueryForIndexRename('mydb', 'mytable', 'oldIndexName', 'newIndexName')
);
}
public function testGetQueryForReorderingTable(): void
{
self::assertSame(
'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
Generator::getQueryForReorderingTable('mytable', 'myOrderField', '')
);
self::assertSame(
'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
Generator::getQueryForReorderingTable('mytable', 'myOrderField', 'S')
);
self::assertSame(
'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
Generator::getQueryForReorderingTable('mytable', 'myOrderField', 'DESC')
);
self::assertSame(
'ALTER TABLE `mytable` ORDER BY `myOrderField` DESC;',
Generator::getQueryForReorderingTable('mytable', 'myOrderField', 'desc')
);
self::assertSame(
'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
Generator::getQueryForReorderingTable('mytable', 'myOrderField', null)
);
}
public function testGetQueryForPartitioningTable(): void
{
self::assertSame(
'ALTER TABLE `mytable` PARTITION ;',
Generator::getQueryForPartitioningTable('mytable', '', [])
);
self::assertSame(
'ALTER TABLE `mytable` PARTITION p1;',
Generator::getQueryForPartitioningTable('mytable', '', ['p1'])
);
self::assertSame(
'ALTER TABLE `mytable` PARTITION p1, p2;',
Generator::getQueryForPartitioningTable('mytable', '', ['p1', 'p2'])
);
self::assertSame(
'ALTER TABLE `mytable` COALESCE PARTITION 2',
Generator::getQueryForPartitioningTable('mytable', 'COALESCE', ['p1', 'p2'])
);
}
}
|
