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
|
<?php
declare(strict_types=1);
namespace Doctrine\DBAL\Driver\SQLite3;
use Doctrine\DBAL\Driver\Statement as StatementInterface;
use Doctrine\DBAL\ParameterType;
use SQLite3;
use SQLite3Stmt;
use function assert;
use const SQLITE3_BLOB;
use const SQLITE3_INTEGER;
use const SQLITE3_NULL;
use const SQLITE3_TEXT;
final class Statement implements StatementInterface
{
private const TYPE_BLOB = SQLITE3_BLOB;
private const TYPE_INTEGER = SQLITE3_INTEGER;
private const TYPE_NULL = SQLITE3_NULL;
private const TYPE_TEXT = SQLITE3_TEXT;
/** @internal The statement can be only instantiated by its driver connection. */
public function __construct(
private readonly SQLite3 $connection,
private readonly SQLite3Stmt $statement,
) {
}
public function bindValue(int|string $param, mixed $value, ParameterType $type): void
{
$this->statement->bindValue($param, $value, $this->convertParamType($type));
}
public function execute(): Result
{
try {
$result = $this->statement->execute();
} catch (\Exception $e) {
throw Exception::new($e);
}
assert($result !== false);
return new Result($result, $this->connection->changes());
}
/** @psalm-return self::TYPE_* */
private function convertParamType(ParameterType $type): int
{
return match ($type) {
ParameterType::NULL => self::TYPE_NULL,
ParameterType::INTEGER, ParameterType::BOOLEAN => self::TYPE_INTEGER,
ParameterType::STRING, ParameterType::ASCII => self::TYPE_TEXT,
ParameterType::BINARY, ParameterType::LARGE_OBJECT => self::TYPE_BLOB,
};
}
}
|
