Package gudusoft.gsqlparser.nodes

Class TJoinItem

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TJoinItem

All Implemented Interfaces:

Visitable, Iterator<TSourceToken>

public class TJoinItem
extends TParseTreeNode

Deprecated.

As of v2.7.4.0, Please use TJoinExpr instead.

SQL 1:

 select f from t1 left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1

In above SQL, the whole from clause can be represented by a TJoin class.

And "left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1" was represented by 2 instance of class TJoinItem.

These 2 instance can be accessed via TJoin.getJoinItems().

One for: "left join t2 on t1.f1 = t2.f1", the other is "right join t3 on t1.f1 = t3.f1".

Field Summary

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor	Description
TJoinItem()	Deprecated.

Method Summary

Modifier and Type	Method	Description
void	accept(TParseTreeVisitor v)	Deprecated. Accept a visitor
void	acceptChildren(TParseTreeVisitor v)	Deprecated. Accept a visitor to iterate this class and sub-nodes of this class
TJoin	getJoin()	Deprecated. Valid when getKind() = TBaseType.join_source_join, means this joinitem start with a join.
EJoinType	getJoinType()	Deprecated.
int	getKind()	Deprecated. According to the table source in from clause, there are 2 kinds of joinitem.
TExpression	getOnCondition()	Deprecated.
TTable	getTable()	Deprecated. Valid when getKind() = TBaseType.join_source_table, means this joinitem start with a table.
TObjectNameList	getUsingColumns()	Deprecated.
void	setJoin(TJoin join)	Deprecated.
void	setJoinType(EJoinType joinType)	Deprecated.
void	setKind(int kind)	Deprecated.
void	setOnCondition(TExpression onCondition)	Deprecated.
void	setTable(TTable table)	Deprecated.
void	setUsingColumns(TObjectNameList usingColumns)	Deprecated.

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getParentObjectName, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toScript, toString, toString2

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Iterator

forEachRemaining

Constructor Details

TJoinItem

public TJoinItem()

Deprecated.

Method Details

getJoin

public TJoin getJoin()

Deprecated.

Valid when getKind() = TBaseType.join_source_join, means this joinitem start with a join.

getJoinType

public EJoinType getJoinType()

Deprecated.

Returns:

join type of this join, such as left join, right join.

getTable

public TTable getTable()

Deprecated.

Valid when getKind() = TBaseType.join_source_table, means this joinitem start with a table.

Returns:

setJoin

public void setJoin(TJoin join)

Deprecated.

setKind

public void setKind(int kind)

Deprecated.

getKind

public int getKind()

Deprecated.

According to the table source in from clause, there are 2 kinds of joinitem.

• TBaseType.join_source_table means this joinitem start with a table.

  select f from t1 join t2 on t1.f1 = t2.f1

  Text representation of this class is: "join t2 on t1.f1 = t2.f1"

  "t2" can be fetch from getTable().

• TBaseType.join_source_join means this joinitem start with a join.

   select f1 from a  join (c join c1 on c.f1 = c1.f1) c2   on a.f1=c2.f1

  Text representation of this class is: "join (c join c1 on c.f1 = c1.f1) c2 on a.f1=c2.f1"

  "(c join c1 on c.f1 = c1.f1)" can be fetched from getJoin().

Returns:

setTable

public void setTable(TTable table)

Deprecated.

setUsingColumns

public void setUsingColumns(TObjectNameList usingColumns)

Deprecated.

getUsingColumns

public TObjectNameList getUsingColumns()

Deprecated.

setOnCondition

public void setOnCondition(TExpression onCondition)

Deprecated.

getOnCondition

public TExpression getOnCondition()

Deprecated.

Returns:

join condition, is type of TExpression.

setJoinType

public void setJoinType(EJoinType joinType)

Deprecated.

accept

public void accept(TParseTreeVisitor v)

Deprecated.

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Deprecated.

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor