Combine the constraints of this ForeignKeyQuery
with another one with the
same target table, leading to a single instance of the target table which
satisfies the constraints of both.
Return a new query containing the elements from both operands.
Return a new query containing the elements from both operands. Duplicate elements are preserved.
The number of distinct elements of the query.
The number of distinct elements of the query.
Select all elements except the first num
ones.
Select all elements except the first num
ones.
Select all elements except the first num
ones.
Select all elements except the first num
ones.
Select all elements except the first num
ones.
Select all elements except the first num
ones.
Encode a reference into this Rep
Test whether this query is non-empty.
Test whether this query is non-empty.
Select all elements of this query which satisfy a predicate.
Select all elements of this query which satisfy a predicate. Unlike
withFilter, this method only allows
Column-valued predicates, so it
guards against the accidental use use plain Booleans.
Build a new query by applying a function to all elements of this query and using the elements of the resulting queries.
Build a new query by applying a function to all elements of this query and using the elements of the resulting queries. This corresponds to an implicit inner join in SQL.
Partition this query into a query of pairs of a key and a nested query containing the elements for the key, according to some discriminator function.
Partition this query into a query of pairs of a key and a nested query containing the elements for the key, according to some discriminator function.
Join two collections with an inner join.
Join two collections with an inner join.
An optional join predicate can be specified later by calling on
.
Join two collections.
Join two collections.
An optional join predicate can be specified later by calling on
.
Join two collections with a left outer join.
Join two collections with a left outer join.
An optional join predicate can be specified later by calling on
.
The total number of elements (i.
The total number of elements (i.e. rows).
Build a new query by applying a function to all elements of this query.
Build a new query by applying a function to all elements of this query.
Join two collections with a full outer join.
Join two collections with a full outer join.
An optional join predicate can be specified later by calling on
.
Join two collections with a right outer join.
Join two collections with a right outer join.
An optional join predicate can be specified later by calling on
.
The total number of elements (i.
The total number of elements (i.e. rows).
Sort this query according to a function which extracts the ordering criteria from the query's elements.
Sort this query according to a function which extracts the ordering criteria from the query's elements.
Sort this query according to a the ordering of its elements.
Sort this query according to a the ordering of its elements.
Select the first num
elements.
Select the first num
elements.
Select the first num
elements.
Select the first num
elements.
Select the first num
elements.
Select the first num
elements.
Get the Node for this Rep
Get the Node for this Rep
Return a new query containing the elements from both operands.
Return a new query containing the elements from both operands. Duplicate elements are eliminated from the result.
Return a new query containing the elements from both operands.
Return a new query containing the elements from both operands. Duplicate elements are preserved.
Select all elements of this query which satisfy a predicate.
Select all elements of this query which satisfy a predicate. This method
is used when desugaring for-comprehensions over queries. There is no
reason to call it directly because it is the same as filter
.
Return a query formed from this query and another query by combining corresponding elements in pairs.
Return a query formed from this query and another query by combining corresponding elements in pairs.
Return a query formed from this query and another query by combining corresponding elements with the specified function.
Return a query formed from this query and another query by combining corresponding elements with the specified function.
Zip this query with its indices (starting at 0).
Zip this query with its indices (starting at 0).
(foreignKeyQuery: StringAdd).self
(foreignKeyQuery: StringFormat).self
Select all elements of this query which satisfy a predicate.
Select all elements of this query which satisfy a predicate. Unlike
withilter
, this method only allows Column
-valued predicates, so it
guards against the accidental use use plain Booleans.
(Since version 2.1) Use filter
instead of where
(foreignKeyQuery: ArrowAssoc[ForeignKeyQuery[E, U]]).x
(Since version 2.10.0) Use leftOfArrow
instead
(foreignKeyQuery: Ensuring[ForeignKeyQuery[E, U]]).x
(Since version 2.10.0) Use resultOfEnsuring
instead
A query that selects data linked by a foreign key.