Package com.hades.builder.sqlCommand.clauseBuilder.join

Class JoinClause<E extends EntityType>

java.lang.Object

com.hades.builder.sqlCommand.clauseBuilder.ClauseElements

com.hades.builder.sqlCommand.clauseBuilder.join.JoinClause<E>

All Implemented Interfaces:

SQLJoinClause<E>

public class JoinClause<E extends EntityType>
extends ClauseElements
implements SQLJoinClause<E>

Author:

alireza_bayat created on 10/30/21

Field Summary

Fields inherited from class com.hades.builder.sqlCommand.clauseBuilder.ClauseElements

clause

Constructor Summary

Constructors

Constructor	Description
JoinClause()
JoinClause(Class<?> clazz)

Method Summary

Modifier and Type	Method	Description
SQLJoinClause<E>	createInstance(E e)	create instance Class of given entity to be used in Join clauses
SQLJoinClause<E>	customJoin(String customJoin)
JoinClause<E>	join(Class<? extends EntityType> referencedClass, String entityKey, String referencedKey, JoinTypes joinTypes)	create join clause with passed referenced class.
SQLJoinClause<E>	join(Class<? extends EntityType> referencedClass, String entityKey, String referencedKey, JoinTypes joinTypes, SQLFilterClause<E> filterClause)	create join clause with passed referenced class.
JoinClause<E>	on()

Methods inherited from class com.hades.builder.sqlCommand.clauseBuilder.ClauseElements

getClause, setClause

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

JoinClause

public JoinClause(Class<?> clazz)

JoinClause

public JoinClause()

Method Details

createInstance

public SQLJoinClause<E> createInstance(E e)

Description copied from interface: SQLJoinClause

create instance Class of given entity to be used in Join clauses

Specified by:

createInstance in interface SQLJoinClause<E extends EntityType>

Returns:

SQLJoinClause object

on

public JoinClause<E> on()

Specified by:

on in interface SQLJoinClause<E extends EntityType>

join

public JoinClause<E> join(Class<? extends EntityType> referencedClass,
 String entityKey,
 String referencedKey,
 JoinTypes joinTypes)

Description copied from interface: SQLJoinClause

create join clause with passed referenced class.

entityKey and referencedKey will be used as foreign key to join to tables.

type of join must be passed to the function from JoinTypes

sample output:
LEFT JOIN listing_type AS listing_type ON listing.listing_type_id = listing_type.id

Specified by:

join in interface SQLJoinClause<E extends EntityType>

Parameters:

referencedClass - entity table class referenced

referencedKey - referenced class key to be used in join

joinTypes - JoinTypes

Returns:

SQLJoinClause

join

public SQLJoinClause<E> join(Class<? extends EntityType> referencedClass,
 String entityKey,
 String referencedKey,
 JoinTypes joinTypes,
 SQLFilterClause<E> filterClause)

Description copied from interface: SQLJoinClause

create join clause with passed referenced class.

entityKey and referencedKey will be used as foreign key to join to tables.

type of join must be passed to the function from JoinTypes

sample output:
LEFT JOIN listing_type AS listing_type ON listing.listing_type_id = listing_type.id AND listing.id != 1000000

Specified by:

join in interface SQLJoinClause<E extends EntityType>

Parameters:

referencedClass - entity table class referenced

referencedKey - referenced class key to be used in join

joinTypes - JoinTypes

filterClause - manage where clause of join

Returns:

SQLJoinClause

See Also:

• SQLFilterClause

customJoin

public SQLJoinClause<E> customJoin(String customJoin)

Specified by:

customJoin in interface SQLJoinClause<E extends EntityType>