TableStatements<Row extends Object, RS extends GeneratedTable<Row, RS>> extension

Utility to compose common statements for tables.

on

• TableOrViewStatements<Row, RS>

Methods

delete() → DeleteStatement<Row, RS>

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Creates a statement to compose a DELETE from the database.

deleteAll() → Future<int>

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Deletes ALL rows from the table.

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

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Deletes the row from the captured table.

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

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Deletes all rows matching the filter from the table.

insert() → InsertStatement<Row, RS>

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

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

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

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Atomically inserts all rows into the table.

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

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

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

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

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Inserts one row into this table.

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

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

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

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

Available on TableOrViewStatements<Row, RS>, 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 TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Replaces a single row with an update statement.

update() → UpdateStatement<Row, RS>

Available on TableOrViewStatements<Row, RS>, provided by the TableStatements extension

Creates a statement to compose an UPDATE into the database.