gudusoft.gsqlparser.stmt

Class TUpdateSqlStatement

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TUpdateSqlStatement

All Implemented Interfaces:

Visitable

public class TUpdateSqlStatement
extends TCustomSqlStatement

SQL update statement.

TCustomSqlStatement.getTargetTable() returns the target table, this table can also be fetched from the first element of TCustomSqlStatement.tables.
If there is a from clause in update statement, TCustomSqlStatement.joins returns all the tables in the from clause.
TCustomSqlStatement.getResultColumnList() returns assignment in set clause.

 UPDATE dbo.Table2
 SET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB
 FROM dbo.Table2
 INNER JOIN dbo.Table1
 ON (dbo.Table2.ColA = dbo.Table1.ColA);

Table: dbo.Table2 can be fetched from TCustomSqlStatement.getTargetTable() or TCustomSqlStatement.tables
set clause: dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB, TCustomSqlStatement.getResultColumnList()
from clause: dbo.Table2 inner join , TCustomSqlStatement.joins

See Also:

TCustomSqlStatement.cteList, TCustomSqlStatement.topClause, TCustomSqlStatement.targetTable, TCustomSqlStatement.outputClause, TCustomSqlStatement.joins, TCustomSqlStatement.resultColumnList, TCustomSqlStatement.whereClause, TCustomSqlStatement.returningClause

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dbvendor, dummytag, isparsed, joins, parser, plsqlparser, rootNode, sourcetokenlist, sqlstatementtype, tables

Constructor Summary

Constructors

Constructor and Description
TUpdateSqlStatement(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method and 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
int	doParseStatement(TCustomSqlStatement psql)
TErrorLoggingClause	getErrorLoggingClause() Oracle, error logging clause
TInsertSqlStatement	getInsertSqlStatement() Teradata, insert statement used after ELSE keyword
TLimitClause	getLimitClause() Couchbase, MySQL limit clause.
TOptionClause	getOptionClause() sql server option clause
TOrderBy	getOrderByClause() Order by clause is not used.
TJoinList	getReferenceJoins() Deprecated. As of v1.9.7.2, use TCustomSqlStatement.joins instead. getReferenceJoins() represents: table_references
TResultColumnList	getUnSetTerms() Couchbase unset clause
TSourceToken	getUpdateToken() UPDATE keyword
TUseKeyIndex	getUseKeyIndex()
void	setErrorLoggingClause(TErrorLoggingClause errorLoggingClause)
void	setLimitClause(TLimitClause limitClause)
void	setOptionClause(TOptionClause optionClause)
void	setOrderByClause(TOrderBy orderByClause)
void	setReferenceJoins(TJoinList referenceJoins)
void	setUnSetTerms(TResultColumnList unSetTerms)
void	setUpdateToken(TSourceToken updateToken)
void	setUseKeyIndex(TUseKeyIndex useKeyIndex)

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeJoin, analyzeTablename, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getFirstPhysicalTable, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentStmt, getResultColumnList, getReturningClause, getStatements, getSymbolTable, getTables, getTargetTable, getTopClause, getTopStatement, getVariableStack, getWhereClause, isnzplsql, isoracleplsql, ispgplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, searchCTEList, searchDaxVariableInStack, setCteList, setEndlabelName, setLabelName, setOutputClause, setParentStmt, setResultColumnList, setReturningClause, setTargetTable, setTopClause, setVariableStack, setWhereClause, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, appendString, doParse, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

TUpdateSqlStatement

public TUpdateSqlStatement(EDbVendor dbvendor)

Method Detail

getInsertSqlStatement

public TInsertSqlStatement getInsertSqlStatement()

Teradata, insert statement used after ELSE keyword

Returns:

insert statement used after ELSE keyword

getErrorLoggingClause

public TErrorLoggingClause getErrorLoggingClause()

Oracle, error logging clause

Returns:

Oracle, error logging clause

getOptionClause

public TOptionClause getOptionClause()

sql server option clause

Returns:

option clause

See Also:

TOptionClause

setUpdateToken

public void setUpdateToken(TSourceToken updateToken)

getUpdateToken

public TSourceToken getUpdateToken()

UPDATE keyword

Returns:

UPDATE keyword in update statement.

getReferenceJoins

public TJoinList getReferenceJoins()

Deprecated. As of v1.9.7.2, use TCustomSqlStatement.joins instead.

getReferenceJoins() represents: table_references

Returns:

table references in from clause

getLimitClause

public TLimitClause getLimitClause()

Couchbase, MySQL limit clause.

Returns:

Couchbase, MySQL limit clause.

getOrderByClause

public TOrderBy getOrderByClause()

Order by clause is not used.

Returns:

Order by clause

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

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

setErrorLoggingClause

public void setErrorLoggingClause(TErrorLoggingClause errorLoggingClause)

setOptionClause

public void setOptionClause(TOptionClause optionClause)

setReferenceJoins

public void setReferenceJoins(TJoinList referenceJoins)

setOrderByClause

public void setOrderByClause(TOrderBy orderByClause)

setLimitClause

public void setLimitClause(TLimitClause limitClause)

setUseKeyIndex

public void setUseKeyIndex(TUseKeyIndex useKeyIndex)

getUseKeyIndex

public TUseKeyIndex getUseKeyIndex()

setUnSetTerms

public void setUnSetTerms(TResultColumnList unSetTerms)

getUnSetTerms

public TResultColumnList getUnSetTerms()

Couchbase unset clause

Returns:

Couchbase unset clause