exposed-core/org.jetbrains.exposed.sql/ColumnSet

ColumnSet

abstract class ColumnSet : FieldSet

Represents a set of columns.

Inheritors

Constructors

constructor()

Properties

abstract val columns: List<Column<*>>

Returns the columns of this column set.

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

Returns the field of this field set.

open val realFields: List<Expression<*>>

Returns all real fields, unrolling composite CompositeColumn if present

open override val source: ColumnSet

Return the column set that contains this field set.

Functions

abstract fun crossJoin(otherTable: ColumnSet): Join

Creates a cross join relation with otherTable.

abstract fun describe(s: Transaction, queryBuilder: QueryBuilder)

Appends the SQL representation of this column set to the specified queryBuilder.

abstract fun fullJoin(otherTable: ColumnSet): Join

Creates a full outer join relation with otherTable.

abstract fun innerJoin(otherTable: ColumnSet): Join

Creates an inner join relation with otherTable.

abstract fun join(otherTable: ColumnSet, joinType: JoinType, onColumn: Expression<*>? = null, otherColumn: Expression<*>? = null, lateral: Boolean = false, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>? = null): Join

Creates a join relation with otherTable. When all joining options are absent Exposed will try to resolve referencing columns by itself.

abstract fun leftJoin(otherTable: ColumnSet): Join

Creates a left outer join relation with otherTable.

abstract fun rightJoin(otherTable: ColumnSet): Join

Creates a right outer join relation with otherTable.

fun select(columns: List<Expression<*>>): Query

Creates a SELECT Query using a list of columns or expressions from this ColumnSet.

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

Creates a SELECT Query by selecting either a single column, or a subset of columns, from this ColumnSet.

inline fun FieldSet.~~select~~(where: SqlExpressionBuilder.() -> Op<Boolean>): Query

fun FieldSet.~~select~~(where: Op<Boolean>): Query

fun FieldSet.selectAll(): Query

Creates a SELECT Query by selecting all columns from this ColumnSet.

selectAllBatched

fun FieldSet.~~selectAllBatched~~(batchSize: Int = 1000): Iterable<Iterable<ResultRow>>

fun FieldSet.~~selectBatched~~(batchSize: Int = 1000, where: SqlExpressionBuilder.() -> Op<Boolean>): Iterable<Iterable<ResultRow>>

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

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

fun ColumnSet.targetTables(): List<Table>

Returns the list of tables to which the columns in this column set belong.