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
|
--TEST--
SQLite3 user authorizer trampoline callback
--EXTENSIONS--
sqlite3
--FILE--
<?php
class TrampolineTest {
public function __call(string $name, array $arguments) {
echo 'Trampoline for ', $name, PHP_EOL;
if ($arguments[0] == SQLite3::SELECT) {
return SQLite3::OK;
}
return SQLite3::DENY;
}
}
$o = new TrampolineTest();
$callback = [$o, 'authorizer'];
$db = new SQLite3(':memory:');
$db->enableExceptions(true);
$db->setAuthorizer($callback);
// This query should be accepted
var_dump($db->querySingle('SELECT 1;'));
try {
// This one should fail
var_dump($db->querySingle('CREATE TABLE test (a, b);'));
} catch (\Exception $e) {
echo $e->getMessage() . "\n";
}
?>
--EXPECT--
Trampoline for authorizer
int(1)
Trampoline for authorizer
Unable to prepare statement: not authorized
|
