DBConnection

Functions

fun execute(query: String, block: Execute.() -> Unit = {})

fun <T> executeBatch(query: String, elements: Iterable<T>, block: ExecuteBatch<T>.() -> Unit = {})

Executes the given SQL query and returns the generated key.

fun <T : Any> queryFirst(query: String, block: Query<T>.() -> Unit): T

Executes a query and retrieves the first result.

fun <T> queryFirstOrNull(query: String, block: Query<T>.() -> Unit): T?

fun <T : Any> queryList(query: String, block: Query<T>.() -> Unit): List<T>

fun <T : Any> querySet(query: String, block: Query<T>.() -> Unit): Set<T>