core
API
Generated with
© 2002-2021 · LAMP/EPFL
© 2002-2021 · LAMP/EPFL
core/easysql.dsl

easysql.dsl

package easysql.dsl

Members list

Concise view

Type members

Classlikes

case class AggExpr[T <: SqlDataType](name: String, args: List[Expr[_]], distinct: Boolean, attrs: Map[String, Expr[_]], orderBy: List[OrderBy]) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class AliasExpr[T <: SqlDataType, Alias <: String](expr: Expr[T], name: Alias) extends SelectItem[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait SelectItem[T]
class Object
trait Matchable
class Any
object AllColumn

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Self type
case class AllColumnExpr(owner: Option[String]) extends Expr[Nothing]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[Nothing]
trait SelectItem[Nothing]
class Object
trait Matchable
class Any
sealed trait AnyTable

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes
class JoinTable
class TableSchema[E]
case class BetweenExpr[T <: SqlDataType](expr: Expr[_], start: Expr[_], end: Expr[_], not: Boolean) extends Expr[Boolean]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[Boolean]
trait SelectItem[Boolean]
class Object
trait Matchable
class Any
case class BinaryExpr[T <: SqlDataType](left: Expr[_], op: SqlBinaryOperator, right: Expr[_]) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class CaseBranch[T](expr: Expr[_], thenValue: Expr[_])

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
case class CaseExpr[T <: SqlDataType](branches: List[CaseBranch[_]], default: Expr[_]) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class CastExpr[T <: SqlDataType](expr: Expr[_], castType: String) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class Column(columnName: String) extends StaticAnnotation

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait StaticAnnotation
class Annotation
class Object
trait Matchable
class Any
case class ColumnExpr[T <: SqlDataType, N <: String](tableName: String, columnName: String, identName: N) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
sealed trait Expr[T <: SqlDataType] extends SelectItem[T]

Attributes

Companion:
object
Graph
Supertypes
trait SelectItem[T]
class Object
trait Matchable
class Any
Known subtypes
class AggExpr[T]
class BetweenExpr[T]
class BinaryExpr[T]
class CaseExpr[T]
class CastExpr[T]
class ColumnExpr[T, N]
class FuncExpr[T]
class IdentExpr[T]
class InExpr[T]
class ListExpr[T]
class LiteralExpr[T]
object NullExpr.type
class OverExpr[T]
class PrimaryKeyExpr[T, N]
class SubQueryExpr[T]
object Expr

Attributes

Companion:
trait
Graph
Supertypes
trait Sum
trait Mirror
class Object
trait Matchable
class Any
Self type
Expr.type
trait ExprOperator[T <: SqlDataType]

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes
object boolOperator.type
object dateOperator.type
object stringOperator.type
case class FuncExpr[T <: SqlDataType](name: String, args: List[Expr[_]]) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class IdentExpr[T <: SqlDataType](column: String) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class InExpr[T <: SqlDataType](expr: Expr[_], inExpr: Expr[_], not: Boolean) extends Expr[Boolean]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[Boolean]
trait SelectItem[Boolean]
class Object
trait Matchable
class Any
case class IncrKey(columnName: String) extends StaticAnnotation

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait StaticAnnotation
class Annotation
class Object
trait Matchable
class Any
case class JoinTable(left: AnyTable, joinType: SqlJoinType, right: AnyTable, onCondition: Option[Expr[Boolean]]) extends AnyTable

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait AnyTable
class Object
trait Matchable
class Any
case class ListExpr[T <: SqlDataType](list: List[Expr[_]]) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class LiteralExpr[T <: SqlDataType](value: T) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case object NullExpr extends Expr[Nothing]

Attributes

Graph
Supertypes
trait Singleton
trait Product
trait Mirror
trait Serializable
trait Product
trait Equals
trait Expr[Nothing]
trait SelectItem[Nothing]
class Object
trait Matchable
class Any
Self type
case class OrderBy(expr: Expr[_], order: SqlOrderByOption)

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
case class OverExpr[T <: SqlDataType](func: AggExpr[T], partitionBy: List[Expr[_]], orderBy: List[OrderBy]) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class PrimaryKey(columnName: String) extends StaticAnnotation

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait StaticAnnotation
class Annotation
class Object
trait Matchable
class Any
case class PrimaryKeyExpr[T <: SqlDataType, N <: String](tableName: String, columnName: String, identName: N, inc: Boolean) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class PrimaryKeyGenerator(columnName: String, gernerator: () => SqlDataType) extends StaticAnnotation

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait StaticAnnotation
class Annotation
class Object
trait Matchable
class Any
trait SelectItem[T]

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes
class AliasExpr[T, Alias]
trait Expr[T]
class AggExpr[T]
class BetweenExpr[T]
class BinaryExpr[T]
class CaseExpr[T]
class CastExpr[T]
class ColumnExpr[T, N]
class FuncExpr[T]
class IdentExpr[T]
class InExpr[T]
class ListExpr[T]
class LiteralExpr[T]
object NullExpr.type
class OverExpr[T]
class PrimaryKeyExpr[T, N]
class SubQueryExpr[T]
class TableSchema[E]
case class SubQueryExpr[T <: SqlDataType](query: Query[(T), _]) extends Expr[T]

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait Expr[T]
trait SelectItem[T]
class Object
trait Matchable
class Any
case class Table(tableName: String) extends StaticAnnotation

Attributes

Graph
Supertypes
trait Serializable
trait Product
trait Equals
trait StaticAnnotation
class Annotation
class Object
trait Matchable
class Any
class TableSchema[E <: Product](`__tableName`: String, `__aliasName`: Option[String], `__cols`: List[ColumnExpr[_, _]]) extends AnyTable with Dynamic with SelectItem[E]

Attributes

Graph
Supertypes
trait SelectItem[E]
trait Dynamic
trait AnyTable
class Object
trait Matchable
class Any

Types

type AliasNames[T <: Tuple] = HasAliasName[T] match { case true => ExtractAliasNames[T] case false => EmptyTuple }
type ElementType[T <: Tuple, N <: Tuple, Name <: String] = (T, N) match { case (t *: tt, n *: nt) => n == Name match { case true => t match { case SqlDataType => t case Option[o] => o match { case SqlDataType => o } } case false => ElementType[tt, nt, Name] } case (EmptyTuple, EmptyTuple) => Nothing }
type ExprType[T <: Tuple] = T match { case h *: t => Expr[h] *: ExprType[t] case EmptyTuple => EmptyTuple }
type ExtractAliasNames[T <: Tuple] = T match { case AliasExpr[_$4, n] *: t => n *: ExtractAliasNames[t] case ColumnExpr[_$5, n] *: t => n *: ExtractAliasNames[t] case PrimaryKeyExpr[_$6, n] *: t => n *: ExtractAliasNames[t] case Any => EmptyTuple }
type FindTypeByName[T <: Tuple, I <: Int, Name <: String] = I >= 0 match { case true => Elem[T, I] match { case (t, n) => n == Name match { case true => t case false => FindTypeByName[T, I - 1, Name] } case Any => Nothing } case false => Nothing }
type HasAliasName[T <: Tuple] = T match { case AliasExpr[_$1, n] *: t => true && HasAliasName[t] case ColumnExpr[_$2, n] *: t => true && HasAliasName[t] case PrimaryKeyExpr[_$3, n] *: t => true && HasAliasName[t] case EmptyTuple => true case Any => false }
type InverseMap[X <: Tuple] = X match { case SelectItem[x] *: t => x *: InverseMap[t] case EmptyTuple => EmptyTuple }
type MapOption[T <: Tuple] = T match { case h *: t => Option[h] *: MapOption[t] case EmptyTuple => EmptyTuple }
type NonEmpty[T <: String] = T != ""
type ResultType[T <: Tuple] = T match { case (t) => Option[t] case Any => MapOption[T] }
type UnionTo[A, B] = A match { case B => B case SqlNumberType => B match { case SqlNumberType => BigDecimal } }
type UnionType[X <: Tuple, Y <: Tuple] = (X, Y) match { case (a *: at, b *: bt) => UnionTo[a, b] *: UnionType[at, bt] case (EmptyTuple, EmptyTuple) => EmptyTuple }
type UpdateType[T <: SqlDataType] = T match { case SqlNumberType => SqlNumberType case String => String case Boolean => Boolean case Date => Date | String }

Value members

Concrete methods

def all[T <: SqlDataType](query: Query[(T), _]): FuncExpr[Boolean]
def any[T <: SqlDataType](query: Query[(T), _]): FuncExpr[Boolean]
inline def asTable[T <: Product]: TableSchema[T]
def avg[T <: SqlNumberType](expr: Expr[T]): AggExpr[BigDecimal]
def caseWhen[T <: SqlDataType](branches: CaseBranch[T]*): CaseExpr[T]
def cast[T <: SqlDataType](expr: Expr[_], castType: String): CastExpr[T]
def col[T <: SqlDataType](columnName: String): IdentExpr[T]
def count(): AggExpr[Long]
def count(expr: Expr[_]): AggExpr[Long]
def countDistinct(expr: Expr[_]): AggExpr[Long]
def cube(expr: Expr[_]*): FuncExpr[Nothing]
inline def delete[T <: Product](pk: SqlDataType | Tuple): Delete
def deleteFrom(table: TableSchema[_]): Delete
def denseRank(): AggExpr[Long]
def dynamicSelect(columns: Expr[_]*): Select[EmptyTuple, EmptyTuple]
def exists[T <: SqlDataType](query: Query[(T), _]): FuncExpr[Boolean]
inline def find[T <: Product](pk: SqlDataType | Tuple): Select[(T), EmptyTuple]
def from[P <: Product](table: TableSchema[P]): Select[(P), EmptyTuple]
def groupingSets(expr: Expr[_] | Tuple | Unit*): FuncExpr[Nothing]
inline def insert[T <: Product](entities: T*): Insert[EmptyTuple, InsertEntity]
inline def insert[T <: Product](eneityList: List[T]): Insert[EmptyTuple, InsertEntity]
def insertInto(table: TableSchema[_])(columns: Tuple): Insert[InverseMap[Tuple], Nothing]
def max[T <: SqlDataType](expr: Expr[T]): AggExpr[T]
def min[T <: SqlDataType](expr: Expr[T]): AggExpr[T]
def notExists[T <: SqlDataType](query: Query[(T), _]): FuncExpr[Boolean]
def rank(): AggExpr[Long]
def rollup(expr: Expr[_]*): FuncExpr[Nothing]
def rowNumber(): AggExpr[Long]
inline def save[T <: Product](entity: T): Save
def select[U <: Tuple](items: U): Select[InverseMap[U], AliasNames[U]]
def select[I <: SqlDataType, E <: Expr[I]](item: E): Select[(I), AliasNames[(E)]]
def select[I <: SqlDataType, N <: String](item: AliasExpr[I, N]): Select[(I), (N)]
def select[P <: Product](table: TableSchema[P]): Select[(P), EmptyTuple]
def some[T <: SqlDataType](query: Query[(T), _]): FuncExpr[Boolean]
def sum[T <: SqlNumberType](expr: Expr[T]): AggExpr[BigDecimal]
def table(name: String): TableSchema[Nothing]
def truncate(table: TableSchema[_]): Truncate
def update(table: TableSchema[_]): Update
inline def update[T <: Product](entity: T, skipNone: Boolean): Update
def value[T <: SqlDataType](v: T): LiteralExpr[T]
def withQuery(query: AliasQuery[_, _]*): With[EmptyTuple]

Extensions

Extensions

extension [T <: SqlDataType](expr: ColumnExpr[T, _] | IdentExpr[T])
def to[V <: UpdateType[T]](value: Expr[V]): (ColumnExpr[T, _] | IdentExpr[T], Expr[V])
extension (s: StringContext)
def sql(args: SqlDataType | List[SqlDataType]*): String
extension (s: Select[_, _])
def toEsDsl: String
def toMongoDsl: String
Generated with
© 2002-2021 · LAMP/EPFL
© 2002-2021 · LAMP/EPFL