Upsert class

Insert or update SQL statement builder.

Use into method to set the table to insert into. Use set, setMany, setValue, setInt, setString, setBool, setDateTime and setValues to set column values.

Use exec statement or Adapter to execute the statement against a database.

Implemented types

• Statement

Constructors

Upsert(String name)

Properties

asImmutable → ImmutableUpsertStatement

Read-only representation of this statement.

no setter

hashCode → int

The hash code for this object.

no setter, inherited

name → String

final

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

exec<T>(Adapter adapter) → Future<T>

Executes the statement with the given adapter.

id(String id) → Upsert

Id is the auto-generated primary key that is set by the database. Adapter will request the database to return this column on inserts.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

set<ValType>(Field<ValType> field, ValType value) → Upsert

Set the the value of given column (field).

setBool(String column, bool value) → Upsert

Convenience method to set the value of bool column.

setDateTime(String column, DateTime value) → Upsert

Convenience method to set the value of date time column.

setInt(String column, int value) → Upsert

Convenience method to set the value of int column.

setMany(Iterable<SetColumn> columns) → Upsert

Sets many columns with a single call.

setString(String column, String value) → Upsert

Convenience method to set the value of string column.

setValue<ValType>(String column, ValType value) → Upsert

Sets the value of the given column.

setValues(Map<String, dynamic> values) → Upsert

Convenience method to set the value of int column.

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited