Application: gvSIG desktop » gvSIG data provider for MS SQLServer

import org.gvsig.expressionevaluator.ExpressionBuilder;

        ExpressionBuilder expbuilder = sqlbuilder.expression();

                expbuilder.ST_SRID(expbuilder.column(columnName))

                expbuilder.and(

                        expbuilder.not_is_null(expbuilder.column(columnName)),

                        expbuilder.not_is_null(expbuilder.ST_SRID(expbuilder.column(columnName)))

import org.gvsig.expressionevaluator.ExpressionBuilder;

        ExpressionBuilder expbuilder = sqlbuilder.expression();

            expbuilder.as_geometry(

                expbuilder.ST_ExtentAggregate(

                        expbuilder.column(columnName)

    public ExpressionBuilder.GeometrySupportType getGeometrySupportType() {

        return ExpressionBuilder.GeometrySupportType.WKB;

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

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

 */

class ST_GeomFromWKB implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_GEOMFROMWKB, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("geometry::STGeomFromWKB({0}, {1})", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

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

 */

class ST_GeomFromText implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_GEOMFROMTEXT, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("geometry::STGeomFromText({0}, {1})", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Crosses implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_CROSSES, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).STCrosses({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Disjoint implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_DISJOINT, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).ST_Disjoint({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Intersects implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_INTERSECTS, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).STIntersects({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import org.cresques.cts.IProjection;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionBuilder.Parameter;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryUtils;

import org.gvsig.mssqlserver.dal.MSSQLServerSQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class MSSQLParameter implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final MSSQLServerSQLBuilder builder;

    private final ExpressionBuilder expbuilder;

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

        this.builder = (MSSQLServerSQLBuilder) builder;

        this.formatter = formatter;

        this.expbuilder = builder.expression();

    }

    @Override

    public boolean canApply(Value value) {

        return value instanceof Parameter;

    }

//    public Object value(Object value) {

//        try {

//            switch (this.type()) {

//                case Constant:

//                    if (value instanceof Geometry) {

//                        Geometry geometry = (Geometry) value;

//                        switch (this.expbuilder.geometry_support_type()) {

//                            case EWKB:

//                                return GeometryUtils.toEWKB(geometry);

//                            case WKB:

//                                return GeometryUtils.toWKB(geometry);

//                            case WKT:

//                            default:

//                                return GeometryUtils.toWKT(geometry);

//                        }

//                    } else if (value instanceof IProjection) {

//                        return this.expbuilder.srs_id((IProjection) value);

//                    }

//                    return value;

//                case Variable:

//                case Geometry:

//                default:

//                    return value;

//            }

//        } catch (Exception ex) {

//            throw new RuntimeException("Can't get value from parameter.", ex);

//        }

//    }

    private String getSRS(Parameter param) {

            if( param.srs()!=null ) {

                return param.srs().toString(formatter);

            }

            if( param instanceof Geometry ) {

                IProjection proj = ((Geometry)param).getProjection();

                Object s = this.expbuilder.srs_id(proj);

                if( s == null ) {

                    throw new IllegalArgumentException("A parameter of type Geometry with an invalid SRS.");

                }

                return s.toString();

            }

            throw new IllegalArgumentException("The parameter of type Geometry need a SRS.");

        }

    @Override

    public String format(Value function) {

        Parameter value = (Parameter) function;

        switch (value.type()) {

            case Constant:

                if (value instanceof Geometry) {

                    switch (this.expbuilder.geometry_support_type()) {

                        case EWKB:

                        case WKB:

                            return MessageFormat.format(

                                    this.builder.FORMAT_ST_GEOMFROMWKB,

                                    "?",

                                    this.getSRS(value)

                            );

                        case WKT:

                        default:

                            return MessageFormat.format(

                                    this.builder.FORMAT_ST_GEOMFROMTEXT,

                                    "?",

                                    this.getSRS(value)

                            );

                    }

                }

            case Variable:

            default:

                return "?";

            case Geometry:

                switch (this.expbuilder.geometry_support_type()) {

                    case EWKB:

                    case WKB:

                        return MessageFormat.format(

                                this.builder.FORMAT_ST_GEOMFROMWKB,

                                "?",

                                this.getSRS(value)

                        );

                    case WKT:

                    default:

                        return MessageFormat.format(

                                this.builder.FORMAT_ST_GEOMFROMTEXT,

                                "?",

                                this.getSRS(value)

                        );

                }

        }

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Equals implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_EQUALS, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).STEquals({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Overlaps implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_OVERLAPS, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).STOverlaps({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.ExpressionBuilder.Variable;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class MSSQLVariable implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

    private final ExpressionBuilder expbuilder;

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

        this.builder = builder;

        this.formatter = formatter;

        this.expbuilder = builder.expression();

    }

    @Override

    public boolean canApply(Value value) {

        return value instanceof Variable;

    }

    @Override

    public String format(Value function) {

        String name = ((Variable) function).name();

        if (StringUtils.isEmpty(name)) {

            return this.expbuilder.toString(EMPTY_FORMATTER);

        }

        return this.builder.as_identifier(name);

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

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

 */

class ST_UnionAggregate implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_UNIONAGGREGATE, ((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("geometry::UnionAggregate({0})", p1);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

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

 */

class ST_SRID implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_SRID, ((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("(({0}).STSrid)", p1);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Within implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_WITHIN, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).STWithin({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import java.util.Objects;

import org.apache.commons.lang3.StringUtils;

import org.cresques.cts.IProjection;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

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

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.feature.spi.SQLBuilderBase;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryUtils;

/**

 *

 * @author jjdelcerro

 */

class MSSQLConstant implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

    private final ExpressionBuilder expbuilder;

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

        this.builder = builder;

        this.formatter = formatter;

        this.expbuilder = builder.expression();

    }

    @Override

    public boolean canApply(Value value) {

        return value instanceof Constant;

    }

    @Override

    public String format(Value function) {

          Object value = ((Constant) function).value();

            if( value==null ) {

                return "NULL";

            }

            if( value instanceof byte[] ) {

                return this.expbuilder.bytearray_0x((byte[]) value);

            }

            if (value instanceof String) {

                return this.builder.as_string((String) value);

            }

            if( value instanceof Geometry ) {

                Geometry geometry = (Geometry) value;

                switch (this.builder.geometry_support_type()) {

                    case EWKB:

                    case WKB:

                        String p1 = this.expbuilder.bytearray_0x(GeometryUtils.toWKB(geometry));

                        String p2 = String.valueOf(this.expbuilder.srs_id(geometry.getProjection()));

                        String r = MessageFormat.format("geometry::STGeomFromWKB({0}, {1})", p1, p2);

                        return r;

                    case WKT:

                    default:

                        String p3 = this.expbuilder.bytearray_0x(GeometryUtils.toWKB(geometry));

                        String p4 = String.valueOf(this.expbuilder.srs_id(geometry.getProjection()));

                        String r1 = MessageFormat.format("geometry::STGeomFromText({0}, {1})", p3, p4);

                        return r1;

                }

            }

            if( value instanceof IProjection ) {

                return Objects.toString(this.expbuilder.srs_id((IProjection)(value)));

            }

            if (value instanceof Boolean) {

                // TODO correct values

                if (((Boolean) value)) {

                    return "(1=1)";

                } else {

                    return "(1<>1)";

                }

            }

            return Objects.toString(value, "");

        }

    }

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author osc

 */

public class MSSQLServerFormatter implements Formatter<ExpressionBuilder.Value> {

    private final SQLBuilder builder;

    private final Formatter<ExpressionBuilder.Value>[] formatters;

    public MSSQLServerFormatter(SQLBuilder builder) {

        this.builder = builder;

        this.formatters = new Formatter[]{

              new ST_AsBinary(this.builder, this),

              new ST_AsText(this.builder, this),

              new ST_Contains(this.builder, this),

              new ST_Crosses(this.builder, this),

              new ST_Disjoint(this.builder, this),

              new ST_Envelope(this.builder, this),

              new ST_Equals(this.builder, this),

              new ST_ExtentAggregate(this.builder, this),

              new ST_GeomFromText(this.builder, this),

              new ST_GeomFromWKB(this.builder, this),

              new ST_Intersects(this.builder, this),

              new ST_IsClosed(this.builder, this),

              new ST_Overlaps(this.builder, this),

              new ST_SRID(this.builder, this),

              new ST_Touches(this.builder, this),

              new ST_UnionAggregate(this.builder, this),

              new ST_Within(this.builder, this),

              new MSSQLConstant(this.builder, this),

              new MSSQLVariable(this.builder, this),

              new MSSQLParameter(this.builder, this)

//            new ILike(this.builder, this),

//            new IsNull(this.builder, this),

//            new IsNotNull(this.builder, this)

//            new ST_AsEWKB(this.builder, this),

//            new ST_ExtentAggregate(this.builder, this),

//            new ST_GeomFromEWKB(this.builder, this),

//            new ST_Intersects(this.builder, this),

//            new ST_UnionAggregate(this.builder, this)

        };

    }

    @Override

    public boolean canApply(ExpressionBuilder.Value value) {

        for (Formatter<ExpressionBuilder.Value> formatter : formatters) {

            if (formatter.canApply(value)) {

                return true;

            }

        }

        return false;

    }

    @Override

    public String format(ExpressionBuilder.Value value) {

        for (Formatter<ExpressionBuilder.Value> formatter : formatters) {

            if (formatter.canApply(value)) {

                return formatter.format(value);

            }

        }

        return value.toString(this);

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

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

 */

class ST_IsClosed implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_ISCLOSED, ((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("(({0}).STIsClosed()=1)", p1);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

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

 */

class ST_AsBinary implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_ASBINARY, ((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("({0}).STAsBinary()", p1);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

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

 */

class ST_AsText implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_ASTEXT, ((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("({0}).STAsText()", p1);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Touches implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_TOUCHES, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).STTouches({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

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

 */

class ST_Envelope implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_ENVELOPE, ((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("(({0}).STEnvelope())", p1);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Constant;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

class ST_Contains implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_CONTAINS, ((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 p2 = parameters.get(1).toString(formatter);

        String r = MessageFormat.format("(({0}).STContains({1})=1)", p1, p2);

        return r;

    }

}

package org.gvsig.mssqlserver.dal.expressionbuilderformatter;

import java.text.MessageFormat;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

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

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

 */

class ST_ExtentAggregate implements Formatter<Value> {

    private final Formatter<Value> formatter;

    private final SQLBuilder builder;

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

        this.builder = builder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(Value value) {

        if (value instanceof Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_ST_EXTENTAGGREGATE, ((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("geometry::EnvelopeAggregate({0})", p1);

        return r;

    }

}

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.mssqlserver.dal.expressionbuilderformatter.MSSQLServerFormatter;

    protected Formatter formatter = null;

    public static final String FORMAT_ST_GEOMFROMEWKB= "geometry::STGeomFromWKB({0}, {1})";

    public static final String FORMAT_ST_GEOMFROMWKB= "geometry::STGeomFromWKB({0}, {1})";

    public static final String FORMAT_ST_GEOMFROMTEXT= "geometry::STGeomFromText({0}, {1})";

//    public interface MSSQLServerSQLConfig extends SQLConfig {

//        public static final String ST_GeomFromTextEx = "ST_GeomFromTextEx";

//        public static final String ST_GeomFromWKBEx = "ST_GeomFromWKBEx";

//        public static final String ST_GeomFromEWKBEx = "ST_GeomFromEWKBEx";

//        public static final String ST_ExtentAggregateEx = "ST_ExtentAggregateEx";

//        public static final String ST_UnionAggregateEx = "ST_UnionAggregateEx";

//    }

        this.defaultSchema = "dbo";

        this.allowAutomaticValues = true;

        this.geometrySupportType = this.helper.getGeometrySupportType();

        this.hasSpatialFunctions = this.helper.hasSpatialFunctions();

        STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table = null;

        STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table = null;

        this.STMT_UPDATE_TABLE_STATISTICS_table ="UPDATE STATISTICS {0}";

        this.type_geometry = "GEOMETRY";

        this.constant_true = "1=1"; // TODO ?

        this.constant_false = "1<>1"; // TODO ?

        this.type_boolean = "BIT";

        this.type_double = "FLOAT"; //float con 53 bits de mantisa = float(54)

        this.type_numeric_p = "NUMERIC({0})";

        this.type_numeric_ps = "NUMERIC({0},{1})";

        this.type_bigdecimal = "NUMERIC({0},{1})";

        this.type_float = "REAL"; //float con 24 bits de mantisa = float(24)

        this.type_int = "INT";

        this.type_long = "BIGINT";        

        this.type_byte = "TINYINT";

        this.type_date = "DATE";

        this.type_time = "TIME";

        this.type_char = "CHAR(1)";

        this.type_string = "TEXT";

        this.type_string_p = "VARCHAR({0})";

        this.type_version = "VARCHAR(30)";

        this.type_URI = "TEXT";

        this.type_URL = "TEXT";

        this.type_FILE = "TEXT";

        this.type_FOLDER = "TEXT";

        this.type_bytearray = "VARBINARY";

        this.type_timestamp = "TIMESTAMP";

//       DID this.ST_SRID, "(({0}).STSrid)");

//       DID this.ST_AsText, "({0}).STAsText()");

//       DID this.ST_AsBinary, "({0}).STAsBinary()");

//        this.ST_AsEWKB, "({0}).STAsBinary()");

//       DID this.ST_ExtentAggregate, "geometry::EnvelopeAggregate({0})");

//       DID this.ST_UnionAggregate, "geometry::UnionAggregate({0})");

//       DID this.ST_Contains, "(({0}).STContains({1})=1)");

//       DID this.ST_Crosses, "(({0}).STCrosses({1})=1)");

//       DID this.ST_Disjoint, "(({0}).STDisjoint({1})=1)");

//       DID this.ST_Equals, "(({0}).STEquals({1})=1)");

//       DID this.ST_IsClosed, "(({0}).STIsClosed()=1)");

//       DID this.ST_Overlaps, "(({0}).STOverlaps({1})=1)");

//       DID this.ST_Touches, "(({0}).STTouches({1})=1)");

//       DID this.ST_Within, "(({0}).STWithin ({1})=1)");

//       DID this.ST_Envelope, "({0}).STEnvelope()");

//       DID this.ST_Intersects, "(({0}).STIntersects({1})=1)");

//       DID this.ST_GeomFromText, "geometry::STGeomFromText({0}, {1})");

//       DID this.ST_GeomFromWKB, "geometry::STGeomFromWKB({0}, {1})");

//       DID this.ST_GeomFromEWKB, "geometry::STGeomFromWKB({0}, {1})");

//        this.ST_Simplify, "({0}).Reduce({1})");

//        this.lcase, "LOWER({0})");

//        this.ucase, "UPPER({0})");

//        this.operator_ILIKE, "LOWER({0}) LIKE LOWER({1})");

//        this.notIsNull,"( ({0}) IS NOT NULL )" );

//

//        config.set(MSSQLServerSQLConfig.ST_ExtentAggregateEx, "{1}::EnvelopeAggregate({0})");

//        config.set(MSSQLServerSQLConfig.ST_UnionAggregateEx, "{1}::UnionAggregate({0})");

//        config.set(MSSQLServerSQLConfig.ST_GeomFromTextEx, "{2}::STGeomFromText({0}, {1})");

//        config.set(MSSQLServerSQLConfig.ST_GeomFromWKBEx, "{2}::STGeomFromWKB({0}, {1})");

//        config.set(MSSQLServerSQLConfig.ST_GeomFromEWKBEx, "{2}::STGeomFromWKB({0}, {1})");

    @Override

    protected Formatter formatter() {

        if( this.formatter==null ) {

            this.formatter = new MSSQLServerFormatter(this);

        }

        return this.formatter;

    }

    protected class MSSQLServerDropTableBuilder extends DropTableBuilderBase {

        @Override

           public List<String> toStrings(Formatter formatter) {

            List<String> sqls = new ArrayList<>();

            sqls.add(

                    MessageFormat.format(

                            STMT_DROP_TABLE_table,

                            this.table.toString(formatter)

                    )

            );

            return sqls;

        }

    }

                builder.append(as_identifier(this.indexName));

                builder.append(as_identifier(this.indexName));

//    public class MSSQLServerParameter extends ParameterBase {

//

//        public MSSQLServerParameter() {

//            super();

//        }

//

//        @Override