Column
Represents a column.
Constructors
Properties
Returns this column's type cast as AutoIncColumnType or null
if the cast fails.
Data type of the column.
Returns the function that calculates the default value for this column.
The foreign key constraint on this column, or null
if the column is not referencing.
Functions
Returns the result of performing a logical and
operation between this expression and the op.
Returns the result of performing a logical and
operation between this expression and the negate op.
UUID column will auto generate its value on a client side just before an insert.
Make @receiver column an auto-increment column to generate its values in a database. Note: Only integer and long columns are supported (signed and unsigned types). Some databases, like PostgreSQL, support auto-increment via sequences. In this case a name should be provided using the idSeqName param and Exposed will create a sequence. If a sequence already exists in the database just use its name in idSeqName.
Make @receiver column an auto-increment column to generate its values in a database. Note: Only integer and long columns are supported (signed and unsigned types). Some databases, like PostgreSQL, support auto-increment via sequences. In this case, a sequence should be provided using the sequence param.
Specifies a conversion from one data type to another.
Returns the length of this string expression, measured in characters, or null
if this expression is null.
Returns the number of input rows for which the value of this expression is not null.
Returns the number of distinct input rows for which the value of this expression is not null.
Returns the list of DDL statements that create this object.
Marks a column as databaseGenerated
if the default value of the column is not known at the time of table creation and/or if it depends on other columns. It makes it possible to omit setting it when inserting a new record, without getting an error. The value for the column can be set by creating a TRIGGER or with a DEFAULT clause or by using GENERATED ALWAYS AS via Column.withDefinition, for example.
Sets the default value for this column in the database side.
Returns the default value for this column on the database-side.
Returns the SQL representation of this column.
Returns the list of DDL statements that drops this object.
Checks if this expression is equal to some t value.
Checks if this expression is equal to some other expression.
Checks if this expression is equal to some other expression.
Checks if this expression is equals to single value returned from query.
Returns value evaluated at the row that is the first row of the window frame.
Calls a custom SQL function with the specified functionName and passes this expression as its only argument.
Checks if this expression is greater than some t value.
Checks if this expression is greater than some other expression.
Checks if this expression is greater than some other expression.
Checks if this expression is greater than or equal to some t value
Checks if this expression is greater than or equal to some other expression.
Checks if this expression is greater than or equal to some other expression
Checks if this expression is equal to any element from list.
Checks if this expression is equals to any row returned from query.
Returns whether this column's value will be generated in the database.
Checks if this expression is not equal to some t value, with null
treated as a comparable value
Checks if this expression is not equal to some other expression.
Checks if this expression is not equal to some other expression, with null
treated as a comparable value
Checks if this expression is equal to some t value, with null
treated as a comparable value
Checks if this expression is equal to some other expression.
Checks if this expression is equal to some other expression, with null
treated as a comparable value
Returns true
if this string expression is null or empty, false
otherwise.
Returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead returns defaultValue. Both offset and defaultValue are evaluated with respect to the current row.
Returns value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead returns defaultValue. Both offset and defaultValue are evaluated with respect to the current row.
Checks if this expression is less than some t value.
Checks if this expression is less than some other expression.
Checks if this expression is less than some other expression.
Checks if this expression is less than or equal to some t value
Checks if this expression is less than or equal to some other expression.
Checks if this expression is less than or equal to some other expression
Checks if this expression matches the specified pattern.
Checks if this expression matches the specified expression.
Checks if this expression matches the specified pattern.
Calculates the remainder of dividing this expression by the t value.
Calculates the remainder of dividing this expression by the other expression.
Returns the list of DDL statements that modify this object.
Returns the SQL statements that modify this column according to differences in the provided ColumnDiff.
Returns the column name in proper case.
Returns the column name with wrapping double-quotation characters removed.
Checks if this expression is not equal to some other value.
Checks if this expression is not equal to some other expression.
Checks if this expression is not equal to some other expression.
Checks if this expression is not equals to single value returned from query.
Checks if this expression is not equal to any element from list.
Checks if this expression is not equals to any row returned from query.
Checks if this expression is not equal to any element from the column of table with only a single column.
Checks if this expression doesn't match the specified pattern.
Checks if this expression doesn't match the specified pattern.
Checks if this expression doesn't match the specified expression.
Returns value evaluated at the row that is the n'th row of the window frame (counting from 1); null if no such row.
Applies a special transformation that allows a non-nullable database column to accept and/or return values as null
on the client side.
Returns the result of performing a logical or
operation between this expression and the op.
Returns the result of performing a logical or
operation between this expression and the negate op.
Calculates the remainder of dividing this expression by the t value.
Calculates the remainder of dividing this expression by the other expression.
Returns the sample standard deviation of the non-null input values, or null
if there are no non-null values.
Appends the SQL representation of this column to the specified queryBuilder.
Transforms a nullable column by specifying a transformer.
Transforms a column by specifying a transformer.
Transforms a nullable column by specifying transformation functions.
Transforms a column by specifying transformation functions.
Returns a copy of this column, but with the given column type.
Appends a database-specific column definition to this column's SQL in a CREATE TABLE statement.