SQL

ldbc.sql.SQL
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

Source
SQL.scala
Graph
Supertypes
class Object
trait Matchable
class Any

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], logHandler: LogHandler[F]): Kleisli[F, Connection[F], T]

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 update(using logHandler: LogHandler[F]): Kleisli[F, Connection[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

inline def headOption[T <: Tuple](using LogHandler[F]): Kleisli[F, Connection[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], logHandler: LogHandler[F]): Kleisli[F, Connection[F], Option[P]]

Attributes

Source
SQL.scala
inline def toList[T <: Tuple](using FactoryCompat[T, List[T]], LogHandler[F]): Kleisli[F, Connection[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], logHandler: LogHandler[F], factory: FactoryCompat[P, List[P]]): Kleisli[F, Connection[F], List[P]]

Attributes

Source
SQL.scala
inline def unsafe[T <: Tuple](using MonadError[F, Throwable], LogHandler[F]): Kleisli[F, Connection[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], logHandler: LogHandler[F], ev: MonadError[F, Throwable]): Kleisli[F, Connection[F], P]

Attributes

Source
SQL.scala