SQL

ldbc.dsl.SQL
See theSQL companion object
trait SQL[F[_]]

A model with a query string and parameters to be bound to the query string that is executed by PreparedStatement, etc.

Type parameters

F

The effect type

Attributes

Companion
object
Source
SQL.scala
Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes
class Mysql[F]

Members list

Value members

Abstract methods

def ++(sql: SQL[F]): SQL[F]

Attributes

Source
SQL.scala

statement has '?' that the statement has.

statement has '?' that the statement has.

Attributes

Source
SQL.scala
def returning[T <: String | Int | Long](using reader: ResultSetReader[F, T]): Executor[F, T]

Methods that return values automatically generated by SQL statements.

Methods that return values automatically generated by SQL statements.

Attributes

Source
SQL.scala

an SQL statement that may contain one or more '?' IN parameter placeholders

an SQL statement that may contain one or more '?' IN parameter placeholders

Attributes

Source
SQL.scala
def to[T](using consumer: ResultSetConsumer[F, T]): Executor[F, T]

Attributes

Source
SQL.scala
def update: Executor[F, Int]

A method to return the number of rows updated by the SQL statement.

A method to return the number of rows updated by the SQL statement.

Attributes

Source
SQL.scala

Concrete methods

def headOption[T](using reader: ResultSetReader[F, T]): Executor[F, Option[T]]

A method to return the data to be retrieved from the database as Option type. If there are multiple data, the first one is retrieved.

A method to return the data to be retrieved from the database as Option type. If there are multiple data, the first one is retrieved.

Attributes

Source
SQL.scala
inline def headOption[P <: Product](using mirror: ProductOf[P]): Executor[F, Option[P]]

Attributes

Source
SQL.scala
def toList[T](using reader: ResultSetReader[F, T]): Executor[F, List[T]]

Methods for returning an array of data to be retrieved from the database.

Methods for returning an array of data to be retrieved from the database.

Attributes

Source
SQL.scala
inline def toList[P <: Product](using mirror: ProductOf[P]): Executor[F, List[P]]

Attributes

Source
SQL.scala
def unsafe[T](using reader: ResultSetReader[F, T], ev: MonadThrow[F]): Executor[F, T]

A method to return the data to be retrieved from the database as is. If the data does not exist, an exception is raised. Use the headOption method if you want to retrieve individual data.

A method to return the data to be retrieved from the database as is. If the data does not exist, an exception is raised. Use the headOption method if you want to retrieve individual data.

Attributes

Source
SQL.scala
inline def unsafe[P <: Product](using mirror: ProductOf[P], ev: MonadThrow[F]): Executor[F, P]

Attributes

Source
SQL.scala