classResultSelect

packages/ztd-query-mysql/src/Rewrite/Transformer/Update/ResultSelect.php:20

final class ResultSelect

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

Result Select.

Methods§

public function buildProjection(
    UpdateStatement $stmt,
    array<int, string> $columns,
    array<int, string> $primaryKeys = [],
    list<MultiTableMutationTarget> $targets = [],
    list<string> $assignmentValues = [],
    ?string $whereExpression = null,
    ?string $sourceExpression = null,
): array{sql: string, table: string, tables: array<string, array{alias: string}>}

source §

Build a result-select SQL from an UPDATE statement.

Parameters

`$stmt`	`UpdateStatement`
`$columns`	`array<int, string>`
`$primaryKeys`	`array<int, string>`
`$targets`	`list<MultiTableMutationTarget>`
`$assignmentValues`	`list<string>`
`$whereExpression`	`?string`
`$sourceExpression`	`?string`

Returns

array{sql: string, table: string, tables: array<string, array{alias: string}>}

Throws

RuntimeException

Test cases 1

ResultSelectTest::testBuildProjection calls

Called from 1

method-call ZtdQuery\Platform\MySql\Rewrite\Transformer\UpdateTransformer::buildProjection() packages/ztd-query-mysql/src/Rewrite/Transformer/UpdateTransformer.php:115

Calls 6

new RuntimeException line 43
method-call ResultSelect::targetTables() line 54
method-call ResultSelect::selectColumns() line 56
method-call TargetProjection::multiTableSelectColumns() line 59
new TargetProjection line 59
method-call ResultSelect::buildQuery() line 62

public function targetTables(UpdateStatement $stmt): array<string, array{alias: string}>

source §

Parameters

$stmt UpdateStatement

Returns

array<string, array{alias: string}>

Test cases 1

ResultSelectTest::testTargetTables calls

Called from 1

method-call ZtdQuery\Platform\MySql\Rewrite\Transformer\Update\ResultSelect::buildProjection() packages/ztd-query-mysql/src/Rewrite/Transformer/Update/ResultSelect.php:54

public function selectColumns(
    UpdateStatement $stmt,
    array<int, string> $columns,
    array<int, string> $primaryKeys,
    string $qualifier,
    list<string> $assignmentValues,
): list<string>

source §

Parameters

`$stmt`	`UpdateStatement`
`$columns`	`array<int, string>`
`$primaryKeys`	`array<int, string>`
`$qualifier`	`string`
`$assignmentValues`	`list<string>`

Returns

list<string>

Test cases 1

ResultSelectTest::testSelectColumns calls

Called from 1

method-call ZtdQuery\Platform\MySql\Rewrite\Transformer\Update\ResultSelect::buildProjection() packages/ztd-query-mysql/src/Rewrite/Transformer/Update/ResultSelect.php:56

Calls 6

function-call trim line 100
function-call str_contains line 101
function-call explode line 102
function-call end line 103
new MutationRowIdentity line 117
method-call MutationRowIdentity::column() line 119

public function buildQuery(
    UpdateStatement $stmt,
    list<string> $selectCols,
    Expression $targetTableExpr,
    string $targetTableName,
    string $qualifier,
    ?string $whereExpression,
    ?string $sourceExpression,
): string

source §

Parameters

`$stmt`	`UpdateStatement`
`$selectCols`	`list<string>`
`$targetTableExpr`	`Expression`
`$targetTableName`	`string`
`$qualifier`	`string`
`$whereExpression`	`?string`
`$sourceExpression`	`?string`