Application: gvSIG desktop

package org.gvsig.sqlite.dal.expressionbuilderformatter;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_DECODE;

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

import org.gvsig.fmap.dal.store.jdbc2.spi.expressionbuilder.formatters.$Constant;

/**

 *

 * @author jjdelcerro

 */

public class Decode implements Formatter<Value> {

    private final SQLBuilder sqlbuilder;

    private final Formatter<Value> formatter;

    public Decode(SQLBuilder sqlbuilder, Formatter<Value> formatter) {

        this.sqlbuilder = sqlbuilder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(ExpressionBuilder.Value value) {

        if (value instanceof ExpressionBuilder.Function) {

            if( StringUtils.equalsIgnoreCase(FUNCTION_DECODE, ((Function) value).name()) ) {

                List<Value> parameters = ((Function) value).parameters();

                if( parameters.size()==2) {

                    Value p1 = parameters.get(0);

                    Value p2 = parameters.get(1);

                    if( $Constant.isConstant(p1) && p2 instanceof ExpressionBuilder.Constant &&

                        ((ExpressionBuilder.Constant)p2).value() instanceof String 

                        ) {

                        String p2value = ((ExpressionBuilder.Constant)p2).value().toString();

                        if( StringUtils.equalsIgnoreCase(p2value, "hex") ) {

                            return true;

                        }

                    }

                }

            }

        }

        return false;

    }

    @Override

    public String format(Value function) {

        List<Value> parameters = ((Function) function).parameters();

        Value p1 = parameters.get(0);

        String p1value = $Constant.resolve(this.sqlbuilder, this.formatter, p1);

        String r = "(X"+p1value+")";

        return r;

    }

}