English | 简体中文

api-docs / me.liuwj.ktorm.support.postgresql

Package me.liuwj.ktorm.support.postgresql

PostgreSQL dialect module for Ktorm.

Types

NameSummary

ILikeExpression

data class ILikeExpression : ScalarExpression<Boolean>

ILike expression, represents PostgreSQL’s ilike keyword.

InsertOrUpdateExpression

data class InsertOrUpdateExpression : SqlExpression

Insert or update expression, represents an insert statement with an
on conflict (key) do update set clause in PostgreSQL.

InsertOrUpdateStatementBuilder

class InsertOrUpdateStatementBuilder : AssignmentsBuilder

DSL builder for insert or update statements.

PostgreSqlDialect

open class PostgreSqlDialect : SqlDialect

SqlDialect implementation for PostgreSQL database.

PostgreSqlExpressionVisitor

open class PostgreSqlExpressionVisitor : SqlExpressionVisitor

Base class designed to visit or modify PostgreSQL’s expression trees using visitor pattern.

PostgreSqlFormatter

open class PostgreSqlFormatter : SqlFormatter

SqlFormatter implementation for PostgreSQL, formatting SQL expressions as strings with their execution arguments.

Functions

NameSummary

ilike

infix fun ColumnDeclaring<>.ilike(
    expr: ColumnDeclaring<String>
): ILikeExpression

infix fun ColumnDeclaring<>.ilike(
    argument: String
): ILikeExpression

ILike operator, translated to the ilike keyword in PostgreSQL.

insertOrUpdate

fun <T : BaseTable<*>> T.insertOrUpdate(
    block: InsertOrUpdateStatementBuilder.(T) -> Unit
): Int

Insert a record to the table, determining if there is a key conflict while it’s being inserted, and automatically
performs an update if any conflict exists.