case class Select[A, R <: Relation](cols: A, from: R, where: Option[Column[Boolean]] = None, startWith: Option[Column[Boolean]] = None, connectBy: Option[Column[Boolean]] = None, groupBy: List[Group] = Nil, having: Option[Column[Boolean]] = None, orderBy: List[Order] = Nil, limit: Option[Long] = None, offset: Option[Long] = None, optimize: Option[Long] = None, union: List[Union[_]] = Nil, subselectAlias: Option[String] = None)(implicit aliasedColumns: AliasedColumns[A]) extends Relation with Query with ColumnSyntax with Product with Serializable
A select statement or subselect.
- Alphabetic
- By Inheritance
- Select
- Serializable
- Serializable
- Product
- Equals
- ColumnSyntax
- Query
- Operation
- Relation
- AnyRef
- Any
- Hide All
- Show All
- Public
- All
Instance Constructors
- new Select(cols: A, from: R, where: Option[Column[Boolean]] = None, startWith: Option[Column[Boolean]] = None, connectBy: Option[Column[Boolean]] = None, groupBy: List[Group] = Nil, having: Option[Column[Boolean]] = None, orderBy: List[Order] = Nil, limit: Option[Long] = None, offset: Option[Long] = None, optimize: Option[Long] = None, union: List[Union[_]] = Nil, subselectAlias: Option[String] = None)(implicit aliasedColumns: AliasedColumns[A])
Type Members
-
implicit
class
AliasColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
AliasedOptionColumnsOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
BooleanColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
ComparisonColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
ConstantColumnOps
[A] extends AnyRef
This enrichment allows writing 1.constant or "abc".constant, which will directly embed the constant value into the generated sql statement.
This enrichment allows writing 1.constant or "abc".constant, which will directly embed the constant value into the generated sql statement. Do not use this on user input as you will enable SQL injection attacks
- Definition Classes
- ColumnSyntax
-
implicit
class
IntColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
LiteralColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
NullableColumnsOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
SomeConstantColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
SomeLiteralColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
-
implicit
class
StringColumnOps
[A] extends AnyRef
- Definition Classes
- ColumnSyntax
Value Members
-
final
def
!=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
final
def
##(): Int
- Definition Classes
- AnyRef → Any
-
final
def
==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
implicit
def
SelectColumnOps[A](select: Select[AliasedColumn[A], _ <: Relation]): SelectColumn[A]
This implicit conversion allows using as a column: a select statement which selects a single column
This implicit conversion allows using as a column: a select statement which selects a single column
- Definition Classes
- ColumnSyntax
- implicit val aliasedColumns: AliasedColumns[A]
- def as(subselectAlias: String): Select[A, R]
-
final
def
asInstanceOf[T0]: T0
- Definition Classes
- Any
-
def
clone(): AnyRef
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
- val cols: A
-
implicit
def
columnSetterPair[A, B](pair: (TableColumn[A], Column[B]))(implicit equivalence: ColumnTypeEquivalence[A, B]): Setter[A, _]
This implicit allows the use of
TableColumn -> Column
in settersThis implicit allows the use of
TableColumn -> Column
in setters- Definition Classes
- ColumnSyntax
- def columns: Seq[AliasedColumn[_]]
- def connectBy(expr: Column[Boolean]): Select[A, R]
- val connectBy: Option[Column[Boolean]]
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
finalize(): Unit
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( classOf[java.lang.Throwable] )
- def from[R2 <: Relation](relation: R2): Select[A, R2]
- val from: R
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
- def groupBy(groupBys: Group*): Select[A, R]
- val groupBy: List[Group]
- def having(expr: Column[Boolean]): Select[A, R]
- val having: Option[Column[Boolean]]
-
final
def
isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- def limit(limit: Long): Select[A, R]
- val limit: Option[Long]
-
implicit
def
literalColumn[A](value: Some[A])(implicit columnType: ColumnType[Option[A]]): Column[Option[A]]
- Definition Classes
- ColumnSyntax
-
implicit
def
literalColumn[A](value: A)(implicit columnType: ColumnType[A]): Column[A]
- Definition Classes
- ColumnSyntax
-
implicit
def
literalSetterPair[A, B](pair: (TableColumn[A], B))(implicit valueType: ColumnType[B], equivalence: ColumnTypeEquivalence[A, B]): Setter[A, _]
This implicit allows the use of
TableColumn -> Value
in setters, as opposed toTableColumn -> Column
as is actually required:This implicit allows the use of
TableColumn -> Value
in setters, as opposed toTableColumn -> Column
as is actually required:- Definition Classes
- ColumnSyntax
-
final
def
ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
final
def
notify(): Unit
- Definition Classes
- AnyRef
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
- def offset(offset: Long): Select[A, R]
- val offset: Option[Long]
- def optimize(optimize: Long): Select[A, R]
- val optimize: Option[Long]
- def optionWhere(expr: Option[Column[Boolean]]): Select[A, R]
- def orderBy(orders: Order*): Select[A, R]
- val orderBy: List[Order]
- def page(number: Long, size: Long): Select[A, R]
- def startWith(expr: Column[Boolean]): Select[A, R]
- val startWith: Option[Column[Boolean]]
- val subselectAlias: Option[String]
-
final
def
synchronized[T0](arg0: ⇒ T0): T0
- Definition Classes
- AnyRef
- def transform[B, S <: Relation](f: (Select[A, R]) ⇒ Select[B, S])(implicit arg0: AliasedColumns[B]): Select[B, S]
- def union(select: Select[A, _ <: Relation]): Select[A, R]
- val union: List[Union[_]]
- def unionAll(select: Select[A, _ <: Relation]): Select[A, R]
-
final
def
wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
- def where(expr: Column[Boolean]): Select[A, R]
- val where: Option[Column[Boolean]]