Application: gvSIG desktop » gvSIG data provider for MS SQLServer

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, "");

        }

    }