ktorm-core/org.ktorm.expression/WindowFunctionExpression

WindowFunctionExpression

data class WindowFunctionExpression<T : Any>(val type: WindowFunctionType, val arguments: List<ScalarExpression<*>>, val isDistinct: Boolean = false, val window: WindowSpecificationExpression = WindowSpecificationExpression(), val sqlType: SqlType<T>, val isLeafNode: Boolean = false, val extraProperties: Map<String, Any> = emptyMap()) : ScalarExpression<T> (source)

Window function expression, represents a SQL window function call.

Since

3.6.0

Constructors

WindowFunctionExpression

constructor(type: WindowFunctionType, arguments: List<ScalarExpression<*>>, isDistinct: Boolean = false, window: WindowSpecificationExpression = WindowSpecificationExpression(), sqlType: SqlType<T>, isLeafNode: Boolean = false, extraProperties: Map<String, Any> = emptyMap())

Properties

val arguments: List<ScalarExpression<*>>

the arguments passed to the window function.

extraProperties

open override val extraProperties: Map<String, Any>

Extra properties of this expression, maybe useful in SqlFormatter to generate some special SQLs.

val isDistinct: Boolean = false

mark if this function is distinct.

open override val isLeafNode: Boolean = false

Check if this expression is a leaf node in expression trees.

open override val sqlType: SqlType<T>

The SqlType of this column or expression.

val type: WindowFunctionType

the type of the window function.

val window: WindowSpecificationExpression

the window specification.

Functions

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

Wrap this instance as a ColumnDeclaringExpression.

infix fun ColumnDeclaring<Boolean>.and(value: Boolean): BinaryExpression<Boolean>

infix fun ColumnDeclaring<Boolean>.and(expr: ColumnDeclaring<Boolean>): BinaryExpression<Boolean>

And operator, translated to the and keyword in SQL.

fun ColumnDeclaring<*>.asc(): OrderByExpression

Order this column or expression in ascending order.

open override fun asExpression(): ScalarExpression<T>

Convert this instance to a ScalarExpression.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.between(range: ClosedRange<T>): BetweenExpression

Between operator, translated to between .. and .. in SQL.

fun <T : Any> ColumnDeclaring<*>.cast(sqlType: SqlType<T>): CastingExpression<T>

Cast the current column or expression to the given SqlType.

fun ColumnDeclaring<*>.desc(): OrderByExpression

Order this column or expression in descending order, corresponding to the desc keyword in SQL.

infix operator fun <T : Number> ColumnDeclaring<T>.div(value: T): BinaryExpression<T>

infix operator fun <T : Number> ColumnDeclaring<T>.div(expr: ColumnDeclaring<T>): BinaryExpression<T>

Divide operator, translated to / in SQL.

infix fun <T : Any> ColumnDeclaring<T>.eq(value: T): BinaryExpression<Boolean>

