classUpsertMutation

packages/ztd-query-core/src/Shadow/Mutation/UpsertMutation.php:18

final class UpsertMutation
    implements DataMutation

Applies INSERT ... ON DUPLICATE KEY UPDATE (UPSERT) to the shadow store.

Type Aliases§

Row = import from TableDefinition

Methods§

public function __construct(
    string $tableName,
    array<int, string> $primaryKeys,
    array<int, string> $updateColumns = [],
    array<string, UpsertExpression|null> $updateValues = [],
    CandidateKeySet|null $candidateKeys = null,
    UpsertExpression|null $updatePredicate = null,
    bool $databaseEvaluated = false,
    array<string, string> $updateSqlValues = [],
    ?string $updateSqlPredicate = null,
    ?UpsertExpression $conflictPredicate = null,
)

source §

Parameters

`$tableName`	`string`	Target table.
`$primaryKeys`	`array<int, string>`	Primary key columns.
`$updateColumns`	`array<int, string>`	Columns to update on duplicate.
`$updateValues`	`array<string, UpsertExpression\|null>`	Values to use for update on duplicate.
`$candidateKeys`	`CandidateKeySet\|null`	Candidate keys used for conflict detection.
`$updatePredicate`	`UpsertExpression\|null`	Condition that controls the conflict update.
`$databaseEvaluated`	`bool`
`$updateSqlValues`	`array<string, string>`	Raw expressions used only for database-evaluation diagnostics.
`$updateSqlPredicate`	`?string`
`$conflictPredicate`	`?UpsertExpression`

Calls 4

new RowSet line 88
static-call CandidateKeySet::fromSchema() line 95
new ConflictSearch line 99
new UpsertUpdate line 100

public function apply(ShadowStore $store, array $rows): void

source §

{@inheritDoc}

Parameters

`$store`	`ShadowStore`
`$rows`	`array`

Throws

UnsupportedSqlException When an assignment is written in a way ZTD cannot work out

Test cases 24

Calls 8

method-call ShadowStore::get() line 119
new RowSet line 122
method-call UpsertUpdate::incomingRow() line 124
method-call ConflictSearch::of() line 125
function-call array_key_last line 128
method-call UpsertUpdate::applies() line 136
method-call UpsertUpdate::of() line 140
method-call ShadowStore::set() line 146

public function tableName(): string

source §

{@inheritDoc}

Returns

string

Test cases 1

UpsertMutationTest::testTableNameReturnsTableName calls

public function resultRows(): list<Row>

source §

Returns

list<Row>

Test cases 5

Calls 1

function-call array_values line 162

Private surface 13§

Implementation details, listed for orientation only.

private string $tableName

private array<int, string> $primaryKeys

private array<int, string> $updateColumns

private array<string, UpsertExpression|null> $updateValues

private CandidateKeySet $candidateKeys

private ?UpsertExpression $updatePredicate

private ?UpsertExpression $conflictPredicate

private bool $databaseEvaluated

private array<string, string> $updateSqlValues

private ?string $updateSqlPredicate

private RowSet $resultRows

private ConflictSearch $conflicts

private UpsertUpdate $update

Test cases 62§

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

Dedicated tests 24

Other tests reaching this symbol 38

Relations§

Instantiated in 3

Type checks 3