package gudusoft.gsqlparser.nodes;


import gudusoft.gsqlparser.EDbObjectType;
import gudusoft.gsqlparser.TSourceTokenList;
import gudusoft.gsqlparser.nodes.mssql.TProcedureOption;
import gudusoft.gsqlparser.nodes.oracle.TInvokerRightsClause;
import gudusoft.gsqlparser.TBaseType;
import gudusoft.gsqlparser.nodes.oracle.TParallelEnableClause;

/**
 * Internal use in the parser.
*/

public class TCreateProcedureSqlNode extends TParseTreeNode {

    private TTypeName returnDataType = null;

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

    public TTypeName getReturnDataType() {

        return returnDataType;
    }

    private TDummy returnTable = null;

    public void setReturnTable(TDummy returnTable) {
        this.returnTable = returnTable;
    }

    public TDummy getReturnTable() {
        return returnTable;
    }

    private TObjectName externalName = null;

    /**
     * SQL Server CLR routine body: the <code>assembly.class.method</code> name
     * after <code>AS EXTERNAL NAME</code>.
     */
    public void setExternalName(TObjectName externalName) {
        this.externalName = externalName;
    }

    public TObjectName getExternalName() {
        return externalName;
    }

    private TConstant functionBody = null;

    public TSourceTokenList getFunctionBodyTokenList() {
        return functionBodyTokenList;
    }

    private TSourceTokenList functionBodyTokenList = null;

    public void setFunctionBody(TConstant functionBody) {
        this.functionBody = functionBody;
    }
    public void setFunctionBody(TDummy functionBody) {
        // used in netezza
        if (functionBody.node1 != null){
            if (functionBody.node1 instanceof TConstant){
                this.functionBody = (TConstant)functionBody.node1;
            }
        }else if ((functionBody.st1 != null)&&(functionBody.st2 != null)){
             functionBodyTokenList = new TSourceTokenList();
             for(int i=functionBody.st1.posinlist; i< functionBody.st2.posinlist;i++){
                 functionBodyTokenList.add(functionBody.st1.container.get(i));
             }
        }

    }

    public TConstant getFunctionBody() {
        return functionBody;
    }
    private TConstant procedureLanguage;

    public void setProcedureLanguage(TConstant procedureLanguage) {
        this.procedureLanguage = procedureLanguage;
    }

    public TConstant getProcedureLanguage() {
        return procedureLanguage;
    }
    private TConstant objfile;
    private TConstant linkSymbol;

    public TConstant getLinkSymbol() {
        return linkSymbol;
    }

    public TConstant getObjfile() {
        return objfile;
    }

    public void setFunctionOption(TCreateFunctionOption option){
        switch (option.getOptionType()){
            case block:
                functionBody = option.getFunctionBody();
                break;
            case stmts:
                //setStmts(option.getSqlNodes());
                functionBody = option.getFunctionBody();
                break;
            case language:
                procedureLanguage = option.getLanguage();
                break;
            case objfile:
                objfile = option.getObjfile();
                linkSymbol = option.getLinkSymbol();
                break;
            default:
                break;
        }
    }

    public void setFunctionOptions(TPTNodeList<TCreateFunctionOption> options){
        if (options == null) return;
        for(int i=0;i<options.size();i++){
            setFunctionOption(options.getElement(i));
        }
    }

    private TObjectName endlabelName;

    public void setEndlabelName(TObjectName endlabelName) {
        this.endlabelName = endlabelName;
    }

    public TObjectName getEndlabelName() {

        return endlabelName;
    }

    private TPTNodeList <TProcedureOption> procedureOptions;

    public void setProcedureOptions(TPTNodeList<TProcedureOption> procedureOptions) {
        this.procedureOptions = procedureOptions;
    }

    public TPTNodeList<TProcedureOption> getProcedureOptions() {

        return procedureOptions;
    }

    private boolean isForReplication;

    public void setForReplication(boolean isForReplication) {
        this.isForReplication = isForReplication;
    }

    public boolean isForReplication() {

        return isForReplication;
    }

    private TObjectName labelName;

    public void setLabelName(TObjectName labelName) {
        this.labelName = labelName;
    }

    public TObjectName getLabelName() {

        return labelName;
    }

    private TInvokerRightsClause invokerRightsClause;

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

