class SimpleSelect[Q, R] extends Select[Q, R]

A SELECT query, with FROM/JOIN/WHERE/GROUP BY clauses, but without ORDER BY/LIMIT/TAKE/UNION clauses

Linear Supertypes
Select[Q, R], Wrapped, DelegateQueryable[Q, Seq[R]], Query[Seq[R]], JoinOps[Select, Q, R], Joinable[Q, R], Aggregatable[Q], WithSqlExpr[Q], Renderable, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. SimpleSelect
  2. Select
  3. Wrapped
  4. DelegateQueryable
  5. Query
  6. JoinOps
  7. Joinable
  8. Aggregatable
  9. WithSqlExpr
  10. Renderable
  11. AnyRef
  12. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Instance Constructors

  1. new SimpleSelect(expr: Q, exprPrefix: Option[(Context) => SqlStr], exprSuffix: Option[(Context) => SqlStr], preserveAll: Boolean, from: Seq[From], joins: Seq[Join], where: Seq[Expr[_]], groupBy0: Option[GroupBy])(implicit qr: Row[Q, R], dialect: DialectTypeMappers)

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. def aggregate[E, V](f: (Proxy[Q]) => E)(implicit qr: Row[E, V]): Aggregate[E, V]

    Performs one or more aggregates in a single Select

    Performs one or more aggregates in a single Select

    Definition Classes
    SimpleSelect → Select
  5. def aggregateExpr[V](f: (Q) => (Context) => SqlStr)(implicit arg0: TypeMapper[V], qr2: Row[Expr[V], V]): Expr[V]
    Definition Classes
    SimpleSelect → Aggregatable
  6. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  7. def asc: Select[Q, R]

    Combined with sortBy to make the sort order ascending, translates into SQL ASC

    Combined with sortBy to make the sort order ascending, translates into SQL ASC

    Definition Classes
    SimpleSelect → Select
  8. def clone(): AnyRef
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.CloneNotSupportedException]) @HotSpotIntrinsicCandidate() @native()
  9. def compound0(op: String, other: Select[Q, R]): CompoundSelect[Q, R]
    Definition Classes
    SimpleSelect → Select
  10. def contains(other: Q): Expr[Boolean]

    Returns whether or not the Select on the left contains the other value on the right

    Returns whether or not the Select on the left contains the other value on the right

    Definition Classes
    Select
  11. def copy[Q, R](expr: Q = this.expr, exprPrefix: Option[(Context) => SqlStr] = this.exprPrefix, exprSuffix: Option[(Context) => SqlStr] = this.exprSuffix, preserveAll: Boolean = this.preserveAll, from: Seq[From] = this.from, joins: Seq[Join] = this.joins, where: Seq[Expr[_]] = this.where, groupBy0: Option[GroupBy] = this.groupBy0)(implicit qr: Row[Q, R]): SimpleSelect[Q, R]
    Attributes
    protected
  12. def crossJoin[Q2, R2, QF, RF](other: Joinable[Q2, R2])(implicit ja: JoinAppend[Q, Q2, QF, RF]): Select[QF, RF]

    Performs a CROSS JOIN, which is an INNER JOIN but without the ON clause

    Performs a CROSS JOIN, which is an INNER JOIN but without the ON clause

    Definition Classes
    JoinOps
  13. def crossJoin[Q2, R2](): Mapper[Q, Q2, R, R2]

    Version of crossJoin meant for usage in for-comprehensions

    Version of crossJoin meant for usage in for-comprehensions

    Definition Classes
    Joinable
  14. def desc: Select[Q, R]

    Combined with sortBy to make the sort order descending, translates into SQL DESC

    Combined with sortBy to make the sort order descending, translates into SQL DESC

    Definition Classes
    SimpleSelect → Select
  15. implicit val dialect: DialectTypeMappers
    Attributes
    protected
    Definition Classes
    SimpleSelect → Select
  16. def distinct: Select[Q, R]

    Causes this Select to ignore duplicate rows, translates into SQL SELECT DISTINCT

    Causes this Select to ignore duplicate rows, translates into SQL SELECT DISTINCT

    Definition Classes
    Select
  17. def drop(n: Int): Select[Q, R]

    Drops the first n rows from this Select.

    Drops the first n rows from this Select. Like when used in Scala collections, if called multiple times the dropped rows add up

    Definition Classes
    SimpleSelect → Select
  18. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  19. def equals(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef → Any
  20. def except(other: Select[Q, R]): Select[Q, R]

    Subtracts the other from this Select, returning only rows present this but absent in other, and removing duplicates.

    Subtracts the other from this Select, returning only rows present this but absent in other, and removing duplicates. Translates into SQL EXCEPT

    Definition Classes
    Select
  21. val expr: Q
    Definition Classes
    SimpleSelect → WithSqlExpr
  22. val exprPrefix: Option[(Context) => SqlStr]
  23. val exprSuffix: Option[(Context) => SqlStr]
  24. def filter(f: (Q) => Expr[Boolean]): Select[Q, R]

    Filters this Select with the given predicate, translates into a SQL WHERE clause

    Filters this Select with the given predicate, translates into a SQL WHERE clause

    Definition Classes
    SimpleSelect → Select
  25. def filterIf(cond: Boolean)(f: (Q) => Expr[Boolean]): Select[Q, R]

    Filters this Select with the given predicate, if cond evaluates to true

    Filters this Select with the given predicate, if cond evaluates to true

    Definition Classes
    SimpleSelect → Select
  26. def filterOpt[T](option: Option[T])(f: (Q, T) => Expr[Boolean]): Select[Q, R]

    Filters this Select with the given predicate consuming provided option as a part of predicate's input, if this option is Some[T]

    Filters this Select with the given predicate consuming provided option as a part of predicate's input, if this option is Some[T]

    Definition Classes
    SimpleSelect → Select
  27. def flatMap[Q2, R2](f: (Q) => Rhs[Q2, R2])(implicit qr2: Row[Q2, R2]): Select[Q2, R2]

    Performs an implicit JOIN between this Select and the one returned by the callback function f

    Performs an implicit JOIN between this Select and the one returned by the callback function f

    Definition Classes
    SimpleSelect → Select
  28. val from: Seq[From]
  29. final def getClass(): Class[_ <: AnyRef]
    Definition Classes
    AnyRef → Any
    Annotations
    @HotSpotIntrinsicCandidate() @native()
  30. def groupBy[K, V, R1, R2](groupKey: (Q) => K)(groupAggregate: (Proxy[Q]) => V)(implicit qrk: Row[K, R1], qrv: Row[V, R2]): Select[(K, V), (R1, R2)]

    Translates into a SQL GROUP BY, takes a function specifying the group-key and a function specifying the group-aggregate.

    Translates into a SQL GROUP BY, takes a function specifying the group-key and a function specifying the group-aggregate.

    Definition Classes
    SimpleSelect → Select
  31. val groupBy0: Option[GroupBy]
  32. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @HotSpotIntrinsicCandidate() @native()
  33. def head: Single[R]

    Shorthand for .take(1).single:

    Shorthand for .take(1).single:

    1. If the query returns a single row, this returns it as a single value of type R 2. If the query returns multiple rows, returns the first as a single value of type R and discards the rest 3. If the query returns zero rows, throws an exception.

    Definition Classes
    Select
  34. def intersect(other: Select[Q, R]): Select[Q, R]

    Intersects the result rows of this Select with another, preserving only rows present in both this and the other and removing duplicates.

    Intersects the result rows of this Select with another, preserving only rows present in both this and the other and removing duplicates. Translates into SQL INTERSECT

    Definition Classes
    Select
  35. def isEmpty: Expr[Boolean]

    Returns whether or not the Select on the left is empty with zero elements

    Returns whether or not the Select on the left is empty with zero elements

    Definition Classes
    Select
  36. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  37. def join[Q2, R2, QF, RF](other: Joinable[Q2, R2])(on: (Q, Q2) => Expr[Boolean])(implicit ja: JoinAppend[Q, Q2, QF, RF]): Select[QF, RF]

    Performs a JOIN/INNER JOIN on the given other, typically a Table or Select.

    Performs a JOIN/INNER JOIN on the given other, typically a Table or Select.

    Definition Classes
    JoinOps
  38. def join[Q2, R2](on: (Q) => Expr[Boolean]): Mapper[Q, Q2, R, R2]

    Version of join meant for usage in for-comprehensions

    Version of join meant for usage in for-comprehensions

    Definition Classes
    Joinable
  39. def join0[Q2, R2, QF, RF](prefix: String, other: Joinable[Q2, R2], on: Option[(Q, Q2) => Expr[Boolean]])(implicit ja: JoinAppend[Q, Q2, QF, RF]): Select[QF, RF]
    Definition Classes
    SimpleSelect → JoinOps
  40. def joinCopy[Q2, R2, Q3, R3](other: Joinable[Q2, R2], on: Option[(Q, Q2) => Expr[Boolean]], joinPrefix: String)(f: (Q, Q2) => Q3)(implicit jqr: Row[Q3, R3]): SimpleSelect[Q3, R3]
    Attributes
    protected
  41. def joinCopy0[Q3, R3](newExpr: Q3, newJoins: Seq[Join], newWheres: Seq[Expr[Boolean]])(implicit jqr: Row[Q3, R3]): SimpleSelect[Q3, R3]
    Attributes
    protected
  42. def joinInfo[Q2, R2](joinPrefix: String, other: Joinable[Q2, R2], on: Option[(Q, Q2) => Expr[Boolean]]): (Seq[Join], Q2)
    Attributes
    protected
    Definition Classes
    JoinOps
  43. def joinableToFromExpr: (From, Q)
    Attributes
    protected
    Definition Classes
    Select → Joinable
  44. val joins: Seq[Join]
  45. def leftJoin[Q2, R2](other: Joinable[Q2, R2])(on: (Q, Q2) => Expr[Boolean])(implicit joinQr: Row[Q2, R2]): Select[(Q, JoinNullable[Q2]), (R, Option[R2])]

    Performs a LEFT JOIN on the given other, typically a Table or Select.

    Performs a LEFT JOIN on the given other, typically a Table or Select.

    Definition Classes
    SimpleSelect → Select
  46. def leftJoin[Q2, R2](on: (Q) => Expr[Boolean]): NullableMapper[Q, Q2, R, R2]

    Version of leftJoin meant for usage in for-comprehensions

    Version of leftJoin meant for usage in for-comprehensions

    Definition Classes
    Joinable
  47. def map[Q2, R2](f: (Q) => Q2)(implicit qr: Row[Q2, R2]): SimpleSelect[Q2, R2]

    Transforms the return value of this Select with the given function

    Transforms the return value of this Select with the given function

    Definition Classes
    SimpleSelect → Select
  48. def mapAggregate[Q2, R2](f: (Q, Proxy[Q]) => Q2)(implicit qr: Row[Q2, R2]): Select[Q2, R2]

    Performs a .map which additionally provides a Aggregatable.Proxy that allows you to perform aggregate functions.

    Performs a .map which additionally provides a Aggregatable.Proxy that allows you to perform aggregate functions.

    Definition Classes
    SimpleSelect → Select
  49. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  50. def newCompoundSelect[Q, R](lhs: SimpleSelect[Q, R], compoundOps: Seq[Op[Q, R]], orderBy: Seq[OrderBy], limit: Option[Int], offset: Option[Int])(implicit qr: Row[Q, R], dialect: DialectTypeMappers): CompoundSelect[Q, R]
    Attributes
    protected
    Definition Classes
    Select
  51. def newSimpleSelect[Q, R](expr: Q, exprPrefix: Option[(Context) => SqlStr], exprSuffix: Option[(Context) => SqlStr], preserveAll: Boolean, from: Seq[From], joins: Seq[Join], where: Seq[Expr[_]], groupBy0: Option[GroupBy])(implicit qr: Row[Q, R], dialect: DialectTypeMappers): SimpleSelect[Q, R]
    Attributes
    protected
    Definition Classes
    Select
  52. def nonEmpty: Expr[Boolean]

    Returns whether or not the Select on the left is nonempty with one or more elements

    Returns whether or not the Select on the left is nonempty with one or more elements

    Definition Classes
    Select
  53. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @HotSpotIntrinsicCandidate() @native()
  54. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @HotSpotIntrinsicCandidate() @native()
  55. def nullsFirst: Select[Q, R]

    Combined with sortBy to configure handling of nulls, translates into SQL NULLS FIRST

    Combined with sortBy to configure handling of nulls, translates into SQL NULLS FIRST

    Definition Classes
    SimpleSelect → Select
  56. def nullsLast: Select[Q, R]

    Combined with sortBy to configure handling of nulls, translates into SQL NULLS LAST

    Combined with sortBy to configure handling of nulls, translates into SQL NULLS LAST

    Definition Classes
    SimpleSelect → Select
  57. def outerJoin[Q2, R2](other: Joinable[Q2, R2])(on: (Q, Q2) => Expr[Boolean])(implicit joinQr: Row[Q2, R2]): Select[(JoinNullable[Q], JoinNullable[Q2]), (Option[R], Option[R2])]

    Performs a OUTER JOIN on the given other, typically a Table or Select.

    Performs a OUTER JOIN on the given other, typically a Table or Select.

    Definition Classes
    SimpleSelect → Select
  58. val preserveAll: Boolean
  59. implicit val qr: Row[Q, R]
    Definition Classes
    SimpleSelect → Select → DelegateQueryable
  60. def queryConstruct(args: ResultSetIterator): Seq[R]
    Attributes
    protected
    Definition Classes
    SimpleSelect → Query
  61. def queryGetGeneratedKeys: Option[Row[_, _]]
    Attributes
    protected
    Definition Classes
    Query
  62. def queryIsExecuteUpdate: Boolean
    Attributes
    protected
    Definition Classes
    DelegateQueryable → Query
  63. def queryIsSingleRow: Boolean
    Attributes
    protected
    Definition Classes
    Select → DelegateQueryable → Query
  64. def queryWalkExprs(): Seq[Expr[_]]
    Attributes
    protected
    Definition Classes
    DelegateQueryable → Query
  65. def queryWalkLabels(): Seq[List[String]]
    Attributes
    protected
    Definition Classes
    DelegateQueryable → Query
  66. def rightJoin[Q2, R2](other: Joinable[Q2, R2])(on: (Q, Q2) => Expr[Boolean])(implicit joinQr: Row[Q2, R2]): Select[(JoinNullable[Q], Q2), (Option[R], R2)]

    Performs a RIGHT JOIN on the given other, typically a Table or Select.

    Performs a RIGHT JOIN on the given other, typically a Table or Select.

    Definition Classes
    SimpleSelect → Select
  67. def selectExprAliases(prevContext: Context): Seq[(Identity, SqlStr)]
    Attributes
    protected
    Definition Classes
    SimpleSelect → Wrapped
  68. def selectRenderer(prevContext: Context): Renderer[_, _]
    Attributes
    protected
    Definition Classes
    SimpleSelect → Wrapped
  69. def selectToSimpleSelect(): SimpleSelect[Q, R]
    Attributes
    protected
    Definition Classes
    SimpleSelect → Select
  70. def selectWithExprPrefix(preserveAll: Boolean, s: (Context) => SqlStr): Select[Q, R]
    Definition Classes
    SimpleSelect → Select
  71. def selectWithExprSuffix(preserveAll: Boolean, s: (Context) => SqlStr): Select[Q, R]
    Definition Classes
    SimpleSelect → Select
  72. def single: Single[R]

    Asserts that this query returns exactly one row, and returns a single value of type R rather than a Seq[R].

    Asserts that this query returns exactly one row, and returns a single value of type R rather than a Seq[R]. Throws an exception if zero or multiple rows are returned.

    Definition Classes
    Select
  73. def sortBy(f: (Q) => Expr[_]): Select[Q, R]

    Sorts this Select via the given expression.

    Sorts this Select via the given expression. Translates into a SQL ORDER BY clause. Can be called more than once to sort on multiple columns, with the last call to sortBy taking priority. Can be followed by asc, desc, nullsFirst or nullsLast to configure the sort order

    Definition Classes
    SimpleSelect → Select
  74. def subquery: SimpleSelect[Q, R]

    Forces this Select to be treated as a subquery that any further operations will operate on, rather than having some operations flattened out into clauses in this Select

    Forces this Select to be treated as a subquery that any further operations will operate on, rather than having some operations flattened out into clauses in this Select

    Definition Classes
    Select
  75. def subqueryRef(implicit qr: Row[Q, R]): SubqueryRef
    Attributes
    protected
    Definition Classes
    Select
  76. final def synchronized[T0](arg0: => T0): T0
    Definition Classes
    AnyRef
  77. def take(n: Int): Select[Q, R]

    Only returns the first n rows from this Select.

    Only returns the first n rows from this Select. Like when used in Scala collections, if called multiple times only the smallest value of n takes effect

    Definition Classes
    SimpleSelect → Select
  78. def toExpr(implicit mt: TypeMapper[R]): Expr[R]

    Converts this Select into an Expr, assuming it returns a single row and a single column.

    Converts this Select into an Expr, assuming it returns a single row and a single column. Note that if this returns multiple rows, behavior is database-specific, with some like Sqlite simply taking the first row while others like Postgres/MySql throwing exceptions

    Definition Classes
    Select
  79. def toString(): String
    Definition Classes
    AnyRef → Any
  80. def union(other: Select[Q, R]): Select[Q, R]

    Concatenates the result rows of this Select with another and removes duplicate rows; translates into SQL UNION

    Concatenates the result rows of this Select with another and removes duplicate rows; translates into SQL UNION

    Definition Classes
    Select
  81. def unionAll(other: Select[Q, R]): Select[Q, R]

    Concatenates the result rows of this Select with another; translates into SQL UNION ALL

    Concatenates the result rows of this Select with another; translates into SQL UNION ALL

    Definition Classes
    Select
  82. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  83. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException]) @native()
  84. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  85. val where: Seq[Expr[_]]
  86. def withFilter(f: (Q) => Expr[Boolean]): Select[Q, R]

    Alias for filter

    Alias for filter

    Definition Classes
    Select

Deprecated Value Members

  1. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.Throwable]) @Deprecated
    Deprecated

    (Since version 9)

Inherited from Select[Q, R]

Inherited from Wrapped

Inherited from DelegateQueryable[Q, Seq[R]]

Inherited from Query[Seq[R]]

Inherited from JoinOps[Select, Q, R]

Inherited from Joinable[Q, R]

Inherited from Aggregatable[Q]

Inherited from WithSqlExpr[Q]

Inherited from Renderable

Inherited from AnyRef

Inherited from Any

Ungrouped