gudusoft.gsqlparser.stmt.oracle

Class TPlsqlCreateTrigger

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.oracle.TPlsqlCreateTrigger

All Implemented Interfaces:

Visitable

public class TPlsqlCreateTrigger
extends TCommonStoredProcedureSqlStatement

The CREATE TRIGGER statement creates or replaces a database trigger, which is either of the following:

• A stored PL/SQL block associated with a table, a schema, or the database.
• An anonymous PL/SQL block or a call to a procedure implemented in PL/SQL or Java.

the database automatically executes a trigger when specified conditions occur.

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
TPlsqlCreateTrigger(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)
TParseTreeNode	getEventClause() Deprecated. As of v2.0.1.0, replaced by getTriggeringClause() Indicates what's kind of trigger, can be one of these: TTriggeringClause,define a single trigger on a DML event. TCompoundDmlTriggerClause,define a compound trigger on a DML event. TNonDmlTriggerClause,define a single trigger on a DDL or database event.
TObjectNameList	getFollowsTriggerList()
TFunctionCall	getFunctionCall() PostgreSQL executed function
TObjectName	getStoredProcedureName()
TCustomSqlStatement	getTriggerBody() the PL/SQL block, PL/SQL compound trigger block, TCommonBlock
TTriggeringClause	getTriggeringClause()
TObjectName	getTriggerName() The name of the trigger to be created.
TExpression	getWhenCondition() A SQL condition that must be satisfied for the database to fire the trigger.
void	setEventClause(TParseTreeNode eventClause)
void	setFollowsTriggerList(TObjectNameList followsTriggerList)
void	setFunctionCall(TFunctionCall functionCall)
void	setTriggerBody(TCustomSqlStatement triggerBody)
void	setTriggerName(TObjectName triggerName)
void	setWhenCondition(TExpression whenCondition)

Methods inherited from class gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

getExceptionClause, isWrapped, setExceptionClause, setWrapped

Methods inherited from class gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

getDeclareStatements, getParameterDeclarations, setDeclareStatements, setParameterDeclarations

Methods inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

getBodyStatements, setBodyStatements

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

TPlsqlCreateTrigger

public TPlsqlCreateTrigger(EDbVendor dbvendor)

Method Detail

getTriggeringClause

public TTriggeringClause getTriggeringClause()

getStoredProcedureName

public TObjectName getStoredProcedureName()

Overrides:

getStoredProcedureName in class TStoredProcedureSqlStatement

setFunctionCall

public void setFunctionCall(TFunctionCall functionCall)

getFunctionCall

public TFunctionCall getFunctionCall()

PostgreSQL executed function

Returns:

function call

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCommonStoredProcedureSqlStatement

getTriggerName

public TObjectName getTriggerName()

The name of the trigger to be created.

Returns:

getEventClause

public TParseTreeNode getEventClause()

Deprecated. As of v2.0.1.0, replaced by getTriggeringClause() Indicates what's kind of trigger, can be one of these:

• TTriggeringClause,define a single trigger on a DML event.
• TCompoundDmlTriggerClause,define a compound trigger on a DML event.
• TNonDmlTriggerClause,define a single trigger on a DDL or database event.

Returns:

trigger clause

getWhenCondition

public TExpression getWhenCondition()

A SQL condition that must be satisfied for the database to fire the trigger.

getTriggerBody

public TCustomSqlStatement getTriggerBody()

the PL/SQL block, PL/SQL compound trigger block, TCommonBlock

or call procedure that the database executes to fire the trigger.

Returns:

body statement of trigger

getFollowsTriggerList

public TObjectNameList getFollowsTriggerList()

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

setTriggerName

public void setTriggerName(TObjectName triggerName)

setEventClause

public void setEventClause(TParseTreeNode eventClause)

setWhenCondition

public void setWhenCondition(TExpression whenCondition)

setTriggerBody

public void setTriggerBody(TCustomSqlStatement triggerBody)

setFollowsTriggerList

public void setFollowsTriggerList(TObjectNameList followsTriggerList)