SelectSQLBuilder

scalikejdbc.QueryDSLFeature.SelectSQLBuilder
case class SelectSQLBuilder[A](sql: SQLSyntax, lazyColumns: Boolean, resultAllProviders: List[ResultAllProvider], ignoreOnClause: Boolean) extends SQLBuilder[A], SubQuerySQLBuilder[A]

SQLBuilder for select queries.

Attributes

Source
QueryDSLFeature.scala
Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait SQLBuilder[A]
class Object
trait Matchable
class Any
Show all

Members list

Value members

Concrete methods

override def append(part: SQLSyntax): SelectSQLBuilder[A]

Attributes

Definition Classes
Source
QueryDSLFeature.scala

Attributes

Source
QueryDSLFeature.scala
def except(anotherQuery: SQLSyntax): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def except(anotherQuery: SQLBuilder[_]): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def exceptAll(anotherQuery: SQLSyntax): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def exceptAll(anotherQuery: SQLBuilder[_]): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def groupBy(columns: SQLSyntax*): GroupBySQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def having(condition: SQLSyntax): GroupBySQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala

Attributes

Source
QueryDSLFeature.scala
def intersect(anotherQuery: SQLSyntax): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def intersect(anotherQuery: SQLBuilder[_]): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def intersectAll(anotherQuery: SQLSyntax): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def intersectAll(anotherQuery: SQLBuilder[_]): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def join(table: Option[TableAsAliasSQLSyntax]): SelectSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala

Attributes

Source
QueryDSLFeature.scala
def limit(n: Int): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala

Attributes

Source
QueryDSLFeature.scala
def offset(n: Int): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def on(onClause: SQLSyntax): SelectSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def on(left: SQLSyntax, right: SQLSyntax): SelectSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def orderBy(columns: SQLSyntax*): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala

Attributes

Source
QueryDSLFeature.scala
override def toSQL: SQL[A, NoExtractor]

Attributes

Definition Classes
Source
QueryDSLFeature.scala
override def toSQLSyntax: SQLSyntax

Attributes

Definition Classes
Source
QueryDSLFeature.scala
def union(anotherQuery: SQLSyntax): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def union(anotherQuery: SQLBuilder[_]): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def unionAll(anotherQuery: SQLSyntax): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala
def unionAll(anotherQuery: SQLBuilder[_]): PagingSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala

Attributes

Source
QueryDSLFeature.scala

Attributes

Source
QueryDSLFeature.scala
def where(whereOpt: Option[SQLSyntax]): ConditionSQLBuilder[A]

Attributes

Source
QueryDSLFeature.scala

Inherited methods

Converts SQLBuilder to sub-query part sqls. e.g. val x = SubQuery.syntax("x").include(u, g) withSQL { select.from(select.from(User as u).leftJoin(Group as g).on(u.groupId, g.id).where.eq(u.groupId, 234).as(x)) }

Converts SQLBuilder to sub-query part sqls. e.g. val x = SubQuery.syntax("x").include(u, g) withSQL { select.from(select.from(User as u).leftJoin(Group as g).on(u.groupId, g.id).where.eq(u.groupId, 234).as(x)) }

Attributes

Inherited from:
SubQuerySQLBuilder
Source
QueryDSLFeature.scala
def productElementNames: Iterator[String]

Attributes

Inherited from:
Product
def productIterator: Iterator[Any]

Attributes

Inherited from:
Product