Application: gvSIG desktop

package org.gvsig.fmap.dal.store.jdbc2.spi.expressionbuilder.formatters;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

public class ToLong implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

    public ToLong(SQLBuilder builder, Formatter<Value> formatter) {

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            if (value instanceof ExpressionBuilder.Function) {

                return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_TOLONG, ((Function) value).name());

            }

        }

        return false;

    }

    @Override

    public String format(Value function) {

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

            String p1 = parameters.get(0).toString(formatter);

            String r = MessageFormat.format(

                    "CAST ( {0} AS BIGINT )",

                    p1

            );

            // En oracle el format seria algo como esto:

            //(case when lower({0}) = 't' then 1 when lower({0}) = 'f' then 0 else cast({0} as number) end)

            return r;

    }

}