dataprism-common
DocsAPI
Generated with
dataprism-common/dataprism/dataprism.platform/dataprism.platform.sql/dataprism.platform.sql.query/SqlQueriesBase

SqlQueriesBase

dataprism.platform.sql.query.SqlQueriesBase
trait SqlQueriesBase extends SqlQueryPlatformBase, SqlDbValuesBase

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Show all
Known subtypes
trait SqlQueries
trait H2Platform
Show all
Self type

Members list

Type members

Classlikes

trait DistinctOnCapability

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait ExceptAllCapability

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait ExceptCapability

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait IntersectAllCapability

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait IntersectCapability

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait LateralJoinCapability

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes
case class QueryAstMetadata[A[_[_]]](ast: SelectAst[Codec], aliases: A[Const[String]], values: A[DbValue])

Attributes

Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
Show all
trait SqlQueryApi

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait H2Api
trait MySqlApi
trait PostgresApi
trait SqliteApi
trait SqlQueryBase[A[_[_]]] extends QueryBase[A]

Attributes

Supertypes
trait QueryBase[A]
class Object
trait Matchable
class Any
Known subtypes
trait SqlQuery[A]
trait SqlQueryGrouped[A]
class SqlQueryGroupedHavingStage[A, Gr, Ma]
class SqlQueryFlatMap[A, B]
class SqlQueryMapWhereStage[A, B]
class SqlQueryValues[A]
Show all
trait SqlQueryCompanion

Attributes

Supertypes
class Object
trait Matchable
class Any
Known subtypes

Inherited classlikes

trait BinOp[LHS, RHS, R]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
class ArrayConcatBinOp[A, LHS, RHS]
enum FundamentalBinOp[LHS, RHS, R]
case Eq[A]
case Neq[A]
case LessThan[A]
case LessOrEqual[A]
case GreaterThan[A]
case GreaterOrEqual[A]
case And[A]
case Or[A]
case Plus[A]
case Minus[A]
case Multiply[A]
case Divide[A]
case Remainder[A]
case NullableOp[LHS1, RHS1, R1]
enum SqlBitwiseBinOp[A]
case And[A]
case Or[A]
case Xor[A]
class SqlStringLikeOp[A]
Show all
trait ConditionCase[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait DbValueBase[A]

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait SqlDbValueBase[A]
enum SqlDbValue[A]
case JoinNullable[B]
case UnaryOp[B, R]
case BinOp[B, C, R]
case AsSome[B]
case Null[B]
case IsNull[B]
case IsNotNull[B]
case InValues[B, R]
case NotInValues[B, R]
case InQuery[B, R]
case NotInQuery[B, R]
case ValueCase[V, R]
Show all
trait FullJoinCapability

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
Known subtypes
object Lift

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
trait Lift[A, B]

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
trait ManyCompanion

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
object Many
object Nullability

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
trait Nullability[A] extends NullabilityBase[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
trait NullabilityBase[A]
class Object
trait Matchable
class Any
trait NullabilityBase[A]

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait Nullability[A]
trait OrdSeqBase

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait OrdSeq
class MultiOrdSeq
enum Ord
trait QueryApi

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait H2Api
trait MySqlApi
trait PostgresApi
trait SqliteApi
trait QueryBase[A[_[_]]]

Attributes

Inherited from:
QueryPlatform
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait QueryGroupedBase[A]
trait SqlQueryGrouped[A]
class SqlQueryGroupedHavingStage[A, Gr, Ma]
trait SqlQueryBase[A]
trait SqlQuery[A]
class SqlQueryFlatMap[A, B]
class SqlQueryMapWhereStage[A, B]
class SqlQueryValues[A]
Show all
trait QueryGroupedBase[A[_[_]]] extends QueryBase[A]

Attributes

Inherited from:
QueryPlatform
Supertypes
trait QueryBase[A]
class Object
trait Matchable
class Any
Known subtypes
trait SqlQueryGrouped[A]
class SqlQueryGroupedHavingStage[A, Gr, Ma]
trait SqlBaseImpl

Attributes

Inherited from:
SqlQueryPlatformBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait SqlCaseCompanion

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait SqlDbValueApi

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait H2Api
trait MySqlApi
trait PostgresApi
trait SqliteApi
trait SqlDbValueBase[A] extends DbValueBase[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
trait DbValueBase[A]
class Object
trait Matchable
class Any
Known subtypes
enum SqlDbValue[A]
case JoinNullable[B]
case UnaryOp[B, R]
case BinOp[B, C, R]
case AsSome[B]
case Null[B]
case IsNull[B]
case IsNotNull[B]
case InValues[B, R]
case NotInValues[B, R]
case InQuery[B, R]
case NotInQuery[B, R]
case ValueCase[V, R]
Show all
trait SqlDbValueCompanion

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait SqlFractionalBase[A] extends SqlNumericBase[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
trait SqlNumericBase[A]
trait SqlOrderedBase[A]
class Object
trait Matchable
class Any
Known subtypes
trait SqlFractional[A]
trait SqlIntegralBase[A] extends SqlNumericBase[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
trait SqlNumericBase[A]
trait SqlOrderedBase[A]
class Object
trait Matchable
class Any
Known subtypes
trait SqlIntegral[A]
trait SqlLogicBase[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait SqlLogic[A]
trait SqlNumericBase[A] extends SqlOrderedBase[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
trait SqlOrderedBase[A]
class Object
trait Matchable
class Any
Known subtypes
trait SqlFractional[A]
trait SqlIntegralBase[A]
trait SqlIntegral[A]
trait SqlNumeric[A]
trait SqlOrdSeqBase extends OrdSeqBase

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
trait OrdSeqBase
class Object
trait Matchable
class Any
Known subtypes
trait OrdSeq
class MultiOrdSeq
enum Ord
trait SqlOrderedBase[A](using val n: NullabilityOf[A])

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait SqlNumericBase[A]
trait SqlFractional[A]
trait SqlIntegralBase[A]
trait SqlIntegral[A]
trait SqlNumeric[A]
trait SqlOrdered[A]
Show all
trait SqlTaggedState

Attributes

Inherited from:
SqlQueryPlatformBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
class TaggedState
trait SqlValuesBaseImpl

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait UnaryOp[V, R]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
enum FundamentalUnaryOp[V, R]
case Not[A]
case Negative[A]
case NullableOp[V1, R1]
class SqlBitwiseNotOp[A]
trait ValueCase0[A]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
trait ValueCase1[A, B]

Attributes

Inherited from:
SqlDbValuesBase
Supertypes
class Object
trait Matchable
class Any
Known subtypes
class DefaultValueCase1[A, B]

Types

type Query[A[_[_]]] <: SqlQueryBase[A]

Inherited types

type AnyDbValue <: DbValue[Any]

Attributes

Inherited from:
SqlDbValuesBase
type CaseCompanion <: SqlCaseCompanion

Attributes

Inherited from:
SqlDbValuesBase
type CastType[A]

Attributes

Inherited from:
SqlDbValuesBase
type Codec[_]

Attributes

Inherited from:
SqlQueryPlatformBase
type DbMath

Attributes

Inherited from:
SqlDbValuesBase
override type DbValue[A] <: SqlDbValueBase[A]

Attributes

Inherited from:
SqlDbValuesBase
type DbValueCompanion <: SqlDbValueCompanion

Attributes

Inherited from:
SqlDbValuesBase
type FullJoin[A[_[_]], B[_[_]]] = [F[_]] =>> (A[Compose2[F, Nullable]], B[Compose2[F, Nullable]])

Attributes

Inherited from:
QueryPlatform
type Impl <: SqlValuesBaseImpl & SqlBaseImpl

Attributes

Inherited from:
SqlDbValuesBase
type InFilterCapability

Attributes

Inherited from:
QueryPlatform
type InGroupByCapability

Attributes

Inherited from:
QueryPlatform
type InHavingCapability

Attributes

Inherited from:
QueryPlatform
type InJoinConditionCapability

Attributes

Inherited from:
QueryPlatform
type InMapCapability

Attributes

Inherited from:
QueryPlatform
type InOrderByCapability

Attributes

Inherited from:
QueryPlatform
type InnerJoin[A[_[_]], B[_[_]]] = [F[_]] =>> (A[F], B[F])

Attributes

Inherited from:
QueryPlatform
type LeftJoin[A[_[_]], B[_[_]]] = [F[_]] =>> (A[F], B[Compose2[F, Nullable]])

Attributes

Inherited from:
QueryPlatform
type Many[A]

Attributes

Inherited from:
SqlDbValuesBase
type NullabilityOf[A] = A match { case Option[b] => Aux[A, b, Option] case Any => Aux[A, A, Id] }

Attributes

Inherited from:
SqlDbValuesBase
type Nullable[A] = A match { case Option[b] => Option[b] case Any => Option[A] }

Attributes

Inherited from:
QueryPlatform
type Ord <: OrdSeq

Attributes

Inherited from:
QueryPlatform
type OrdSeq <: SqlOrdSeqBase

Attributes

Inherited from:
SqlDbValuesBase
type QueryGrouped[A[_[_]]] <: QueryGroupedBase[A] & Query[A]

Attributes

Inherited from:
QueryPlatform
type RightJoin[A[_[_]], B[_[_]]] = [F[_]] =>> (A[Compose2[F, Nullable]], B[F])

Attributes

Inherited from:
QueryPlatform
type SqlFractional[A] <: SqlNumeric[A] & SqlFractionalBase[A]

Attributes

Inherited from:
SqlDbValuesBase
type SqlIntegral[A] <: SqlNumeric[A] & SqlIntegralBase[A]

Attributes

Inherited from:
SqlDbValuesBase
type SqlLogic[A] <: SqlLogicBase[A]

Attributes

Inherited from:
SqlDbValuesBase
type SqlNumeric[A] <: SqlNumericBase[A] & SqlOrdered[A]

Attributes

Inherited from:
SqlDbValuesBase
type SqlOrdered[A] <: SqlOrderedBase[A]

Attributes

Inherited from:
SqlDbValuesBase
type TagState[A] = State[TaggedState, A]

Attributes

Inherited from:
SqlQueryPlatformBase
type TaggedState <: SqlTaggedState

Attributes

Inherited from:
SqlQueryPlatformBase
type Type[A] = SelectedType[Codec, A]

Attributes

Inherited from:
SqlQueryPlatformBase

Value members

Inherited methods

protected def freshTaggedState: TaggedState

Attributes

Inherited from:
SqlQueryPlatformBase

Inherited fields

val AnsiTypes: AnsiTypes[Codec]

Attributes

Inherited from:
SqlQueryPlatformBase
val Api: Api

Attributes

Inherited from:
QueryPlatform
val Case: CaseCompanion

Attributes

Inherited from:
SqlDbValuesBase
val DbMath: DbMath

Attributes

Inherited from:
SqlDbValuesBase
val DbValue: DbValueCompanion

Attributes

Inherited from:
SqlDbValuesBase
protected val Impl: Impl

Attributes

Inherited from:
SqlQueryPlatformBase
protected val InFilterCapability: InFilterCapability

Attributes

Inherited from:
QueryPlatform
protected val InGroupByCapability: InGroupByCapability

Attributes

Inherited from:
QueryPlatform
protected val InHavingCapability: InHavingCapability

Attributes

Inherited from:
QueryPlatform
protected val InJoinConditionCapability: InJoinConditionCapability

Attributes

Inherited from:
QueryPlatform
protected val InMapCapability: InMapCapability

Attributes

Inherited from:
QueryPlatform
protected val InOrderByCapability: InOrderByCapability

Attributes

Inherited from:
QueryPlatform
val Many: ManyCompanion

Attributes

Inherited from:
SqlDbValuesBase
val Query: QueryCompanion

Attributes

Inherited from:
QueryPlatform
lazy val sqlRenderer: AstRenderer[Codec]

Attributes

Inherited from:
SqlQueryPlatformBase

Givens

Inherited givens

given booleanOptSqlLogic: SqlLogic[Option[Boolean]]

Attributes

Inherited from:
SqlDbValuesBase
given booleanSqlLogic: SqlLogic[Boolean]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericBigDecimal: SqlFractional[BigDecimal]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericDouble: SqlFractional[Double]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericFloat: SqlFractional[Float]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericInt: SqlIntegral[Int]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericLong: SqlIntegral[Long]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericOptDouble: SqlFractional[Option[Double]]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericOptFloat: SqlFractional[Option[Float]]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericOptInt: SqlIntegral[Option[Int]]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericOptLong: SqlIntegral[Option[Long]]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericOptShort: SqlIntegral[Option[Short]]

Attributes

Inherited from:
SqlDbValuesBase
given sqlNumericShort: SqlIntegral[Short]

Attributes

Inherited from:
SqlDbValuesBase

Extensions

Extensions

extension [A](query: Query[[F[_]] =>> F[A]])
def asDbValue: DbValue[A]

Inherited extensions

extension [A](optVal: DbValue[Option[A]])(using ev: NotGiven[A <:< Option[_]])
def filter(f: (DbValue[A]) => DbValue[Boolean]): DbValue[Option[A]]

Attributes

Inherited from:
SqlDbValuesBase
def flatMap[B](f: (DbValue[A]) => DbValue[Option[B]]): DbValue[Option[B]]

Attributes

Inherited from:
SqlDbValuesBase
def getOrElse(other: DbValue[A]): DbValue[A]

Attributes

Inherited from:
SqlDbValuesBase
def isDefined: DbValue[Boolean]

Attributes

Inherited from:
SqlDbValuesBase
def isEmpty: DbValue[Boolean]

Attributes

Inherited from:
SqlDbValuesBase
def map[B](f: (DbValue[A]) => DbValue[B]): DbValue[Option[B]]

Attributes

Inherited from:
SqlDbValuesBase
def orElse(other: DbValue[Option[A]]): DbValue[Option[A]]

Attributes

Inherited from:
SqlDbValuesBase
def unsafeGet: DbValue[A]

Attributes

Inherited from:
SqlDbValuesBase
extension [A](t: CastType[A])
def castTypeName: String

Attributes

Inherited from:
SqlDbValuesBase
def castTypeType: Type[A]

Attributes

Inherited from:
SqlDbValuesBase
extension [T](t: T)(using mr: MapRes[Many, T])
def mapManyN[B](f: (mr.K[DbValue]) => DbValue[B]): Many[B]

Attributes

Inherited from:
SqlDbValuesBase
extension [T](t: T)(using mr: MapRes[Compose2[DbValue, Option], T])
def mapNullableN[B](f: (mr.K[DbValue]) => DbValue[B]): DbValue[Option[B]]

Attributes

Inherited from:
SqlDbValuesBase
extension [A](tpe: Codec[A])
def name: String

Attributes

Inherited from:
SqlQueryPlatformBase
extension [A](tpe: Type[A])
def name: String

Attributes

Inherited from:
SqlQueryPlatformBase
extension [A](tpe: Type[A])
def typedChoice(using NotGiven[A <:< Option[_]]): NullabilityTypeChoice[Codec, A, tpe.Dimension]

Attributes

Inherited from:
SqlQueryPlatformBase
extension [A](tpe: Type[Option[A]])
def typedChoice: NullabilityTypeChoice[Codec, A, tpe.Dimension]

Attributes

Inherited from:
SqlQueryPlatformBase
extension [A](v: A)
def as(tpe: Type[A]): DbValue[A]

Attributes

Inherited from:
SqlDbValuesBase
def asNullable(tpe: Type[A])(using NotGiven[A <:< Option[_]]): DbValue[Option[A]]

Attributes

Inherited from:
SqlDbValuesBase
Generated with