Batch class Null safety

Contains operations to run queries in a batched mode. This can be much more efficient when running a lot of similar queries at the same time, making this api suitable for bulk updates.

Properties

hashCode int
The hash code for this object. [...]
read-only, inherited
runtimeType Type
A representation of the runtime type of the object.
read-only, inherited

Methods

customStatement(String sql, [List? args]) → void
Executes the custom sql statement with variables instantiated to args. [...]
delete<T extends Table, D>(TableInfo<T, D> table, Insertable<D> row) → void
Deletes row from the table when this batch is executed. [...]
deleteWhere<T extends Table, D>(TableInfo<T, D> table, Expression<bool?> filter(T tbl)) → void
Deletes all rows from table matching the provided filter. [...]
insert<T extends Table, D>(TableInfo<T, D> table, Insertable<D> row, {InsertMode? mode, UpsertClause<T, D>? onConflict}) → void
Inserts a row constructed from the fields in row. [...]
insertAll<T extends Table, D>(TableInfo<T, D> table, List<Insertable<D>> rows, {InsertMode? mode, UpsertClause<T, D>? onConflict}) → void
Inserts all rows into the table. [...]
insertAllOnConflictUpdate<T extends Table, D>(TableInfo<T, D> table, List<Insertable<D>> rows) → void
Equivalent of InsertStatement.insertOnConflictUpdate for multiple rows that will be inserted in this batch.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a non-existent method or property is accessed. [...]
inherited
replace<T extends Table, D>(TableInfo<T, D> table, Insertable<D> row) → void
Replaces the row from the table with the updated values. The row in the table with the same primary key will be replaced. [...]
replaceAll<T extends Table, D>(TableInfo<T, D> table, List<Insertable<D>> rows) → void
Helper that calls replace for all rows.
toString() String
A string representation of this object. [...]
inherited
update<T extends Table, D>(TableInfo<T, D> table, Insertable<D> row, {Expression<bool?> where(T table)?}) → void
Writes all present columns from the row into all rows in the table that match the where clause. [...]

Operators

operator ==(Object other) bool
The equality operator. [...]
inherited