codemc-api/io.codemc.api.database/Users

Users

object Users : Table

Represents the users SQL table.

Properties

val autoIncColumn: Column<*>?

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

open val ddl: List<String>

val discord: Column<Long>

The discord column, representing their Discord ID.

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

val foreignKeys: List<ForeignKeyConstraint>

val indices: List<Index>

open override val primaryKey: Table.PrimaryKey

open val realFields: List<Expression<*>>

val schemaName: String?

val sequences: List<Sequence>

open override val source: ColumnSet

open val tableName: String

val username: Column<String>

The username column, representing their Jenkins username.

Functions

inline fun <E : Any> array(name: String, maximumCardinality: Int?): Column<List<E>>

fun <E> array(name: String, columnType: ColumnType<E & Any>, maximumCardinality: Int?): Column<List<E>>

inline fun <T : Any, R : List<Any>> Table.array(name: String, maximumCardinality: List<Int>?, dimensions: Int): Column<R>

fun <E, R : List<Any?>> Table.array(name: String, columnType: ColumnType<E & Any>, maximumCardinality: List<Int>?, dimensions: Int): Column<R>

inline fun <T : Any, R : List<Any>> Table.array(name: String, maximumCardinality: List<Int>?, dimensions: Int): Column<R>

fun <E, R : List<Any?>> Table.array(name: String, columnType: ColumnType<E & Any>, maximumCardinality: List<Int>?, dimensions: Int): Column<R>

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

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

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

fun <N : Any> Column<N>.autoIncrement(sequence: Sequence): Column<N>

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

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

fun blob(name: String, useObjectIdentifier: Boolean): 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> 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>

databaseGenerated

fun <T> Column<T>.databaseGenerated(): 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 : Any> Column<T>.entityId(): Column<EntityID<T>>

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

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

inline fun <T : Enum<T>> enumeration(name: String): Column<T>

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

enumerationByName

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

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>

fun foreignKey(vararg references: Pair<Column<*>, Column<*>>, onUpdate: ReferenceOption?, onDelete: ReferenceOption?, name: String?)

fun foreignKey(vararg from: Column<*>, target: Table.PrimaryKey, onUpdate: ReferenceOption?, onDelete: ReferenceOption?, name: String?)

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<*>, functions: List<ExpressionWithColumnType<*>>?, indexType: String?, filterCondition: FilterCondition)

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<*>?, lateral: Boolean, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>?): Join

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

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

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

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

modifyStatement

open override fun modifyStatement(): List<String>

nameInDatabaseCase

fun nameInDatabaseCase(): String

nameInDatabaseCaseUnquoted

fun nameInDatabaseCaseUnquoted(): String

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

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

fun <Unwrapped : Any, Wrapped : Any> Column<Unwrapped>.nullTransform(transformer: ColumnTransformer<Unwrapped, Wrapped?>): Column<Wrapped?>

fun <Unwrapped : Any, Wrapped : Any> Column<Unwrapped>.nullTransform(wrap: (Unwrapped) -> Wrapped?, unwrap: (Wrapped?) -> Unwrapped): Column<Wrapped?>

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

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

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

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

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

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

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

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

fun <T : Any, 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<T & Any>): 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 select(columns: List<Expression<*>>): Query

fun select(column: Expression<*>, vararg columns: Expression<*>): Query

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 <Unwrapped : Any, Wrapped : Any> Column<Unwrapped?>.transform(transformer: ColumnTransformer<Unwrapped?, Wrapped?>): Column<Wrapped?>

fun <Unwrapped : Any, Wrapped : Any> Column<Unwrapped>.transform(transformer: ColumnTransformer<Unwrapped, Wrapped>): Column<Wrapped>

fun <Unwrapped : Any, Wrapped : Any> Column<Unwrapped?>.transform(wrap: (Unwrapped?) -> Wrapped?, unwrap: (Wrapped?) -> Unwrapped?): Column<Wrapped?>

fun <Unwrapped : Any, Wrapped : Any> Column<Unwrapped>.transform(wrap: (Unwrapped) -> Wrapped, unwrap: (Wrapped) -> Unwrapped): Column<Wrapped>

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

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

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

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

fun uniqueIndex(vararg columns: Column<*>, filterCondition: FilterCondition)

fun uniqueIndex(customIndexName: String?, vararg columns: Column<*>, functions: List<ExpressionWithColumnType<*>>?, filterCondition: FilterCondition)

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

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

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

fun <T> Column<T>.withDefinition(vararg definition: Any): Column<T>