Package net.sf.basedb.core
Class RealJoin
java.lang.Object
net.sf.basedb.core.RealJoin
- All Implemented Interfaces:
Join
,QueryElement
Represents a join from one virtual table in the dynamic database to
a table in the regular database or between two tables in the
regular database.
virtualTable vt JOIN regularTable rt ON rt.id = vt.leftColumn
.
Note that the join is always done to the 'id' of the items in the regular table.
- Version:
- 2.0
- Author:
- Nicklas
- See Also:
- Last modified
- $Date: 2012-09-14 09:28:35 +0200 (fr, 14 sep 2012) $
-
Field Summary
Modifier and TypeFieldDescriptionprivate final JoinType
private final RealTable
private RealTable
private String
private VirtualTable
private VirtualColumn
-
Constructor Summary
ConstructorDescriptionCreate a new join between two regular tables.RealJoin
(JoinType joinType, VirtualTable left, RealTable right, VirtualColumn leftColumn) Create a new join between a virtual and a regular table. -
Method Summary
Modifier and TypeMethodDescriptionboolean
This join is equal to another RealJoin if they join between the same tables using the same columns and join types.Collection<? extends QueryElement>
Get the children of this query element or null if it has no children.private String
getLeftTableAlias
(Query query) private String
getThetaJoin
(Query query, DbControl dc) getThetaJoinCondition
(Query query, DbControl dc) int
hashCode()
Create a query language string of the query element.toString()
-
Field Details
-
joinType
-
right
-
vLeft
-
vLeftColumn
-
rLeft
-
rLeftColumn
-
-
Constructor Details
-
RealJoin
RealJoin(JoinType joinType, VirtualTable left, RealTable right, VirtualColumn leftColumn) Create a new join between a virtual and a regular table.SELECT ... FROM left JOIN right ON right.id = left.column
.- Parameters:
joinType
- The type of joinleft
- The left table to join from, if not specified we join from the root tableright
- The table to join toleftColumn
- The column in the left table to join from, we always join to the id of the real table
-
RealJoin
Create a new join between two regular tables.SELECT ... FROM left JOIN right ON right.id = left.column
.- Parameters:
joinType
- The type of joinleft
- The left table to join from, if not specified we join from the root tableright
- The table to join toleftColumn
- The column in the left table to join from, we always join to the id of the real table
-
-
Method Details
-
toQl
Description copied from interface:QueryElement
Create a query language string of the query element. Use theQuery.getQueryType()
method to find out which query language is wanted in case the element requires different syntax for different languages.- Specified by:
toQl
in interfaceQueryElement
- Parameters:
query
- The query that is about to be executeddc
- TheDbControl
object used to execute the query- Throws:
BaseException
- If there is any other error
-
getChildren
Description copied from interface:QueryElement
Get the children of this query element or null if it has no children. For example theAddExpression
has two children, the expression beeing added.- Specified by:
getChildren
in interfaceQueryElement
- Returns:
- Always null
-
getThetaJoin
- Specified by:
getThetaJoin
in interfaceJoin
- Throws:
BaseException
-
getThetaJoinCondition
- Specified by:
getThetaJoinCondition
in interfaceJoin
- Throws:
BaseException
-
toString
-
equals
This join is equal to another RealJoin if they join between the same tables using the same columns and join types. -
hashCode
public int hashCode() -
getLeftTableAlias
-
getLeftTableColumn
-