TableOrViewStatements<Row extends Object, RS extends ResultSet<Row, RS>> class final

Methods to compose common queries and statements on tables or views.

To obtain an instance of this, use GetTableOrViewStatements.statements on a generated table or view instance.

Available extensions

• TableStatements

Properties

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

all() → Selectable<Row>

Selects all rows that are in this table.

count({Expression<bool> where(RS row)?}) → Selectable<int>

Counts the rows in this table.

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.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

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

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

Replaces a single row with an update statement.

select({bool distinct = false}) → SingleTableSelectStatement<Row, RS>

Composes a SELECT statement on the captured table or view.

selectOnly({bool distinct = false}) → SelectStatement

Composes a SELECT statement only selecting a subset of columns.

toString() → String

A string representation of this object.

inherited

update() → UpdateStatement<Row, RS>

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

Creates a statement to compose an UPDATE into the database.

Operators

operator ==(Object other) → bool

The equality operator.

inherited