sqlx4k-mysql/io.github.smyrgeorge.sqlx4k.mysql/IMySQL

IMySQL

interface IMySQL : Driver, Migrator.Driver(source)

Inheritors

MySQL

Types

Companion

object Companion

Properties

encoders

abstract val encoders: ValueEncoderRegistry

Functions

acquire

abstract suspend fun acquire(): Result<Connection>

begin

abstract suspend fun begin(): Result<Transaction>

abstract suspend fun close(): Result<Unit>

execute

abstract suspend fun execute(statement: Statement): Result<Long>

abstract suspend fun execute(@Language(value = "SQL") sql: String): Result<Long>

executeWithResult

open suspend fun executeWithResult(statement: Statement): Result<ExecuteResult>

open suspend fun executeWithResult(@Language(value = "SQL") sql: String): Result<ExecuteResult>

fetch

abstract fun fetch(statement: Statement, fetchSize: Int): Flow<ResultSet.Row>

abstract fun fetch(@Language(value = "SQL") sql: String, fetchSize: Int): Flow<ResultSet.Row>

open fun <T> fetch(statement: Statement, rowMapper: RowMapper<T>, fetchSize: Int): Flow<T>

open fun <T> fetch(@Language(value = "SQL") sql: String, rowMapper: RowMapper<T>, fetchSize: Int): Flow<T>

fetchAll

abstract suspend fun fetchAll(statement: Statement): Result<ResultSet>

abstract suspend fun fetchAll(@Language(value = "SQL") sql: String): Result<ResultSet>

open suspend fun <T> fetchAll(statement: Statement, rowMapper: RowMapper<T>): Result<List<T>>

open suspend fun <T> fetchAll(@Language(value = "SQL") sql: String, rowMapper: RowMapper<T>): Result<List<T>>

migrate

abstract suspend fun migrate(supplier: () -> List<MigrationFile>, table: String, schema: String?, createSchema: Boolean, afterStatementExecution: suspend (Statement, Duration) -> Unit, afterFileMigration: suspend (Migration, Duration) -> Unit): Result<Migrator.Results>

abstract suspend fun migrate(path: String, table: String, schema: String?, createSchema: Boolean, afterStatementExecution: suspend (Statement, Duration) -> Unit, afterFileMigration: suspend (Migration, Duration) -> Unit): Result<Migrator.Results>

abstract suspend fun migrate(files: List<MigrationFile>, table: String, schema: String?, createSchema: Boolean, afterStatementExecution: suspend (Statement, Duration) -> Unit, afterFileMigration: suspend (Migration, Duration) -> Unit): Result<Migrator.Results>

poolIdleSize

abstract fun poolIdleSize(): Int

poolSize

abstract fun poolSize(): Int

transaction

open suspend fun <T> transaction(f: suspend Transaction.() -> T): T

transactionCatching

open suspend fun <T> transactionCatching(f: suspend Transaction.() -> T): Result<T>

withSingleConnection

suspend fun <T> QueryExecutor.withSingleConnection(block: suspend (QueryExecutor) -> Result<T>): Result<T>

Runs block on a single database connection: this executor itself when it already is one (a connection or a transaction), or a connection borrowed from it for the duration of block when it is a pool.