TableOrViewOperations<Tbl extends HasResultSet, Row> class

A capture of a table and a generated database.

Table operations can be captured with DatabaseConnectionUser.from, which may make some common operations easier to write:

• Use from(table).select() or from(table).selectOnly() instead of select(table) or selectOnly(table), respectively.
• Use from(table).insert() instead of insert(table). You can also use from(table).insertOne, or TableOperations.insertOnConflictUpdate to insert rows directly.
• Use from(table).update() instead of update(table). You can also use from(table).replace() to replace an existing row.
• Use from(table).delete(), from(table).deleteOne() or from(table).deleteWhere to delete rows easily.

Available extensions

• TableOperations

Annotations

• @sealed

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

delete() → DeleteStatement<Tbl, Row>

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

Creates a statement to compose a DELETE from the database.

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

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

Deletes the row from the captured table.

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

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

Deletes all rows matching the filter from the table.

insert() → InsertStatement<Tbl, Row>

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

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

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

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

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>

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

Inserts one row into the captured table.

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

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

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

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

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

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

Replaces a single row with an update statement.

select({bool distinct = false}) → SimpleSelectStatement<Tbl, Row>

Composes a SELECT statement on the captured table or view.

selectOnly({bool distinct = false, bool includeJoinedTableColumns = true}) → JoinedSelectStatement<Tbl, Row>

Composes a SELECT statement only selecting a subset of columns.

toString() → String

A string representation of this object.

inherited

update() → UpdateStatement<Tbl, Row>

Available on TableOrViewOperations<Tbl, Row>, provided by the TableOperations extension

Creates a statement to compose an UPDATE into the database.

Operators

operator ==(Object other) → bool

The equality operator.

inherited