sqlx4k-postgres/io.github.smyrgeorge.sqlx4k.postgres/PostgreSQL

PostgreSQL

class PostgreSQL(host: String, port: Int, username: String, password: String, database: String, maxConnections: Int)

Constructors

PostgreSQL

constructor(host: String, port: Int, username: String, password: String, database: String, maxConnections: Int)

Types

Companion

object Companion

Notification

data class Notification(val channel: String, val value: String)

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>>

listen

suspend fun listen(channel: String, f: (PostgreSQL.Notification) -> Unit)

suspend fun listen(channels: List<String>, f: (PostgreSQL.Notification) -> Unit)

notify

suspend fun notify(channel: String, value: String)

We accept only String values, because only the text type is supported by postgres. https://www.postgresql.org/docs/current/sql-notify.html

poolIdleSize

open fun poolIdleSize(): Int

poolSize

open fun poolSize(): Int