Application: gvSIG desktop

    public Object runCode(Code arg) throws Exception;

        Object value = null;

        try {

            value = interpreter.runCode(arg);

        } catch(RuntimeException ex) {

            throw ex;

        } catch(Exception ex) {

            throw new ExpressionRuntimeException(arg, "", ex);

        }

package org.gvsig.expressionevaluator.spi.formatter.value;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

/**

 *

 * @author jjdelcerro

 */

public class Cast implements Formatter<Value> {

    private final Formatter<Value> formatter;

    public Cast(Formatter<Value> formatter) {

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(ExpressionBuilder.Value value) {

        if (value instanceof ExpressionBuilder.Function) {

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

        }

        return false;

    }

    @Override

    public String format(Value function0) {

        Function function = (Function) function0;

        StringBuilder builder = new StringBuilder();

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

        builder.append("CAST(");

        builder.append(args.get(0).toString(formatter));

        builder.append(" AS ");

        builder.append(((ExpressionBuilder.Constant)args.get(1)).value());

        builder.append(")");

        return builder.toString();

    }

}

        assertEquals(true, r);

    @Override

                Code code = this.codes.get(i);

                if(code != null){

                    x.add(code.clone());

                } else {

                    x.add(null);

                }

            if(this.args != null){

                x.args = this.args.clone();

            } else {

                x.args = null;

            }

import org.cresques.cts.IProjection;

        //ST_GEOMFROMTEXT

            if(value == null){

                return "CAST(NULL AS geometry)";

            }

            Geometry geom = (Geometry) value;

            IProjection proj = geom.getProjection();

            if(proj == null){

                builder.append("ST_GEOMFROMTEXT('");

                builder.append(geom.convertToWKT());

                builder.append("')");

            } else {

                String abrev = geom.getProjection().getAbrev();

                String srid = abrev.split(":")[1];

                builder.append("ST_SETSRID(ST_GEOMFROMTEXT('");

                builder.append(geom.convertToWKT());

                builder.append("'),");

                builder.append(srid);

                builder.append(")");

            }

            builder.append("CAST('UNKNOW' AS geometry)");

                "((\"campo1\" > 10) AND ST_Intersects(ST_SETSRID(ST_GEOMFROMTEXT('POLYGON ((0 0, 0 100, 100 100, 100 0, 0 0))'),4326), \"GEOMETRY\"))",

    protected Code replaceLocalVariables(Interpreter interpreter, Code expression, FeatureType currentType) {

        try {

            SymbolTable symbolTable = interpreter.getSymbolTable();

            TableAttributeHandler table = (TableAttributeHandler) symbolTable.value(SYMBOL_CURRENT_TABLE);

            List<Pair<Code, Code>> replaces = new ArrayList<>();

            CodeBuilder codeBuilder = ExpressionUtils.createCodeBuilder();

            Code expression2 = expression.clone();

            expression2.accept((Object o) -> {

                if (o == null) {

                    return;

                }

                Code code = (Code) o;

                switch (code.code()) {

                    case Code.IDENTIFIER:

                        Code.Identifier id = (Code.Identifier) code;

                        if (currentType.getAttributeDescriptor(id.name()) == null && symbolTable.exists(id.name())) {

                            Object value = symbolTable.value(id.name());

                            replaces.add(

                                    new ImmutablePair<>(

                                            id,

                                            codeBuilder.constant(value)

                                    )

                            );

                        }

                        break;

                }

            });

            if (replaces.isEmpty()) {

                return expression;

            }

            for (Pair<Code, Code> replace : replaces) {

                if (replace != null) {

                    expression2.replace(replace.getLeft(), replace.getRight());

                }

            }

            return expression2;

        } catch (Exception ex) {

            throw new ExpressionRuntimeException("Can't remove references to outer tables.", ex);

        }

    }

            if (order != null || order_mode != null) {

                for (int n = 0; n < order.parameters().size(); n++) {

                    if (queryOrder == null) {

                        queryOrder = new DefaultFeatureQueryOrder();

                    }

                    Boolean mode = (Boolean) ((Code.Constant)order_mode.parameters().get(n)).value();

                    Code memberCode = order.parameters().get(n);

                    if(memberCode.code() == Code.IDENTIFIER) {

                        queryOrder.add(((Code.Identifier)memberCode).name(), mode);

                    } else {

                        Code memberCode2 = replaceLocalVariables(interpreter, memberCode, featureStore.getDefaultFeatureTypeQuietly());

                        Expression exp = ExpressionUtils.createExpression(memberCode2.toString());

                        queryOrder.add(exp, mode);

                    }

                }

            }

            String intovar = null;

            if( args.size()>INTOVAR ) {

                intovar = this.getIdentifier(args, INTOVAR);

            }

            if (value != null){

                ((Geometry)value).setProjection(column.getSRS());

            }

import org.gvsig.expressionevaluator.spi.formatter.value.Cast;

            new Cast(this),