case class SqlSelect(context: Context, withs: List[WithRef], table: TableExpr, cols: List[SqlColumn], joins: List[SqlJoin], wheres: List[Predicate], orders: List[OrderSelection[_]], offset: Option[Int], limit: Option[Int], distinct: List[SqlColumn], oneToOne: Boolean, predicate: Boolean) extends SqlQuery with Product with Serializable
Representation of an SQL SELECT
- Alphabetic
- By Inheritance
- SqlSelect
- SqlQuery
- ColumnOwner
- Serializable
- Product
- Equals
- AnyRef
- Any
- Hide All
- Show All
- Public
- Protected
Instance Constructors
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
- def addFilterOrderByOffsetLimit(filter: Option[(Predicate, List[SqlJoin])], orderBy: Option[(List[OrderSelection[_]], List[SqlJoin])], offset0: Option[Int], limit0: Option[Int], predIsOneToOne: Boolean, parentConstraints: List[List[(SqlColumn, SqlColumn)]]): Result[SqlSelect]
Add WHERE, ORDER BY and LIMIT to this query
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- def asSelects: List[SqlSelect]
Yields a collection of
SqlSelectswhich when combined as a union are equivalent to this queryYields a collection of
SqlSelectswhich when combined as a union are equivalent to this query- Definition Classes
- SqlQuery
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @native() @HotSpotIntrinsicCandidate()
- def codecs: List[(Boolean, SqlMappingLike.Codec)]
The codecs corresponding to the columns of this query
- val cols: List[SqlColumn]
The columns of this query
- def contains(other: ColumnOwner): Boolean
- Definition Classes
- SqlSelect → ColumnOwner
- val context: Context
The context for this query
The context for this query
- Definition Classes
- SqlSelect → SqlQuery → ColumnOwner
- def debugShow: String
- Definition Classes
- ColumnOwner
- def directlyOwns(col: SqlColumn): Boolean
- Definition Classes
- SqlSelect → ColumnOwner
- val distinct: List[SqlColumn]
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def findNamedOwner(col: SqlColumn): Option[TableExpr]
- Definition Classes
- SqlSelect → ColumnOwner
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @native() @HotSpotIntrinsicCandidate()
- def isDistinct: Boolean
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- def isSameOwner(other: ColumnOwner): Boolean
- Definition Classes
- SqlSelect → ColumnOwner
- def isUnion: Boolean
Is this query an SQL Union
- val joins: List[SqlJoin]
- val limit: Option[Int]
- def nameOption: Option[String]
The name, if any, of this
ColumnOwnerThe name, if any, of this
ColumnOwner- Definition Classes
- ColumnOwner
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def needsCollation(col: SqlColumn): Result[Boolean]
Does the given column need collation?
- def nest(parentContext: Context, extraCols: List[SqlColumn], oneToOne: Boolean, lateral: Boolean): Result[SqlSelect]
Nest this query as a subobject in the enclosing
parentContext - final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @HotSpotIntrinsicCandidate()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @HotSpotIntrinsicCandidate()
- val offset: Option[Int]
- val oneToOne: Boolean
Does one row of this query correspond to exactly one complete GraphQL value
- lazy val orderCols: Result[List[SqlColumn]]
The columns, if any, on which this select is ordered
- val orders: List[OrderSelection[_]]
- def owns(col: SqlColumn): Boolean
- Definition Classes
- SqlSelect → ColumnOwner
- val predicate: Boolean
- def productElementNames: Iterator[String]
- Definition Classes
- Product
- def subqueryToWithQuery: SqlSelect
If the from clause of this query is a subquery, convert it to a common table expression
- def subst(from: TableExpr, to: TableExpr): SqlSelect
Yields a copy of this select with all occurences of
fromreplaced byto - final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- def syntheticName(suffix: String): String
Yield a name for this select derived from any names associated with its from clauses or joins
- val table: TableExpr
- def toFragment: Aliased[SqlMappingLike.Fragment]
Render this
SqlSelectas aFragment - def toSubquery(name: String, lateral: Boolean): SqlSelect
Yields an equivalent query encapsulating this query as a subquery
- def toWithQuery(name: String, refName: Option[String]): SqlSelect
Yields an equivalent query encapsulating this query as a common table expression
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- val wheres: List[Predicate]
- def withContext(context: Context, extraCols: List[SqlColumn], extraJoins: List[SqlJoin]): SqlSelect
This query in the given context
- val withs: List[WithRef]