php-src/ext/pdo_sqlite/tests/subclasses/pdo_sqlite_createcollation_trampoline.phpt at 660996662a2649c73b6908deb7fec6d3b84a67a0 · php/php-src · GitHub

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
--TEST--
Test Pdo\Sqlite::createCollation() trampoline callback
--EXTENSIONS--
pdo_sqlite
--FILE--
<?php

$db = new Pdo\Sqlite('sqlite::memory:');

$db->query('CREATE TABLE test_pdo_sqlite_createcollation_trampoline (s VARCHAR(4))');

$stmt = $db->query("INSERT INTO test_pdo_sqlite_createcollation_trampoline VALUES ('a1'), ('a10'), ('a2')");

class TrampolineTest {
    public function __call(string $name, array $arguments) {
        echo 'Trampoline for ', $name, PHP_EOL;
        return strnatcmp(...$arguments);
    }
}

var_dump($db->createCollation('NAT', [new TrampolineTest(), 'NAT']));

echo "default\n";
foreach ($db->query('SELECT s FROM test_pdo_sqlite_createcollation_trampoline ORDER BY s') as $row) {
    var_dump($row);
}

echo "natural\n";
foreach ($db->query('SELECT s FROM test_pdo_sqlite_createcollation_trampoline ORDER BY s COLLATE NAT') as $row) {
    var_dump($row);
}

?>
--EXPECT--
bool(true)
default
array(2) {
  ["s"]=>
  string(2) "a1"
  [0]=>
  string(2) "a1"
}
array(2) {
  ["s"]=>
  string(3) "a10"
  [0]=>
  string(3) "a10"
}
array(2) {
  ["s"]=>
  string(2) "a2"
  [0]=>
  string(2) "a2"
}
natural
Trampoline for NAT
Trampoline for NAT
array(2) {
  ["s"]=>
  string(2) "a1"
  [0]=>
  string(2) "a1"
}
array(2) {
  ["s"]=>
  string(2) "a2"
  [0]=>
  string(2) "a2"
}
array(2) {
  ["s"]=>
  string(3) "a10"
  [0]=>
  string(3) "a10"
}