TableQuery
Related Docs:
object TableQuery
| package lifted
Return a new query containing the elements from both operands.
Return a new query containing the elements from both operands. Duplicate elements are preserved.
Get the "raw" table row that represents the table itself, as opposed to a Path for a variable of the table's type.
Get the "raw" table row that represents the table itself, as opposed to a Path for a variable of the table's type. This method should generally not be called from user code.
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 Rep-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 queries with a cross join or inner join.
Join two queries with a cross join or inner join.
An optional join predicate can be specified later by calling on.
Join two queries with a full outer join.
Join two queries with a full outer join.
An optional join predicate can be specified later by calling on.
Both sides of the join are lifted to an Option. If at least one element on either side
matches the other side, all matching elements are returned as Some, otherwise a single
None row is returned.
Join two queries with a left outer join.
Join two queries with a left outer join.
An optional join predicate can be specified later by calling on.
The right side of the join is lifted to an Option. If at least one element on the right
matches, all matching elements are returned as Some, otherwise a single None row is
returned.
Join two queries with a right outer join.
Join two queries with a right outer join.
An optional join predicate can be specified later by calling on.
The left side of the join is lifted to an Option. If at least one element on the left
matches, all matching elements are returned as Some, otherwise a single None row is
returned.
The total number of elements (i.e.
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.
The total number of elements (i.e.
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).
Join two queries with a cross / inner join.
Join two queries with a cross / inner join.
An optional join predicate can be specified later by calling on.
(Since version 3.0) Use join instead of joinInner
Join two queries.
Join two queries.
An optional join predicate can be specified later by calling on.
(Since version 3.0) Use join (without explicit JoinType), joinLeft, joinRight or joinOuter instead
Join two queries with a left outer join.
Join two queries with a left outer join.
An optional join predicate can be specified later by calling on.
(Since version 3.0) Use joinLeft (with correct Option types) instead of leftJoin
Join two queries with a full outer join.
Join two queries with a full outer join.
An optional join predicate can be specified later by calling on.
(Since version 3.0) Use joinFull (with correct Option types) instead of outerJoin
Join two queries with a right outer join.
Join two queries with a right outer join.
An optional join predicate can be specified later by calling on.
(Since version 3.0) Use joinRight (with correct Option types) instead of rightJoin
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.
(Since version 2.1) Use filter instead of where
Represents a database table. Profiles add extension methods to TableQuery for operations that can be performed on tables but not on arbitrary queries, e.g. getting the table DDL.