public class JoinObject extends AbstractSQLFragment
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
CROSS
Inner join type Usage: table_reference CROSS [INNER] JOIN table_reference
|
static java.lang.String |
FULL
Outer join type: FULL Usage: table_reference [NATURAL] FULL [OUTER] JOIN table_reference [ON|USING...]
|
static java.lang.String |
INNER
Inner join type Usage: table_reference [CROSS|NATURAL] [INNER] JOIN table_reference [ON|USING...]
|
static java.lang.String |
LEFT
Outer join type: LEFT Usage: table_reference [NATURAL] LEFT [OUTER] JOIN table_reference [ON|USING...]
|
static java.lang.String |
RIGHT
Outer join type: RIGHT Usage: table_reference [NATURAL] RIGHT [OUTER] JOIN table_reference [ON|USING...]
|
COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, NEWLINE, SPACE
Constructor and Description |
---|
JoinObject() |
JoinObject(FromObject left, FromObject right, JoinCondition condition)
Creates a default join for the given FromObjects and condition.
|
JoinObject(FromObject left, FromObject right, java.lang.String type, boolean natural, JoinCondition condition)
Note: If using existing FromObjects for the left or right parameters, it is the responsibility of the API user to remove these FromObjects from the query.
|
Modifier and Type | Method and Description |
---|---|
JoinCondition |
getCondition() |
boolean |
getIncludeJoinKeyword() |
java.lang.String |
getJoinType() |
FromObject |
getLeftExpression() |
ExpressionList |
getLeftPartitionBy() |
FromObject |
getRightExpression() |
ExpressionList |
getRightPartitionBy() |
java.lang.String |
getSQLText()
Return the SQL for this fragment.
|
boolean |
isNatural() |
boolean |
isOuterJoin()
Returns true if this is a FULL, LEFT or RIGHT OUTER JOIN, and false if this is an INNER JOIN.
|
void |
setCondition(JoinCondition condition) |
void |
setIncludeJoinKeyword(boolean inc) |
void |
setJoinType(java.lang.String type) |
void |
setLeftExpression(FromObject left) |
void |
setLeftPartitionBy(ExpressionList leftPartitionBy) |
void |
setNatural(boolean natural) |
void |
setRightExpression(FromObject right) |
void |
setRightPartitionBy(ExpressionList rightPartitionBy) |
appendToBuffer, argsToString, getStartOffset, getTextOrNull, getTextOrNull, getType, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString
setParent
checkInit, checkInit, copyToImpl, equalsImpl, fireObjectUpdated, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization
addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
getParent, setParent
addObjectListener, copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getReferenceIDs, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName
getProperty, getProperty, setProperties, setProperty
public static final java.lang.String LEFT
public static final java.lang.String RIGHT
public static final java.lang.String FULL
public static final java.lang.String INNER
public static final java.lang.String CROSS
public JoinObject()
public JoinObject(FromObject left, FromObject right, JoinCondition condition)
left
-right
-condition
-public JoinObject(FromObject left, FromObject right, java.lang.String type, boolean natural, JoinCondition condition)
left
-right
-type
-natural
-condition
-public FromObject getLeftExpression()
public void setLeftExpression(FromObject left)
public FromObject getRightExpression()
public void setRightExpression(FromObject right)
public boolean getIncludeJoinKeyword()
public void setIncludeJoinKeyword(boolean inc)
public java.lang.String getJoinType()
public void setJoinType(java.lang.String type)
public boolean isNatural()
public void setNatural(boolean natural)
public JoinCondition getCondition()
public void setCondition(JoinCondition condition)
public ExpressionList getLeftPartitionBy()
public void setLeftPartitionBy(ExpressionList leftPartitionBy)
public ExpressionList getRightPartitionBy()
public void setRightPartitionBy(ExpressionList rightPartitionBy)
public boolean isOuterJoin()
public java.lang.String getSQLText()
SQLFragment