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
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin\Tests\Query;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Dbal\DbalInterface;
use PhpMyAdmin\Query\Compatibility;
use PHPUnit\Framework\TestCase;
/**
* @covers \PhpMyAdmin\Query\Compatibility
*/
#[\PHPUnit\Framework\Attributes\CoversClass(\PhpMyAdmin\Query\Compatibility::class)]
class CompatibilityTest extends TestCase
{
/**
* @dataProvider providerForTestHasAccountLocking
*/
#[\PHPUnit\Framework\Attributes\DataProvider('providerForTestHasAccountLocking')]
public function testHasAccountLocking(bool $expected, bool $isMariaDb, int $version): void
{
self::assertSame($expected, Compatibility::hasAccountLocking($isMariaDb, $version));
}
/**
* @return array[]
* @psalm-return array<string, array{bool, bool, int}>
*/
public static function providerForTestHasAccountLocking(): array
{
return [
'MySQL 5.7.5' => [false, false, 50705],
'MySQL 5.7.6' => [true, false, 50706],
'MySQL 5.7.7' => [true, false, 50707],
'MariaDB 10.4.1' => [false, true, 100401],
'MariaDB 10.4.2' => [true, true, 100402],
'MariaDB 10.4.3' => [true, true, 100403],
];
}
/**
* @dataProvider providerForTestIsUUIDSupported
*/
#[\PHPUnit\Framework\Attributes\DataProvider('providerForTestIsUUIDSupported')]
public function testIsUUIDSupported(bool $expected, bool $isMariaDb, int $version): void
{
$dbiStub = $this->createStub(DatabaseInterface::class);
$dbiStub->method('isMariaDB')->willReturn($isMariaDb);
$dbiStub->method('getVersion')->willReturn($version);
self::assertSame($expected, Compatibility::isUUIDSupported($dbiStub));
}
/**
* @return array[]
* @psalm-return array<string, array{bool, bool, int}>
*/
public static function providerForTestIsUUIDSupported(): array
{
return [
'MySQL 5.7.5' => [false, false, 50705],
'MySQL 8.0.30' => [false, false, 80030],
'MariaDB 10.6.0' => [false, true, 100600],
'MariaDB 10.7.0' => [true, true, 100700],
];
}
/** @dataProvider showBinLogStatusProvider */
#[\PHPUnit\Framework\Attributes\DataProvider('showBinLogStatusProvider')]
public function testGetShowBinLogStatusStmt(string $serverName, int $version, string $expected): void
{
$dbal = self::createStub(DbalInterface::class);
$dbal->method('isMySql')->willReturn($serverName === 'MySQL');
$dbal->method('isMariaDB')->willReturn($serverName === 'MariaDB');
$dbal->method('getVersion')->willReturn($version);
self::assertSame($expected, Compatibility::getShowBinLogStatusStmt($dbal));
}
/** @return iterable<int, array{string, int, string}> */
public static function showBinLogStatusProvider(): iterable
{
yield ['MySQL', 80200, 'SHOW BINARY LOG STATUS'];
yield ['MariaDB', 100502, 'SHOW BINLOG STATUS'];
yield ['MySQL', 80199, 'SHOW MASTER STATUS'];
yield ['MariaDB', 100501, 'SHOW MASTER STATUS'];
yield ['MySQL', 100502, 'SHOW BINARY LOG STATUS'];
}
}
|
