classConflictClause

packages/ztd-query-postgres/src/Sql/Statement/ConflictClause.php:18

final class ConflictClause

Restricted visibility: declared "@visibility root". Code outside that scope must not name this declaration.

Conflict clause operations for PostgreSQL statement.

Methods§

public function extractOnConflictTarget(string $sql): ?PgSqlConflictTarget

source §

Extract on conflict target.

Parameters

$sql string

Returns

?PgSqlConflictTarget

Test cases 1

ConflictClauseTest::testExtractOnConflictTarget calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\PgSqlParser::extractOnConflictTarget() packages/ztd-query-postgres/src/Sql/PgSqlParser.php:109

Calls 9

static-call SqlTokenStream::tokenize() line 25
static-call PgSqlLexerProfile::create() line 25
static-call ConflictClause::findOnConflictTargetStart() line 26
new PgSqlConflictTarget line 36
method-call ConflictClause::namedConstraint() line 39
static-call ConflictClause::findTopLevelSymbol() line 45
function-call substr line 50
method-call ConflictClause::indexColumns() line 55
method-call ConflictClause::indexTarget() line 60

public static function findOnConflictTargetStart(list<SqlToken> $tokens): ?int

source §

Parameters

$tokens list<SqlToken>

Returns

?int

Test cases 1

ConflictClauseTest::testFindOnConflictTargetStart calls

Called from 1

static-call ZtdQuery\Platform\Postgres\Sql\Statement\ConflictClause::extractOnConflictTarget() packages/ztd-query-postgres/src/Sql/Statement/ConflictClause.php:26

public static function findTopLevelSymbol(
    list<SqlToken> $tokens,
    int $start,
    string $symbol,
): ?int

source §

Parameters

`$tokens`	`list<SqlToken>`
`$start`	`int`
`$symbol`	`string`

Returns

?int

Test cases 1

ConflictClauseTest::testFindTopLevelSymbol calls

Called from 1

static-call ZtdQuery\Platform\Postgres\Sql\Statement\ConflictClause::extractOnConflictTarget() packages/ztd-query-postgres/src/Sql/Statement/ConflictClause.php:45

Calls 2

function-call count line 89
class-const SqlTokenKind::Symbol() line 94

public static function findTopLevelKeyword(
    list<SqlToken> $tokens,
    int $start,
    string $keyword,
): ?int

source §

Parameters

`$tokens`	`list<SqlToken>`
`$start`	`int`
`$keyword`	`string`

Returns

?int

Test cases 1

ConflictClauseTest::testFindTopLevelKeyword calls

Called from 1

static-call ZtdQuery\Platform\Postgres\Sql\Statement\ConflictClause::indexTarget() packages/ztd-query-postgres/src/Sql/Statement/ConflictClause.php:226

Calls 1

function-call count line 110

public function extractOnConflictUpdateColumns(string $sql): array{columns: list<string>, values: array<string, string>}

source §

Extract ON CONFLICT ... DO UPDATE SET columns and values.

Parameters

$sql string

Returns

array{columns: list<string>, values: array<string, string>}

Test cases 1

ConflictClauseTest::testExtractOnConflictUpdateColumns calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\PgSqlParser::extractOnConflictUpdateColumns() packages/ztd-query-postgres/src/Sql/PgSqlParser.php:122

Calls 7

static-call SqlTokenStream::tokenize() line 133
static-call PgSqlLexerProfile::create() line 133
function-call rtrim line 145
function-call trim line 150
function-call preg_match line 151
method-call IdentifierDecoder::unquoteIdentifier() line 152
new IdentifierDecoder line 152

public function extractOnConflictUpdateWhere(string $sql): ?string

source §

Extract on conflict update where.

Parameters

$sql string

Returns

?string

Test cases 1

ConflictClauseTest::testExtractOnConflictUpdateWhere calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\PgSqlParser::extractOnConflictUpdateWhere() packages/ztd-query-postgres/src/Sql/PgSqlParser.php:133

Calls 2

static-call SqlTokenStream::tokenize() line 166
static-call PgSqlLexerProfile::create() line 166

public function namedConstraint(list<SqlToken> $tokens, int $conflict): ?PgSqlConflictTarget

source §

Resolves an ON CONSTRAINT target after the conflict keyword.

Parameters

`$tokens`	`list<SqlToken>`
`$conflict`	`int`

Returns

?PgSqlConflictTarget

Test cases 1

ConflictClauseTest::testNamedConstraintReadsTheArbiterName calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\Statement\ConflictClause::extractOnConflictTarget() packages/ztd-query-postgres/src/Sql/Statement/ConflictClause.php:39

Calls 3

static-call SqlTokenStream::tokenize() line 189
static-call PgSqlLexerProfile::create() line 189
new PgSqlConflictTarget line 194

public function indexColumns(string $columnSql): list<string>|null

source §

Requires each inferred-index item to consist of one identifier.

Parameters

$columnSql string

Returns

list<string>|null

Test cases 1

ConflictClauseTest::testIndexColumnsRejectsExpressionsAndPreservesNames calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\Statement\ConflictClause::extractOnConflictTarget() packages/ztd-query-postgres/src/Sql/Statement/ConflictClause.php:55

Calls 3

static-call SqlTokenStream::tokenize() line 204
static-call PgSqlLexerProfile::create() line 204
function-call count line 210

public function indexTarget(
    string $sql,
    list<SqlToken> $tokens,
    int $closing,
    list<string> $columns,
): ?PgSqlConflictTarget

source §

Resolves the optional index predicate and requires an ON CONFLICT action.

Parameters

`$sql`	`string`
`$tokens`	`list<SqlToken>`
`$closing`	`int`
`$columns`	`list<string>`

Returns

?PgSqlConflictTarget

Test cases 1

ConflictClauseTest::testIndexTargetCarriesThePartialPredicate calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\Statement\ConflictClause::extractOnConflictTarget() packages/ztd-query-postgres/src/Sql/Statement/ConflictClause.php:60

Calls 4

static-call ConflictClause::findTopLevelKeyword() line 226
function-call trim line 235
function-call substr line 235
new PgSqlConflictTarget line 246

public function hasOnConflict(string $sql): bool

source §

Check if INSERT has ON CONFLICT clause.

Parameters

$sql string

Returns

bool

Test cases 1

ConflictClauseTest::testHasOnConflictIgnoresCommentedClauses calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\PgSqlParser::hasOnConflict() packages/ztd-query-postgres/src/Sql/PgSqlParser.php:98

Calls 2

static-call PostgreSqlLexicalMasker::maskComments() line 254
function-call preg_match line 255

Test cases 27§

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

Dedicated tests 10

Other tests reaching this symbol 17

Relations§

Instantiated in 4

Method calls 4