Package gudusoft.gsqlparser.nodes

Class TForUpdate

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.nodes.TForUpdate

All Implemented Interfaces:

Visitable, Iterator<TSourceToken>

public class TForUpdate
extends TParseTreeNode

The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock or update the rows until you end your transaction. This clause only in a top-level SELECT statement, not in subqueries.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	TForUpdate.EForUpdateType

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

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.
TObjectNameList	getColumnRefs()	Use the OF ...
TForUpdate.EForUpdateType	getForUpdateType()
String	getWaitValue()
void	init(Object arg1)	Initialize a query tree node.
boolean	isNowait()
boolean	isWait()
void	setColumnRefs(TObjectNameList columnRefs)
void	setForUpdateType(TForUpdate.EForUpdateType forUpdateType)
void	setNowait(boolean nowait)
void	setWait(boolean wait)
void	setWaitNoWait(TDummy dummy)
void	setWaitValue(String waitValue)

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

TForUpdate

public TForUpdate()

Method Details

setWaitNoWait

public void setWaitNoWait(TDummy dummy)

setWait

public void setWait(boolean wait)

setNowait

public void setNowait(boolean nowait)

setWaitValue

public void setWaitValue(String waitValue)

isWait

public boolean isWait()

isNowait

public boolean isNowait()

getWaitValue

public String getWaitValue()

setForUpdateType

public void setForUpdateType(TForUpdate.EForUpdateType forUpdateType)

getForUpdateType

public TForUpdate.EForUpdateType getForUpdateType()

getColumnRefs

public TObjectNameList getColumnRefs()

Use the OF ... column clause to lock the select rows only for a particular table or view in a join. The columns in the OF clause only indicate which table or view rows are locked. The specific columns that you specify are not significant. However, you must specify an actual column name, not a column alias. If you omit this clause, then the database locks the selected rows from all the tables in the query.

Returns:

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

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

setColumnRefs

public void setColumnRefs(TObjectNameList columnRefs)