classInsertClauseParser

packages/ztd-query-sqlite/src/Sql/Dml/Insert/InsertClauseParser.php:12

final class InsertClauseParser

Restricted visibility: declared "@visibility ZtdQuery\Platform\Sqlite". Code outside that scope must not name this declaration.

Extracts INSERT sources and conflict-handling clauses.

Methods§

public function extractInsertColumns(string $sql): array<int, string>

source §

Extract columns from an INSERT statement.

Parameters

$sql string

Returns

array<int, string>

Test cases 10

Called from 1

method-call ZtdQuery\Platform\Sqlite\Sql\SqliteParser::extractInsertColumns() packages/ztd-query-sqlite/src/Sql/SqliteParser.php:85

Calls 5

method-call LiteralMasker::stripComments() line 21
new LiteralMasker line 21
function-call preg_match line 22
method-call IdentifierDecoder::parseColumnList() line 23
new IdentifierDecoder line 23

public function extractInsertValues(string $sql): array<int, array<int, string>>

source §

Extract VALUES from an INSERT statement.

Parameters

$sql string

Returns

array<int, array<int, string>>

Test cases 23

Called from 1

method-call ZtdQuery\Platform\Sqlite\Sql\SqliteParser::extractInsertValues() packages/ztd-query-sqlite/src/Sql/SqliteParser.php:98

Calls 7

method-call LiteralMasker::stripComments() line 36
new LiteralMasker line 36
method-call InsertClauseParser::findInsertSourceClause() line 37
function-call substr line 45
function-call strlen line 45
method-call ValueListParser::parseValueSets() line 47
new ValueListParser line 47

public function hasOnConflict(string $sql): bool

source §

Check if an INSERT statement has ON CONFLICT clause (upsert).

Parameters

$sql string

Returns

bool

Test cases 6

Called from 1

method-call ZtdQuery\Platform\Sqlite\Sql\SqliteParser::hasOnConflict() packages/ztd-query-sqlite/src/Sql/SqliteParser.php:177

Calls 3

method-call LiteralMasker::stripComments() line 55
new LiteralMasker line 55
function-call preg_match line 56

public function isReplace(string $sql): bool

source §

Check if the statement is INSERT OR REPLACE / REPLACE INTO.

Parameters

$sql string

Returns

bool

Test cases 9

Called from 1

method-call ZtdQuery\Platform\Sqlite\Sql\SqliteParser::isReplace() packages/ztd-query-sqlite/src/Sql/SqliteParser.php:188

Calls 6

function-call ltrim line 64
method-call LiteralMasker::stripComments() line 64
new LiteralMasker line 64
function-call strtoupper line 65
function-call str_starts_with line 67
function-call preg_match line 68

public function isInsertIgnore(string $sql): bool

source §

Check if the statement is INSERT OR IGNORE / INSERT IGNORE.

Parameters

$sql string

Returns

bool

Test cases 8

Called from 1

method-call ZtdQuery\Platform\Sqlite\Sql\SqliteParser::isInsertIgnore() packages/ztd-query-sqlite/src/Sql/SqliteParser.php:199

Calls 4

function-call ltrim line 76
method-call LiteralMasker::stripComments() line 76
new LiteralMasker line 76
function-call preg_match line 78

public function hasInsertSelect(string $sql): bool

source §

Check if an INSERT has a SELECT subquery.

Parameters

$sql string

Returns

bool

Test cases 12

Called from 1

method-call ZtdQuery\Platform\Sqlite\Sql\SqliteParser::hasInsertSelect() packages/ztd-query-sqlite/src/Sql/SqliteParser.php:234

Calls 3

method-call LiteralMasker::stripComments() line 86
new LiteralMasker line 86
method-call InsertClauseParser::findInsertSourceClause() line 87

public function extractInsertSelect(string $sql): ?string

source §

Extract the SELECT subquery from an INSERT ... SELECT statement.

Parameters

$sql string

Returns

?string

Test cases 15

Called from 1

method-call ZtdQuery\Platform\Sqlite\Sql\SqliteParser::extractInsertSelect() packages/ztd-query-sqlite/src/Sql/SqliteParser.php:245

Calls 4

method-call LiteralMasker::stripComments() line 97
new LiteralMasker line 97
method-call InsertClauseParser::findInsertSourceClause() line 98
function-call substr line 100

public function findInsertSourceClause(string $sql): array{keyword: string, offset: int}|null

source §

Parameters

$sql string

Returns

array{keyword: string, offset: int}|null

Test cases 1

InsertClauseParserTest::testFindInsertSourceClauseSkipsSubqueries calls

Called from 3

Calls 2

method-call TopLevelKeywordScanner::scanTopLevelKeywords() line 112
new TopLevelKeywordScanner line 112

Test cases 100§

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

Dedicated tests 77

Other tests reaching this symbol 23

ReferencedTableLookupTest calls
MatchExpressionRewriterTest calls
SqliteFullTextSearchRewriterTest calls
SqliteQueryGuardTest calls
SqliteRewriterTest calls
StatementRewriterTest calls
DeleteTransformerTest calls
InsertProjectionBuilderTest calls
InsertTransformerTest calls
SelectTransformerTest calls
SqliteTransformerTest calls
UpdateTransformerTest calls
ColumnDefinitionParserTest calls
TableDefinitionBuilderTest calls
VirtualTableParserTest calls
SqliteSchemaParserTest calls
AddColumnResolverTest calls
InsertMutationResolverTest calls
RowMutationResolverTest calls
TableMutationResolverTest calls
SqliteMutationResolverTest calls
SqliteParserTest calls
SqliteSessionFactoryTest calls

Relations§

Instantiated in 7

Method calls 7