Chad/org.openredstone.chad/SqlCommand

SqlCommand

object SqlCommand : Table

Functions

fun Column<UUID>.autoGenerate(): Column<UUID>

fun <N : Comparable<N>> Column<EntityID<N>>.autoinc(idSeqName: String?): Column<EntityID<N>>

fun <N : Any> Column<N>.autoIncrement(idSeqName: String?): Column<N>

fun binary(name: String): Column<ByteArray>

fun binary(name: String, length: Int): Column<ByteArray>

fun blob(name: String): Column<ExposedBlob>

fun bool(name: String): Column<Boolean>

fun byte(name: String): Column<Byte>

fun char(name: String): Column<Char>

fun char(name: String, length: Int, collate: String?): Column<String>

fun check(name: String, op: SqlExpressionBuilder.() -> Op<Boolean>)

fun <T> Column<T>.check(name: String, op: SqlExpressionBuilder.(Column<T>) -> Op<Boolean>): Column<T>

fun <T : Any> Column<T>.clientDefault(defaultValue: () -> T): Column<T>

createStatement

open override fun createStatement(): List<String>

open infix override fun crossJoin(otherTable: ColumnSet): Join

customEnumeration

fun <T : Enum<T>> customEnumeration(name: String, sql: String?, fromDb: (Any) -> T, toDb: (T) -> Any): Column<T>

fun decimal(name: String, precision: Int, scale: Int): Column<BigDecimal>

fun <T> Column<T>.default(defaultValue: T): Column<T>

fun <T> CompositeColumn<T>.default(defaultValue: T): CompositeColumn<T>

defaultExpression

fun <T> Column<T>.defaultExpression(defaultValue: Expression<T>): Column<T>

open override fun describe(s: Transaction, queryBuilder: QueryBuilder)

fun double(name: String): Column<Double>

open override fun dropStatement(): List<String>

fun <T : Comparable<T>> Column<T>.entityId(): Column<EntityID<T>>

fun <ID : Comparable<ID>> entityId(name: String, table: IdTable<ID>): Column<EntityID<ID>>

fun <ID : Comparable<ID>> entityId(name: String, originalColumn: Column<ID>): Column<EntityID<ID>>

fun <T : Enum<T>> enumeration(name: String, klass: KClass<T>): Column<T>

enumerationByName

fun <T : Enum<T>> enumerationByName(name: String, length: Int, klass: KClass<T>): Column<T>

open operator override fun equals(other: Any?): Boolean

fun float(name: String): Column<Float>

open infix override fun fullJoin(otherTable: ColumnSet): Join

open override fun hashCode(): Int

fun index(isUnique: Boolean, vararg columns: Column<*>)

fun <T> Column<T>.index(customIndexName: String?, isUnique: Boolean): Column<T>

fun index(customIndexName: String?, isUnique: Boolean, vararg columns: Column<*>, indexType: String?)

open infix override fun innerJoin(otherTable: ColumnSet): Join

fun integer(name: String): Column<Int>

open override fun join(otherTable: ColumnSet, joinType: JoinType, onColumn: Expression<*>?, otherColumn: Expression<*>?, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>?): Join

open infix override fun leftJoin(otherTable: ColumnSet): Join

fun long(name: String): Column<Long>

modifyStatement

open override fun modifyStatement(): List<String>

nameInDatabaseCase

fun nameInDatabaseCase(): String

fun <T : Any, C : CompositeColumn<T>> C.nullable(): CompositeColumn<T?>

fun <T : Any> Column<T>.nullable(): Column<T?>

fun <T : Comparable<T>> optReference(name: String, foreign: IdTable<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<EntityID<T>?>

fun <T : Comparable<T>> optReference(name: String, refColumn: Column<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<T?>

fun <T : Comparable<T>, E : EntityID<T>> optReference(name: String, refColumn: Column<E>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<E?>

~~fun~~ <T> Column<T>.~~primaryKey~~(~~indx~~: Int?): Column<T>

fun <T : Comparable<T>> reference(name: String, foreign: IdTable<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<EntityID<T>>

fun <T : Comparable<T>> reference(name: String, refColumn: Column<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<T>

fun <T : Comparable<T>, E : EntityID<T>> reference(name: String, refColumn: Column<E>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<E>

infix fun <T : Comparable<T>, S : T, C : Column<S>> C.references(ref: Column<T>): C

fun <T : Comparable<T>, S : T, C : Column<S>> C.references(ref: Column<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): C

fun <T : Comparable<T>, S : T, C : Column<S>> C.references(ref: Column<EntityID<T>>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): C

fun <T> registerColumn(name: String, type: IColumnType): Column<T>

registerCompositeColumn

fun <R, T : CompositeColumn<R>> registerCompositeColumn(column: T): T

fun <TColumn : Column<*>> replaceColumn(oldColumn: Column<*>, newColumn: TColumn): TColumn

open infix override fun rightJoin(otherTable: ColumnSet): Join

fun short(name: String): Column<Short>

fun slice(columns: List<Expression<*>>): FieldSet

fun slice(column: Expression<*>, vararg columns: Expression<*>): FieldSet

fun text(name: String, collate: String?, eagerLoading: Boolean): Column<String>

fun ubyte(name: String): Column<UByte>

fun uinteger(name: String): Column<UInt>

fun ulong(name: String): Column<ULong>

fun uniqueIndex(vararg columns: Column<*>)

fun <T> Column<T>.uniqueIndex(customIndexName: String?): Column<T>

fun uniqueIndex(customIndexName: String?, vararg columns: Column<*>)

fun ushort(name: String): Column<UShort>

fun uuid(name: String): Column<UUID>

fun varchar(name: String, length: Int, collate: String?): Column<String>

Properties

val autoIncColumn: Column<*>?

open override val columns: List<Column<*>>

val ddl: List<String>

open override val fields: List<Expression<*>>

val indices: List<Index>

val key: Column<String>

open val primaryKey: Table.PrimaryKey?

open val realFields: List<Expression<*>>

val response: Column<String>

open override val source: ColumnSet

open val tableName: String