ProcessedTableManager<DB extends GeneratedDatabase, T extends Table, D extends DataClass, FS extends FilterComposer<DB, T>, OS extends OrderingComposer<DB, T>, C extends ProcessedTableManager<DB, T, D, FS, OS, C, CI, CU>, CI extends Function, CU extends Function> class

A table manager that exposes methods to a table manager that already has filters/orderings/limit applied

Inheritance
Implemented types

Constructors

ProcessedTableManager(TableManagerState<DB, T, D, FS, OS, C, CI, CU> $state)
Create a new ProcessedTableManager instance
const

Properties

$state TableManagerState<DB, T, D, FS, OS, C, CI, CU>
The state for this manager
finalinherited
hashCode int
The hash code for this object.
no setterinherited
runtimeType Type
A representation of the runtime type of the object.
no setterinherited

Methods

count({bool distinct = true}) Future<int>
Return the count of rows matched by the built statement When counting rows, the query will only count distinct rows by default
inherited
delete() Future<int>
Deletes all rows matched by built statement
inherited
exists() Future<bool>
Checks whether any rows exist
inherited
filter(ComposableFilter f(FS f)) → C
Add a filter to the statement
inherited
get({bool distinct = false, int? limit, int? offset}) Future<List<D>>
Executes the statement and returns all rows as a list.
inherited
getSingle() Future<D>
Executes this statement, like get, but only returns one value. If the query returns no or too many rows, the returned future will complete with an error.
inherited
getSingleOrNull() Future<D?>
Executes this statement, like get, but only returns one value. If the result too many values, this method will throw. If no row is returned, null will be returned instead.
inherited
limit(int limit, {int? offset}) → C
Add a limit to the statement
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
orderBy(ComposableOrdering o(OS o)) → C
Add ordering to the statement
inherited
toString() String
A string representation of this object.
inherited
update(Insertable<D> f(CU o)) Future<int>
Writes all non-null fields from the entity into the columns of all rows that match the filter clause. Warning: That also means that, when you're not setting a where clause explicitly, this method will update all rows in the $state.table.
inherited
watch({bool distinct = false, int? limit, int? offset}) Stream<List<D>>
Creates an auto-updating stream of the result that emits new items whenever any table used in this statement changes.
inherited
watchSingle() Stream<D>
Creates an auto-updating stream of this statement, similar to watch. However, it is assumed that the query will only emit one result, so instead of returning a Stream<List<D>>, this returns a Stream<D>. If, at any point, the query emits no or more than one rows, an error will be added to the stream instead.
inherited
watchSingleOrNull() Stream<D?>
Creates an auto-updating stream of this statement, similar to watch. However, it is assumed that the query will only emit one result, so instead of returning a Stream<List<D>>, this returns a Stream<D?>. If the query emits more than one row at some point, an error will be emitted to the stream instead. If the query emits zero rows at some point, null will be added to the stream instead.
inherited

Operators

operator ==(Object other) bool
The equality operator.
inherited