TableOperations<Tbl extends Table, Row> extension

Additional methods for a TableOrViewOperations that are only available on tables.

on

• TableOrViewOperations<Tbl, Row>

Methods

delete() → DeleteStatement<Tbl, Row>

Creates a statement to compose a DELETE from the database.

deleteOne(Insertable<Row> row) → Future<bool>

Deletes the row from the captured table.

deleteWhere(Expression<bool?> filter(Tbl tbl)) → Future<int>

Deletes all rows matching the filter from the table.

insert() → InsertStatement<Tbl, Row>

Creates an insert statment to be used to compose an insert on the captured table.

insertOnConflictUpdate(Insertable<Row> row) → Future<int>

Inserts one row into the captured table, replacing an existing row if it exists already.

insertOne(Insertable<Row> row, {InsertMode? mode, UpsertClause<Tbl, Row>? onConflict}) → Future<int>

Inserts one row into the captured table.

insertReturning(Insertable<Row> row, {InsertMode? mode, UpsertClause<Tbl, Row>? onConflict}) → Future<Row>

Inserts one row into the captured table and returns it, along with auto- generated fields.

replace(Insertable<Row> row) → Future<void>

Replaces a single row with an update statement.

update() → UpdateStatement<Tbl, Row>

Creates a statement to compose an UPDATE into the database.