- Implemented types
-
- Implementers
Methods
-
addSelect(List<String> columns)
→ QueryBuilder
-
inherited
-
alerts()
→ Stream<DatabaseAlert>
-
-
avg(String column)
→ Future<num>
-
inherited
-
batchProcess({required int batchSize, required Future<void> processor(List<Map<String, dynamic>> batch, int batchNumber), List<String> columns = const ['*']})
→ Future<void>
-
inherited
-
build({String? aggregateFunction, String? aggregateColumn})
→ String
-
-
buildJoins()
→ String
-
-
buildWhereClause()
→ String
-
-
bulkDelete({String? column, List? values, int batchSize = 1000})
→ Future<bool>
-
inherited
-
bulkDeleteWhere(List<Map<String, dynamic>> conditions, {int batchSize = 500})
→ Future<bool>
-
inherited
-
bulkInsert(List<Map<String, dynamic>> data, {ConflictAction conflictAction = ConflictAction.ignore, List<String>? conflictColumns, List<String>? updateColumns, int batchSize = 1000, bool returnIds = false})
→ Future<bool>
-
inherited
-
bulkUpdate(List<Map<String, dynamic>> updates, {required String matchColumn, List<String>? updateColumns, int batchSize = 500, Map<String, dynamic>? additionalValues})
→ Future<bool>
-
inherited
-
chunk(int chunk, void callback(List<Map<String, dynamic>> data))
→ Future<void>
-
inherited
-
chunkById(int chunk, void callback(List<Map<String, dynamic>> data), [String column])
→ Future<void>
-
inherited
-
chunkedProcess({required int chunkSize, required Future<List<Map<String, dynamic>>> processor(List<Map<String, dynamic>> chunk), String? destination, List<String> columns = const ['*']})
→ Future<void>
-
inherited
-
connection([String? connection])
→ QueryBuilder
-
-
count([String columns = '*'])
→ Future<int>
-
inherited
-
crossJoin(String table, [List bindings = const []])
→ QueryBuilder
-
inherited
-
cumeDist({String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
cursor([int chunk = 1000])
→ Stream<Map<String, dynamic>>
-
inherited
-
decrement(String column, [int amount = 1, ])
→ Future<bool>
-
inherited
-
delete()
→ Future<bool>
-
inherited
-
denseRank({String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
doesntExist()
→ Future<bool>
-
inherited
-
each(void callback(Map<String, dynamic>))
→ Future<void>
-
inherited
-
exists()
→ Future<bool>
-
inherited
-
find(dynamic id, {String byColumnName = 'id', List<String> columns = const ['*']})
→ Future<Map<String, dynamic>?>
-
inherited
-
findOrFail(dynamic id, {String byColumnName = 'id', List<String> columns = const ['*']})
→ Future<Map<String, dynamic>?>
-
inherited
-
first([List<String> columns])
→ Future<Map<String, dynamic>?>
-
inherited
-
firstOrFail([List<String> columns = const ['*']])
→ Future<Map<String, dynamic>?>
-
inherited
-
firstValue(String column, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
firstWhere(String column, [String? operator, dynamic value, List<String> columns = const ['*']])
→ Future<Map<String, dynamic>?>
-
inherited
-
formatValue(dynamic value)
→ String
-
-
get([List<String> columns])
→ Future<List<Map<String, dynamic>>>
-
inherited
-
getBindings()
→ Map<String, dynamic>
-
-
getConnection()
→ Future<DatabaseConnection>
-
-
getPerformanceStats()
→ Map<String, PerformanceStats>
-
-
groupBy(List<String> groups)
→ QueryBuilder
-
-
having(String column, [String? operator, dynamic value, String boolean = 'and'])
→ QueryBuilder
-
-
havingBetween(String column, List values, {String boolean = 'and', bool not = false})
→ QueryBuilder
-
-
increment(String column, [int amount = 1, ])
→ Future<bool>
-
inherited
-
incrementEach(Map<String, int> increments, [])
→ Future<bool>
-
inherited
-
inRandomOrder([dynamic seed])
→ QueryBuilder
-
-
insert(Map<String, dynamic> values)
→ Future<bool>
-
inherited
-
insertGetId(Map<String, dynamic> values, [String? sequence])
→ Future
-
inherited
-
insertMany(List<Map<String, dynamic>> values)
→ Future<bool>
-
inherited
-
insertOrIgnore(Map<String, dynamic> values)
→ Future<bool>
-
inherited
-
insertUsing(List<String> columns, QueryBuilder subQuery)
→ Future<bool>
-
inherited
-
join(String table, String firstColumn, [String? operator, String? secondColumn, String type = 'inner', bool where = false])
→ QueryBuilder
-
inherited
-
joinSub(QueryBuilder subQuery, String as, String firstColumn, [String? operator, String? secondColumn, String type = 'inner'])
→ QueryBuilder
-
inherited
-
lag(String column, {int offset = 1, dynamic defaultValue, String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
lastValue(String column, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
latest([String column = 'created_at'])
→ QueryBuilder
-
-
lazy([int chunk = 1000, String column])
→ Stream<Iterable<Map<String, dynamic>>>
-
inherited
-
lead(String column, {int offset = 1, dynamic defaultValue, String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
leftJoin(String table, String firstColumn, [String? operator, String? secondColumn, bool where = false])
→ QueryBuilder
-
inherited
-
leftJoinSub(QueryBuilder subQuery, String as, String firColumnst, [String? operator, String? secondColumn])
→ QueryBuilder
-
inherited
-
limit(int value)
→ QueryBuilder
-
-
max(String column)
→ Future
-
inherited
-
merge(List<Map<String, dynamic>> sourceData, {required List<String> matchOn, ConflictAction whenMatched = ConflictAction.update, ConflictAction whenNotMatched = ConflictAction.ignore, ConflictAction? whenNotMatchedBySource, List<String>? updateColumns, List<String>? insertColumns, Map<String, dynamic>? additionalValues})
→ Future<bool>
-
inherited
-
min(String column)
→ Future
-
inherited
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
ntile(int buckets, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
offset(int value)
→ QueryBuilder
-
-
orderBy(String column, [String direction = 'ASC'])
→ QueryBuilder
-
-
orderByAsc(String column)
→ QueryBuilder
-
-
orderByDesc(String column)
→ QueryBuilder
-
-
orWhere(dynamic condition, [String operator = '=', dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
orWhereBetween(String column, List values, {bool not = false})
→ QueryBuilder
-
inherited
-
orWhereColumn(String first, String operator, String secondColumn)
→ QueryBuilder
-
inherited
-
orWhereDate(String column, String operator, dynamic value)
→ QueryBuilder
-
inherited
-
orWhereDay(String column, String operator, dynamic value)
→ QueryBuilder
-
inherited
-
orWhereDoesntHave(String relation, QueryCallback callback)
→ QueryBuilder
-
inherited
-
orWhereExists(QueryCallback callback, {bool not = false})
→ QueryBuilder
-
inherited
-
orWhereFullText(dynamic columns, dynamic query, [Map<String, dynamic> options = const {}])
→ QueryBuilder
-
inherited
-
orWhereHas(String relation, QueryCallback callback)
→ QueryBuilder
-
inherited
-
orWhereHour(String column, String operator, dynamic value)
→ QueryBuilder
-
inherited
-
orWhereIn(String column, List values, {bool not = false})
→ QueryBuilder
-
inherited
-
orWhereJsonContains(String column, dynamic value, {bool not = false})
→ QueryBuilder
-
inherited
-
orWhereJsonDoesntContain(String column, dynamic value)
→ QueryBuilder
-
inherited
-
orWhereJsonLength(String column, String operator, dynamic value)
→ QueryBuilder
-
inherited
-
orWhereLike(String column, dynamic value, {bool caseSensitive = false})
→ QueryBuilder
-
inherited
-
orWhereMonth(String column, String operator, dynamic value)
→ QueryBuilder
-
inherited
-
orWhereNotBetween(String column, List values)
→ QueryBuilder
-
inherited
-
orWhereNotExists(QueryCallback callback)
→ QueryBuilder
-
inherited
-
orWhereNotIn(String column, List values)
→ QueryBuilder
-
inherited
-
orWhereNotLike(String column, dynamic value, {bool caseSensitive = false, String boolean = 'and'})
→ QueryBuilder
-
inherited
-
orWhereNotNull(String column)
→ QueryBuilder
-
inherited
-
orWhereNull(String column)
→ QueryBuilder
-
inherited
-
orWhereRaw(String sql, [List bindings = const []])
→ QueryBuilder
-
inherited
-
orWhereRowValues(List<String> columns, String operator, List values)
→ QueryBuilder
-
inherited
-
orWhereTime(String column, String operator, dynamic value)
→ QueryBuilder
-
inherited
-
orWhereYear(String column, String operator, dynamic value)
→ QueryBuilder
-
inherited
-
paginate({int perPage = 15, List<String> columns = const ['*'], String? pageName, int? page})
→ Future<Map<String, dynamic>>
-
inherited
-
parallelBulkInsert(List<Map<String, dynamic>> data, {int parallelism = 2, int batchSize = 1000, ConflictAction conflictAction = ConflictAction.ignore, List<String>? conflictColumns})
→ Future<bool>
-
inherited
-
percentRank({String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
pluck(String column, [String? key])
→ Future
-
inherited
-
rank({String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
raw(String value)
→ RawExpression
-
-
reorder([String? column, String? direction])
→ QueryBuilder
-
-
rightJoin(String table, String firstColumn, [String? operator, String? secondColumn])
→ QueryBuilder
-
inherited
-
rowNumber({String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
select([List<String> columns])
→ QueryBuilder
-
inherited
-
selectRaw(String query, [List bindings = const []])
→ QueryBuilder
-
inherited
-
selectSub(QueryBuilder subQuery, String as)
→ QueryBuilder
-
inherited
-
simplePaginate([int perPage, List<String> columns, String pageName, int? page])
→ Future<Map<String, dynamic>>
-
inherited
-
skip(int value)
→ QueryBuilder
-
-
sum(String column)
→ Future<num>
-
inherited
-
table(String table, [String? as])
→ QueryBuilder
-
-
take(int value)
→ QueryBuilder
-
-
toRawSql()
→ String
-
-
toSql()
→ String
-
-
toString()
→ String
-
A string representation of this object.
inherited
-
transaction(Future<bool> action(), [String? conditionName])
→ Future<bool>
-
-
transactionalBulkOperation(Future<bool> operations())
→ Future<bool>
-
inherited
-
truncate({bool force = false})
→ Future<bool>
-
inherited
-
union(QueryBuilder query)
→ QueryBuilder
-
inherited
-
unionAll(QueryBuilder query)
→ QueryBuilder
-
inherited
-
update(Map<String, dynamic> values)
→ Future<bool>
-
inherited
-
updateMany(List<Map<String, dynamic>> updates, String column)
→ Future<bool>
-
inherited
-
updateOrInsert(Map<String, dynamic> search, Map<String, dynamic> update)
→ Future<bool>
-
inherited
-
upsert(Map<String, dynamic> values, List<String> uniqueBy, [Map<String, dynamic>? update])
→ Future<bool>
-
inherited
-
value(String column)
→ Future
-
inherited
-
where(dynamic condition, [String operator = '=', dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereAfterToday(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereAll(String column, List values, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereAny(String column, List values, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereBeforeToday(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereBetween(String column, List values, {String boolean = 'and', bool not = false})
→ QueryBuilder
-
inherited
-
whereBetweenColumns(String column, List<String> columns, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereColumn(String firstColumn, String operator, String secondColumn, [String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereDate(String column, String operator, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereDay(String column, String operator, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereDoesntHave(String relation, QueryCallback callback, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereEqualTo(dynamic condition, [dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereExists(QueryCallback callback, {String boolean = 'and', bool not = false})
→ QueryBuilder
-
inherited
-
whereFullText(dynamic columns, dynamic query, [Map<String, dynamic> options = const {}])
→ QueryBuilder
-
inherited
-
whereFuture(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereGreaterThan(dynamic condition, [dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereGreaterThanOrEqualTo(dynamic condition, [dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereHas(String relation, QueryCallback callback, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereHour(String column, String operator, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereIn(String column, List values, {String boolean = 'and', bool not = false})
→ QueryBuilder
-
inherited
-
whereJsonContains(String column, dynamic value, {String boolean = 'and', bool not = false})
→ QueryBuilder
-
inherited
-
whereJsonDoesntContain(String column, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereJsonLength(String column, String operator, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereLessThan(dynamic condition, [dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereLessThanOrEqualTo(dynamic condition, [dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereLike(String column, dynamic value, {bool caseSensitive = false, String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereMonth(String column, String operator, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNone(String column, List values, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNotBetween(String column, List values, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNotBetweenColumns(String column, List<String> columns, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNotEqualTo(dynamic condition, [dynamic value, String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereNotExists(QueryCallback callback, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNotIn(String column, List values, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNotLike(String column, dynamic value, {bool caseSensitive = false, String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNotNull(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNowOrFuture(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNowOrPast(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereNull(String column, {String boolean = 'and', bool not = false})
→ QueryBuilder
-
inherited
-
wherePast(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereRaw(String sql, [List bindings = const [], String boolean = 'and'])
→ QueryBuilder
-
inherited
-
whereRowValues(List<String> columns, String operator, List values, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereTime(String column, String operator, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereToday(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereTodayOrAfter(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereTodayOrBefore(String column, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
whereYear(String column, String operator, dynamic value, {String boolean = 'and'})
→ QueryBuilder
-
inherited
-
windowAvg(String column, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
windowCount(String column, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
windowMax(String column, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
windowMin(String column, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
windowSum(String column, {String? partitionBy, String? orderBy, String? as})
→ QueryBuilder
-
inherited
-
withCte(String name, QueryBuilder subQuery, {List<String>? columns})
→ QueryBuilder
-
inherited
-
withMaterialized(String name, QueryBuilder subQuery, {List<String>? columns})
→ QueryBuilder
-
inherited
-
withMultiple(Map<String, QueryBuilder> ctes, {Map<String, List<String>>? columnsMap})
→ QueryBuilder
-
inherited
-
withNotMaterialized(String name, QueryBuilder subQuery, {List<String>? columns})
→ QueryBuilder
-
inherited
-
withRecursive(String name, QueryBuilder baseCase, QueryBuilder recursiveCase, {List<String>? columns})
→ QueryBuilder
-
inherited
-
withSoftDeletes([String column = 'deleted_at'])
→ QueryBuilder
-
inherited
