| com.completex.objective.components.persistency.core.Join
All known Subclasses: com.completex.objective.components.persistency.core.impl.JoinImpl,
| Join | | public interface Join (Code) | | Represents database join. Depending on the database policy it will produce either ANSI or proprietiry
join SQL fragments
author:
Gennady Krizhevsky |
| Inner Class :public static class Type implements Serializable | |
| Inner Class :public static class TableIterator | |
| Field Summary | |
| final public static Type | INNER
| | final public static Type | JOIN
| | final public static Type | LEFT
| | final public static Type | NULL_JOIN
| | final public static Type | RIGHT
| | final public static String | SPC
|
| Method Summary | |
| Join | addInnerJoin(String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
Object representation of clause like
... | | Join | addInnerJoin(String joinedTableName, String joinedTableAlias)
| | public Join | addInnerJoin(String joinedTableName)
| | public Join | addInnerJoin(String joinedTableName, String[] firstTableColumns, String[] joinedTableColumns)
| | Join | addInnerJoin(String joinedTableName, String firstTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
| | Join | addJoin(Type type, String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
| | public Join | addJoin(Type type, String joinedTableName, String[] firstTableColumns, String[] joinedTableColumns)
| | Join | addJoin(Type type, String firstTableName, String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
| | Join | addLeftJoin(String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
Object representation of clause like
... | | public Join | addLeftJoin(String joinedTableName, String[] firstTableColumns, String[] joinedTableColumns)
| | Join | addLeftJoin(String joinedTableName, String firstTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
| | Join | addRightJoin(String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
Object representation of clause like
... | | public Join | addRightJoin(String joinedTableName, String[] firstTableColumns, String[] joinedTableColumns)
| | Join | addRightJoin(String joinedTableName, String firstTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)
| | void | addTable(Table table)
| | Object | clone()
| | Join | compile(DatabasePolicy policy)
| | Table | getFirstAddedTable()
| | String | getFrom()
| | Table | getLastAddedTable()
| | String | getWhere()
| | boolean | isCompiled()
| | TableIterator | iterator()
| | Join | joinMinusOne()
This method will produce join of all tables excluding the very 1st one.
It assumes that only the 2nd table is connected to the 1st one. | | int | size()
|
| INNER | | final public static Type INNER(Code) | | |
| JOIN | | final public static Type JOIN(Code) | | |
| LEFT | | final public static Type LEFT(Code) | | |
| NULL_JOIN | | final public static Type NULL_JOIN(Code) | | |
| RIGHT | | final public static Type RIGHT(Code) | | |
| addInnerJoin | | Join addInnerJoin(String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)(Code) | | Object representation of clause like
... INNER JOIN ON ( = )
Parameters:
joinedTableName -
Parameters:
joinedTableAlias -
Parameters:
firstTableColumns -
Parameters:
joinedTableColumns - this Join |
| addInnerJoin | | Join addInnerJoin(String joinedTableName, String joinedTableAlias)(Code) | | Add root table in join
Parameters:
joinedTableName -
Parameters:
joinedTableAlias - this Join |
| addLeftJoin | | Join addLeftJoin(String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)(Code) | | Object representation of clause like
... LEFT JOIN ON ( = )
Parameters:
joinedTableName -
Parameters:
joinedTableAlias -
Parameters:
firstTableColumns -
Parameters:
joinedTableColumns - this Join |
| addRightJoin | | Join addRightJoin(String joinedTableName, String joinedTableAlias, String[] firstTableColumns, String[] joinedTableColumns)(Code) | | Object representation of clause like
... RIGHT JOIN ON ( = )
Parameters:
joinedTableName -
Parameters:
joinedTableAlias -
Parameters:
firstTableColumns -
Parameters:
joinedTableColumns - this Join |
| addTable | | void addTable(Table table)(Code) | | |
| getFirstAddedTable | | Table getFirstAddedTable()(Code) | | |
| getLastAddedTable | | Table getLastAddedTable()(Code) | | |
| getWhere | | String getWhere()(Code) | | Returns different result depending on whether ANSI or proprietory joing is used
where |
| isCompiled | | boolean isCompiled()(Code) | | Returns different result depending on whether ANSI or proprietory joing is used
true if Join is compiled |
| iterator | | TableIterator iterator()(Code) | |
See Also: TableIterator TableIterator |
| joinMinusOne | | Join joinMinusOne()(Code) | | This method will produce join of all tables excluding the very 1st one.
It assumes that only the 2nd table is connected to the 1st one. Otherwise
it will produce result that does not make sense
join of all tables excluding the 1st one |
|
|