package gudusoft.gsqlparser.stmt.oracle;

import gudusoft.gsqlparser.*;
import gudusoft.gsqlparser.nodes.*;
import gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement;


/**
 *  The CREATE TRIGGER statement creates or replaces a database trigger, which is either of the following:
 * <ul>
 * <li> A stored PL/SQL block associated with a table, a schema, or the database.</li>
 * <li> An anonymous PL/SQL block or a call to a procedure implemented in PL/SQL or Java.</li>
 * </ul>
 *  For detailed information about Oracle simple_dml_trigger, compound_dml_trigger, non_dml_trigger
 *  Please check {@link TTriggeringClause}
 *
 * <p>the database automatically executes a trigger when specified conditions occur.
 */
public class TPlsqlCreateTrigger extends TCommonStoredProcedureSqlStatement {
     public TPlsqlCreateTrigger(EDbVendor dbvendor){
        super(dbvendor);
        sqlstatementtype = ESqlStatementType.sstplsql_createtrigger ;
        }

    void buildsql() {
    }

    void clear() {
    }

    String getasprettytext() {
        return "";
    }

    void iterate(TVisitorAbs pvisitor) {
    }

    private TTriggeringClause triggeringClause;

    public TTriggeringClause getTriggeringClause() {
        return triggeringClause;
    }

    public TObjectName getStoredProcedureName(){
        return triggerName;
    }

    private TFunctionCall functionCall;//postgresql

    public void setFunctionCall(TFunctionCall functionCall) {
        this.functionCall = functionCall;
    }

    /**
     * PostgreSQL executed function
     *
     * @return function call
     */
    public TFunctionCall getFunctionCall() {

        return functionCall;
    }

    public int doParseStatement(TCustomSqlStatement psql) {
        if (rootNode == null) return -1;
        if (super.doParseStatement(psql) != 0) return -1;

        TCreateTriggerSqlNode createTriggerNode = (TCreateTriggerSqlNode)rootNode;
        //super.doParseStatement(psql);
        this.triggerName = createTriggerNode.getTriggerName();
        //createTriggerNode.getTrigger_event_clause().doParse(this,ESqlClause.unknown);
        //this.eventClause = createTriggerNode.getTrigger_event_clause();
        triggeringClause = createTriggerNode.getTriggeringClause();
        triggeringClause.doParse(this,ESqlClause.unknown);


        if (createTriggerNode.getWhenCondition() != null){
            createTriggerNode.getWhenCondition().doParse(this,ESqlClause.unknown);
            this.whenCondition = createTriggerNode.getWhenCondition(); 
        }

        functionCall = createTriggerNode.getFunctionCall();

        followsTriggerList = createTriggerNode.getFollowsTriggerList();
        
        createTriggerNode.getStmt().doParse(this,ESqlClause.unknown);
        this.triggerBody = createTriggerNode.getStmt().getStmt(); 

        return 0;
    }

    private TObjectName triggerName;

    /**
     * The name of the trigger to be created.
     * @return
     */
    public TObjectName getTriggerName() {
        return triggerName;
    }

    private TParseTreeNode eventClause;

    /**
     * @deprecated As of v2.0.1.0, replaced by {@link #getTriggeringClause()}
     *
     * Indicates what's kind of trigger, can be one of these:
     * <ul>
     * <li>{@link gudusoft.gsqlparser.nodes.TTriggeringClause},define a single trigger on a DML event.</li>
     * <li>{@link TCompoundDmlTriggerClause},define a compound trigger on a DML event.</li>
     * <li>{@link TNonDmlTriggerClause},define a single trigger on a DDL or database event.</li>
     * </ul>
     * @return trigger clause
     */
    public TParseTreeNode getEventClause() {
        return eventClause;
    }

    /**
     * A SQL condition that must be satisfied for the database to fire the trigger.
     */
    public TExpression getWhenCondition() {
        return whenCondition;
    }

    private TExpression whenCondition;

    private TCustomSqlStatement triggerBody;

    /**
     * the PL/SQL block, PL/SQL compound trigger block, {@link gudusoft.gsqlparser.stmt.TCommonBlock}
     * <p>or call procedure that the database executes to fire the trigger.
     * @return body statement of trigger
     */
    public TCustomSqlStatement getTriggerBody() {
        return triggerBody;
    }

    private TObjectNameList followsTriggerList;

    public TObjectNameList getFollowsTriggerList() {
        return followsTriggerList;
    }

    public void accept(TParseTreeVisitor v){
        v.preVisit(this);
        v.postVisit(this);
    }

    public void acceptChildren(TParseTreeVisitor v){
        v.preVisit(this);
        if (eventClause != null) {
            eventClause.acceptChildren(v);
        }else if (getTriggeringClause() != null){
            getTriggeringClause().acceptChildren(v);
        }
        if (followsTriggerList != null)  followsTriggerList.acceptChildren(v);
        if (whenCondition != null) whenCondition.acceptChildren(v);
        triggerBody.acceptChildren(v);
        v.postVisit(this);
    }

    public void setTriggerName(TObjectName triggerName) {
        this.triggerName = triggerName;
    }

    public void setEventClause(TParseTreeNode eventClause) {
        this.eventClause = eventClause;
    }

    public void setWhenCondition(TExpression whenCondition) {
        this.whenCondition = whenCondition;
    }

    public void setTriggerBody(TCustomSqlStatement triggerBody) {
        this.triggerBody = triggerBody;
    }

    public void setFollowsTriggerList(TObjectNameList followsTriggerList) {
        this.followsTriggerList = followsTriggerList;
    }
}