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
|
<?php
declare(strict_types=1);
use PHPUnit\Framework\Attributes\DataProvider;
final class DatabaseDAOTest extends \PHPUnit\Framework\TestCase {
/** @return list<array{string,string,bool,bool}> */
public static function provideStrilikeCommon(): array {
return [
['abc', 'abc', false, true],
['AbC', 'aBc', false, true],
['zabc', 'abc', false, false],
['abcd', 'abc', false, false],
['aéc', 'ac', false, false],
['abcd', 'bc', true, true],
['abcd', 'BC', true, true],
['aßc', 'ß', true, true],
['aéc', 'é', true, true],
['Été', 'Ét', true, true],
['aßc', 'ac', true, false],
['ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz', false, true],
['abcdefghijklmnopqrstuvwxyz', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', true, true],
];
}
/** @return list<array{string,string,bool,bool}> */
public static function provideStrilikeAccents(): array {
return [
['café', 'cafè', false, false],
['Été', 'Eté', false, false],
['Été', 'Et', true, false],
];
}
/** @return list<array{string,string,bool,bool}> */
public static function provideStrilikeNoAccents(): array {
return [
['café', 'cafè', false, true],
['Été', 'Eté', false, true],
['Été', 'Et', true, true],
];
}
/** @return list<array{string,string,bool,bool}> */
public static function provideStrilikeAccentsCasing(): array {
return [
['Été', 'été', false, true],
['AÎNÉE', 'aîné', true, true],
['AÎNÉ', 'aine', false, false],
['AÎNÉE', 'aine', true, false],
];
}
/** @return list<array{string,string,bool,bool}> */
public static function provideStrilikeUnicodeCasing(): array {
return [
['ČĆĐŠŽ', 'čćđšž', false, true], // Croatian
['ÁČĎÉĚÍŇÓŘŠŤÚŮÝŽ', 'áčďéěíňóřšťúůýž', false, true], // Czech
['ÆØÅ', 'æøå', false, true], // Danish
['ŠŽÕÄÖÜ', 'šžõäöü', false, true], // Estonian
['ÄÖ', 'äö', false, true], // Finnish
['ÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ', 'àâæçèéêëîïôœùûüÿ', false, true], // French
['ÄÖÜ', 'äöü', false, true], // German
['ΑΆΒΓΔΕΈΖΗΉΘΙΊΪΚΛΜΝΞΟΌΠΡΣΤΥΎΫΦΧΨΩΏ', 'αάβγδεέζηήθιίϊκλμνξοόπρστυύϋφχψωώ', false, true], // Greek
['ÁÉÍÓÖŐÚÜŰ', 'áéíóöőúüű', false, true], // Hungarian
['ÁÉÍÓÚ', 'áéíóú', false, true], // Irish
['ÀÈÉÌÒÓÙ', 'àèéìòóù', false, true], // Italian
['ĀČĒĢĪĶĻŅŠŪŽ', 'āčēģīķļņšūž', false, true], // Latvian
['ĄČĘĖĮŠŲŪŽ', 'ąčęėįšųūž', false, true], // Lithuanian
['ĊĠĦŻ', 'ċġħż', false, true], // Maltese
['ĄĆĘŁŃÓŚŹŻ', 'ąćęłńóśźż', false, true], // Polish
['ÁÂÃÇÉÍÓÕÚ', 'áâãçéíóõú', false, true], // Portuguese
['ĂÂÎȘȚ', 'ăâîșț', false, true], // Romanian
['ÁÄČĎÉÍĹĽŇÓÔŔŠŤÚÝŽ', 'áäčďéíĺľňóôŕšťúýž', false, true], // Slovak
['ČŠŽ', 'čšž', false, true], // Slovenian
['ÁÉÍÑÓÚÜ', 'áéíñóúü', false, true], // Spanish
['ÅÄÖ', 'åäö', false, true], // Swedish
];
}
/** @return list<array{string,string,bool,bool}> */
public static function provideStrilikeNoUnicodeCasing(): array {
return [
['café', 'cafè', false, false],
['café', 'Café', true, true],
['Été', 'été', true, false],
];
}
#[DataProvider('provideStrilikeCommon')]
#[DataProvider('provideStrilikeNoAccents')]
#[DataProvider('provideStrilikeUnicodeCasing')]
public static function test_strilike_MySQL(string $haystack, string $needle, bool $contains, bool $expected): void {
if (!function_exists('transliterator_transliterate') && str_contains($haystack, 'α')) {
self::markTestSkipped('transliterator_transliterate function not available to handle e.g. Greek.');
return; // @phpstan-ignore deadCode.unreachable
}
self::assertSame($expected, FreshRSS_DatabaseDAO::strilike($haystack, $needle, $contains));
}
#[DataProvider('provideStrilikeCommon')]
#[DataProvider('provideStrilikeAccents')]
#[DataProvider('provideStrilikeAccentsCasing')]
#[DataProvider('provideStrilikeUnicodeCasing')]
public static function test_strilike_PGSQL(string $haystack, string $needle, bool $contains, bool $expected): void {
self::assertSame($expected, FreshRSS_DatabaseDAOPGSQL::strilike($haystack, $needle, $contains));
}
#[DataProvider('provideStrilikeCommon')]
#[DataProvider('provideStrilikeAccents')]
#[DataProvider('provideStrilikeNoUnicodeCasing')]
public static function test_strilike_SQLite(string $haystack, string $needle, bool $contains, bool $expected): void {
self::assertSame($expected, FreshRSS_DatabaseDAOSQLite::strilike($haystack, $needle, $contains));
}
}
|
