QueryBuilderImpl class
- Inheritance
-
- Object
- QueryBuilder
- QueryBuilderImpl
- Implemented types
- Implementers
Constructors
Properties
-
bindings
→ Map<
String, dynamic> -
finalinherited
-
conditions
→ List<
String> -
finalinherited
- conn ↔ DatabaseConnection
-
getter/setter pairinherited
- connectionName ↔ String
-
getter/setter pairoverride-getter
- cteConfiguration → CteConfiguration
-
no setterinherited
- cteCount → int
-
no setterinherited
-
cteNames
→ List<
String> -
no setterinherited
- currentParamCounter → int
-
Returns the current parameter counter value.
Useful for synchronizing nested queries.
no setterinherited
- dbConnection → DatabaseConnection?
-
no setterinherited
- getTable → String
-
no setteroverride
- hasCtes → bool
-
no setterinherited
- hashCode → int
-
The hash code for this object.
no setterinherited
-
joins
↔ List<
String> -
getter/setter pairinherited
- paramCounter ← int
-
no getterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
-
selectColumns
↔ List<
String> -
getter/setter pairinherited
-
unions
↔ List<
String> -
getter/setter pairinherited
Methods
-
addSelect(
List< String> columns) → QueryBuilder -
inherited
-
alerts(
) → Stream< DatabaseAlert> -
override
-
avg(
String column) → Future< num> -
inherited
-
batchProcess(
{required int batchSize, required Future< void> processor(List<Map< batch, int batchNumber), List<String, dynamic> >String> columns = const ['*']}) → Future<void> -
inherited
-
build(
{String? aggregateFunction, String? aggregateColumn}) → String -
override
-
buildJoins(
) → String -
inherited
-
buildWhereClause(
) → String -
inherited
-
buildWithClause(
) → String -
inherited
-
bulkDelete(
{String? column, List? values, int batchSize = 1000}) → Future< bool> -
inherited
-
bulkDeleteWhere(
List< Map< conditions, {int batchSize = 500}) → Future<String, dynamic> >bool> -
inherited
-
bulkInsert(
List< Map< data, {ConflictAction conflictAction = ConflictAction.ignore, List<String, dynamic> >String> ? conflictColumns, List<String> ? updateColumns, int batchSize = 1000, bool returnIds = false}) → Future<bool> -
inherited
-
bulkUpdate(
List< Map< updates, {required String matchColumn, List<String, dynamic> >String> ? updateColumns, int batchSize = 500, Map<String, dynamic> ? additionalValues}) → Future<bool> -
inherited
-
chunk(
int chunk, void callback(List< Map< data)) → Future<String, dynamic> >void> -
inherited
-
chunkById(
int chunk, void callback(List< Map< data), [String column = 'id']) → Future<String, dynamic> >void> -
inherited
-
chunkedProcess(
{required int chunkSize, required Future< List< processor(List<Map< >String, dynamic> >Map< chunk), String? destination, List<String, dynamic> >String> columns = const ['*']}) → Future<void> -
inherited
-
clearBulkOperations(
) → void -
inherited
-
clearCtes(
) → void -
inherited
-
clearWindowFunctions(
) → void -
inherited
-
collection(
String name) → QueryBuilder -
Alias for table. Some drivers (document stores) prefer the
"collection" spelling; both names route to the same underlying
state on every driver.
inherited
-
configureCte(
CteConfiguration config) → void -
inherited
-
connection(
[String? connection]) → QueryBuilder -
override
-
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, Map< String, dynamic> extra = const {}]) → 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> q)) → 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 = const []]) → 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 -
inherited
-
get(
[List< String> columns = const []]) → Future<List< Map< >String, dynamic> > -
inherited
-
getBindings(
) → Map< String, dynamic> -
override
-
getCacheStats(
) → Map< String, dynamic> -
inherited
-
getConnection(
) → Future< DatabaseConnection> -
inherited
-
getCteBindings(
) → Map< String, dynamic> -
inherited
-
getCteInfo(
) → List< Map< String, dynamic> > -
inherited
-
getPerformanceStats(
) → Map< String, PerformanceStats> -
override
-
groupBy(
List< String> groups) → QueryBuilder -
override
-
groupByRaw(
String expression) → QueryBuilder -
Emits
expressioninto GROUP BY verbatim.override -
hasCte(
String name) → bool -
inherited
-
having(
String column, [String? operator, dynamic value, String boolean = 'and']) → QueryBuilder -
override
-
havingBetween(
String column, List values, {String boolean = 'and', bool not = false}) → QueryBuilder -
override
-
increment(
String column, [int amount = 1, Map< String, dynamic> extra = const {}]) → Future<bool> -
inherited
-
incrementEach(
Map< String, int> increments, [Map<String, dynamic> extra = const {}]) → Future<bool> -
inherited
-
inRandomOrder(
[dynamic seed]) → QueryBuilder -
override
-
insert(
Map< String, dynamic> values) → Future<bool> -
inherited
-
insertGetId(
Map< String, dynamic> values, [String? sequence]) → Future -
inherited
-
insertMany(
List< Map< valuesList) → Future<String, dynamic> >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 -
override
-
lazy(
[int chunk = 100, String column = 'id']) → 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 firstColumn, [String? operator, String? secondColumn]) → QueryBuilder -
inherited
-
limit(
int value) → QueryBuilder -
override
-
max(
String column) → Future -
inherited
-
merge(
List< Map< sourceData, {required List<String, dynamic> >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 -
override
-
orderBy(
String column, [String direction = 'ASC']) → QueryBuilder -
override
-
orderByAsc(
String column) → QueryBuilder -
override
-
orderByDesc(
String column) → QueryBuilder -
override
-
orderByRaw(
String expression) → QueryBuilder -
Emits
expressioninto ORDER BY verbatim.override -
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, dynamic 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 rawBindings = 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< data, {int parallelism = 2, int batchSize = 1000, ConflictAction conflictAction = ConflictAction.ignore, List<String, dynamic> >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 -
override
-
removeCte(
String name) → bool -
inherited
-
reorder(
[String? column, String? direction]) → QueryBuilder -
override
-
resetCteState(
) → void -
Hook for QueryBuilder.resetQuery. Leaves the configuration and
escaping strategy alone — those describe the dialect, not the query.
inherited
-
resetQuery(
) → void -
Drops every clause accumulated so far, leaving the table, alias and
connection in place so the builder can be reused for a fresh query.
override
-
resetWindowState(
) → void -
Hook for QueryBuilder.resetQuery; the list is private to this
library, so the reset has to be driven from here.
inherited
-
rightJoin(
String table, String firstColumn, [String? operator, String? secondColumn]) → QueryBuilder -
inherited
-
rowNumber(
{String? partitionBy, String? orderBy, String? as}) → QueryBuilder -
inherited
-
select(
[List< String> columns = const ['*']]) → QueryBuilder -
inherited
-
selectRaw(
String query, [List bindings = const []]) → QueryBuilder -
inherited
-
selectSub(
QueryBuilder subQuery, String as) → QueryBuilder -
inherited
-
simplePaginate(
[int perPage = 15, List< String> columns = const [], String? pageName, int? page]) → Future<Map< String, dynamic> > -
inherited
-
skip(
int value) → QueryBuilder -
override
-
sum(
String column) → Future< num> -
inherited
-
table(
String table, [String? as]) → QueryBuilder -
override
-
take(
int value) → QueryBuilder -
override
-
toRawSql(
) → String -
override
-
toSql(
) → String -
override
-
toString(
) → String -
A string representation of this object.
inherited
-
transaction(
Future< bool> action(), [String? conditionName]) → Future<bool> -
override
-
transactionalBulkOperation(
Future< bool> action()) → 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< updates, String column) → Future<String, dynamic> >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
-
validateAllCtes(
) → void -
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, dynamic 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 rawBindings = 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< ? columnsMap}) → QueryBuilderString> > -
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
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited