SqliteJoinedQueryable<R> class

A joined queryable, produced by join_ or groupJoin_.

The join itself is done in Dart: the inner is materialized once and indexed by key, the outer is fetched via SQL and the matching pairs (or groups) are evaluated. The result is a flat sequence (for join_) or one element per outer (for groupJoin_, with empty inner list for no match).

Inheritance
Available extensions

Properties

expression → Expr?
The expression that produced this queryable, or null for a raw source (e.g. users.asQueryable with no operator applied).
no setteroverride
first → R
The first element.
no setterinherited
firstOrNull → T?

Available on Iterable<T>, provided by the IterableExtensions extension

The first element of this iterator, or null if the iterable is empty.
no setter
hashCode → int
The hash code for this object.
no setterinherited
indexed → Iterable<(int, T)>

Available on Iterable<T>, provided by the IterableExtensions extension

Pairs of elements of the indices and elements of this iterable.
no setter
isEmpty → bool
Whether this collection has no elements.
no setterinherited
isNotEmpty → bool
Whether this collection has at least one element.
no setterinherited
iterator → Iterator<R>
A new Iterator that allows iterating the elements of this Iterable.
no setteroverride
last → R
The last element.
no setterinherited
lastOrNull → T?

Available on Iterable<T>, provided by the IterableExtensions extension

The last element of this iterable, or null if the iterable is empty.
no setter
length → int
The number of elements in this Iterable.
no setterinherited
nonNulls → Iterable<T>

Available on Iterable<T?>, provided by the NullableIterableExtensions extension

The non-null elements of this iterable.
no setter
provider → IQueryProvider
The provider that owns this queryable.
no setteroverride
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
single → R
Checks that this iterable has only one element, and returns that element.
no setterinherited
singleOrNull → T?

Available on Iterable<T>, provided by the IterableExtensions extension

The single element of this iterator, or null.
no setter
toJSIterable → JSIterable<T>

Available on Iterable<T>, provided by the IterableToJSIterable extension

A JSIterable wrapper that proxies to the Dart iterable API.
no setter
wait → Future<List<T>>

Available on Iterable<Future<T>>, provided by the FutureIterable extension

Waits for futures in parallel.
no setter

Methods

aggregate_<TResult>({required TResult seed, required Expr func}) → TResult

Available on IQueryable<T>, provided by the AggregatesOp extension

Applies an accumulator function over the source.
all_(Expr predicate) → bool

Available on IQueryable<T>, provided by the QuantifiersOp extension

Returns true if all elements satisfy predicate. Vacuously true for an empty source.
any(bool test(R element)) → bool
Checks whether any element of this iterable satisfies test.
inherited
any_({Expr? where}) → bool

Available on IQueryable<T>, provided by the QuantifiersOp extension

Returns true if the source has at least one element, or if at least one element satisfies the optional where predicate.
asEnumerable_() → Iterable<T>

Available on IQueryable<T>, provided by the ConversionsOp extension

Returns the queryable as a plain Iterable<T>. Useful at the boundary between LINQ code and dart:core collection APIs.
asNameMap() → Map<String, T>

Available on Iterable<T>, provided by the EnumByName extension

Creates a map from the names of enum values to the values.
asQueryable() → IQueryable<T>

Available on Iterable<T>, provided by the ToQueryableExtension extension

Returns an IQueryable view over this Iterable. The conversion is cheap — no elements are iterated until you call a terminal operator (e.g. toList, forEach, first).
average_(Expr selector) → double

Available on IQueryable<T>, provided by the AggregatesOp extension

Returns the arithmetic mean of the values produced by the selector LambdaExpr. Throws StateError on an empty source.
byName(String name) → T

Available on Iterable<T>, provided by the EnumByName extension

Finds the enum value in this list with name name.
cast<R>() → Iterable<R>
A view of this iterable as an iterable of R instances.
inherited
cast_<TResult>() → IQueryable<TResult>

Available on IQueryable<T>, provided by the ConversionsOp extension

Casts each element of the source to TResult. Returns an IQueryable<TResult> whose elements are the cast results.
concat_(IQueryable<T> other) → IQueryable<T>

Available on IQueryable<T>, provided by the ConcatOp extension

Concatenates this queryable with other.
contains(Object? element) → bool
Whether the collection contains an element equal to element.
inherited
contains_(T value) → bool

Available on IQueryable<T>, provided by the QuantifiersOp extension

Returns true if value is an element of the source, compared with == (and hashCode).
count_() → int
Returns the number of elements yielded by the join.
count_({Expr? where}) → int

Available on IQueryable<T>, provided by the AggregatesOp extension

Returns the number of elements in the source. If where is provided, only elements matching the predicate are counted.
distinct_() → IQueryable<T>

Available on IQueryable<T>, provided by the DistinctOp extension

Returns the elements of the source with duplicates removed.
elementAt(int index) → R
Returns the indexth element.
inherited
elementAt_(int index) → T

Available on IQueryable<T>, provided by the ElementOp extension

Returns the element at index. Throws RangeError on out-of-range indices.
elementAtOrDefault_(int index) → T?

Available on IQueryable<T>, provided by the ElementOp extension

Returns the element at index or null if the index is out-of-range.
elementAtOrNull(int index) → T?

Available on Iterable<T>, provided by the IterableExtensions extension

The element at position index of this iterable, or null.
every(bool test(R element)) → bool
Checks whether every element of this iterable satisfies test.
inherited
except_(IQueryable<T> other) → IQueryable<T>

Available on IQueryable<T>, provided by the SetOps extension

Returns the set difference: elements in this queryable that are not in other.
expand<T>(Iterable<T> toElements(R element)) → Iterable<T>
Expands each element of this Iterable into zero or more elements.
inherited
first_({Expr? where}) → T

Available on IQueryable<T>, provided by the ElementOp extension

Returns the first element of the source, or the first element matching the optional where predicate.
firstOrDefault_({Expr? where}) → T?

Available on IQueryable<T>, provided by the ElementOp extension

Returns the first element of the source, or null if the source is empty (or no element matches the optional where predicate).
firstWhere(bool test(R element), {R orElse()?}) → R
The first element that satisfies the given predicate test.
inherited
fold<T>(T initialValue, T combine(T previousValue, R element)) → T
Reduces a collection to a single value by iteratively combining each element of the collection with an existing value
inherited
followedBy(Iterable<R> other) → Iterable<R>
Creates the lazy concatenation of this iterable and other.
inherited
forEach(void action(R element)) → void
Invokes action on each element of this iterable in iteration order.
inherited
groupBy_<TKey>({required Expr keySelector}) → IQueryable<IGrouping<TKey, T>>

Available on IQueryable<T>, provided by the GroupByOp extension

Groups elements by the value produced by keySelector.
groupJoin_<TInner, TKey, TResult>({required IQueryable<TInner> inner, required Expr outerKeySelector, required Expr innerKeySelector, required Expr resultSelector}) → IQueryable<TResult>

Available on IQueryable<TOuter>, provided by the JoinOp extension

LEFT OUTER JOIN: each outer element is paired with a list of matching inner elements (the list is empty if no match).
intersect_(IQueryable<T> other) → IQueryable<T>

Available on IQueryable<T>, provided by the SetOps extension

Returns the set intersection of this queryable and other.
join([String separator = ""]) → String
Converts each element to a String and concatenates the strings.
inherited
join_<TInner, TKey, TResult>({required IQueryable<TInner> inner, required Expr outerKeySelector, required Expr innerKeySelector, required Expr resultSelector}) → IQueryable<TResult>

Available on IQueryable<TOuter>, provided by the JoinOp extension

INNER JOIN: pairs each element of this with elements of inner whose key matches the outer element's key.
lastWhere(bool test(R element), {R orElse()?}) → R
The last element that satisfies the given predicate test.
inherited
longCount_({Expr? where}) → int

Available on IQueryable<T>, provided by the AggregatesOp extension

Same as count_ but kept for API parity with C# LINQ. On the Dart VM int is 64-bit on native, so there is no overflow risk in practice; this method exists for naming consistency.
map<T>(T toElement(R e)) → Iterable<T>
The current elements of this iterable modified by toElement.
inherited
max_(Expr selector) → Object?

Available on IQueryable<T>, provided by the AggregatesOp extension

Returns the largest value produced by the selector LambdaExpr. Throws StateError on an empty source.
min_(Expr selector) → Object?

Available on IQueryable<T>, provided by the AggregatesOp extension

Returns the smallest value produced by the selector LambdaExpr. Throws StateError on an empty source.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
ofType_<TResult>() → IQueryable<TResult>

Available on IQueryable<T>, provided by the OfTypeOp extension

Returns the elements whose runtime type is a subtype of TResult.
orderBy_(Expr keySelector) → IQueryable<T>

Available on IQueryable<T>, provided by the OrderByOp extension

Sorts the elements in ascending order of the values produced by keySelector.
orderByDescending_(Expr keySelector) → IQueryable<T>

Available on IQueryable<T>, provided by the OrderByOp extension

Sorts the elements in descending order of the values produced by keySelector.
reduce(R combine(R value, R element)) → R
Reduces a collection to a single value by iteratively combining elements of the collection using the provided function.
inherited
select_<TResult>(Expr selector) → IQueryable<TResult>

Available on IQueryable<T>, provided by the SelectOp extension

Projects each element into a new form.
selectMany_<TCollection, TResult>(Expr collectionSelector, {Expr? resultSelector}) → IQueryable<TResult>

Available on IQueryable<T>, provided by the SelectManyOp extension

Projects each element into a collection and flattens the result.
single_({Expr? where}) → T

Available on IQueryable<T>, provided by the ElementOp extension

Returns the only element of the source (or the only one matching the optional where predicate).
singleOrDefault_({Expr? where}) → T?

Available on IQueryable<T>, provided by the ElementOp extension

Returns the only element of the source, or null if there are zero matching elements. Throws StateError if there is more than one matching element.
singleWhere(bool test(R element), {R orElse()?}) → R
The single element that satisfies test.
inherited
skip(int count) → Iterable<R>
Creates an Iterable that provides all but the first count elements.
inherited
skip_(int count) → IQueryable<T>

Available on IQueryable<T>, provided by the SkipOp extension

Returns a queryable that skips the first count elements.
skipWhile(bool test(R element)) → Iterable<R>
Creates an Iterable that skips leading elements while test is satisfied.
inherited
skipWhile_(Expr predicate) → IQueryable<T>

Available on IQueryable<T>, provided by the SkipWhileOp extension

Skips the prefix of the source where predicate is true.
sum_(Expr selector) → num

Available on IQueryable<T>, provided by the AggregatesOp extension

Returns the sum of the values produced by the selector LambdaExpr. The values must be num (int or double).
take(int count) → Iterable<R>
Creates a lazy iterable of the count first elements of this iterable.
inherited
take_(int count) → IQueryable<T>

Available on IQueryable<T>, provided by the TakeOp extension

Returns a queryable containing at most the first count elements.
takeWhile(bool test(R element)) → Iterable<R>
Creates a lazy iterable of the leading elements satisfying test.
inherited
takeWhile_(Expr predicate) → IQueryable<T>

Available on IQueryable<T>, provided by the TakeWhileOp extension

Returns the prefix of the source where predicate is true.
thenBy_(Expr keySelector) → IQueryable<T>

Available on IQueryable<T>, provided by the ThenByOp extension

Adds a secondary ascending sort to the ordering.
thenByDescending_(Expr keySelector) → IQueryable<T>

Available on IQueryable<T>, provided by the ThenByOp extension

Adds a secondary descending sort to the ordering.
toList({bool growable = true}) → List<R>
Creates a List containing the elements of this Iterable.
inherited
toList_() → List<T>

Available on IQueryable<T>, provided by the ConversionsOp extension

Materializes the queryable into a List<T>.
toList_() → List<R>
Materializes the joined sequence.
toLookup_<TKey>({required Expr keySelector}) → ILookup<TKey, T>

Available on Iterable<T>, provided by the InMemoryLookupOp extension

: groups the source by keySelector. The result is iterable: iterate to get IGrouping<TKey, T> entries (one per key).
toMap_<TKey>({required Expr keySelector}) → Map<TKey, T>

Available on IQueryable<T>, provided by the ConversionsOp extension

Materializes the queryable into a Map<TKey, T> using the keySelector to extract the key for each element.
toSet() → Set<R>
Creates a Set containing the same elements as this iterable.
inherited
toSet_() → Set<T>

Available on IQueryable<T>, provided by the ConversionsOp extension

Materializes the queryable into a Set<T>.
toString() → String
Returns a string representation of (some of) the elements of this.
inherited
union_(IQueryable<T> other) → IQueryable<T>

Available on IQueryable<T>, provided by the SetOps extension

Returns the set union of this queryable and other.
where(bool test(R element)) → Iterable<R>
Creates a new lazy Iterable with all elements that satisfy the predicate test.
inherited
where_(Expr predicate) → IQueryable<T>

Available on IQueryable<T>, provided by the WhereOp extension

Filters the queryable to elements for which predicate returns true. The predicate must be a single-parameter LambdaExpr.
whereType<T>() → Iterable<R>
Creates a new lazy Iterable with all elements that have type T.
inherited

Operators

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