exposed-core/org.jetbrains.exposed.v1.core/Join

Join

class Join(val table: ColumnSet) : ColumnSet

Represents a join relation between multiple column sets.

Constructors

constructor( table: ColumnSet, otherTable: ColumnSet, joinType: JoinType = JoinType.INNER, onColumn: Expression<*>? = null, otherColumn: Expression<*>? = null, lateral: Boolean = false, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>? = null)

constructor(table: ColumnSet)

Properties

columns

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

Returns the columns of this column set.

fields

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

Returns the field of this field set.

lastQueryAlias

val Join.lastQueryAlias: QueryAlias?

Returns the most recent QueryAlias instance used to create this join relation, or null if a query was not joined.

realFields

open val realFields: List<Expression<*>>

Returns all real fields, unrolling composite CompositeColumn if present

source

open override val source: ColumnSet

Return the column set that contains this field set.

table

val table: ColumnSet

The column set to which others will be joined.

Functions

alreadyInJoin

fun alreadyInJoin(table: Table): Boolean

Return true if the specified table is already in this join, false otherwise.

crossJoin

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

Creates a cross join relation with otherTable.

describe

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

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

fullJoin

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

Creates a full outer join relation with otherTable.

innerJoin

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

Creates an inner join relation with otherTable.

join

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

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

joinQuery

fun Join.joinQuery( on: SqlExpressionBuilder.(QueryAlias) -> Op<Boolean>? = null, joinType: JoinType = JoinType.INNER, lateral: Boolean = false, joinPart: () -> AbstractQuery<*>): Join

Creates a join relation with a query.

leftJoin

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

Creates a left outer join relation with otherTable.

rightJoin

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

Creates a right outer join relation with otherTable.

targetTables

fun ColumnSet.targetTables(): List<Table>

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