Application: gvSIG desktop

package org.gvsig.fmap.dal.store.jdbc2.spi.expressionbuilderformatter;

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 static org.gvsig.fmap.dal.DataManager.FUNCTION_SELECT;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

public class Select implements Formatter<Value> {

    private final SQLBuilder sqlbuilder;

    private final Formatter<Value> formatter;

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

        this.sqlbuilder = sqlbuilder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(ExpressionBuilder.Value value) {

        if (value instanceof ExpressionBuilder.Function) {

            return StringUtils.equalsIgnoreCase(FUNCTION_SELECT, ((Function) value).name());

        }

        return false;

    }

    @Override

    public String format(Value function0) {

        Function function = (Function) function0;

        String tableName = function.getParameter("TABLE").toString();

        Value where = function.getParameter("WHERE");

        Value order = function.getParameter("ORDER");

        Value limit = function.getParameter("LIMIT");

        Value order_mode = function.getParameter("ORDER_MODE");

        StringBuilder builder = new StringBuilder();

        builder.append("(SELECT * FROM ");

        builder.append(tableName);

        if( where!=null ) {

          builder.append(" WHERE ");

          builder.append(where.toString(formatter));

        }

        for( int n=0 ; function.containsParameter("ORDER", n); n++) {

          if( n>0 ) {

            builder.append(", ");

          }

          builder.append(function.getParameter("ORDER",n).toString(formatter));

          if( StringUtils.equalsIgnoreCase(function.getParameter("ORDER_MODE",n).toString(),"true") ) {

            builder.append(" ASC ");

          } else {

            builder.append(" DESC ");

          }

        }

        if( limit!=null ) {

          builder.append(" LIMIT ");

          builder.append(limit.toString(formatter));

        }

        builder.append(")");

        return builder.toString();

    }

}