    public TInvokerRightsClause getInvokerRightsClause() {

        return invokerRightsClause;
    }

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

        return parallelEnableClause;
    }

    private TDummy defaultCollation = null;
    public TDummy getDefaultCollation() {
        return defaultCollation;
    }

    public TDummy accessibleByClause = null;
    public void setAccessibleByClause(TDummy accessibleByClause) {
        this.accessibleByClause = accessibleByClause;
    }
    public TDummy getAccessibleByClause() {
        return accessibleByClause;
    }

    public void setDefaultInvokerAccessByDummy(TDummy dummy){
        if (dummy == null) return;
        switch (dummy.int1){
            case 1: // default_invoker_accessible_item_lists
                for(int i=0;i<dummy.arrayList1.size();i++) {
                    TDummy dummyItem = (TDummy) dummy.arrayList1.get(0);
                    String itemName = dummyItem.toString().toLowerCase();
                    if (itemName.startsWith("default")) {
                        defaultCollation = dummyItem;
                    } else if (itemName.startsWith("auth")) {
                        this.invokerRightsClause = (TInvokerRightsClause) dummyItem.node1;
                    } else if (itemName.startsWith("accessible")) {
                        this.accessibleByClause =dummyItem;
                    }
                }
                break;
            case 2: // parallel_enable_clause
                this.parallelEnableClause = (TParallelEnableClause)dummy.node1;
                break;
            case 3: // RW_PACKAGE
                break;
        }
    }

    private TCallSpec callSpec = null;

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

    public TCallSpec getCallSpec() {

        return callSpec;
    }

    public TObjectName getProcedureName() {
        return procedureName;
    }

    private TObjectName procedureName = null;

    public TParameterDeclarationList getParameters() {
        return parameters;
    }

    private TParameterDeclarationList parameters = null;

    public void setParameters(TParameterDeclarationList parameters) {
        this.parameters = parameters;
    }

    public void setParametersByDummy(TDummy node) {
        if (node == null) return;
        if (node.node1 != null){
            this.parameters = (TParameterDeclarationList)node.node1;
        }
    }

    private TStatementListSqlNode innerStmts = null; //oracle plsql

    public void setInnerStmts(TStatementListSqlNode innerStmts) {
        this.innerStmts = innerStmts;
    }

    private TStatementSqlNode stmt = null;//mysql single stmt in function body

    public void setStmt(TStatementSqlNode stmt) {
        this.stmt = stmt;
    }

    public TStatementSqlNode getStmt() {

        return stmt;
    }

    private TBlockSqlNode blcok = null;    // MySQL

    public void setBlcok(TBlockSqlNode blcok) {
        this.blcok = blcok;
    }

    public TBlockSqlNode getBlcok() {

        return blcok;
    }

    public void init(Object arg1)
    {
       procedureName = (TObjectName)arg1;
       //procedureName.setObjectType(TObjectName.ttobjProcedureName);
       procedureName.setDbObjectType(EDbObjectType.procedure);
       procedureName.splitNameInQuotedIdentifier();
    }
    
    public int getKind() {
        return kind;
    }

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

    }

    private int kind = TBaseType.kind_create;

    public TExceptionClause getExceptionClause() {
        return exceptionClause;
    }

    public void setExceptionClause(TExceptionClause exceptionClause) {
        this.exceptionClause = exceptionClause;
    }

    private TExceptionClause exceptionClause = null; //plsql exception

    public TStatementListSqlNode getInnerStmts() {
        return innerStmts;
    }

    public TStatementListSqlNode getStmts() {
        return stmts;
    }

    private TStatementListSqlNode stmts = null;

    public TStatementListSqlNode getDeclareStmts() {
        return declareStmts;
    }

    public void setDeclareStmts(TStatementListSqlNode declareStmts) {
        this.declareStmts = declareStmts;

    }

    private TStatementListSqlNode declareStmts = null;

    public void setStmts(TStatementListSqlNode stmts) {
        this.stmts = stmts;
    }

    private TCompoundSqlNode compoundSqls = null;

    public void setCompoundSqls(TCompoundSqlNode compoundSqls) {
        this.compoundSqls = compoundSqls;
    }

    public TCompoundSqlNode getCompoundSqls() {

        return compoundSqls;
    }
}