Column

data class Column<T : Any> : ColumnDeclaring<T> (source code)

Represents database columns.

Constructors

Name	Summary
<init>	`Column( table: BaseTable<*>, name: String, binding: ColumnBinding? = null, extraBindings: List<ColumnBinding> = emptyList(), sqlType: SqlType<T>)` Represents database columns.

Properties

Name	Summary
allBindings	`val allBindings: List<ColumnBinding>` Return all the bindings of this column, including the primary binding and extraBindings.
binding	`val binding: ColumnBinding?` The column’s primary binding. A column might be bound to a simple property, nested properties, or a reference to another table, null if the column doesn’t bind to any property.
extraBindings	`val extraBindings: List<ColumnBinding>` The column’s extra bindings. Useful when we need to configure two or more bindings for a column.
label	`val label: String` The column’s label, used to identify the selected columns and to obtain query results.
name	`val name: String` The column’s name.
referenceTable	`val referenceTable: BaseTable<*>?` If the column is bound to a reference table, return the table, otherwise return null.
sqlType	`val sqlType: SqlType<T>` The SqlType of this column or expression.
table	`val table: BaseTable<*>` The table that this column belongs to.

Functions

Name	Summary
aliased	`fun aliased(label: String?): ColumnDeclaringExpression<T>` Wrap this column as a ColumnDeclaringExpression.
asExpression	`fun asExpression(): ColumnExpression<T>` Convert this column to a ColumnExpression.
equals	`fun equals(other: Any?): Boolean` Indicates whether some other object is “equal to” this column. Two columns are equal only if they are the same instance.
hashCode	`fun hashCode(): Int` Return a hash code value for this column.
toString	`fun toString(): String` Return a string representation of this column.
wrapArgument	`fun wrapArgument(argument: T?): ArgumentExpression<T>` Wrap the given argument as an ArgumentExpression using the sqlType.

Extension Functions