infix fun <T : Any> ColumnDeclaring<T>.eq(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Equal operator, translated to = in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.greater(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.greater(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Greater operator, translated to > in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.greaterEq(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.greaterEq(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Greater-eq operator, translated to >= in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.gt(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.gt(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Greater operator, translated to > in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.gte(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.gte(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Greater-eq operator, translated to >= in SQL.

infix fun ColumnDeclaring<*>.inList(query: Query): InListExpression

fun <T : Any> ColumnDeclaring<T>.inList(vararg list: T): InListExpression

infix fun <T : Any> ColumnDeclaring<T>.inList(list: Collection<T>): InListExpression

In-list operator, translated to the in keyword in SQL.

fun ColumnDeclaring<*>.isNotNull(): UnaryExpression<Boolean>

Check if the current column or expression is not null, translated to is not null in SQL.

fun ColumnDeclaring<*>.isNull(): UnaryExpression<Boolean>

Check if the current column or expression is null, translated to is null in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.less(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.less(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Less operator, translated to < in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.lessEq(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.lessEq(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Less-eq operator, translated to <= in SQL.

infix fun ColumnDeclaring<*>.like(value: String): BinaryExpression<Boolean>

infix fun ColumnDeclaring<*>.like(expr: ColumnDeclaring<String>): BinaryExpression<Boolean>

Like operator, translated to the like keyword in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.lt(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.lt(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Less operator, translated to < in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.lte(value: T): BinaryExpression<Boolean>

infix fun <T : Comparable<T>> ColumnDeclaring<T>.lte(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Less-eq operator, translated to <= in SQL.

infix operator fun <T : Number> ColumnDeclaring<T>.minus(value: T): BinaryExpression<T>

infix operator fun <T : Number> ColumnDeclaring<T>.minus(expr: ColumnDeclaring<T>): BinaryExpression<T>

Minus operator, translated to - in SQL.

infix fun <T : Any> ColumnDeclaring<T>.neq(value: T): BinaryExpression<Boolean>

infix fun <T : Any> ColumnDeclaring<T>.neq(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Not-equal operator, translated to <> in SQL.

operator fun ColumnDeclaring<Boolean>.not(): UnaryExpression<Boolean>

Negative operator, translated to the not keyword in SQL.

infix fun <T : Comparable<T>> ColumnDeclaring<T>.notBetween(range: ClosedRange<T>): BetweenExpression

Not-between operator, translated to not between .. and .. in SQL.

infix fun <T : Any> ColumnDeclaring<T>.notEq(value: T): BinaryExpression<Boolean>

infix fun <T : Any> ColumnDeclaring<T>.notEq(expr: ColumnDeclaring<T>): BinaryExpression<Boolean>

Not-equal operator, translated to <> in SQL.

infix fun ColumnDeclaring<*>.notInList(query: Query): InListExpression

fun <T : Any> ColumnDeclaring<T>.notInList(vararg list: T): InListExpression

infix fun <T : Any> ColumnDeclaring<T>.notInList(list: Collection<T>): InListExpression

Not-in-list operator, translated to the not in keyword in SQL.

infix fun ColumnDeclaring<*>.notLike(value: String): BinaryExpression<Boolean>

infix fun ColumnDeclaring<*>.notLike(expr: ColumnDeclaring<String>): BinaryExpression<Boolean>

Not like operator, translated to the not like keyword in SQL.

infix fun ColumnDeclaring<Boolean>.or(value: Boolean): BinaryExpression<Boolean>

infix fun ColumnDeclaring<Boolean>.or(expr: ColumnDeclaring<Boolean>): BinaryExpression<Boolean>

Or operator, translated to the or keyword in SQL.

inline fun <T : Any> WindowFunctionExpression<T>.over(configure: WindowSpecificationExpression.() -> WindowSpecificationExpression): WindowFunctionExpression<T>

fun <T : Any> WindowFunctionExpression<T>.over(window: WindowSpecificationExpression = window()): WindowFunctionExpression<T>

Specify the window specification for this window function.

infix operator fun <T : Number> ColumnDeclaring<T>.plus(value: T): BinaryExpression<T>

infix operator fun <T : Number> ColumnDeclaring<T>.plus(expr: ColumnDeclaring<T>): BinaryExpression<T>

Plus operator, translated to + in SQL.

infix operator fun <T : Number> ColumnDeclaring<T>.rem(value: T): BinaryExpression<T>

infix operator fun <T : Number> ColumnDeclaring<T>.rem(expr: ColumnDeclaring<T>): BinaryExpression<T>

Mod operator, translated to % in SQL.

infix operator fun <T : Number> ColumnDeclaring<T>.times(value: T): BinaryExpression<T>

infix operator fun <T : Number> ColumnDeclaring<T>.times(expr: ColumnDeclaring<T>): BinaryExpression<T>

Multiply operator, translated to * in SQL.

fun ColumnDeclaring<out Number>.toDouble(): CastingExpression<Double>

Cast the current column or expression's type to Double.

fun ColumnDeclaring<out Number>.toFloat(): CastingExpression<Float>

Cast the current column or expression's type to Float.

@JvmName(name = "booleanToInt")

fun ColumnDeclaring<Boolean>.~~toInt~~(): CastingExpression<Int>

fun ColumnDeclaring<out Number>.toInt(): CastingExpression<Int>

Cast the current column or expression's type to Int.

fun ColumnDeclaring<out Number>.toLong(): CastingExpression<Long>

Cast the current column or expression's type to Long.

fun ColumnDeclaring<out Number>.toShort(): CastingExpression<Short>

Cast the current column or expression's type to Short.

operator fun <T : Number> ColumnDeclaring<T>.unaryMinus(): UnaryExpression<T>

Unary minus operator, translated to - in SQL.

operator fun <T : Number> ColumnDeclaring<T>.unaryPlus(): UnaryExpression<T>

Unary plus operator, translated to + in SQL.

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

Wrap the given argument as an ArgumentExpression using the sqlType.

infix fun ColumnDeclaring<Boolean>.xor(value: Boolean): BinaryExpression<Boolean>

infix fun ColumnDeclaring<Boolean>.xor(expr: ColumnDeclaring<Boolean>): BinaryExpression<Boolean>

Xor operator, translated to the xor keyword in SQL.