Class

SQLConflictUpdateBuilder

A builder for specifying column updates and an optional predicate to be applied to rows that caused unique key conflicts during an INSERT.

final class SQLConflictUpdateBuilder

Topics

Initializers

init()
Create a conflict update builder.

Instance Properties

var predicate: (any SQLExpression)?
The predicate under construction.
var values: [any SQLExpression]
List of assignment pairs.

Instance Methods

func set(excludedContentOf: some Encodable & Sendable, prefix: String?, keyEncodingStrategy: SQLQueryEncoder.KeyEncodingStrategy, nilEncodingStrategy: SQLQueryEncoder.NilEncodingStrategy, userInfo: [CodingUserInfoKey : any Sendable]) throws -> Self
Encodes the given Encodable value to a sequence of key-value pairs and adds an assignment for each pair which uses the values each column was given in the original INSERT query’s VALUES list.
func set(excludedContentOf: some Encodable & Sendable, with: SQLQueryEncoder) throws -> Self
Encodes the given Encodable value to a sequence of key-value pairs and adds an assignment for each pair which uses the values each column was given in the original INSERT query’s VALUES list. See SQLExcludedColumn and SQLQueryEncoder.
func set(excludedValueOf:)
Add an assignment of the given column, using the value the column was given in the INSERT query’s VALUES list.

Relationships

Conforms To

See Also

Query Builders

class SQLAlterEnumBuilder
Builds SQLAlterEnum queries.
class SQLAlterTableBuilder
Builds SQLAlterTable queries.
class SQLCreateEnumBuilder
Builds SQLCreateEnum queries.
class SQLCreateIndexBuilder
Builds SQLCreateIndex queries.
class SQLCreateTableBuilder
Builds SQLCreateTable queries.
class SQLCreateTriggerBuilder
Builds SQLCreateTrigger queries.
class SQLDeleteBuilder
Builds SQLDelete queries.
class SQLDropEnumBuilder
Builds SQLDropEnum queries.
class SQLDropIndexBuilder
Builds SQLDropIndex queries.
class SQLDropTableBuilder
Builds SQLDropTable queries.
class SQLDropTriggerBuilder
Builds SQLDropTrigger queries.
class SQLInsertBuilder
Builds SQLInsert queries.
class SQLPredicateGroupBuilder
Nested SQLPredicateBuilder for building expression groups.
class SQLRawBuilder
Builds raw SQL queries.
class SQLReturningResultBuilder
A builder returned from the methods of SQLReturningBuilder; this builder wraps the original builder with one which provides SQLQueryFetcher conformance. As such, the returning(_:) methods must always be the last ones in any call chain.