Name	Summary
and	`infix fun ColumnDeclaring<Boolean>.and( expr: ColumnDeclaring<Boolean> ): BinaryExpression<Boolean>` `infix fun ColumnDeclaring<Boolean>.and( value: Boolean ): BinaryExpression<Boolean>` And operator, translated to the `and` keyword in SQL.
asc	`fun ColumnDeclaring<*>.asc(): OrderByExpression` Order this column or expression in ascending order.
cast	`fun <T : Any> ColumnDeclaring<*>.cast( sqlType: SqlType<T> ): CastingExpression<T>` Cast the current column or expression to the given SqlType.
containedIn	`fun ColumnDeclaring<HStore>.containedIn( expr: ColumnDeclaring<HStore> ): HStoreExpression<Boolean>` `fun ColumnDeclaring<HStore>.containedIn( argument: HStore ): HStoreExpression<Boolean>` HStore contained-in operator, translated to the <@ operator in PostgreSQL.
contains	`fun ColumnDeclaring<Cube>.contains( expr: ColumnDeclaring<Cube> ): CubeExpression<Boolean>` `fun ColumnDeclaring<Cube>.contains( argument: Cube ): CubeExpression<Boolean>` `fun ColumnDeclaring<Cube>.contains( expr: ColumnDeclaring<Earth> ): CubeExpression<Boolean>` `fun ColumnDeclaring<Cube>.contains( argument: Earth ): CubeExpression<Boolean>` Cube contains operator, translated to the @> operator in PostgreSQL. `fun ColumnDeclaring<HStore>.contains( expr: ColumnDeclaring<HStore> ): HStoreExpression<Boolean>` `fun ColumnDeclaring<HStore>.contains( argument: HStore ): HStoreExpression<Boolean>` HStore contains operator, translated to the @> operator in PostgreSQL.
containsAll	`fun ColumnDeclaring<HStore>.containsAll( expr: ColumnDeclaring<TextArray> ): HStoreExpression<Boolean>` `fun ColumnDeclaring<HStore>.containsAll( argument: TextArray ): HStoreExpression<Boolean>` HStore contains-all-keys operator, translated to the ?& operator in PostgreSQL.
containsAny	`fun ColumnDeclaring<HStore>.containsAny( expr: ColumnDeclaring<TextArray> ): HStoreExpression<Boolean>` `fun ColumnDeclaring<HStore>.containsAny( argument: TextArray ): HStoreExpression<Boolean>` HStore contains-any-keys operator, translated to the ?\| operator in PostgreSQL.
containsKey	`fun ColumnDeclaring<HStore>.containsKey( expr: ColumnDeclaring<String> ): HStoreExpression<Boolean>` `fun ColumnDeclaring<HStore>.containsKey( argument: String ): HStoreExpression<Boolean>` HStore contains-key operator, translated to the ? operator in PostgreSQL.
defaultValue	`fun <T : Any> Column<T>.defaultValue(): DefaultValueExpression<T>` Return a default value for this column, see DefaultValueExpression.
defaultValue	`fun <T : Any> Column<T>.defaultValue(): DefaultValueExpression<T>` Return a default value for this column, see DefaultValueExpression.
desc	`fun ColumnDeclaring<*>.desc(): OrderByExpression` Order this column or expression in descending order, corresponding to the `desc` keyword in SQL.
div	`infix operator fun <T : Number> ColumnDeclaring<T>.div( expr: ColumnDeclaring<T> ): BinaryExpression<T>` `infix operator fun <T : Number> ColumnDeclaring<T>.div( value: T ): BinaryExpression<T>` Divide operator, translated to `/` in SQL.
eq	`infix fun <T : Any> ColumnDeclaring<T>.eq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` `infix fun <T : Any> ColumnDeclaring<T>.eq( value: T ): BinaryExpression<Boolean>` `infix fun <T : Any> T.eq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Equal operator, translated to `=` in SQL.
get	`operator fun ColumnDeclaring<HStore>.get( expr: ColumnDeclaring<String> ): HStoreExpression<String>` `operator fun ColumnDeclaring<HStore>.get( argument: String ): HStoreExpression<String>` HStore get-value-for-key operator, translated to the -> operator in PostgreSQL. `operator fun ColumnDeclaring<HStore>.get( expr: ColumnDeclaring<TextArray> ): HStoreExpression<TextArray>` `operator fun ColumnDeclaring<HStore>.get( argument: TextArray ): HStoreExpression<TextArray>` HStore get-values-for-keys operator, translated to the -> operator in PostgreSQL.
ifNull	`fun <T : Any> ColumnDeclaring<T>.ifNull( right: ColumnDeclaring<T> ): FunctionExpression<T>` `fun <T : Any> ColumnDeclaring<T>.ifNull( right: T? ): FunctionExpression<T>` MySQL ifnull function, translated to `ifnull(left, right)`.
ifNull	`fun <T : Any> ColumnDeclaring<T>.ifNull( right: ColumnDeclaring<T> ): FunctionExpression<T>` `fun <T : Any> ColumnDeclaring<T>.ifNull( right: T? ): FunctionExpression<T>` SQLite ifnull function, translated to `ifnull(left, right)`.
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.
inList	`fun <T : Any> ColumnDeclaring<T>.inList( vararg list: T ): InListExpression` `infix fun <T : Any> ColumnDeclaring<T>.inList( list: Collection<T> ): InListExpression` `infix fun ColumnDeclaring<*>.inList( query: Query ): InListExpression` In-list operator, translated to the `in` keyword in SQL.
instr	`fun ColumnDeclaring<String>.instr( right: ColumnDeclaring<String> ): FunctionExpression<Int>` `fun ColumnDeclaring<String>.instr( right: String ): FunctionExpression<Int>` SQLite instr function, translated to `instr(left, right)`.
isNotNull	`fun ColumnDeclaring<*>.isNotNull(): UnaryExpression<Boolean>` Check if the current column or expression is not null, translated to `is not null` in SQL.
isNull	`fun ColumnDeclaring<*>.isNull(): UnaryExpression<Boolean>` Check if the current column or expression is null, translated to `is null` in SQL.
jsonContains	`fun <T : Any> Column<List<T>>.jsonContains( item: T, sqlType: SqlType<T> = SqlType.of() ?: error("Cannot detect the item's SqlType, please specify manually.") ): FunctionExpression<Boolean>` MySQL json_contains function, translated to `json_contains(column, json_array(item))`.
jsonExtract	`fun <T : Any> Column<*>.jsonExtract( path: String, sqlType: SqlType<T> = SqlType.of() ?: error("Cannot detect the result's SqlType, please specify manually.") ): FunctionExpression<T>` MySQL json_extract function, translated to `json_extract(column, path)`.
jsonExtract	`fun <T : Any> ColumnDeclaring<*>.jsonExtract( path: String, sqlType: SqlType<T> = SqlType.of() ?: error("Cannot detect the result's SqlType, please specify manually.") ): FunctionExpression<T>` SQLite json_extract function, translated to `json_extract(column, path)`.
jsonPatch	`fun ColumnDeclaring<>.jsonPatch( right: ColumnDeclaring<> ): FunctionExpression<String>` SQLite json_patch function, translated to `json_patch(left, right)`.
jsonRemove	`fun ColumnDeclaring<*>.jsonRemove( path: String ): FunctionExpression<String>` SQLite json_remove function, translated to `json_remove(column, path)`.
jsonValid	`fun ColumnDeclaring<*>.jsonValid(): FunctionExpression<Boolean>` SQLite json_valid function, translated to `json_valid(column)`.
like	`infix fun ColumnDeclaring<>.like( expr: ColumnDeclaring<String> ): BinaryExpression<Boolean>` `infix fun ColumnDeclaring<>.like( value: String ): BinaryExpression<Boolean>` Like operator, translated to the `like` keyword in SQL.
minus	`infix operator fun <T : Number> ColumnDeclaring<T>.minus( expr: ColumnDeclaring<T> ): BinaryExpression<T>` `infix operator fun <T : Number> ColumnDeclaring<T>.minus( value: T ): BinaryExpression<T>` Minus operator, translated to `-` in SQL.
minus	`operator fun ColumnDeclaring<HStore>.minus( expr: ColumnDeclaring<String> ): HStoreExpression<HStore>` `operator fun ColumnDeclaring<HStore>.minus( argument: String ): HStoreExpression<HStore>` HStore delete-key operator, translated to the - operator in PostgreSQL. `operator fun ColumnDeclaring<HStore>.minus( expr: ColumnDeclaring<TextArray> ): HStoreExpression<HStore>` `operator fun ColumnDeclaring<HStore>.minus( argument: TextArray ): HStoreExpression<HStore>` HStore delete-keys operator, translated to the - operator in PostgreSQL. `operator fun ColumnDeclaring<HStore>.minus( expr: ColumnDeclaring<HStore> ): HStoreExpression<HStore>` `operator fun ColumnDeclaring<HStore>.minus( argument: HStore ): HStoreExpression<HStore>` HStore delete-matching-pairs operator, translated to the - operator in PostgreSQL.
neq	`infix fun <T : Any> ColumnDeclaring<T>.neq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` `infix fun <T : Any> ColumnDeclaring<T>.neq( value: T ): BinaryExpression<Boolean>` `infix fun <T : Any> T.neq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.
not	`operator fun ColumnDeclaring<Boolean>.not(): UnaryExpression<Boolean>` Negative operator, translated to the `not` keyword in SQL.
notEq	`infix fun <T : Any> ColumnDeclaring<T>.notEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` `infix fun <T : Any> ColumnDeclaring<T>.notEq( value: T ): BinaryExpression<Boolean>` `infix fun <T : Any> T.notEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.
notInList	`fun <T : Any> ColumnDeclaring<T>.notInList( vararg list: T ): InListExpression` `infix fun <T : Any> ColumnDeclaring<T>.notInList( list: Collection<T> ): InListExpression` `infix fun ColumnDeclaring<*>.notInList( query: Query ): InListExpression` Not-in-list operator, translated to the `not in` keyword in SQL.
notLike	`infix fun ColumnDeclaring<>.notLike( expr: ColumnDeclaring<String> ): BinaryExpression<Boolean>` `infix fun ColumnDeclaring<>.notLike( value: String ): BinaryExpression<Boolean>` Not like operator, translated to the `not like` keyword in SQL.
or	`infix fun ColumnDeclaring<Boolean>.or( expr: ColumnDeclaring<Boolean> ): BinaryExpression<Boolean>` `infix fun ColumnDeclaring<Boolean>.or( value: Boolean ): BinaryExpression<Boolean>` Or operator, translated to the `or` keyword in SQL.
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	`infix operator fun <T : Number> ColumnDeclaring<T>.plus( expr: ColumnDeclaring<T> ): BinaryExpression<T>` `infix operator fun <T : Number> ColumnDeclaring<T>.plus( value: T ): BinaryExpression<T>` Plus operator, translated to `+` in SQL.
plus	`operator fun ColumnDeclaring<HStore>.plus( expr: ColumnDeclaring<HStore> ): HStoreExpression<HStore>` `operator fun ColumnDeclaring<HStore>.plus( argument: HStore ): HStoreExpression<HStore>` HStore concatenate operator, translated to the \|\| operator in PostgreSQL.
rem	`infix operator fun <T : Number> ColumnDeclaring<T>.rem( expr: ColumnDeclaring<T> ): BinaryExpression<T>` `infix operator fun <T : Number> ColumnDeclaring<T>.rem( value: T ): BinaryExpression<T>` Mod operator, translated to `%` in SQL.
times	`infix operator fun <T : Number> ColumnDeclaring<T>.times( expr: ColumnDeclaring<T> ): BinaryExpression<T>` `infix operator fun <T : Number> ColumnDeclaring<T>.times( value: T ): BinaryExpression<T>` Multiply operator, translated to `*` in SQL.
toDouble	`fun ColumnDeclaring<out Number>.toDouble(): CastingExpression<Double>` Cast the current column or expression’s type to Double.
toFloat	`fun ColumnDeclaring<out Number>.toFloat(): CastingExpression<Float>` Cast the current column or expression’s type to Float.
toLong	`fun ColumnDeclaring<out Number>.toLong(): CastingExpression<Long>` Cast the current column or expression’s type to Long.
toShort	`fun ColumnDeclaring<out Number>.toShort(): CastingExpression<Short>` Cast the current column or expression’s type to Short.
unaryMinus	`operator fun <T : Number> ColumnDeclaring<T>.unaryMinus(): UnaryExpression<T>` Unary minus operator, translated to `-` in SQL.
unaryPlus	`operator fun <T : Number> ColumnDeclaring<T>.unaryPlus(): UnaryExpression<T>` Unary plus operator, translated to `+` in SQL.
xor	`infix fun ColumnDeclaring<Boolean>.xor( expr: ColumnDeclaring<Boolean> ): BinaryExpression<Boolean>` `infix fun ColumnDeclaring<Boolean>.xor( value: Boolean ): BinaryExpression<Boolean>` Xor operator, translated to the `xor` keyword in SQL.