package gudusoft.gsqlparser.stmt.oracle;

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

/**
 * This class represents 3 types of SQL statement:
 * <ul>
 * <li> Create procedure statement, creates or replaces a standalone stored procedure or a call specification.
 * </li>
 * <li> Declare a procedure inside a PL/SQL block or package.
 * </li>
 * <li> Define a procedure inside a PL/SQL block or package.
 * </li>
 * </ul>
 *
 * @see gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement#declareStatements
 * @see gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement#bodyStatements
*/
public class TPlsqlCreateProcedure extends TCommonStoredProcedureSqlStatement {

    private TInvokerRightsClause invokerRightsClause;

    public void setInvokerRightsClause(TInvokerRightsClause invokerRightsClause) {
        this.invokerRightsClause = invokerRightsClause;
    }

    public TInvokerRightsClause getInvokerRightsClause() {

        return invokerRightsClause;
    }

    @Override
    public TObjectName getStoredProcedureName(){
        return procedureName;
    }
    private int kind = TBaseType.kind_create;

    public void setKind(int kind) {
        this.kind = kind;
    }

    /**
     * Indicates what's kind of SQL statement this class represents for, create proceure, declare a procudure or define a procedure.
     * @return
     */
    public int getKind() {

        return kind;
    }


    /**
     * The name that you give to the procedure that you are declaring or defining.
     * @return
     */
    public TObjectName getProcedureName() {
        return procedureName;
    }

    private TObjectName procedureName = null;

    
    public TPlsqlCreateProcedure(EDbVendor dbvendor){
        super(dbvendor);
        sqlstatementtype = ESqlStatementType.sstplsql_createprocedure ;
        }

    /**
     *
     * @return Oracle plsql inner statements in declared section before IS keyword.
     */
    public TStatementList getInnerStatements() {
        if (innerStatements == null){
            innerStatements = new TStatementList();
        }
        return innerStatements;
    }
    private TStatementList innerStatements = null;


    void buildsql() {
    }

    void clear() {
    }

    String getasprettytext() {
        return "";
    }

    void iterate(TVisitorAbs pvisitor) {
    }

    private TCallSpec callSpec = null;

    /**
     *
     * @return call specification
     */
    public TCallSpec getCallSpec() {
        return callSpec;
    }
    //   private TStatementListSqlNode stmts = null;

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

         //super.doParseStatement(psql);

         this.kind = createProcedureNode.getKind();
         this.callSpec = createProcedureNode.getCallSpec();
         setLabelName(createProcedureNode.getLabelName());
         setEndlabelName(createProcedureNode.getLabelName());

         procedureName = createProcedureNode.getProcedureName();
         this.setParameterDeclarations(createProcedureNode.getParameters());

         invokerRightsClause = createProcedureNode.getInvokerRightsClause();

         // push parameterDeclarations into symbolTable
         if (this.getParameterDeclarations() != null){
             for(int i=0;i< this.getParameterDeclarations().size();i++){
                this.getTopStatement().getSymbolTable().push( new TSymbolTableItem(TObjectName.ttobjParameter,this, this.getParameterDeclarations().getParameterDeclarationItem(i)));
             }
         }
         
         if (createProcedureNode.getInnerStmts() != null){
            createProcedureNode.getInnerStmts().doParse(this,ESqlClause.unknown);

             for(int i= 0; i<createProcedureNode.getInnerStmts().size();i++){
               this.getInnerStatements().add(createProcedureNode.getInnerStmts().getStatementSqlNode(i).getStmt());
             }
         }

         if (createProcedureNode.getDeclareStmts() != null){
            createProcedureNode.getDeclareStmts().doParse(this,ESqlClause.unknown);

             // push variable declare into symbolTable, and add to declareStatements
             for(int i=0;i<createProcedureNode.getDeclareStmts().size();i++){
                this.getTopStatement().getSymbolTable().push( new TSymbolTableItem(TObjectName.ttobjVariable,this,createProcedureNode.getDeclareStmts().getStatementSqlNode(i).getStmt() ));
                this.getDeclareStatements().add(createProcedureNode.getDeclareStmts().getStatementSqlNode(i).getStmt());
             }

         }

         if (createProcedureNode.getStmts() != null){
            createProcedureNode.getStmts().doParse(this,ESqlClause.unknown);

             for(int i= 0; i<createProcedureNode.getStmts().size();i++){
               this.getBodyStatements().add(createProcedureNode.getStmts().getStatementSqlNode(i).getStmt());
             }
         }


         if (createProcedureNode.getExceptionClause() != null){
             createProcedureNode.getExceptionClause().doParse(this,ESqlClause.unknown);
             this.setExceptionClause(createProcedureNode.getExceptionClause());
         }

         if (createProcedureNode.getDeclareStmts() != null){

             // pop variable declare from symbolTable
             for(int i=0;i<createProcedureNode.getDeclareStmts().size();i++){
                this.getTopStatement().getSymbolTable().pop();
             }

         }

         // pop parameterDeclarations from symbolTable
         if (this.getParameterDeclarations() != null){
             for(int i=0;i< this.getParameterDeclarations().size();i++){
                this.getTopStatement().getSymbolTable().pop();
             }
         }

        return 0;
    }

    public void init(Object arg1)
    {
   //     stmts = (TStatementListSqlNode)arg1;
    }



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

    public void acceptChildren(TParseTreeVisitor v){
        v.preVisit(this);

        if (this.getParameterDeclarations() != null) getParameterDeclarations().acceptChildren(v);
        if (getInnerStatements().size() > 0) getInnerStatements().acceptChildren(v);
        if (this.getDeclareStatements().size() > 0) this.getDeclareStatements().acceptChildren(v);
        if ( this.getBodyStatements().size() > 0) getBodyStatements().acceptChildren(v);
        if (getExceptionClause() != null) getExceptionClause().acceptChildren(v);

        v.postVisit(this);
    }

    public void setProcedureName(TObjectName procedureName) {
        this.procedureName = procedureName;
    }

    public void setInnerStatements(TStatementList innerStatements) {
        this.innerStatements = innerStatements;
    }

    public void setCallSpec(TCallSpec callSpec) {
        this.callSpec = callSpec;
    }

}