TableStatements<Tbl extends Table, Row> extension

Easily-accessible methods to compose common operations or statements on tables.

on

• TableInfo<Tbl, Row>

Methods

delete() → DeleteStatement<Tbl, Row>

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Creates a statement to compose a DELETE from the database.

deleteAll() → Future<int>

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Deletes ALL rows from the table.

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

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Deletes the row from the captured table.

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

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Deletes all rows matching the filter from the table.

insert() → InsertStatement<Tbl, Row>

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

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

insertAll(Iterable<Insertable<Row>> rows, {InsertMode? mode, UpsertClause<Tbl, Row>? onConflict}) → Future<void>

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Atomically inserts all rows into the table.

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

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

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

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

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Inserts one row into this table.

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

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

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

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

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

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

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

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Replaces a single row with an update statement.

update() → UpdateStatement<Tbl, Row>

Available on TableInfo<Tbl, Row>, provided by the TableStatements extension

Creates a statement to compose an UPDATE into the database.