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

MySQL

class MySQL(url: String, username: String, password: String, options: <Error class: unknown class> = Driver.Pool.Options())

The MySQL class provides a driver implementation for interacting with a MySQL database. It supports connection pooling, transactional operations, and executing SQL queries.

The connection URL should follow the nex pattern, as described by MySQL.

The generic format of the connection URL: mysql:///database?properties

Parameters

url

The connection URL for the MySQL database.

username

The username for authenticating with the database.

password

The password for authenticating with the database.

options

The optional configuration for the connection pool, such as min/max connections and timeout settings.

Constructors

MySQL

constructor(url: String, username: String, password: String, options: <Error class: unknown class> = Driver.Pool.Options())

Types

Companion

object Companion

class Tx(var tx: <Error class: unknown class><out <Error class: unknown class>>)

Functions

begin

open suspend fun begin(): <Error class: unknown class><<Error class: unknown class>>

open suspend fun close(): <Error class: unknown class><Unit>

execute

open suspend fun execute(statement: <Error class: unknown class>): <Error class: unknown class><Long>

open suspend fun execute(sql: String): <Error class: unknown class><Long>

fetchAll

open suspend fun fetchAll(statement: <Error class: unknown class>): <Error class: unknown class><<Error class: unknown class>>

open suspend fun fetchAll(sql: String): <Error class: unknown class><<Error class: unknown class>>

open suspend fun <T> fetchAll(statement: <Error class: unknown class>, rowMapper: <Error class: unknown class><T>): <Error class: unknown class><List<T>>

migrate

open suspend fun migrate(path: String): <Error class: unknown class><Unit>

poolIdleSize

open fun poolIdleSize(): Int

poolSize

open fun poolSize(): Int