Package gudusoft.gsqlparser.nodes

Class TCaseExpression

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TCaseExpression

All Implemented Interfaces:

Visitable, Iterator<TSourceToken>

public class TCaseExpression
extends TParseTreeNode

CASE expressions let you use IF ... THEN ... ELSE logic in SQL statements without having to invoke procedures.

simple case expression:

• CASE input_expr {WHEN comparison_expr THEN return_expr}[...n] [ELSE else_expr] END
• input_expr: getInput_expr()
• WHEN...THEN... list: getWhenClauseItemList()
• else_expr: getElse_expr()

searched case expression: CASE {WHEN comparison_expr THEN return_expr}[...n] [ELSE else_expr] END

• WHEN...THEN... list: getWhenClauseItemList()
• else_expr: getElse_expr()

plsql case statement

• CASE input_expr {WHEN comparison_expr THEN statement}[...n] [ELSE else_statement_list] END
  • input_expr: getInput_expr()
  • WHEN...THEN... list: getWhenClauseItemList()
  • else_statement_list: getElse_statement_list()

See Also:

• TWhenClauseItem
• TWhenClauseItemList

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
TCaseExpression()

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	getElse_expr()
TStatementList	getElse_statement_list()
TStatementListSqlNode	getElse_statement_node_list()
TExpression	getInput_expr()
TWhenClauseItemList	getWhenClauseItemList()
void	init(Object arg1, Object arg2, Object arg3)
void	setElse_expr(TExpression else_expr)
void	setElse_statement_list(TStatementList else_statement_list)
void	setElse_statement_node_list(TStatementListSqlNode else_statement_node_list)
void	setInput_expr(TExpression input_expr)
void	setWhenClauseItemList(TWhenClauseItemList whenClauseItemList)

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, 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

TCaseExpression

public TCaseExpression()

Method Details

getElse_expr

public TExpression getElse_expr()

getInput_expr

public TExpression getInput_expr()

getWhenClauseItemList

public TWhenClauseItemList getWhenClauseItemList()

Returns:

List of When...Then... clause.

getElse_statement_node_list

public TStatementListSqlNode getElse_statement_node_list()

getElse_statement_list

public TStatementList getElse_statement_list()

Returns:

else statement list in plsql case statement.

init

public void init(Object arg1,
 Object arg2,
 Object arg3)

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

setInput_expr

public void setInput_expr(TExpression input_expr)

setElse_expr

public void setElse_expr(TExpression else_expr)

setWhenClauseItemList

public void setWhenClauseItemList(TWhenClauseItemList whenClauseItemList)

setElse_statement_node_list

public void setElse_statement_node_list(TStatementListSqlNode else_statement_node_list)

setElse_statement_list

public void setElse_statement_list(TStatementList else_statement_list)