Package-level declarations

Types

Link copied to clipboard
Link copied to clipboard
interface KExpression<T : Any>
Link copied to clipboard
interface KNonNullExpression<T : Any> : KExpression<T> , Selection<T>
Link copied to clipboard
interface KNullableExpression<T : Any> : KExpression<T> , Selection<T?>
Link copied to clipboard
interface KPropExpression<T : Any> : KExpression<T>

Functions

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
fun KExpression<*>.asc(): Order
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
fun count(expression: KExpression<*>, distinct: Boolean = false): KNonNullExpression<Long>
fun count(table: KTable<*>, distinct: Boolean = false): KNonNullExpression<Long>
Link copied to clipboard
fun KExpression<*>.desc(): Order
Link copied to clipboard
fun <T : Temporal> KNonNullExpression<T>.diff(other: T, timeUnit: SqlTimeUnit): KNonNullExpression<Float>
fun <T : Temporal> KNonNullExpression<T>.diff(other: KNonNullExpression<T>, timeUnit: SqlTimeUnit): KNonNullExpression<Float>
fun <T : Date> KNonNullExpression<T>.diff(other: T, timeUnit: SqlTimeUnit): KNonNullExpression<Float>
fun <T : Date> KNonNullExpression<T>.diff(other: KNonNullExpression<T>, timeUnit: SqlTimeUnit): KNonNullExpression<Float>
fun <T : Temporal> KNullableExpression<T>.diff(other: T, timeUnit: SqlTimeUnit): KNullableExpression<Float>
fun <T : Temporal> KNullableExpression<T>.diff(other: KExpression<T>, timeUnit: SqlTimeUnit): KNullableExpression<Float>
fun <T : Date> KNullableExpression<T>.diff(other: T, timeUnit: SqlTimeUnit): KNullableExpression<Float>
fun <T : Date> KNullableExpression<T>.diff(other: KExpression<T>, timeUnit: SqlTimeUnit): KNullableExpression<Float>
Link copied to clipboard
operator fun <N : Number> KExpression<N>.div(right: N): KNullableExpression<N>
operator fun <N : Number> KExpression<N>.div(right: KExpression<N>): KNullableExpression<N>
operator fun <N : Number> KNonNullExpression<N>.div(right: N): KNonNullExpression<N>
Link copied to clipboard
infix fun <T : Any> KExpression<T>.eq(right: T?): KNonNullExpression<Boolean>

infix fun <E : Any> KTable<E>.eq(right: E): KNonNullExpression<Boolean>?
infix fun <E : Any> KTable<E>.eq(right: View<E>): KNonNullExpression<Boolean>?
infix fun <E : Any> KTable<E>.eq(right: KExample<E>): KNonNullExpression<Boolean>?

QBE

infix fun <E : Any> KTable<E>.eq(right: KTable<E>): KNonNullExpression<Boolean>

Shortcut for this.id eq right

Link copied to clipboard
infix fun <T : Any> KExpression<T>.eq?(right: T?): KNonNullExpression<Boolean>?
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
infix fun <T : Comparable<*>> KExpression<T>.ge?(right: T?): KNonNullExpression<Boolean>?
Link copied to clipboard
Link copied to clipboard
infix fun <T : Comparable<*>> KExpression<T>.gt?(right: T?): KNonNullExpression<Boolean>?
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
infix fun <T : Comparable<*>> KExpression<T>.le?(right: T?): KNonNullExpression<Boolean>?
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
infix fun <T : Comparable<*>> KExpression<T>.lt?(right: T?): KNonNullExpression<Boolean>?
Link copied to clipboard
fun <T : Comparable<*>> max(expression: KExpression<T>): KNullableExpression<T>
Link copied to clipboard
fun <T : Comparable<*>> min(expression: KExpression<T>): KNullableExpression<T>
Link copied to clipboard
operator fun <N : Number> KExpression<N>.minus(right: N): KNullableExpression<N>
operator fun <N : Number> KNonNullExpression<N>.minus(right: N): KNonNullExpression<N>
fun <T : Temporal> KNonNullExpression<T>.minus(value: Long, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Temporal> KNonNullExpression<T>.minus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Date> KNonNullExpression<T>.minus(value: Long, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Date> KNonNullExpression<T>.minus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Temporal> KNullableExpression<T>.minus(value: Long, timeUnit: SqlTimeUnit): KNullableExpression<T>
fun <T : Temporal> KNullableExpression<T>.minus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNullableExpression<T>
fun <T : Date> KNullableExpression<T>.minus(value: Long, timeUnit: SqlTimeUnit): KNullableExpression<T>
fun <T : Date> KNullableExpression<T>.minus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNullableExpression<T>
Link copied to clipboard
infix fun <T : Any> KExpression<T>.ne(right: T?): KNonNullExpression<Boolean>
Link copied to clipboard
infix fun <T : Any> KExpression<T>.ne?(right: T?): KNonNullExpression<Boolean>?
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
operator fun <N : Number> KExpression<N>.plus(right: N): KNullableExpression<N>
operator fun <N : Number> KExpression<N>.plus(right: KExpression<N>): KNullableExpression<N>
operator fun <N : Number> KNonNullExpression<N>.plus(right: N): KNonNullExpression<N>
fun <T : Temporal> KNonNullExpression<T>.plus(value: Long, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Temporal> KNonNullExpression<T>.plus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Date> KNonNullExpression<T>.plus(value: Long, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Date> KNonNullExpression<T>.plus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNonNullExpression<T>
fun <T : Temporal> KNullableExpression<T>.plus(value: Long, timeUnit: SqlTimeUnit): KNullableExpression<T>
fun <T : Temporal> KNullableExpression<T>.plus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNullableExpression<T>
fun <T : Date> KNullableExpression<T>.plus(value: Long, timeUnit: SqlTimeUnit): KNullableExpression<T>
fun <T : Date> KNullableExpression<T>.plus(value: KNonNullExpression<Long>, timeUnit: SqlTimeUnit): KNullableExpression<T>
Link copied to clipboard
operator fun <N : Number> KExpression<N>.rem(right: N): KNullableExpression<N>
operator fun <N : Number> KExpression<N>.rem(right: KExpression<N>): KNullableExpression<N>
operator fun <N : Number> KNonNullExpression<N>.rem(right: N): KNonNullExpression<N>
Link copied to clipboard
Link copied to clipboard
inline fun <T : Any> sql(sql: String, vararg expressions: KExpression<*>): KNonNullExpression<T>
inline fun <T : Any> sql(sql: String, noinline block: NativeDsl.() -> Unit): KNonNullExpression<T>
fun <T : Any> sql(type: KClass<T>, sql: String, vararg expressions: KExpression<*>): KNonNullExpression<T>
fun <T : Any> sql(type: KClass<T>, sql: String, block: NativeDsl.() -> Unit): KNonNullExpression<T>
Link copied to clipboard
inline fun <T : Any> sqlNullable(sql: String, vararg expressions: KExpression<*>): KNullableExpression<T>
inline fun <T : Any> sqlNullable(sql: String, noinline block: NativeDsl.() -> Unit): KNullableExpression<T>
fun <T : Any> sqlNullable(type: KClass<T>, sql: String, vararg expressions: KExpression<*>): KNullableExpression<T>
fun <T : Any> sqlNullable(type: KClass<T>, sql: String, block: NativeDsl.() -> Unit): KNullableExpression<T>
Link copied to clipboard
fun <T : Number> sum(expression: KExpression<T>): KNullableExpression<T>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
fun <T1, T2> tuple(selection1: Selection<T1>, selection2: Selection<T2>): KNonNullExpression<Tuple2<T1, T2>>
fun <T1, T2, T3> tuple(selection1: Selection<T1>, selection2: Selection<T2>, selection3: Selection<T3>): KNonNullExpression<Tuple3<T1, T2, T3>>
fun <T1, T2, T3, T4> tuple(selection1: Selection<T1>, selection2: Selection<T2>, selection3: Selection<T3>, selection4: Selection<T4>): KNonNullExpression<Tuple4<T1, T2, T3, T4>>
fun <T1, T2, T3, T4, T5> tuple(selection1: Selection<T1>, selection2: Selection<T2>, selection3: Selection<T3>, selection4: Selection<T4>, selection5: Selection<T5>): KNonNullExpression<Tuple5<T1, T2, T3, T4, T5>>
fun <T1, T2, T3, T4, T5, T6> tuple(selection1: Selection<T1>, selection2: Selection<T2>, selection3: Selection<T3>, selection4: Selection<T4>, selection5: Selection<T5>, selection6: Selection<T6>): KNonNullExpression<Tuple6<T1, T2, T3, T4, T5, T6>>
fun <T1, T2, T3, T4, T5, T6, T7> tuple(selection1: Selection<T1>, selection2: Selection<T2>, selection3: Selection<T3>, selection4: Selection<T4>, selection5: Selection<T5>, selection6: Selection<T6>, selection7: Selection<T7>): KNonNullExpression<Tuple7<T1, T2, T3, T4, T5, T6, T7>>
fun <T1, T2, T3, T4, T5, T6, T7, T8> tuple(selection1: Selection<T1>, selection2: Selection<T2>, selection3: Selection<T3>, selection4: Selection<T4>, selection5: Selection<T5>, selection6: Selection<T6>, selection7: Selection<T7>, selection8: Selection<T8>): KNonNullExpression<Tuple8<T1, T2, T3, T4, T5, T6, T7, T8>>
fun <T1, T2, T3, T4, T5, T6, T7, T8, T9> tuple(selection1: Selection<T1>, selection2: Selection<T2>, selection3: Selection<T3>, selection4: Selection<T4>, selection5: Selection<T5>, selection6: Selection<T6>, selection7: Selection<T7>, selection8: Selection<T8>, selection9: Selection<T9>): KNonNullExpression<Tuple9<T1, T2, T3, T4, T5, T6, T7, T8, T9>>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
fun <T : Any> value(value: T): KNonNullExpression<T>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard