Packages

c

sqlest.ast

Select

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.

Linear Supertypes
Serializable, Serializable, Product, Equals, ColumnSyntax, Query, Operation, Relation, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. Select
  2. Serializable
  3. Serializable
  4. Product
  5. Equals
  6. ColumnSyntax
  7. Query
  8. Operation
  9. Relation
  10. AnyRef
  11. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. 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

  1. implicit class AliasColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  2. implicit class AliasedOptionColumnsOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  3. implicit class BooleanColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  4. implicit class ComparisonColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  5. 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
  6. implicit class IntColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  7. implicit class LiteralColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  8. implicit class NullableColumnsOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  9. implicit class SomeConstantColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  10. implicit class SomeLiteralColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax
  11. implicit class StringColumnOps [A] extends AnyRef
    Definition Classes
    ColumnSyntax

Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. 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
  5. implicit val aliasedColumns: AliasedColumns[A]
  6. def as(subselectAlias: String): Select[A, R]
  7. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  8. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  9. val cols: A
  10. 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 setters

    This implicit allows the use of TableColumn -> Column in setters

    Definition Classes
    ColumnSyntax
  11. def columns: Seq[AliasedColumn[_]]
  12. def connectBy(expr: Column[Boolean]): Select[A, R]
  13. val connectBy: Option[Column[Boolean]]
  14. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  15. def finalize(): Unit
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  16. def from[R2 <: Relation](relation: R2): Select[A, R2]
  17. val from: R
  18. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
  19. def groupBy(groupBys: Group*): Select[A, R]
  20. val groupBy: List[Group]
  21. def having(expr: Column[Boolean]): Select[A, R]
  22. val having: Option[Column[Boolean]]
  23. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  24. def limit(limit: Long): Select[A, R]
  25. val limit: Option[Long]
  26. implicit def literalColumn[A](value: Some[A])(implicit columnType: ColumnType[Option[A]]): Column[Option[A]]
    Definition Classes
    ColumnSyntax
  27. implicit def literalColumn[A](value: A)(implicit columnType: ColumnType[A]): Column[A]
    Definition Classes
    ColumnSyntax
  28. 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 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
  29. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  30. final def notify(): Unit
    Definition Classes
    AnyRef
  31. final def notifyAll(): Unit
    Definition Classes
    AnyRef
  32. def offset(offset: Long): Select[A, R]
  33. val offset: Option[Long]
  34. def optimize(optimize: Long): Select[A, R]
  35. val optimize: Option[Long]
  36. def optionWhere(expr: Option[Column[Boolean]]): Select[A, R]
  37. def orderBy(orders: Order*): Select[A, R]
  38. val orderBy: List[Order]
  39. def page(number: Long, size: Long): Select[A, R]
  40. def startWith(expr: Column[Boolean]): Select[A, R]
  41. val startWith: Option[Column[Boolean]]
  42. val subselectAlias: Option[String]
  43. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  44. def transform[B, S <: Relation](f: (Select[A, R]) ⇒ Select[B, S])(implicit arg0: AliasedColumns[B]): Select[B, S]
  45. def union(select: Select[A, _ <: Relation]): Select[A, R]
  46. val union: List[Union[_]]
  47. def unionAll(select: Select[A, _ <: Relation]): Select[A, R]
  48. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  49. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  50. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  51. def where(expr: Column[Boolean]): Select[A, R]
  52. 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