package gudusoft.gsqlparser.stmt;

import gudusoft.gsqlparser.*;
import gudusoft.gsqlparser.compiler.TFrame;
import gudusoft.gsqlparser.compiler.TVariable;
import gudusoft.gsqlparser.nodes.*;

import static gudusoft.gsqlparser.EDeclareType.variable;


/**
 * Represents declare statement that used to decalre variable, constant, exception and subtype. 
 * Or Signifies that the statement is a pragma (compiler directive), including exception_init_pragma,
 *  autonomous_transaction_pragma, restrict_references_pragma, serially_resuable_pragma and pragma_timestamp
 */

public class TVarDeclStmt extends TCustomSqlStatement {

    public TVarDeclStmt(){
        this(EDbVendor.dbvoracle);
    }

    public TVarDeclStmt(EDbVendor dbvendor){
        super(dbvendor);
        sqlstatementtype = ESqlStatementType.sstplsql_vardecl ;
        }

    void buildsql() {
    }

    void clear() {
    }

    String getasprettytext() {
        return "";
    }

    void iterate(TVisitorAbs pvisitor) {
    }

    private TObjectName elementName = null;
    private TTypeName dataType = null;
    private boolean NotNull = false;
    private TExpression value = null;


    private int howtoSetValue = TBaseType.howtoSetValue_none;

    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#variable}
     */
    public final static int whatDeclared_variable = 1;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#constant}
     */
    public final static int whatDeclared_constant = 2;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#exception}
     */
    public final static int whatDeclared_exception = 3;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#subtype}
     */
    public final static int whatDeclared_subtype = 4;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_exception_init}
     */
    public final static int whatDeclared_pragma_exception_init = 5;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_autonomous_transaction}
     */
    public final static int whatDeclared_pragma_autonomous_transaction = 6;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_serially_reusable}
     */
    public final static int whatDeclared_pragma_serially_reusable = 7;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_timestamp}
     */
    public final static int whatDeclared_pragma_timestamp = 8;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_restrict_references}
     */
    public final static int whatDeclared_pragma_restrict_references = 9;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_interface}
     */
    public final static int whatDeclared_pragma_interface = 10;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_coverage}
     */
    public final static int whatDeclared_pragma_coverage = 11;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_deprecate}
     */
    public final static int whatDeclared_pragma_deprecate = 12;
    /**
     * @deprecated As of v1.4.8.8, replaced by {@link EDeclareType#pragma_suppresses_warning_6009}
     */
    public final static int whatDeclared_pragma_suppresses_warning_6009 = 13;

    public void setWhatDeclared(int whatDeclared) {
        this.whatDeclared = whatDeclared;
    }

    /**
     * Indicates what's kind of element this delcare statement declared such as variable, constant, exception, subtype and various pragma clause.
     * @return
     */
    public int getWhatDeclared() {
        return whatDeclared;
    }

    /**
     * How deafult value of a variable or constant was set.
     * <p> := | DEFAULT
     * <p> := {@link  TBaseType#howtoSetValue_assign}
     * <p> or DEFAULT keyword  {@link  TBaseType#howtoSetValue_default};
     * @return
     */

    public int getHowtoSetValue() {
        return howtoSetValue;
    }

    /**
     * @deprecated As of v1.4.8.8, replaced by {@link #getDefaultValue()}
     */
    public TExpression getValue() {
        return value;
    }

    /**
     * Specifies that no element can have the value NULL.
     * @return
     */
    public boolean getNotNull() {
        return NotNull;
    }

    private int whatDeclared = whatDeclared_variable;
    private EDeclareType declareType = variable;
    private TObjectName collateName;
    private TExpression defaultValue;

    public void setDefaultValue(TExpression defaultValue) {
        this.defaultValue = defaultValue;
    }

    /**
     * Default value of a variable or constant that declared.
     */
    public TExpression getDefaultValue() {

        return defaultValue;
    }

    public void setCollateName(TObjectName collateName) {
        this.collateName = collateName;
    }

    public TObjectName getCollateName() {

        return collateName;
    }

    public void setDeclareType(EDeclareType declareType) {
        this.declareType = declareType;
    }

    public EDeclareType getDeclareType() {

        return declareType;
    }

    private TObjectName exception_name = null;
    private TExpression error_number = null;

    public void setError_number(TExpression error_number) {
        this.error_number = error_number;
    }

    public void setException_name(TObjectName exception_name) {
        this.exception_name = exception_name;
    }

    /**
     * Any valid Oracle Database error number. Used when this class represents exception_init_pragma.
     * @return
     */
    public TExpression getError_number() {
        return error_number;
    }

    /**
     * Name of a user-defined exception declared within the current scope. Used when this class represents exception_init_pragma.
     * @return
     */

    public TObjectName getException_name() {
        return exception_name;
    }

    private TObjectName aliasItem;

    public void setAliasItem(TObjectName aliasItem) {
        this.aliasItem = aliasItem;
    }

    public TObjectName getAliasItem() {

        return aliasItem;
    }

    // SUBTYPE RANGE constraint fields (Oracle 26c)
    private TExpression rangeLowBound;
    private TExpression rangeHighBound;

    /**
     * Sets the low bound of the RANGE constraint for a SUBTYPE declaration.
     * @param rangeLowBound the low bound expression
     */
    public void setRangeLowBound(TExpression rangeLowBound) {
        this.rangeLowBound = rangeLowBound;
    }

    /**
     * Gets the low bound of the RANGE constraint for a SUBTYPE declaration.
     * For example, in "SUBTYPE Digit IS PLS_INTEGER RANGE 0..9", returns 0.
     * @return the low bound expression, or null if no RANGE constraint
     */
    public TExpression getRangeLowBound() {
        return rangeLowBound;
    }

    /**
     * Sets the high bound of the RANGE constraint for a SUBTYPE declaration.
     * @param rangeHighBound the high bound expression
     */
    public void setRangeHighBound(TExpression rangeHighBound) {
        this.rangeHighBound = rangeHighBound;
    }

    /**
     * Gets the high bound of the RANGE constraint for a SUBTYPE declaration.
     * For example, in "SUBTYPE Digit IS PLS_INTEGER RANGE 0..9", returns 9.
     * @return the high bound expression, or null if no RANGE constraint
     */
    public TExpression getRangeHighBound() {
        return rangeHighBound;
    }

    /**
     * Checks if this SUBTYPE declaration has a RANGE constraint.
     * @return true if RANGE constraint is present
     */
    public boolean hasRangeConstraint() {
        return rangeLowBound != null && rangeHighBound != null;
    }

    public void init(Object arg1){
        if (arg1 instanceof EDeclareType){
            this.declareType = (EDeclareType)arg1;
        }else{
            elementName = (TObjectName)arg1;
            elementName.setObjectType(TObjectName.ttobjVariable);
        }
    }

    public void init(Object arg1,Object arg2){
        init(arg1);
        switch (declareType){
            case exception:
            case procedure:
                elementName = (TObjectName)arg2;
                break;
            default:
                if (arg2 != null){
                    dataType = (TTypeName)arg2;
                }
                break;
        }
    }

    public void init(Object arg1,Object arg2,Object arg3,Object arg4){

        init(arg1,arg2);
        NotNull = (arg3 != null);

        if (arg4 != null){ //tdummy
            if (arg4 instanceof TDummy){
                value = (TExpression)((TDummy)arg4).node1;
                defaultValue = value;
                howtoSetValue = ((TDummy)arg4).int1;
            }else if (arg4 instanceof TExpression){
                defaultValue = (TExpression)arg4;
            }
        }
    }

    /**
     * Datatype of declared element.
     * @return
     */
    public TTypeName getDataType() {
        return dataType;
    }


    public int doParseStatement(TCustomSqlStatement psql) {
        super.doParseStatement(psql);
        if (elementName != null){
            TFrame stackFrame = getFrameStack().peek();
            stackFrame.getScope().addSymbol(new TVariable(elementName,this));
        }
        if (value != null){
            value.doParse(this,ESqlClause.unknown);
        }

        if (defaultValue != null){
            defaultValue.doParse(this,ESqlClause.unknown);
        }
        return 0;
    }

    /**
     * Name of element that declared.
     * @return
     */
    public TObjectName getElementName() {
        return elementName;
    }

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

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

    public void setElementName(TObjectName elementName) {
        this.elementName = elementName;
    }

    public void setDataType(TTypeName dataType) {
        this.dataType = dataType;
    }

    public void setNotNull(boolean notNull) {
        NotNull = notNull;
    }

    public void setValue(TExpression value) {
        this.value = value;
    }

    public void setHowtoSetValue(int howtoSetValue) {
        this.howtoSetValue = howtoSetValue;
    }
}