UpsertClause<Row extends Object, RS extends GeneratedTable<Row, RS>> class sealed

A upsert clause controls how to behave when a uniqueness constraint is violated during an insert.

Typically, one would use DoUpdate to run an update instead in this case.

Implemented types

• SqlComponent

Constructors

UpsertClause.doNothing({List<TableColumn<Object>>? target})

Creates a DoNothing clause.

const

factory

UpsertClause.doUpdate(Insertable<Row> update(RS old), {List<TableColumn<Object>>? target, Expression<bool> where(RS old)?, Expression<bool> targetCondition(RS old)?})

Creates a DoUpdate clause turning the insert into an update for the conflicting row.

factory

Properties

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

compileWith(StatementCompiler compiler) → void

Compiles this component with the given StatementCompiler by invoking the relevant add method on it.

inherited

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited