SqlServer

class SqlServer[+N <: NamingStrategy](val naming: N, val ds: DataSource) extends Quill[SQLServerDialect, N] with SqlServerJdbcTypes[SQLServerDialect, N]
Companion:
object
trait SqlServerJdbcTypes[SQLServerDialect, N]
trait UUIDStringEncoding
trait BooleanObjectEncoding
trait ObjectGenericTimeDecoders
trait ObjectGenericTimeEncoders
trait Quill[SQLServerDialect, N]
trait QuillBaseContext[SQLServerDialect, N]
trait ZioTranslateContext[SQLServerDialect, N]
trait ContextTranslateMacro[SQLServerDialect, N]
trait ContextTranslateProto[SQLServerDialect, N]
trait JdbcContextTypes[SQLServerDialect, N]
trait Decoders
trait Encoders
trait SqlContext[SQLServerDialect, N]
trait ZioContext[SQLServerDialect, N]
trait ContextVerbStream[SQLServerDialect, N]
trait ProtoStreamContext[SQLServerDialect, N]
trait Context[SQLServerDialect, N]
trait Closeable
trait AutoCloseable
trait EncodingDsl
trait LowPriorityImplicits
trait ProtoContextSecundus[SQLServerDialect, N]
trait RowContext
class Object
trait Matchable
class Any

Type members

Inherited classlikes

case class BatchGroup(string: String, prepare: List[Prepare])
Inherited from:
RowContext
case class BatchGroupReturning(string: String, returningBehavior: ReturnAction, prepare: List[Prepare])
Inherited from:
RowContext
Inherited from:
Context
case class JdbcDecoder[T](decoder: () => T) extends BaseDecoder[T]
Inherited from:
Decoders
case class JdbcEncoder[T](sqlType: Int, encoder: () => T) extends BaseEncoder[T]
Inherited from:
Encoders
class JdbcNullChecker extends BaseNullChecker
Inherited from:
JdbcContextTypes

Inherited types

type BaseDecoder[T] = GenericDecoder[ResultRow, Session, T, Specific]
Inherited from:
EncodingDsl
type BaseEncoder[T] = GenericEncoder[T, PrepareRow, Session]
Inherited from:
EncodingDsl
type BaseNullChecker = GenericNullChecker[ResultRow, Session]
Inherited from:
EncodingDsl
type ColumnResolver = GenericColumnResolver[ResultRow]
Inherited from:
EncodingDsl
type Decoder[T] = JdbcDecoder[T]
Inherited from:
Decoders
type DecoderMethod[T] = (Int, ResultRow, Session) => T
Inherited from:
EncodingDsl
type Encoder[T] = JdbcEncoder[T]
Inherited from:
Encoders
type EncoderMethod[T] = (Int, T, PrepareRow, Session) => PrepareRow
Inherited from:
EncodingDsl
override type Environment = Any
Inherited from:
QuillBaseContext
override type Error = SQLException
Inherited from:
QuillBaseContext
type Extractor[T] = (ResultRow, Session) => T
Inherited from:
RowContext
type Index = Int
Inherited from:
JdbcContextTypes
Inherited from:
JdbcContextTypes
type Prepare = (PrepareRow, Session) => (List[Any], PrepareRow)
Inherited from:
RowContext
override type PrepareRow = PreparedStatement
Inherited from:
QuillBaseContext
override type Result[T] = ZIO[Environment, Error, T]
Inherited from:
QuillBaseContext
override type ResultRow = ResultSet
Inherited from:
QuillBaseContext
type RowTyper[T] = GenericRowTyper[ResultRow, T]
Inherited from:
EncodingDsl
override type RunActionResult = Long
Inherited from:
QuillBaseContext
override type RunActionReturningResult[T] = T
Inherited from:
QuillBaseContext
override type RunBatchActionResult = List[Long]
Inherited from:
QuillBaseContext
override type RunBatchActionReturningResult[T] = List[T]
Inherited from:
QuillBaseContext
override type RunQueryResult[T] = List[T]
Inherited from:
QuillBaseContext
override type RunQuerySingleResult[T] = T
Inherited from:
QuillBaseContext
override type Runner = Unit
Inherited from:
QuillBaseContext
type RunnerBehavior <: RunnerSummoningBehavior
Inherited from:
ContextTranslateMacro
override type Session = Connection
Inherited from:
QuillBaseContext
override type StreamResult[T] = ZStream[Environment, Error, T]
Inherited from:
QuillBaseContext
override type TranslateResult[T] = ZIO[Environment, Error, T]
Inherited from:
QuillBaseContext
override type TranslateRunner = Unit
Inherited from:
QuillBaseContext

Value members

Inherited methods

inline def _streamInternal[T](inline quoted: Quoted[Query[T]], fetchSize: Option[Int]): StreamResult[T]

Internal API that cannot be made private due to how inline functions

Internal API that cannot be made private due to how inline functions

Inherited from:
ContextVerbStream

Internal API that cannot be made private due to how inline functions

Internal API that cannot be made private due to how inline functions

Inherited from:
ContextTranslateMacro
override def close(): Unit
Definition Classes
QuillBaseContext -> Context -> Closeable -> AutoCloseable
Inherited from:
QuillBaseContext
override protected def context: Runner
Definition Classes
QuillBaseContext -> Context
Inherited from:
QuillBaseContext
def decoder[T](f: ResultRow => Index => T): JdbcDecoder[T]
Inherited from:
Decoders
def decoder[T](d: (Int, ResultRow, Session) => T): JdbcDecoder[T]
Inherited from:
Decoders
def encoder[T](sqlType: Int, f: PrepareRow => (Index, T) => Unit): JdbcEncoder[T]
Inherited from:
Encoders
def encoder[T](sqlType: Int, f: (Index, T, PrepareRow) => Unit): JdbcEncoder[T]
Inherited from:
Encoders
def executeAction(sql: String, prepare: Prepare)(info: ExecutionInfo, dc: Runner): ZIO[Any, SQLException, Long]
Inherited from:
QuillBaseContext
def executeActionReturning[O](sql: String, prepare: Prepare, extractor: () => O, returningBehavior: ReturnAction)(info: ExecutionInfo, dc: Runner): ZIO[Any, SQLException, O]
Inherited from:
QuillBaseContext
def executeActionReturningMany[O](sql: String, prepare: Prepare, extractor: () => O, returningBehavior: ReturnAction)(info: ExecutionInfo, dc: Runner): ZIO[Any, SQLException, List[O]]
Inherited from:
QuillBaseContext
def executeBatchAction(groups: List[BatchGroup])(info: ExecutionInfo, dc: Runner): ZIO[Any, SQLException, List[Long]]
Inherited from:
QuillBaseContext
def executeBatchActionReturning[T](groups: List[BatchGroupReturning], extractor: () => T)(info: ExecutionInfo, dc: Runner): ZIO[Any, SQLException, List[T]]
Inherited from:
QuillBaseContext
def executeQuery[T](sql: String, prepare: Prepare, extractor: () => T)(info: ExecutionInfo, dc: Runner): ZIO[Any, SQLException, List[T]]
Inherited from:
QuillBaseContext
override def executeQuerySingle[T](sql: String, prepare: Prepare, extractor: () => T)(info: ExecutionInfo, dc: Runner): ZIO[Any, SQLException, T]
Definition Classes
QuillBaseContext -> ZioContext -> ProtoContextSecundus
Inherited from:
QuillBaseContext
protected def handleSingleResult[T](sql: String, list: List[T]): T
Inherited from:
Context
protected def jdbcEncodeInstant(value: Instant): Any
Inherited from:
ObjectGenericTimeEncoders
protected def jdbcTypeOfInstant: Int
Inherited from:
ObjectGenericTimeEncoders
protected def jdbcTypeOfLocalDate: Int
Inherited from:
ObjectGenericTimeEncoders
protected def jdbcTypeOfLocalDateTime: Int
Inherited from:
ObjectGenericTimeEncoders
protected def jdbcTypeOfLocalTime: Int
Inherited from:
ObjectGenericTimeEncoders
protected def jdbcTypeOfOffsetDateTime: Int
Inherited from:
ObjectGenericTimeEncoders
protected def jdbcTypeOfOffsetTime: Int
Inherited from:
ObjectGenericTimeEncoders
protected def jdbcTypeOfZonedDateTime: Int
Inherited from:
ObjectGenericTimeEncoders
inline def lift[T](inline runtimeValue: T): T
Inherited from:
Context
inline def liftQuery[U <: (Iterable), T](inline runtimeValue: U[T]): Query[T]
Inherited from:
Context
protected def mappedBaseDecoder[Base, Mapped](mapped: MappedEncoding[Base, Mapped], decoder: () => Base): () => Mapped
Inherited from:
EncodingDsl
protected def mappedBaseEncoder[Mapped, Base](mapped: MappedEncoding[Mapped, Base], encoder: () => Base): () => Mapped
Inherited from:
EncodingDsl
def parseJdbcType(intType: Int): String

Parses instances of java.sql.Types to string form so it can be used in creation of sql arrays. Some databases does not support each of generic types, hence it's welcome to override this method and provide alternatives to non-existent types.

Parses instances of java.sql.Types to string form so it can be used in creation of sql arrays. Some databases does not support each of generic types, hence it's welcome to override this method and provide alternatives to non-existent types.

Value parameters:
intType

one of java.sql.Types

Returns:

JDBC type in string form

Inherited from:
JdbcContextTypes
@tailrec
final protected def prepareParam(param: Any): String
Inherited from:
ContextTranslateProto
override def push[A, B](result: TranslateResult[A])(f: A => B): TranslateResult[B]
Definition Classes
ZioTranslateContext -> ContextTranslateProto
Inherited from:
ZioTranslateContext
@targetName("runBatchActionReturningDefault")
inline def run[I, T, A <: Action[I] & QAC[I, T]](inline quoted: Quoted[BatchAction[A]]): ZIO[Any, SQLException, List[T]]
Inherited from:
QuillBaseContext
@targetName("runBatchActionReturning")
inline def run[I, T, A <: Action[I] & QAC[I, T]](inline quoted: Quoted[BatchAction[A]], rowsPerBatch: Int): ZIO[Any, SQLException, List[T]]
Inherited from:
QuillBaseContext
@targetName("runBatchActionDefault")
inline def run[I, A <: Action[I] & QAC[I, Nothing]](inline quoted: Quoted[BatchAction[A]]): ZIO[Any, SQLException, List[Long]]
Inherited from:
QuillBaseContext
@targetName("runBatchAction")
inline def run[I, A <: Action[I] & QAC[I, Nothing]](inline quoted: Quoted[BatchAction[A]], rowsPerBatch: Int): ZIO[Any, SQLException, List[Long]]
Inherited from:
QuillBaseContext
@targetName("runActionReturningMany")
inline def run[E, T](inline quoted: Quoted[ActionReturning[E, List[T]]]): ZIO[Any, SQLException, List[T]]
Inherited from:
QuillBaseContext
@targetName("runActionReturning")
inline def run[E, T](inline quoted: Quoted[ActionReturning[E, T]]): ZIO[Any, SQLException, T]
Inherited from:
QuillBaseContext
@targetName("runAction")
inline def run[E](inline quoted: Quoted[Action[E]]): ZIO[Any, SQLException, Long]
Inherited from:
QuillBaseContext
@targetName("runQuerySingle")
inline def run[T](inline quoted: Quoted[T]): ZIO[Any, SQLException, T]
Inherited from:
QuillBaseContext
@targetName("runQuery")
inline def run[T](inline quoted: Quoted[Query[T]], inline wrap: OuterSelectWrap): ZIO[Any, SQLException, List[T]]
Inherited from:
QuillBaseContext
@targetName("runQueryDefault")
inline def run[T](inline quoted: Quoted[Query[T]]): ZIO[Any, SQLException, List[T]]
Inherited from:
QuillBaseContext
override def seq[A](list: List[TranslateResult[A]]): TranslateResult[List[A]]
Definition Classes
ZioTranslateContext -> ContextTranslateProto
Inherited from:
ZioTranslateContext
@targetName("streamQueryWithFetchSize")
inline def stream[T](inline quoted: Quoted[Query[T]], fetchSize: Int): StreamResult[T]
Inherited from:
ContextVerbStream
@targetName("streamQuery")
inline def stream[T](inline quoted: Quoted[Query[T]]): StreamResult[T]
Inherited from:
ContextVerbStream
def streamQuery[T](fetchSize: Option[Int], sql: String, prepare: Prepare, extractor: () => T)(info: ExecutionInfo, dc: Runner): ZStream[Any, SQLException, T]
Inherited from:
QuillBaseContext
def transaction[R, A](op: ZIO[R, Throwable, A]): ZIO[R, Throwable, A]

Execute instructions in a transaction. For example, to add a Person row to the database and return the contents of the Person table immediately after that:

Execute instructions in a transaction. For example, to add a Person row to the database and return the contents of the Person table immediately after that:

 val a = run(query[Person].insert(Person(...)): ZIO[Has[DataSource], SQLException, Long]
 val b = run(query[Person]): ZIO[Has[DataSource], SQLException, Person]
 transaction(a *> b): ZIO[Has[DataSource], SQLException, Person]
Inherited from:
QuillBaseContext
@targetName("translateBatchActionReturning")
inline def translate[I, T, A <: Action[I] & QAC[I, T]](inline quoted: Quoted[BatchAction[A]], inline prettyPrint: Boolean): TranslateResult[List[String]]
Inherited from:
ContextTranslateMacro
@targetName("translateBatchActionReturning")
inline def translate[I, T, A <: Action[I] & QAC[I, T]](inline quoted: Quoted[BatchAction[A]]): TranslateResult[List[String]]
Inherited from:
ContextTranslateMacro
@targetName("translateBatchAction")
inline def translate[I, A <: Action[I] & QAC[I, Nothing]](inline quoted: Quoted[BatchAction[A]], inline prettyPrint: Boolean): TranslateResult[List[String]]
Inherited from:
ContextTranslateMacro
@targetName("translateBatchAction")
inline def translate[I, A <: Action[I] & QAC[I, Nothing]](inline quoted: Quoted[BatchAction[A]]): TranslateResult[List[String]]
Inherited from:
ContextTranslateMacro
@targetName("translateActionReturning")
inline def translate[E, T](inline quoted: Quoted[ActionReturning[E, T]], inline prettyPrint: Boolean): TranslateResult[String]
Inherited from:
ContextTranslateMacro
@targetName("translateActionReturning")
inline def translate[E, T](inline quoted: Quoted[ActionReturning[E, T]]): TranslateResult[String]
Inherited from:
ContextTranslateMacro
@targetName("translateAction")
inline def translate[E](inline quoted: Quoted[Action[E]], inline prettyPrint: Boolean): TranslateResult[String]
Inherited from:
ContextTranslateMacro
@targetName("translateAction")
inline def translate[E](inline quoted: Quoted[Action[E]]): TranslateResult[String]
Inherited from:
ContextTranslateMacro
@targetName("translateQuerySingle")
inline def translate[T](inline quoted: Quoted[T], inline prettyPrint: Boolean): TranslateResult[String]
Inherited from:
ContextTranslateMacro
@targetName("translateQuerySingle")
inline def translate[T](inline quoted: Quoted[T]): TranslateResult[String]
Inherited from:
ContextTranslateMacro
@targetName("translateQuery")
inline def translate[T](inline quoted: Quoted[Query[T]], inline prettyPrint: Boolean): TranslateResult[String]
Inherited from:
ContextTranslateMacro
@targetName("translateQuery")
inline def translate[T](inline quoted: Quoted[Query[T]]): TranslateResult[String]
Inherited from:
ContextTranslateMacro
override def translateBatchQueryEndpoint(groups: List[BatchGroup], prettyPrint: Boolean)(executionInfo: ExecutionInfo, dc: Runner): TranslateResult[List[String]]
Definition Classes
QuillBaseContext -> ContextTranslateProto
Inherited from:
QuillBaseContext
def translateBatchQueryReturningEndpoint(groups: List[BatchGroupReturning], prettyPrint: Boolean)(executionInfo: ExecutionInfo, dc: TranslateRunner): TranslateResult[List[String]]
Inherited from:
ContextTranslateProto
override def translateQueryEndpoint[T](statement: String, prepare: Prepare, extractor: () => T, prettyPrint: Boolean)(executionInfo: ExecutionInfo, dc: Runner): TranslateResult[String]
Definition Classes
QuillBaseContext -> ContextTranslateProto
Inherited from:
QuillBaseContext
override def wrap[T](t: => T): TranslateResult[T]
Definition Classes
ZioTranslateContext -> ContextTranslateProto
Inherited from:
ZioTranslateContext

Concrete fields

override val ds: DataSource
val dsDelegate: ZioJdbcContext[SQLServerDialect, N]
val idiom: SQLServerDialect
val naming: N

Inherited fields

protected val dateTimeZone: TimeZone
Inherited from:
JdbcContextTypes
Inherited from:
RowContext
protected val identityPrepare: Prepare
Inherited from:
RowContext
final lazy val underlying: ZioJdbcContext[SQLServerDialect, N]
Inherited from:
QuillBaseContext

Extensions

Inherited extensions

extension [T](dynamicQuery: DynamicEntityQuery[T])
inline def insertValue(value: T): DynamicInsert[T]
Inherited from:
Context
inline def updateValue(value: T): DynamicUpdate[T]
Inherited from:
Context
extension [T](entity: EntityQuery[T])
inline def insertValue(inline value: T): Insert[T]
Inherited from:
Context
inline def updateValue(inline value: T): Update[T]
Inherited from:
Context
extension [T](q: Query[T])
inline def filterByKeys(inline map: Map[String, Any]): Query[T]

When using this with FilterColumns make sure it comes FIRST. Otherwise the columns are you filtering may have been nullified in the SQL before the filteration has actually happened.

When using this with FilterColumns make sure it comes FIRST. Otherwise the columns are you filtering may have been nullified in the SQL before the filteration has actually happened.

Inherited from:
Context
inline def filterColumns(inline columns: List[String]): Query[T]
Inherited from:
Context
extension [T](quotedEntity: Quoted[EntityQuery[T]])
inline def insertValue(inline value: T): Insert[T]
Inherited from:
Context
inline def updateValue(inline value: T): Update[T]
Inherited from:
Context

Implicits

Inherited implicits

implicit inline def anyValDecoder[Cls <: AnyVal]: JdbcDecoder[Cls]
Inherited from:
LowPriorityImplicits
implicit inline def anyValEncoder[Cls <: AnyVal]: JdbcEncoder[Cls]
Inherited from:
LowPriorityImplicits
implicit val bigDecimalDecoder: JdbcDecoder[BigDecimal]
Inherited from:
Decoders
implicit val bigDecimalEncoder: JdbcEncoder[BigDecimal]
Inherited from:
Encoders
implicit val booleanDecoder: JdbcDecoder[Boolean]
Inherited from:
BooleanObjectEncoding
implicit val booleanEncoder: JdbcEncoder[Boolean]
Inherited from:
BooleanObjectEncoding
implicit val byteArrayDecoder: JdbcDecoder[Array[Byte]]
Inherited from:
Decoders
implicit val byteArrayEncoder: JdbcEncoder[Array[Byte]]
Inherited from:
Encoders
implicit val byteDecoder: JdbcDecoder[Byte]
Inherited from:
Decoders
implicit val byteEncoder: JdbcEncoder[Byte]
Inherited from:
Encoders
implicit val dateDecoder: JdbcDecoder[Date]
Inherited from:
Decoders
implicit val dateEncoder: JdbcEncoder[Date]
Inherited from:
Encoders
implicit inline def dec[T]: GenericDecoder[ResultRow, Session, T, Generic]
Inherited from:
Context
implicit val doubleDecoder: JdbcDecoder[Double]
Inherited from:
Decoders
implicit val doubleEncoder: JdbcEncoder[Double]
Inherited from:
Encoders
implicit val floatDecoder: JdbcDecoder[Float]
Inherited from:
Decoders
implicit val floatEncoder: JdbcEncoder[Float]
Inherited from:
Encoders
implicit val instantDecoder: JdbcDecoder[Instant]
Inherited from:
ObjectGenericTimeDecoders
implicit val instantEncoder: JdbcEncoder[Instant]
Inherited from:
ObjectGenericTimeEncoders
implicit val intDecoder: JdbcDecoder[Int]
Inherited from:
Decoders
implicit val intEncoder: JdbcEncoder[Int]
Inherited from:
Encoders
implicit val localDateDecoder: JdbcDecoder[LocalDate]
Inherited from:
ObjectGenericTimeDecoders
implicit val localDateEncoder: JdbcEncoder[LocalDate]
Inherited from:
ObjectGenericTimeEncoders
implicit val localDateTimeDecoder: JdbcDecoder[LocalDateTime]
Inherited from:
ObjectGenericTimeDecoders
implicit val localDateTimeEncoder: JdbcEncoder[LocalDateTime]
Inherited from:
ObjectGenericTimeEncoders
implicit val localTimeDecoder: JdbcDecoder[LocalTime]
Inherited from:
ObjectGenericTimeDecoders
implicit val localTimeEncoder: JdbcEncoder[LocalTime]
Inherited from:
ObjectGenericTimeEncoders
implicit val longDecoder: JdbcDecoder[Long]
Inherited from:
Decoders
implicit val longEncoder: JdbcEncoder[Long]
Inherited from:
Encoders
implicit def mappedDecoder[I, O](implicit mapped: MappedEncoding[I, O], d: JdbcDecoder[I]): JdbcDecoder[O]
Inherited from:
Decoders
implicit override def mappedEncoder[I, O](implicit mapped: MappedEncoding[I, O], e: JdbcEncoder[O]): JdbcEncoder[I]
Definition Classes
Encoders -> EncodingDsl
Inherited from:
Encoders
Inherited from:
JdbcContextTypes
implicit val nullEncoder: JdbcEncoder[Null]
Inherited from:
Encoders
implicit val offseDateTimeEncoder: JdbcEncoder[OffsetDateTime]
Inherited from:
ObjectGenericTimeEncoders
implicit val offseTimeEncoder: JdbcEncoder[OffsetTime]
Inherited from:
ObjectGenericTimeEncoders
implicit val offsetDateTimeDecoder: JdbcDecoder[OffsetDateTime]
Inherited from:
ObjectGenericTimeDecoders
implicit val offsetTimeDecoder: JdbcDecoder[OffsetTime]
Inherited from:
ObjectGenericTimeDecoders
implicit def optionDecoder[T](implicit d: JdbcDecoder[T]): JdbcDecoder[Option[T]]
Inherited from:
Decoders
implicit def optionEncoder[T](implicit d: JdbcEncoder[T]): JdbcEncoder[Option[T]]
Inherited from:
Encoders
implicit val shortDecoder: JdbcDecoder[Short]
Inherited from:
Decoders
implicit val shortEncoder: JdbcEncoder[Short]
Inherited from:
Encoders
implicit val sqlDateDecoder: JdbcDecoder[Date]
Inherited from:
Decoders
implicit val sqlDateEncoder: JdbcEncoder[Date]
Inherited from:
Encoders
implicit val sqlTimeDecoder: JdbcDecoder[Time]
Inherited from:
Decoders
implicit val sqlTimeEncoder: JdbcEncoder[Time]
Inherited from:
Encoders
implicit val sqlTimestampDecoder: JdbcDecoder[Timestamp]
Inherited from:
Decoders
implicit val sqlTimestampEncoder: JdbcEncoder[Timestamp]
Inherited from:
Encoders
implicit val stringDecoder: JdbcDecoder[String]
Inherited from:
Decoders
implicit val stringEncoder: JdbcEncoder[String]
Inherited from:
Encoders
implicit val uuidDecoder: JdbcDecoder[UUID]
Inherited from:
UUIDStringEncoding
implicit val uuidEncoder: JdbcEncoder[UUID]
Inherited from:
UUIDStringEncoding
implicit val zonedDateTimeDecoder: JdbcDecoder[ZonedDateTime]
Inherited from:
ObjectGenericTimeDecoders
implicit val zonedDateTimeEncoder: JdbcEncoder[ZonedDateTime]
Inherited from:
ObjectGenericTimeEncoders