English | 简体中文

api-docs / org.ktorm.expression / JoinType

JoinType

enum class JoinType (source code)

The enum of joining types in a JoinExpression.

Enum Values

NameSummary

CROSS_JOIN

Cross join, translated to the cross join keyword in SQL.

INNER_JOIN

Inner join, translated to the inner join keyword in SQL.

LEFT_JOIN

Left join, translated to the left join keyword in SQL.

RIGHT_JOIN

Right join, translated to the right join keyword in SQL.

FULL_JOIN

Full join, translated to the full join keyword in SQL.

Functions

NameSummary

toString

fun toString(): String

Extension Functions

NameSummary

eq

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

Equal operator, translated to = in SQL.

greater

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

Greater operator, translated to > in SQL.

greaterEq

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

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

gt

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

Greater operator, translated to > in SQL.

gte

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

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

less

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

Less operator, translated to < in SQL.

lessEq

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

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

lt

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

Less operator, translated to < in SQL.

lte

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

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

neq

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

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

notEq

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

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