grackle-sql
0.18.1
API
Generated with
grackle-sql/grackle.sql/SqlMappingLike/SqlQuery/SqlSelect

SqlSelect

grackle.sql.SqlMappingLike.SqlQuery.SqlSelect
See theSqlSelect companion object
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

Representation of an SQL SELECT

Attributes

Companion
object
Source
SqlMapping.scala
Graph
Supertypes
trait SqlQuery
trait ColumnOwner
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
Show all

Members list

Value members

Concrete methods

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

Add WHERE, ORDER BY and LIMIT to this query

Attributes

Source
SqlMapping.scala
def codecs: List[(Boolean, Codec)]

The codecs corresponding to the columns of this query

The codecs corresponding to the columns of this query

Attributes

Source
SqlMapping.scala
def contains(other: ColumnOwner): Boolean

Attributes

Source
SqlMapping.scala
def directlyOwns(col: SqlColumn): Boolean

Attributes

Source
SqlMapping.scala
def findNamedOwner(col: SqlColumn): Option[TableExpr]

Attributes

Source
SqlMapping.scala
def isDistinct: Boolean

Attributes

Source
SqlMapping.scala
override def isSameOwner(other: ColumnOwner): Boolean

Attributes

Definition Classes
Source
SqlMapping.scala
def isUnion: Boolean

Is this query an SQL Union

Is this query an SQL Union

Attributes

Source
SqlMapping.scala
def needsCollation(col: SqlColumn): Result[Boolean]

Does the given column need collation?

Does the given column need collation?

Attributes

Source
SqlMapping.scala
def nest(parentContext: Context, extraCols: List[SqlColumn], oneToOne: Boolean, lateral: Boolean): Result[SqlSelect]

Nest this query as a subobject in the enclosing parentContext

Nest this query as a subobject in the enclosing parentContext

Attributes

Source
SqlMapping.scala
def owns(col: SqlColumn): Boolean

Attributes

Source
SqlMapping.scala
def subqueryToWithQuery: SqlSelect

If the from clause of this query is a subquery, convert it to a common table expression

If the from clause of this query is a subquery, convert it to a common table expression

Attributes

Source
SqlMapping.scala
def subst(from: TableExpr, to: TableExpr): SqlSelect

Yields a copy of this select with all occurences of from replaced by to

Yields a copy of this select with all occurences of from replaced by to

Attributes

Source
SqlMapping.scala
def syntheticName(suffix: String): String

Yield a name for this select derived from any names associated with its from clauses or joins

Yield a name for this select derived from any names associated with its from clauses or joins

Attributes

Source
SqlMapping.scala
def toFragment: Aliased[Fragment]

Render this SqlSelect as a Fragment

Render this SqlSelect as a Fragment

Attributes

Source
SqlMapping.scala
def toSubquery(name: String, lateral: Boolean): Result[SqlSelect]

Yields an equivalent query encapsulating this query as a subquery

Yields an equivalent query encapsulating this query as a subquery

Attributes

Source
SqlMapping.scala
def withContext(context: Context, extraCols: List[SqlColumn], extraJoins: List[SqlJoin]): Result[SqlSelect]

This query in the given context

This query in the given context

Attributes

Source
SqlMapping.scala

Inherited methods

def asSelects: List[SqlSelect]

Yields a collection of SqlSelects which when combined as a union are equivalent to this query

Yields a collection of SqlSelects which when combined as a union are equivalent to this query

Attributes

Inherited from:
SqlQuery
Source
SqlMapping.scala
def debugShow: String

Attributes

Inherited from:
ColumnOwner
Source
SqlMapping.scala
def nameOption: Option[String]

The name, if any, of this ColumnOwner

The name, if any, of this ColumnOwner

Attributes

Inherited from:
ColumnOwner
Source
SqlMapping.scala
def productElementNames: Iterator[String]

Attributes

Inherited from:
Product
def productIterator: Iterator[Any]

Attributes

Inherited from:
Product

Concrete fields

lazy val orderCols: Result[List[SqlColumn]]

The columns, if any, on which this select is ordered

The columns, if any, on which this select is ordered

Attributes

Source
SqlMapping.scala
Generated with