classPgSqlErrorClassifier

packages/ztd-query-postgres/src/Connection/PgSqlErrorClassifier.php:22

final class PgSqlErrorClassifier
    implements ErrorClassifier

Public API: explicitly declared with @visibility public.

PostgreSQL-specific error classifier.

Classifies PostgreSQL SQLSTATE codes to determine the type of error. PostgreSQL uses 5-character SQLSTATE codes; driver error codes are mapped from these.

Distinguish schema errors from syntax errorsdoctest

$classifier = new \ZtdQuery\Platform\Postgres\Connection\PgSqlErrorClassifier();
    $classifier->isUnknownSchemaError(new \ZtdQuery\Connection\Exception\DatabaseException('42P01: relation "users" does not exist')) // => true
    $classifier->isUnknownSchemaError(new \ZtdQuery\Connection\Exception\DatabaseException('42601: syntax error')) // => false

Methods§

public function isUnknownSchemaError(DatabaseException $e): bool

source §

Public API: explicitly declared with @visibility public.

{@inheritDoc}

Parameters

$e DatabaseException

Returns

bool

Distinguish schema errors from syntax errorsdoctest

$classifier = new \ZtdQuery\Platform\Postgres\Connection\PgSqlErrorClassifier();
    $classifier->isUnknownSchemaError(new \ZtdQuery\Connection\Exception\DatabaseException('42P01: relation "users" does not exist')) // => true
    $classifier->isUnknownSchemaError(new \ZtdQuery\Connection\Exception\DatabaseException('42601: syntax error')) // => false

Test cases 20

Calls 7

method-call DatabaseException::getDriverErrorCode() line 53
method-call DatabaseException::getMessage() line 55
class-const PgSqlErrorClassifier::SCHEMA_SQLSTATES() line 56
function-call str_contains line 57
function-call preg_match line 62
function-call in_array line 76
class-const PgSqlErrorClassifier::SCHEMA_ERROR_CODES() line 76

Private surface 2§

Implementation details, listed for orientation only.

private const SCHEMA_ERROR_CODES = [7]

private const SCHEMA_SQLSTATES = [
    '42703',
    // undefined_column
    '42P01',
    // undefined_table
    …

Test cases 20§

Test cases that cover or call this symbol, from the coverage report and from the analyzed test sources.

Dedicated tests 20