com.speedment.runtime.join.builder

Interface JoinBuilder1<T0>

Type Parameters:

T0 - the first entity type

All Superinterfaces:

HasJoins<JoinBuilder1.AfterJoin<T0,?>,JoinBuilder2<T0,?>>, HasWhere<T0,JoinBuilder1<T0>>

public interface JoinBuilder1<T0>
extends HasJoins<JoinBuilder1.AfterJoin<T0,?>,JoinBuilder2<T0,?>>, HasWhere<T0,JoinBuilder1<T0>>

Join Builder stage used when only 1 table has been specified so far.

Since:

3.1.1

Author:

Per Minborg, Emil Forslund

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static interface	JoinBuilder1.AfterJoin<T0,T1>

Method Summary

Modifier and Type	Method and Description
<T1> JoinBuilder2<T0,T1>	crossJoin(TableIdentifier<T1> joinedTable) Adds the provided joinedTable to the collection of joined tables.
<T1> JoinBuilder1.AfterJoin<T0,T1>	innerJoinOn(HasComparableOperators<T1,?> joinedField) Adds the provided joinedField to the collection of joined column/tables.
<T1> JoinBuilder1.AfterJoin<T0,T1>	leftJoinOn(HasComparableOperators<T1,?> joinedField) Adds the provided joinedField to the collection of joined column/tables.
<T1> JoinBuilder1.AfterJoin<T0,T1>	rightJoinOn(HasComparableOperators<T1,?> joinedField) Adds the provided joinedField to the collection of joined column/tables.

Methods inherited from interface com.speedment.runtime.join.trait.HasWhere

where

Method Detail

innerJoinOn

<T1> JoinBuilder1.AfterJoin<T0,T1> innerJoinOn(HasComparableOperators<T1,?> joinedField)

Description copied from interface: HasJoins

Adds the provided joinedField to the collection of joined column/tables. Elements are joined from the table of the provided joinedField using an INNER JOIN whereby rows from two tables are present only if there is a match between the joining columns. Thus, rows that do not have matches in the joining columns will not be present in the result.

Specified by:

innerJoinOn in interface HasJoins<JoinBuilder1.AfterJoin<T0,?>,JoinBuilder2<T0,?>>

Type Parameters:

T1 - entity type

Parameters:

joinedField - to add to the current join builder

Returns:

a builder where the provided joinedField is added

leftJoinOn

<T1> JoinBuilder1.AfterJoin<T0,T1> leftJoinOn(HasComparableOperators<T1,?> joinedField)

Description copied from interface: HasJoins

Adds the provided joinedField to the collection of joined column/tables. Elements are joined from the table of the provided joinedField using an LEFT JOIN whereby rows from two tables are present either if there is a match between the joining columns or for each row from previously existing table(s).

Unmatched rows will have entities from the table in the given joinedField set to null

Specified by:

leftJoinOn in interface HasJoins<JoinBuilder1.AfterJoin<T0,?>,JoinBuilder2<T0,?>>

Type Parameters:

T1 - entity type

Parameters:

joinedField - to add to the current join builder

Returns:

a builder where the provided joinedField is added

rightJoinOn

<T1> JoinBuilder1.AfterJoin<T0,T1> rightJoinOn(HasComparableOperators<T1,?> joinedField)

Description copied from interface: HasJoins

Adds the provided joinedField to the collection of joined column/tables. Elements are joined from the table of the provided joinedField using an RIGHT JOIN whereby rows from two tables are present either if there is a match between the joining columns or for each row from the table for the provided joinedField.

Unmatched rows will have entities from the table in the given joinedField set to null

Specified by:

rightJoinOn in interface HasJoins<JoinBuilder1.AfterJoin<T0,?>,JoinBuilder2<T0,?>>

Type Parameters:

T1 - entity type

Parameters:

joinedField - to add to the current join builder

Returns:

a builder where the provided joinedField is added

crossJoin

<T1> JoinBuilder2<T0,T1> crossJoin(TableIdentifier<T1> joinedTable)

Description copied from interface: HasJoins

Adds the provided joinedTable to the collection of joined tables. Elements are joined from the table of the provided joinedTable using an CROSS JOIN whereby all combination of rows using all tables(s) are produced.

Specified by:

crossJoin in interface HasJoins<JoinBuilder1.AfterJoin<T0,?>,JoinBuilder2<T0,?>>

Type Parameters:

T1 - entity type

Parameters:

joinedTable - to add to the current join builder

Returns:

a builder where the provided joinedField is added