$$AccountsTableTableManager class
- Inheritance
-
- Object
- Selectable<AccountRow>
- BaseTableManager<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), AccountRow, PrefetchHooks Function()>
- RootTableManager<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), AccountRow, PrefetchHooks Function()>
- $$AccountsTableTableManager
Properties
-
$state
→ TableManagerState<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), AccountRow, PrefetchHooks Function()>
-
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
-
asyncMap<N>(FutureOr<N> mapper(AccountRow))
→ Selectable<N>
-
Maps this selectable by the
mapper function.
inherited
-
bulkCreate(Iterable<Insertable<AccountRow>> f($$AccountsTableCreateCompanionBuilder o), {InsertMode? mode, UpsertClause<$AccountsTable, AccountRow>? onConflict})
→ Future<void>
-
Create multiple rows in the table using the given function
inherited
-
bulkReplace(Iterable<Insertable<AccountRow>> entities)
→ Future<void>
-
Replace multiple rows in the table
inherited
-
computedField<T extends Object>(Expression<T> a($$AccountsTableAnnotationComposer a))
→ ComputedField<T, $AccountsTable>
-
Create an computed field for adding additional columns to the query
inherited
-
computedfieldWithConverter<DartType, SqlType extends Object>(GeneratedColumnWithTypeConverter<DartType, SqlType> a($$AccountsTableAnnotationComposer a))
→ ComputedFieldWithConverter<DartType, SqlType, $AccountsTable>
-
Create an
computed field with type converter support
inherited
-
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
-
create(Insertable<AccountRow> f($$AccountsTableCreateCompanionBuilder o), {InsertMode? mode, UpsertClause<$AccountsTable, AccountRow>? onConflict})
→ Future<int>
-
Creates a new row in the table using the given function
inherited
-
createReturning(Insertable<AccountRow> f($$AccountsTableCreateCompanionBuilder o), {InsertMode? mode, UpsertClause<$AccountsTable, AccountRow>? onConflict})
→ Future<AccountRow>
-
Inserts a row into the table and returns it.
inherited
-
createReturningOrNull(Insertable<AccountRow> f($$AccountsTableCreateCompanionBuilder o), {InsertMode? mode, UpsertClause<$AccountsTable, AccountRow>? onConflict})
→ Future<AccountRow?>
-
Inserts a row into the table and returns it.
inherited
-
delete()
→ Future<int>
-
Deletes all rows matched by built statement
inherited
-
exists()
→ Future<bool>
-
Checks whether any rows exist
inherited
-
filter(Expression<bool> f($$AccountsTableFilterComposer f))
→ ProcessedTableManager<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), AccountRow, PrefetchHooks Function()>
-
Add a filter to the statement
inherited
-
get({bool distinct = false, int? limit, int? offset})
→ Future<List<AccountRow>>
-
Executes the statement and returns all rows as a list.
inherited
-
getSingle({bool distinct = true})
→ Future<AccountRow>
-
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({bool distinct = true})
→ Future<AccountRow?>
-
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})
→ ProcessedTableManager<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), AccountRow, PrefetchHooks Function()>
-
Add a limit to the statement
inherited
-
map<N>(N mapper(AccountRow))
→ Selectable<N>
-
Maps this selectable by the
mapper function.
inherited
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
orderBy(ComposableOrdering o($$AccountsTableOrderingComposer o))
→ ProcessedTableManager<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), AccountRow, PrefetchHooks Function()>
-
Add ordering to the statement
inherited
-
replace(Insertable<AccountRow> entity)
→ Future<bool>
-
Replaces the old version of
entity that is stored in the database with
the fields of the entity provided here. This implicitly applies a
filter clause to rows with the same primary key as entity, so that only
the row representing outdated data will be replaced.
inherited
-
toString()
→ String
-
A string representation of this object.
inherited
-
update(Insertable<AccountRow> f($$AccountsTableUpdateCompanionBuilder 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<AccountRow>>
-
Creates an auto-updating stream of the result that emits new items
whenever any table used in this statement changes.
inherited
-
watchSingle({bool distinct = true})
→ Stream<AccountRow>
-
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({bool distinct = true})
→ Stream<AccountRow?>
-
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
-
withFields(Iterable<BaseComputedField<Object, $AccountsTable>> computedFields)
→ ProcessedTableManager<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), PrefetchHooks Function()>
-
Add computed fields to the statement which will be used to add additional columns to the query
These columns will be returned in the result set and can be used in filters/orderings
inherited
-
withReferences([PrefetchHooks prefetch(PrefetchHooks prefetch())?])
→ ProcessedTableManager<_$CommonDatabase, $AccountsTable, AccountRow, $$AccountsTableFilterComposer, $$AccountsTableOrderingComposer, $$AccountsTableAnnotationComposer, $$AccountsTableCreateCompanionBuilder, $$AccountsTableUpdateCompanionBuilder, (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), (AccountRow, BaseReferences<_$CommonDatabase, $AccountsTable, AccountRow>), PrefetchHooks Function()>
-
This function with return a new manager which will return each item in the database with its references
inherited