com.speedment.runtime.join.builder

Interface JoinBuilder3<T0,T1,T2>

Type Parameters:

T0 - the first entity type

T1 - the second entity type

T2 - the third entity type

All Superinterfaces:

HasDefaultBuild<com.speedment.common.tuple.nullable.Tuple3OfNullables<T0,T1,T2>>, HasJoins<JoinBuilder3.AfterJoin<T0,T1,T2,?>,JoinBuilder4<T0,T1,T2,?>>, HasWhere<T2,JoinBuilder3<T0,T1,T2>>

public interface JoinBuilder3<T0,T1,T2>
extends HasJoins<JoinBuilder3.AfterJoin<T0,T1,T2,?>,JoinBuilder4<T0,T1,T2,?>>, HasWhere<T2,JoinBuilder3<T0,T1,T2>>, HasDefaultBuild<com.speedment.common.tuple.nullable.Tuple3OfNullables<T0,T1,T2>>

Join Builder stage used when only 3 tables 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	JoinBuilder3.AfterJoin<T0,T1,T2,T3>

Method Summary

Modifier and Type	Method and Description
default Join<com.speedment.common.tuple.nullable.Tuple3OfNullables<T0,T1,T2>>	build() Creates and returns a new Join object where elements in the Join object's stream method is of a default Tuple type.
<T> Join<T>	build(com.speedment.common.function.TriFunction<T0,T1,T2,T> constructor) Creates and returns a new Join object where elements in the Join object's stream method is created using the provided constructor.
<T3> JoinBuilder4<T0,T1,T2,T3>	crossJoin(TableIdentifier<T3> joinedTable) Adds the provided joinedTable to the collection of joined tables.
<T3> JoinBuilder3.AfterJoin<T0,T1,T2,T3>	innerJoinOn(HasComparableOperators<T3,?> joinedField) Adds the provided joinedField to the collection of joined column/tables.
<T3> JoinBuilder3.AfterJoin<T0,T1,T2,T3>	leftJoinOn(HasComparableOperators<T3,?> joinedField) Adds the provided joinedField to the collection of joined column/tables.
<T3> JoinBuilder3.AfterJoin<T0,T1,T2,T3>	rightJoinOn(HasComparableOperators<T3,?> 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

<T3> JoinBuilder3.AfterJoin<T0,T1,T2,T3> innerJoinOn(HasComparableOperators<T3,?> 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<JoinBuilder3.AfterJoin<T0,T1,T2,?>,JoinBuilder4<T0,T1,T2,?>>

Type Parameters:

T3 - entity type

Parameters:

joinedField - to add to the current join builder

Returns:

a builder where the provided joinedField is added

leftJoinOn

<T3> JoinBuilder3.AfterJoin<T0,T1,T2,T3> leftJoinOn(HasComparableOperators<T3,?> 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<JoinBuilder3.AfterJoin<T0,T1,T2,?>,JoinBuilder4<T0,T1,T2,?>>

Type Parameters:

T3 - entity type

Parameters:

joinedField - to add to the current join builder

Returns:

a builder where the provided joinedField is added

rightJoinOn

<T3> JoinBuilder3.AfterJoin<T0,T1,T2,T3> rightJoinOn(HasComparableOperators<T3,?> 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<JoinBuilder3.AfterJoin<T0,T1,T2,?>,JoinBuilder4<T0,T1,T2,?>>

Type Parameters:

T3 - entity type

Parameters:

joinedField - to add to the current join builder

Returns:

a builder where the provided joinedField is added

crossJoin

<T3> JoinBuilder4<T0,T1,T2,T3> crossJoin(TableIdentifier<T3> 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<JoinBuilder3.AfterJoin<T0,T1,T2,?>,JoinBuilder4<T0,T1,T2,?>>

Type Parameters:

T3 - entity type

Parameters:

joinedTable - to add to the current join builder

Returns:

a builder where the provided joinedField is added

build

default Join<com.speedment.common.tuple.nullable.Tuple3OfNullables<T0,T1,T2>> build()

Description copied from interface: HasDefaultBuild

Creates and returns a new Join object where elements in the Join object's stream method is of a default Tuple type.

Specified by:

build in interface HasDefaultBuild<com.speedment.common.tuple.nullable.Tuple3OfNullables<T0,T1,T2>>

Returns:

a new Join object where elements in the Join object's stream method is of a default Tuple type

build

<T> Join<T> build(com.speedment.common.function.TriFunction<T0,T1,T2,T> constructor)

Creates and returns a new Join object where elements in the Join object's stream method is created using the provided constructor.

Type Parameters:

T - the type of element in the Join object's stream method.

Parameters:

constructor - to use to create stream elements.

Returns:

a new Join object where elements in the Join object's stream method is of a default Tuple type

Throws:

NullPointerException - if the provided constructor is null