SqlSelect

case class SqlSelect(context: Context, table: TableExpr, cols: List[ColumnRef], joins: List[SqlJoin], wheres: List[Where], orders: List[Order], limit: Option[Int], distinct: Boolean, aliases: List[String], collate: Set[ColumnRef]) extends SqlQuery

Representation of an SQL SELECT

trait Serializable
trait Product
trait Equals
trait SqlQuery
class Object
trait Matchable
class Any

Value members

Concrete methods

def addColumns(extraCols: List[ColumnRef]): SqlSelect

Add the given columns to this query

Add the given columns to this query

def addFilterOrderByLimit(pred: Option[Predicate], oss: Option[List[OrderSelection[_]]], limit: Option[Int], folQuery: Option[SqlSelect], aliasedMappings: AliasedMappings): Option[(SqlSelect, AliasedMappings)]

Add WHERE, ORDER BY and LIMIT to this query

Add WHERE, ORDER BY and LIMIT to this query

def colsOf(table: TableExpr): List[ColumnRef]

The columns of the given table expression that are referred to by this SELECT

The columns of the given table expression that are referred to by this SELECT

def fetch: F[Table]

Execute this query in F

Execute this query in F

def index(col: ColumnRef): Int

The index of the given unaliased column in the result set

The index of the given unaliased column in the result set

def nest(parentContext: Context, fieldName: String, resultName: String, extraCols: List[ColumnRef], extraJoins: List[SqlJoin], aliasedMappings: AliasedMappings): (SqlSelect, AliasedMappings)

Nest this query as a subobject in the enclosing parentContext

Nest this query as a subobject in the enclosing parentContext

def plural: Boolean

Does the result of this query contain lists of subobject?

Does the result of this query contain lists of subobject?

def withContext(context: Context): SqlSelect

This query in the given context

This query in the given context

Inherited methods

def productElementNames: Iterator[String]
Inherited from
Product
def productIterator: Iterator[Any]
Inherited from
Product