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
-
aggregateWithGroupBy<T extends Table, D>({required List<String> groupByColumns, required Map<String, String> aggregations, Expression<bool>? filter, String? having})
→ Future<List<Map<String, Object?>>>
-
-
avg<T extends Table, D>(String columnName, {Expression<bool>? filter})
→ Future<double?>
-
-
batchDelete<T extends Table, D>(Expression<bool> filter(T))
→ Future<int>
-
-
batchInsert<T extends Table, D>(List<Insertable<D>> entities, {InsertMode mode = InsertMode.insertOrAbort, UpsertClause<T, D>? onConflict})
→ Future<List<int>>
-
-
batchUpdate<T extends Table, D>(List<Insertable<D>> entities)
→ Future<List<bool>>
-
-
closeDatabase()
→ Future<void>
-
-
count<T extends Table, D>({Expression<bool>? filter})
→ Future<int>
-
-
customInsert(String query, {List<Variable<Object>>? variables})
→ Future<int>
-
-
customSelect<T>(String query, {List<Variable<Object>>? variables})
→ Future<List<T>>
-
-
customStatement(String query, {List<Variable<Object>>? variables})
→ Future<void>
-
-
customUpdate(String query, {List<Variable<Object>>? variables})
→ Future<int>
-
-
delete<T extends Table, D>(Expression<bool> filter(T))
→ Future<int>
-
-
executeBatch(List<BatchOperation> operations)
→ Future<void>
-
-
getAll<T extends Table, D>()
→ Future<List<D>>
-
-
getFirstSorted<T extends Table, D>(List<OrderingTerm Function(T)> orderBy, {Expression<bool> filter(T)?})
→ Future<D?>
-
-
getFirstWhere<T extends Table, D>(List<Expression<bool>> conditions, {bool andLogic = true})
→ Future<D?>
-
-
getIn<T extends Table, D>(Expression<Object> column, List<Object?> values)
→ Future<List<D>>
-
-
getLike<T extends Table, D>(Expression<String> column, String pattern)
→ Future<List<D>>
-
-
getLimited<T extends Table, D>(int limit, {Expression<bool> filter(T)?, List<OrderClauseGenerator<T>>? orderBy})
→ Future<List<D>>
-
-
getPaged<T extends Table, D>({Expression<bool> filter(T)?, List<OrderClauseGenerator<T>>? orderBy, required int limit, required int offset})
→ Future<List<D>>
-
-
getSingle<T extends Table, D>(Expression<bool> filter(T))
→ Future<D?>
-
-
getWithComplexFilter<T extends Table, D>(List<Expression<bool>> filters, {bool andLogic = true})
→ Future<List<D>>
-
-
getWithSorting<T extends Table, D>(List<OrderingTerm Function(T)> orderBy, {Expression<bool> filter(T)?, int? limit, int? offset})
→ Future<List<D>>
-
-
insert<T extends Table, D>(Insertable<D> entity, {InsertMode mode = InsertMode.insertOrAbort, UpsertClause<T, D>? onConflict})
→ Future<int>
-
-
max<T extends Table, D>(String columnName, {Expression<bool>? filter})
→ Future<Object?>
-
-
min<T extends Table, D>(String columnName, {Expression<bool>? filter})
→ Future<Object?>
-
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
sum<T extends Table, D>(String columnName, {Expression<bool>? filter})
→ Future<double?>
-
-
toString()
→ String
-
A string representation of this object.
inherited
-
transaction<R>(Future<R> action())
→ Future<R>
-
-
update<T extends Table, D>(Insertable<D> entity)
→ Future<bool>
-
-
watchAll<T extends Table, D>()
→ Stream<List<D>>
-
-
watchFiltered<T extends Table, D>(Expression<bool> filter(T))
→ Stream<List<D>>
-
-
watchSingle<T extends Table, D>(Expression<bool> filter(T))
→ Stream<D?>
-
