17455666098

Committed 04 Sep 2025 06:43AM UTC coverage: 50.189% (-0.2%) from 50.432%

Build # 17455666098

Build Type

push

github

Committed by

BenMorel

Commit Message

Use @extends and @implements instead of @template-* variants

For consistency with the rest of the project.

Run Details

1858 of 3702 relevant lines covered (50.19%)

851.09 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

93.1

/src/Engine/Sqlite3Engine.php

<?php

declare(strict_types=1);

namespace Brick\Geo\Engine;

use Brick\Geo\Engine\Internal\TypeChecker;
use Brick\Geo\Exception\GeometryEngineException;
use Brick\Geo\LineString;
use Brick\Geo\Point;
use Exception;
use Override;
use SQLite3;
use SQLite3Stmt;

use function assert;
use function is_float;
use function is_int;

use const SQLITE3_BLOB;
use const SQLITE3_FLOAT;
use const SQLITE3_INTEGER;
use const SQLITE3_NUM;
use const SQLITE3_TEXT;

/**
 * Database engine based on a SQLite3 driver.
 *
 * The spatialite extension must be loaded in this driver.
 */
final class Sqlite3Engine extends DatabaseEngine
{
    /**
     * The database connection.
     */
    private readonly SQLite3 $sqlite3;

    /**
     * A cache of the prepared statements, indexed by query.
     *
     * @var array<string, SQLite3Stmt>
     */
    private array $statements = [];

    public function __construct(SQLite3 $sqlite3, bool $useProxy = true)
    {
        parent::__construct($useProxy);

        $this->sqlite3 = $sqlite3;
    }

    public function getSQLite3(): SQLite3
    {
        return $this->sqlite3;
    }

    #[Override]
    public function lineInterpolatePoint(LineString $lineString, float $fraction): Point
    {
        $result = $this->queryGeometry('ST_Line_Interpolate_Point', $lineString, $fraction);
        TypeChecker::check($result, Point::class);

        return $result;
    }

    #[Override]
    protected function executeQuery(string $query, array $parameters): array
    {
        $enableExceptions = $this->sqlite3->enableExceptions(true);

        try {
            if (isset($this->statements[$query])) {
                $statement = $this->statements[$query];
                $statement->reset();
            } else {
                $statement = $this->sqlite3->prepare($query);
                $this->statements[$query] = $statement;
            }

            $index = 1;

            foreach ($parameters as $parameter) {
                if ($parameter instanceof GeometryParameter) {
                    $statement->bindValue($index++, $parameter->data, $parameter->isBinary ? SQLITE3_BLOB : SQLITE3_TEXT);
                    $statement->bindValue($index++, $parameter->srid, SQLITE3_INTEGER);
                } else {
                    if (is_int($parameter)) {
                        $type = SQLITE3_INTEGER;
                    } elseif (is_float($parameter)) {
                        $type = SQLITE3_FLOAT;
                    } else {
                        $type = SQLITE3_TEXT;
                    }

                    $statement->bindValue($index++, $parameter, $type);
                }
            }

            $sqlite3Result = $statement->execute();

            /** @var list<mixed>|false $result */
            $result = $sqlite3Result->fetchArray(SQLITE3_NUM);
        } catch (Exception $e) {
            throw GeometryEngineException::wrap($e);
        } finally {
            $this->sqlite3->enableExceptions($enableExceptions);
        }

        assert($result !== false);

        return $result;
    }
}

1	<?php
2
3	declare(strict_types=1);
4
5	namespace Brick\Geo\Engine;
6
7	use Brick\Geo\Engine\Internal\TypeChecker;
8	use Brick\Geo\Exception\GeometryEngineException;
9	use Brick\Geo\LineString;
10	use Brick\Geo\Point;
11	use Exception;
12	use Override;
13	use SQLite3;
14	use SQLite3Stmt;
15
16	use function assert;
17	use function is_float;
18	use function is_int;
19
20	use const SQLITE3_BLOB;
21	use const SQLITE3_FLOAT;
22	use const SQLITE3_INTEGER;
23	use const SQLITE3_NUM;
24	use const SQLITE3_TEXT;
25
26	/**
27	* Database engine based on a SQLite3 driver.
28	*
29	* The spatialite extension must be loaded in this driver.
30	*/
31	final class Sqlite3Engine extends DatabaseEngine
32	{
33	/**
34	* The database connection.
35	*/
36	private readonly SQLite3 $sqlite3;
37
38	/**
39	* A cache of the prepared statements, indexed by query.
40	*
41	* @var array<string, SQLite3Stmt>
42	*/
43	private array $statements = [];
44
45	public function __construct(SQLite3 $sqlite3, bool $useProxy = true)
46	{
47	parent::__construct($useProxy);	×
48
49	$this->sqlite3 = $sqlite3;	×
50	}
51
52	public function getSQLite3(): SQLite3
53	{
54	return $this->sqlite3;	2✔
55	}
56
57	#[Override]
58	public function lineInterpolatePoint(LineString $lineString, float $fraction): Point
59	{
60	$result = $this->queryGeometry('ST_Line_Interpolate_Point', $lineString, $fraction);	21✔
61	TypeChecker::check($result, Point::class);	21✔
62
63	return $result;	21✔
64	}
65
66	#[Override]
67	protected function executeQuery(string $query, array $parameters): array
68	{
69	$enableExceptions = $this->sqlite3->enableExceptions(true);	274✔
70
71	try {
72	if (isset($this->statements[$query])) {	274✔
73	$statement = $this->statements[$query];	215✔
74	$statement->reset();	215✔
75	} else {
76	$statement = $this->sqlite3->prepare($query);	65✔
77	$this->statements[$query] = $statement;	36✔
78	}
79
80	$index = 1;	245✔
81
82	foreach ($parameters as $parameter) {	245✔
83	if ($parameter instanceof GeometryParameter) {	245✔
84	$statement->bindValue($index++, $parameter->data, $parameter->isBinary ? SQLITE3_BLOB : SQLITE3_TEXT);	245✔
85	$statement->bindValue($index++, $parameter->srid, SQLITE3_INTEGER);	245✔
86	} else {
87	if (is_int($parameter)) {	50✔
88	$type = SQLITE3_INTEGER;	7✔
89	} elseif (is_float($parameter)) {	43✔
90	$type = SQLITE3_FLOAT;	39✔
91	} else {
92	$type = SQLITE3_TEXT;	9✔
93	}
94
95	$statement->bindValue($index++, $parameter, $type);	50✔
96	}
97	}
98
99	$sqlite3Result = $statement->execute();	245✔
100
101	/** @var list<mixed>\|false $result */
102	$result = $sqlite3Result->fetchArray(SQLITE3_NUM);	245✔
103	} catch (Exception $e) {	29✔
104	throw GeometryEngineException::wrap($e);	29✔
105	} finally {
106	$this->sqlite3->enableExceptions($enableExceptions);	274✔
107	}
108
109	assert($result !== false);
110
111	return $result;	245✔
112	}
113	}

brick / geo / 17455666098

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous