package gudusoft.gsqlparser.stmt.oracle;

import gudusoft.gsqlparser.*;
import gudusoft.gsqlparser.compiler.TVariable;
import gudusoft.gsqlparser.nodes.*;
import gudusoft.gsqlparser.nodes.oracle.TInvokerRightsClause;
import gudusoft.gsqlparser.nodes.oracle.TParallelEnableClause;
import gudusoft.gsqlparser.nodes.oracle.TResultCacheClause;
import gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement;


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

/**
 * Oracle create function.
 *
 */
public class TPlsqlCreateFunction extends TCommonStoredProcedureSqlStatement {

    private boolean isDeterministic;
    private TInvokerRightsClause invokerRightsClause;
    private TParallelEnableClause parallelEnableClause;
    private TResultCacheClause resultCacheClause;
    private TObjectName implementionType;

    public TObjectName getImplementionType() {
        return implementionType;
    }

    public boolean isDeterministic() {
        return isDeterministic;
    }

    public TParallelEnableClause getParallelEnableClause() {
        return parallelEnableClause;
    }

    public TResultCacheClause getResultCacheClause() {
        return resultCacheClause;
    }

    public TInvokerRightsClause getInvokerRightsClause() {

        return invokerRightsClause;
    }
    @Override
    public TObjectName getStoredProcedureName(){
        return functionName;
    }


    /**
     * The name that you give to the function that you are declaring or defining.
     * @return
     */
    public TObjectName getFunctionName() {
        return functionName;
    }
    
    /**
     * Indicates what's kind of SQL statement this class represents for, create function, declare a function or define a function.
     * @return
     */
    public int getKind() {
        return kind;
    }

    private TObjectName functionName = null;

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

    private int kind = TBaseType.kind_create;// what's kind of this function

    public TPlsqlCreateFunction(EDbVendor dbvendor){
        super(dbvendor);
        sqlstatementtype = ESqlStatementType.sstplsql_createfunction ;
        }

    private TCallSpec callSpec = null;

    /**
     * call specification
     * @return
     */
    public TCallSpec getCallSpec() {
        return callSpec;
    }

    void buildsql() {
    }



    void clear() {
    }

    String getasprettytext() {
        return "";
    }

    void iterate(TVisitorAbs pvisitor) {
    }

 //   private TStatementListSqlNode stmts = null;

     public int doParseStatement(TCustomSqlStatement psql) {
         if (rootNode == null) return -1;
         if (isWrapped()) return  0;
         TCreateFunctionSqlNode createFunctionNode = (TCreateFunctionSqlNode)rootNode;

         //super.doParseStatement(psql);
         if (super.doParseStatement(psql) != 0) return -1;
         functionName = createFunctionNode.getFunctionName();
         this.setParameterDeclarations(createFunctionNode.getParameters());
         this.returnDataType = createFunctionNode.getReturnDataType(); 

         invokerRightsClause = createFunctionNode.getInvokerRightsClause();
         isDeterministic = createFunctionNode.isDeterministic();
         parallelEnableClause = createFunctionNode.getParallelEnableClause();
         resultCacheClause = createFunctionNode.getResultCacheClause();

         this.implementionType = createFunctionNode.getImplementionType();
         this.callSpec = createFunctionNode.getCallSpec();
         setLabelName(createFunctionNode.getLabelName());
         setEndlabelName(createFunctionNode.getLabelName());

         // 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)));

                 TParameterDeclaration parameterDeclaration = this.getParameterDeclarations().getParameterDeclarationItem(i);
                 if (parameterDeclaration.getParameterName() != null){
                     this.stmtScope.addSymbol(new TVariable(parameterDeclaration.getParameterName(),parameterDeclaration,functionName));
                 }
             }
         }

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

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


         if (createFunctionNode.getStmts() != null){
            createFunctionNode.getStmts().doParse(this,ESqlClause.unknown);
             for(int i= 0; i<createFunctionNode.getStmts().size();i++){
               this.getBodyStatements().add(createFunctionNode.getStmts().getStatementSqlNode(i).getStmt());
             }
         }

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

         if (createFunctionNode.getDeclareStmts() != null){
           
             // pop variable declare from symbolTable
             for(int i=0;i<createFunctionNode.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;
    }

    private TTypeName returnDataType = null;

    public void setReturnDataType(TTypeName returnDataType) {
        this.returnDataType = returnDataType;
    }

    /**
     * Datatype of value returned by this function.
     * @return
     */
    public TTypeName getReturnDataType() {

        return returnDataType;
    }


    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 (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 setDeterministic(boolean isDeterministic) {
        this.isDeterministic = isDeterministic;
    }

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

    public void setParallelEnableClause(TParallelEnableClause parallelEnableClause) {
        this.parallelEnableClause = parallelEnableClause;
    }

    public void setResultCacheClause(TResultCacheClause resultCacheClause) {
        this.resultCacheClause = resultCacheClause;
    }

    public void setImplementionType(TObjectName implementionType) {
        this.implementionType = implementionType;
    }

    public void setFunctionName(TObjectName functionName) {
        this.functionName = functionName;
    }

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