gudusoft.gsqlparser.stmt

Class TDeleteSqlStatement

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TDeleteSqlStatement

All Implemented Interfaces:

Visitable

public class TDeleteSqlStatement
extends TCustomSqlStatement

SQL delete statement.

TCustomSqlStatement.getTargetTable() returns the target table of delete statement, this table also stored in the first element of TCustomSqlStatement.tables.
MySQL may contains multiple target tables, please fetch those tables from TCustomSqlStatement.joins.
If there is a FROM clause in the delete statement, all those tables in the from clause can be fetched from getReferenceJoins().

   DELETE FROM Production.ProductCostHistory
   WHERE StandardCost > 1000.00;
  

Production.ProductCostHistory can be fetched from TCustomSqlStatement.getTargetTable() or TCustomSqlStatement.tables

  DELETE FROM Sales.SalesPersonQuotaHistory
  FROM Sales.SalesPersonQuotaHistory AS spqh
  INNER JOIN Sales.SalesPerson AS sp
  ON spqh.BusinessEntityID = sp.BusinessEntityID
  WHERE sp.SalesYTD > 2500000.00;
 

Sales.SalesPersonQuotaHistory AS spqh should be fetched froom getReferenceJoins()

See Also:

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

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
TDeleteSqlStatement(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) Used internal.
TSourceToken	getDeleteToken() DELETE keyword of the delete statement.
TErrorLoggingClause	getErrorLoggingClause() Oracle error logging clause
TLimitClause	getLimitClause() MySQL limit clause.
TOptionClause	getOptionClause() sql server option clause
TOrderBy	getOrderByClause() MySQL order by clause.
TJoinList	getReferenceJoins() If there is a FROM clause in delete statement, this method returns the list of join table in the from clause.
TUseKeyIndex	getUseKeyIndex() Couchbase use key index
boolean	isFromKeyword() Whether FROM keyword is used.
void	setDeleteToken(TSourceToken deleteToken)
void	setErrorLoggingClause(TErrorLoggingClause errorLoggingClause)
void	setFromKeyword(boolean fromKeyword)
void	setLimitClause(TLimitClause limitClause)
void	setOptionClause(TOptionClause optionClause)
void	setOrderByClause(TOrderBy orderByClause)
void	setReferenceJoins(TJoinList referenceJoins)
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

TDeleteSqlStatement

public TDeleteSqlStatement(EDbVendor dbvendor)

Method Detail

setFromKeyword

public void setFromKeyword(boolean fromKeyword)

isFromKeyword

public boolean isFromKeyword()

Whether FROM keyword is used.

Returns:

true if FROM keyword is used after delete.

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

setDeleteToken

public void setDeleteToken(TSourceToken deleteToken)

getDeleteToken

public TSourceToken getDeleteToken()

DELETE keyword of the delete statement.

Returns:

DELETE token in delete statement.

getOrderByClause

public TOrderBy getOrderByClause()

MySQL order by clause.

Returns:

MySQL order by clause.

getLimitClause

public TLimitClause getLimitClause()

MySQL limit clause.

Returns:

MySQL limit clause.

getReferenceJoins

public TJoinList getReferenceJoins()

If there is a FROM clause in delete statement, this method returns the list of join table in the from clause.

Returns:

list of TJoin

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Used internal.

Overrides:

doParseStatement in class TCustomSqlStatement

Parameters:

psql - input sql.

Returns:

zero if no syntax error detected.

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)

setOrderByClause

public void setOrderByClause(TOrderBy orderByClause)

setLimitClause

public void setLimitClause(TLimitClause limitClause)

setReferenceJoins

public void setReferenceJoins(TJoinList referenceJoins)

setUseKeyIndex

public void setUseKeyIndex(TUseKeyIndex useKeyIndex)

getUseKeyIndex

public TUseKeyIndex getUseKeyIndex()

Couchbase use key index

Returns:

use key index