Select

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, 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 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, B]

This implicit allows the use of TableColumn -> Column in setters
This 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: Aux[A, 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, B]

This implicit allows the use of TableColumn -> Value in setters, as opposed to TableColumn -> Column as is actually required:
This implicit allows the use of TableColumn -> Value in setters, as opposed to TableColumn -> 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 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 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]]

Related Doc: package ast

Instance Constructors

Type Members

implicit class AliasColumnOps[A] extends AnyRef

implicit class AliasedOptionColumnsOps[A] extends AnyRef

implicit class BooleanColumnOps[A] extends AnyRef

implicit class ComparisonColumnOps[A] extends AnyRef

implicit class ConstantColumnOps[A] extends AnyRef

implicit class IntColumnOps[A] extends AnyRef

implicit class LiteralColumnOps[A] extends AnyRef

implicit class NullableColumnsOps[A] extends AnyRef

implicit class StringColumnOps[A] extends AnyRef

Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

implicit def SelectColumnOps[A](select: Select[AliasedColumn[A], _ <: Relation]): SelectColumn[A]

implicit val aliasedColumns: AliasedColumns[A]

def as(subselectAlias: String): Select[A, R]

final def asInstanceOf[T0]: T0

def clone(): AnyRef

val cols: A

implicit def columnSetterPair[A, B](pair: (TableColumn[A], Column[B]))(implicit equivalence: ColumnTypeEquivalence[A, B]): Setter[A, B]

def columns: Seq[AliasedColumn[_]]

def connectBy(expr: Column[Boolean]): Select[A, R]

val connectBy: Option[Column[Boolean]]

final def eq(arg0: AnyRef): Boolean

def finalize(): Unit

def from[R2 <: Relation](relation: R2): Select[A, R2]

val from: R

final def getClass(): Class[_]

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

def limit(limit: Long): Select[A, R]

val limit: Option[Long]

implicit def literalColumn[A](value: Some[A])(implicit columnType: Aux[A, A]): Column[Option[A]]

implicit def literalColumn[A](value: A)(implicit columnType: ColumnType[A]): Column[A]

implicit def literalSetterPair[A, B](pair: (TableColumn[A], B))(implicit valueType: ColumnType[B], equivalence: ColumnTypeEquivalence[A, B]): Setter[A, B]

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

def offset(offset: Long): Select[A, R]

val offset: Option[Long]

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

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

final def wait(arg0: Long, arg1: Int): Unit

final def wait(arg0: Long): Unit

def where(expr: Column[Boolean]): Select[A, R]

val where: Option[Column[Boolean]]

Inherited from Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from ColumnSyntax

Inherited from Query

Inherited from Operation

Inherited from Relation

Inherited from AnyRef

Inherited from Any

Ungrouped