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()
orfrom(table).selectOnly()
instead ofselect(table)
orselectOnly(table)
, respectively. - Use
from(table).insert()
instead ofinsert(table)
. You can also usefrom(table).insertOne
, or TableOperations.insertOnConflictUpdate to insert rows directly. - Use
from(table).update()
instead ofupdate(table)
. You can also usefrom(table).replace()
to replace an existing row. - Use
from(table).delete()
,from(table).deleteOne()
orfrom(table).deleteWhere
to delete rows easily.
- Available Extensions
- Annotations
-
- @sealed
Properties
- hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
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
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited