ktorm-support-postgresql/org.ktorm.support.postgresql/DefaultValueExpression

DefaultValueExpression

data class DefaultValueExpression<T : Any>(val sqlType: SqlType<T>, val isLeafNode: Boolean = true, val extraProperties: Map<String, Any> = emptyMap()) : ScalarExpression<T> (source)

Default value expression, translated to the default keyword in PostgreSQL, used in insert statements.

For example:

insert into table (column1, column2) values (default, ?)

Constructors

DefaultValueExpression

constructor(sqlType: SqlType<T>, isLeafNode: Boolean = true, extraProperties: Map<String, Any> = emptyMap())

Properties

extraProperties

open override val extraProperties: Map<String, Any>

isLeafNode

open override val isLeafNode: Boolean = true

sqlType

open override val sqlType: SqlType<T>

Functions

aliased

open override fun aliased(label: String?): ColumnDeclaringExpression<T>

asExpression

open override fun asExpression(): ScalarExpression<T>

containedIn

@JvmName(name = "earthContainedIn")

fun ColumnDeclaring<Earth>.containedIn(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>

@JvmName(name = "earthContainedIn")

fun ColumnDeclaring<Earth>.containedIn(argument: Cube): CubeExpression<Boolean>

fun ColumnDeclaring<Cube>.containedIn(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>

fun ColumnDeclaring<Cube>.containedIn(argument: Cube): CubeExpression<Boolean>

Cube contained in operator, translated to the <@ operator in PostgreSQL.

fun ColumnDeclaring<HStore>.containedIn(argument: HStore): HStoreExpression<Boolean>

fun ColumnDeclaring<HStore>.containedIn(expr: ColumnDeclaring<HStore>): HStoreExpression<Boolean>

HStore contained-in operator, translated to the <@ operator in PostgreSQL.

contains

fun ColumnDeclaring<HStore>.contains(argument: HStore): HStoreExpression<Boolean>

fun ColumnDeclaring<HStore>.contains(expr: ColumnDeclaring<HStore>): HStoreExpression<Boolean>

HStore contains operator, translated to the @> operator in PostgreSQL.

@JvmName(name = "containsEarth")

fun ColumnDeclaring<Cube>.contains(argument: Earth): CubeExpression<Boolean>

@JvmName(name = "containsEarth")

fun ColumnDeclaring<Cube>.contains(expr: ColumnDeclaring<Earth>): CubeExpression<Boolean>

fun ColumnDeclaring<Cube>.contains(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>

fun ColumnDeclaring<Cube>.contains(argument: Cube): CubeExpression<Boolean>

Cube contains operator, translated to the @> operator in PostgreSQL.

containsAll

fun ColumnDeclaring<HStore>.containsAll(argument: TextArray): HStoreExpression<Boolean>

fun ColumnDeclaring<HStore>.containsAll(expr: ColumnDeclaring<TextArray>): HStoreExpression<Boolean>

HStore contains-all-keys operator, translated to the ?& operator in PostgreSQL.

containsAny

fun ColumnDeclaring<HStore>.containsAny(argument: TextArray): HStoreExpression<Boolean>

fun ColumnDeclaring<HStore>.containsAny(expr: ColumnDeclaring<TextArray>): HStoreExpression<Boolean>

HStore contains-any-keys operator, translated to the ?| operator in PostgreSQL.

containsKey

fun ColumnDeclaring<HStore>.containsKey(argument: String): HStoreExpression<Boolean>

fun ColumnDeclaring<HStore>.containsKey(expr: ColumnDeclaring<String>): HStoreExpression<Boolean>

HStore contains-key operator, translated to the ? operator in PostgreSQL.

get

@JvmName(name = "getValues")

operator fun ColumnDeclaring<HStore>.get(argument: TextArray): HStoreExpression<TextArray>

@JvmName(name = "getValues")

operator fun ColumnDeclaring<HStore>.get(expr: ColumnDeclaring<TextArray>): HStoreExpression<TextArray>

HStore get-values-for-keys operator, translated to the -> operator in PostgreSQL.

@JvmName(name = "getValue")

operator fun ColumnDeclaring<HStore>.get(argument: String): HStoreExpression<String>

@JvmName(name = "getValue")

operator fun ColumnDeclaring<HStore>.get(expr: ColumnDeclaring<String>): HStoreExpression<String>

HStore get-value-for-key operator, translated to the -> operator in PostgreSQL.

ilike

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

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

ILike operator, translated to the ilike keyword in PostgreSQL.

minus

@JvmName(name = "minusKeys")

operator fun ColumnDeclaring<HStore>.minus(argument: TextArray): HStoreExpression<HStore>

@JvmName(name = "minusKeys")

operator fun ColumnDeclaring<HStore>.minus(expr: ColumnDeclaring<TextArray>): HStoreExpression<HStore>

HStore delete-keys operator, translated to the - operator in PostgreSQL.

@JvmName(name = "minusKey")

operator fun ColumnDeclaring<HStore>.minus(argument: String): HStoreExpression<HStore>

@JvmName(name = "minusKey")

operator fun ColumnDeclaring<HStore>.minus(expr: ColumnDeclaring<String>): HStoreExpression<HStore>

HStore delete-key operator, translated to the - operator in PostgreSQL.

@JvmName(name = "minusMatching")

operator fun ColumnDeclaring<HStore>.minus(argument: HStore): HStoreExpression<HStore>

@JvmName(name = "minusMatching")

operator fun ColumnDeclaring<HStore>.minus(expr: ColumnDeclaring<HStore>): HStoreExpression<HStore>

HStore delete-matching-pairs operator, translated to the - operator in PostgreSQL.

overlaps

fun ColumnDeclaring<Cube>.overlaps(expr: ColumnDeclaring<Cube>): CubeExpression<Boolean>

fun ColumnDeclaring<Cube>.overlaps(argument: Cube): CubeExpression<Boolean>

Cube overlap operator, translated to the && operator in PostgreSQL.

plus

operator fun ColumnDeclaring<HStore>.plus(argument: HStore): HStoreExpression<HStore>

operator fun ColumnDeclaring<HStore>.plus(expr: ColumnDeclaring<HStore>): HStoreExpression<HStore>

HStore concatenate operator, translated to the || operator in PostgreSQL.

wrapArgument

open override fun wrapArgument(argument: T?): ArgumentExpression<T>