Package gudusoft.gsqlparser.nodes

Class TMergeWhenClause

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TMergeWhenClause

All Implemented Interfaces:

Visitable, Iterator<TSourceToken>

public class TMergeWhenClause
extends TParseTreeNode

when [not] matched clause in merge statement.

     merge into ....
     [when matched [and search_conditions ] then update set {col_name = expression} | delete]
     [when not matched [and search_conditions ] then insert [(column_list)] values (value_list)]
 

call method getCondition() to return search_condition if any.

call method getUpdateClause(), getDeleteClause() and getInsertClause() separately to get related update clause, delete clause and insert clause.

See Also:

• TMergeUpdateClause
• TMergeDeleteClause
• TMergeInsertClause

Field Summary

Fields

Modifier and Type	Field	Description
static final int	matched
static final int	matched_with_condition
static final int	not_matched
static final int	not_matched_by_source
static final int	not_matched_by_source_with_condition
static final int	not_matched_by_target
static final int	not_matched_by_target_with_condition
static final int	not_matched_with_condition

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

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

Constructor Summary

Constructors

Constructor	Description
TMergeWhenClause()

Method Summary

Modifier and Type	Method	Description
void	accept(TParseTreeVisitor v)	Accept a visitor
void	acceptChildren(TParseTreeVisitor v)	Accept a visitor to iterate this class and sub-nodes of this class
void	doParse(TCustomSqlStatement psql, ESqlClause plocation)	Analyze the sub-nodes inside this node.
TExpression	getCondition()
TMergeDeleteClause	getDeleteClause()
TMergeDoNothingClause	getDoNothingClause()
TMergeInsertClause	getInsertClause()
int	getType()
TMergeUpdateClause	getUpdateClause()
void	init(Object arg1)	Initialize a query tree node.
void	init(Object arg1, Object arg2)
void	setCondition(TExpression condition)
void	setDeleteClause(TMergeDeleteClause deleteClause)
void	setInsertClause(TMergeInsertClause insertClause)
void	setType(int type)
void	setUpdateClause(TMergeUpdateClause updateClause)

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, 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, 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

Field Details

matched

public static final int matched

See Also:

• Constant Field Values

not_matched

public static final int not_matched

See Also:

• Constant Field Values

matched_with_condition

public static final int matched_with_condition

See Also:

• Constant Field Values

not_matched_with_condition

public static final int not_matched_with_condition

See Also:

• Constant Field Values

not_matched_by_target

public static final int not_matched_by_target

See Also:

• Constant Field Values

not_matched_by_target_with_condition

public static final int not_matched_by_target_with_condition

See Also:

• Constant Field Values

not_matched_by_source

public static final int not_matched_by_source

See Also:

• Constant Field Values

not_matched_by_source_with_condition

public static final int not_matched_by_source_with_condition

See Also:

• Constant Field Values

Constructor Details

TMergeWhenClause

public TMergeWhenClause()

Method Details

setCondition

public void setCondition(TExpression condition)

getType

public int getType()

getCondition

public TExpression getCondition()

getDoNothingClause

public TMergeDoNothingClause getDoNothingClause()

getUpdateClause

public TMergeUpdateClause getUpdateClause()

getDeleteClause

public TMergeDeleteClause getDeleteClause()

getInsertClause

public TMergeInsertClause getInsertClause()

setType

public void setType(int type)

init

public void init(Object arg1)

Description copied from class: TParseTreeNode

Initialize a query tree node. Used internally

Overrides:

init in class TParseTreeNode

Parameters:

arg1 - first argument

init

public void init(Object arg1,
 Object arg2)

Overrides:

init in class TParseTreeNode

doParse

public void doParse(TCustomSqlStatement psql,
 ESqlClause plocation)

Description copied from class: TParseTreeNode

Analyze the sub-nodes inside this node. Such as build the relationship between table and column.

Overrides:

doParse in class TParseTreeNode

Parameters:

psql - SQL statement this node belongs to

plocation - SQL clause this node belongs to

accept

public void accept(TParseTreeVisitor v)

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)

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

setUpdateClause

public void setUpdateClause(TMergeUpdateClause updateClause)

setInsertClause

public void setInsertClause(TMergeInsertClause insertClause)

setDeleteClause

public void setDeleteClause(TMergeDeleteClause deleteClause)