/**
* {@inheritdoc}
*/
protected function executeQuery($query, array $parameters)
{
if (isset($this->statements[$query])) {
$statement = $this->statements[$query];
} else {
// Temporary set the error reporting level to 0 to avoid any warning.
$errorReportingLevel = error_reporting(0);
$statement = $this->sqlite3->prepare($query);
// Restore the original error reporting level.
error_reporting($errorReportingLevel);
$errorCode = $this->sqlite3->lastErrorCode();
if ($errorCode !== 0) {
$exception = new SQLite3Exception($this->sqlite3->lastErrorMsg(), $errorCode);
if ($errorCode === 1) {
// SQL error cause by a missing function, this must be reported with a GeometryEngineException.
throw GeometryEngineException::operationNotSupportedByEngine($exception);
} else {
// Other SQLite3 error; we cannot trigger the original E_WARNING, so we throw this exception instead.
throw $exception;
}
} else {
$this->statements[$query] = $statement;
}
}
$index = 1;
foreach ($parameters as $parameter) {
if ($parameter instanceof Geometry) {
if ($parameter->isEmpty()) {
$statement->bindValue($index++, $parameter->asText(), SQLITE3_TEXT);
$statement->bindValue($index++, $parameter->SRID(), SQLITE3_INTEGER);
} else {
$statement->bindValue($index++, $parameter->asBinary(), SQLITE3_BLOB);
$statement->bindValue($index++, $parameter->SRID(), SQLITE3_INTEGER);
}
} else {
if ($parameter === null) {
$type = SQLITE3_NULL;
} elseif (is_int($parameter)) {
$type = SQLITE3_INTEGER;
} elseif (is_float($parameter)) {
$type = SQLITE3_FLOAT;
} else {
$type = SQLITE3_TEXT;
}
$statement->bindValue($index++, $parameter, $type);
}
}
$result = $statement->execute();
return $result->fetchArray(SQLITE3_NUM);
}
/**
* {@inheritdoc}
*/
protected function executeQuery($query, array $parameters)
{
$errMode = $this->pdo->getAttribute(\PDO::ATTR_ERRMODE);
$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
try {
if (!isset($this->statements[$query])) {
$this->statements[$query] = $this->pdo->prepare($query);
}
$statement = $this->statements[$query];
$index = 1;
foreach ($parameters as $parameter) {
if ($parameter instanceof Geometry) {
if ($parameter->isEmpty()) {
$statement->bindValue($index++, $parameter->asText(), \PDO::PARAM_STR);
$statement->bindValue($index++, $parameter->SRID(), \PDO::PARAM_INT);
} else {
$statement->bindValue($index++, $parameter->asBinary(), \PDO::PARAM_LOB);
$statement->bindValue($index++, $parameter->SRID(), \PDO::PARAM_INT);
}
} else {
$statement->bindValue($index++, $parameter);
}
}
$statement->execute();
$result = $statement->fetch(\PDO::FETCH_NUM);
} catch (\PDOException $e) {
$errorClass = substr($e->getCode(), 0, 2);
// 42XXX = syntax error or access rule violation; reported on undefined function.
// 22XXX = data exception; reported by MySQL 5.7 on unsupported geometry.
if ($errorClass == '42' || $errorClass == '22') {
throw GeometryEngineException::operationNotSupportedByEngine($e);
}
throw $e;
}
$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, $errMode);
return $result;
}
/**
* {@inheritdoc}
*/
public function simplify(Geometry $g, $tolerance)
{
try {
return $this->fromGEOS($this->toGEOS($g)->simplify($tolerance));
} catch (\Exception $e) {
throw GeometryEngineException::operationNotSupportedByEngine($e);
}
}