enumUpsertColumnSource

packages/ztd-query-core/src/Shadow/Mutation/UpsertColumnSource.php:14

enum UpsertColumnSource

Which of the two rows an UPSERT assignment reads a column from.

A conflicting write has two rows in play: the one already there and the one the statement was trying to write. Every dialect spells the difference differently and this is what they all mean.

Cases§

case Existing

source §

case Incoming

source §

Test cases 26§

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

Dedicated tests 1

UpsertColumnSourceTest::testListsSemanticColumnSources calls

Other tests reaching this symbol 25

ConflictSearchTest::testOfIsNothingWhereTheIncomingRowTakesNoPartInTheNarrowedKey calls
ConflictSearchTest::testOfLeavesOutTheRowsAlreadyThereThatTakeNoPart calls
ConflictSearchTest::testOfReportsTheRowUnderTheKeyTheCallerKnowsItBy calls
MutationImpactTest::testSkippedConditionalUpsertHasNoAffectedOrReturningRows calls
InsertMutationTest::testInsertIgnoreUsesPartialConflictPredicate calls
PrimaryParserTest::testColumnSourceResolvesIncomingAndExistingQualifiers calls
ExpressionReaderTest::testColumnSourceDistinguishesIncomingAlias calls
PrimaryExpressionParserTest::testColumnSourceDistinguishesTableAndExcluded calls
UpsertExpressionTest::testColumnReadsTheSelectedRowAndColumn calls
UpsertExpressionTest::testEvaluatesNullNumericTextAndCaseInsensitiveColumnBoundaries calls
UpsertExpressionTest::testLiteralAnswersTheValueTheStatementWrote calls
UpsertExpressionTest::testOperandRefusesAColumnTheRowDoesNotCarry calls
UpsertMutationTest::testApplyAccumulatesExistingAndIncomingValues calls
UpsertMutationTest::testApplyAccumulatesSequentialConflictsAgainstLatestRow calls
UpsertMutationTest::testApplyUpdatesExistingRowOnUniqueKeyConflict calls
UpsertMutationTest::testApplyUsesConflictPredicateAndReportsOnlyAppliedRows calls
UpsertMutationTest::testApplyWithExcludedColumnReference calls
UpsertMutationTest::testApplyWithExcludedQuotedColumnReference calls
UpsertMutationTest::testApplyWithUpdateValuesExpression calls
UpsertMutationTest::testConflictPredicateRestrictsIncomingAndExistingCandidateRows calls
UpsertMutationTest::testDatabaseEvaluatedBatchDetectsConflictsWithRowsInsertedEarlierInStatement calls
UpsertMutationTest::testDatabaseEvaluatedBatchReevaluatesAgainstLatestConflictRow calls
UpsertMutationTest::testDatabaseEvaluatedPredicateFallsBackWhenMetadataIsMissing calls
UpsertMutationTest::testSkippedConditionalRowDoesNotStopFollowingRows calls
UpsertUpdateTest::testWithColumnReadsTheExpressionAgainstTheRowAsTheStatementLeftIt calls

Relations§

Constant reads 11

class-const ZtdQuery\Shadow\Mutation\UpsertExpression::evaluate() packages/ztd-query-core/src/Shadow/Mutation/UpsertExpression.php:150
class-const ZtdQuery\Platform\MySql\Shadow\Mutation\Upsert\ExpressionReader::parseValuesReference() packages/ztd-query-mysql/src/Shadow/Mutation/Upsert/ExpressionReader.php:243
class-const ZtdQuery\Platform\MySql\Shadow\Mutation\Upsert\ExpressionReader::columnSource() packages/ztd-query-mysql/src/Shadow/Mutation/Upsert/ExpressionReader.php:257
class-const ZtdQuery\Platform\MySql\Shadow\Mutation\Upsert\ExpressionReader::columnSource() packages/ztd-query-mysql/src/Shadow/Mutation/Upsert/ExpressionReader.php:260
class-const ZtdQuery\Platform\MySql\Shadow\Mutation\Upsert\ExpressionReader::parseColumnReference() packages/ztd-query-mysql/src/Shadow/Mutation/Upsert/ExpressionReader.php:325
class-const ZtdQuery\Platform\Postgres\Shadow\Mutation\Upsert\Expression\PrimaryParser::columnSource() packages/ztd-query-postgres/src/Shadow/Mutation/Upsert/Expression/PrimaryParser.php:77
class-const ZtdQuery\Platform\Postgres\Shadow\Mutation\Upsert\Expression\PrimaryParser::columnSource() packages/ztd-query-postgres/src/Shadow/Mutation/Upsert/Expression/PrimaryParser.php:80
class-const ZtdQuery\Platform\Postgres\Shadow\Mutation\Upsert\Expression\PrimaryParser::column() packages/ztd-query-postgres/src/Shadow/Mutation/Upsert/Expression/PrimaryParser.php:111
class-const ZtdQuery\Platform\Sqlite\Shadow\Mutation\Upsert\PrimaryExpressionParser::columnSource() packages/ztd-query-sqlite/src/Shadow/Mutation/Upsert/PrimaryExpressionParser.php:75
class-const ZtdQuery\Platform\Sqlite\Shadow\Mutation\Upsert\PrimaryExpressionParser::columnSource() packages/ztd-query-sqlite/src/Shadow/Mutation/Upsert/PrimaryExpressionParser.php:78
class-const ZtdQuery\Platform\Sqlite\Shadow\Mutation\Upsert\PrimaryExpressionParser::parseColumn() packages/ztd-query-sqlite/src/Shadow/Mutation/Upsert/PrimaryExpressionParser.php:114

Type declarations 5

type ZtdQuery\Shadow\Mutation\UpsertExpression packages/ztd-query-core/src/Shadow/Mutation/UpsertExpression.php:43
type ZtdQuery\Shadow\Mutation\UpsertExpression packages/ztd-query-core/src/Shadow/Mutation/UpsertExpression.php:74
type ZtdQuery\Platform\MySql\Shadow\Mutation\Upsert\ExpressionReader packages/ztd-query-mysql/src/Shadow/Mutation/Upsert/ExpressionReader.php:250
type ZtdQuery\Platform\Postgres\Shadow\Mutation\Upsert\Expression\PrimaryParser packages/ztd-query-postgres/src/Shadow/Mutation/Upsert/Expression/PrimaryParser.php:74
type ZtdQuery\Platform\Sqlite\Shadow\Mutation\Upsert\PrimaryExpressionParser packages/ztd-query-sqlite/src/Shadow/Mutation/Upsert/PrimaryExpressionParser.php:72