T0
- the first entity typeT1
- the second entity typepublic interface JoinBuilder2<T0,T1> extends HasJoins<JoinBuilder2.AfterJoin<T0,T1,?>,JoinBuilder3<T0,T1,?>>, HasWhere<T1,JoinBuilder2<T0,T1>>, HasDefaultBuild<com.speedment.common.tuple.nullable.Tuple2OfNullables<T0,T1>>
Modifier and Type | Interface and Description |
---|---|
static interface |
JoinBuilder2.AfterJoin<T0,T1,T2> |
Modifier and Type | Method and Description |
---|---|
default Join<com.speedment.common.tuple.nullable.Tuple2OfNullables<T0,T1>> |
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(BiFunction<T0,T1,T> constructor)
Creates and returns a new Join object where elements in the Join
object's stream method is created using the provided
constructor . |
<T2> JoinBuilder3<T0,T1,T2> |
crossJoin(TableIdentifier<T2> joinedTable)
Adds the provided
joinedTable to the collection of joined tables. |
<T2> JoinBuilder2.AfterJoin<T0,T1,T2> |
innerJoinOn(HasComparableOperators<T2,?> joinedField)
Adds the provided
joinedField to the collection of joined
column/tables. |
<T2> JoinBuilder2.AfterJoin<T0,T1,T2> |
leftJoinOn(HasComparableOperators<T2,?> joinedField)
Adds the provided
joinedField to the collection of joined
column/tables. |
<T2> JoinBuilder2.AfterJoin<T0,T1,T2> |
rightJoinOn(HasComparableOperators<T2,?> joinedField)
Adds the provided
joinedField to the collection of joined
column/tables. |
<T2> JoinBuilder2.AfterJoin<T0,T1,T2> innerJoinOn(HasComparableOperators<T2,?> joinedField)
HasJoins
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.innerJoinOn
in interface HasJoins<JoinBuilder2.AfterJoin<T0,T1,?>,JoinBuilder3<T0,T1,?>>
T2
- entity typejoinedField
- to add to the current join builderjoinedField
is added<T2> JoinBuilder2.AfterJoin<T0,T1,T2> leftJoinOn(HasComparableOperators<T2,?> joinedField)
HasJoins
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
leftJoinOn
in interface HasJoins<JoinBuilder2.AfterJoin<T0,T1,?>,JoinBuilder3<T0,T1,?>>
T2
- entity typejoinedField
- to add to the current join builderjoinedField
is added<T2> JoinBuilder2.AfterJoin<T0,T1,T2> rightJoinOn(HasComparableOperators<T2,?> joinedField)
HasJoins
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
rightJoinOn
in interface HasJoins<JoinBuilder2.AfterJoin<T0,T1,?>,JoinBuilder3<T0,T1,?>>
T2
- entity typejoinedField
- to add to the current join builderjoinedField
is added<T2> JoinBuilder3<T0,T1,T2> crossJoin(TableIdentifier<T2> joinedTable)
HasJoins
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.crossJoin
in interface HasJoins<JoinBuilder2.AfterJoin<T0,T1,?>,JoinBuilder3<T0,T1,?>>
T2
- entity typejoinedTable
- to add to the current join builderjoinedField
is addeddefault Join<com.speedment.common.tuple.nullable.Tuple2OfNullables<T0,T1>> build()
HasDefaultBuild
Tuple
type.build
in interface HasDefaultBuild<com.speedment.common.tuple.nullable.Tuple2OfNullables<T0,T1>>
Tuple
type<T> Join<T> build(BiFunction<T0,T1,T> constructor)
constructor
.T
- the type of element in the Join object's stream
method.constructor
- to use to create stream elements.Tuple
typeNullPointerException
- if the provided constructor
is
null
Copyright © 2019 Speedment, Inc.. All rights reserved.