Application: gvSIG desktop » gvSIG data provider for MS SQLServer

//package org.gvsig.fmap.dal.store.jdbc2;

//

//import java.util.ArrayList;

//import java.util.List;

//import org.apache.commons.lang3.ArrayUtils;

//import org.cresques.cts.IProjection;

//import org.gvsig.fmap.crs.CRSFactory;

//import org.gvsig.expressionevaluator.ExpressionBuilder;

//import org.gvsig.expressionevaluator.ExpressionBuilder.Parameter;

//import org.gvsig.expressionevaluator.ExpressionBuilder.Variable;

//import org.gvsig.fmap.dal.SQLBuilder;

//import org.gvsig.fmap.dal.SQLBuilder.Privilege;

//import org.gvsig.fmap.dal.feature.spi.SQLBuilderBase;

//import org.gvsig.fmap.geom.DataTypes;

//import org.gvsig.fmap.geom.Geometry;

//import org.gvsig.fmap.geom.GeometryLocator;

//import org.gvsig.fmap.geom.GeometryManager;

//import org.gvsig.fmap.geom.primitive.Polygon;

//import org.gvsig.tools.junit.AbstractLibraryAutoInitTestCase;

//

//public class SQLBuilderTest extends AbstractLibraryAutoInitTestCase {

//    

//    @Override

//    protected void doSetUp() throws Exception {

//

//    }

////    

////    List<String> getVariableNames(ExpressionBuilder builder) {

////        List<String> vars = new ArrayList<>();

////        for (Variable var : builder.getVariables()) {

////            vars.add(var.getName());

////        }

////        return vars;

////    }

////    

////    List<String> getParameterNames(ExpressionBuilder builder) {

////        List<String> params = new ArrayList<>();

////        for (Parameter param : builder.getParameters()) {

////            String s;

////            switch(param.getType()) {

////                case Constant:

////                    Object value = param.getValue();

////                    if( value==null ) {

////                        s = "null";

////                    } else if( value instanceof String ) {

////                        s = "'" + (String)value + "'";

////                    } else {

////                        s = value.toString();

////                    }    

////                    break;

////                case Geometry:

////                case Variable:

////                default:

////                    s = "\"" + param.getName() + "\"";

////            }

////            params.add(s);

////        }

////        return params;

//    }

//    

// 

//    public void testCalulateEnvelope() throws Exception {

//        GeometryManager geometryManager = GeometryLocator.getGeometryManager();

//        IProjection proj = CRSFactory.getCRS("EPSG:4326");

//        

//        Polygon limit = geometryManager.createPolygon(Geometry.SUBTYPES.GEOM2D);

//        limit.addVertex(0, 0);

//        limit.addVertex(0, 100);

//        limit.addVertex(100, 100);

//        limit.addVertex(100, 0);

//        limit.addVertex(0, 0);

//        

//        SQLBuilder builder = new SQLBuilderBase();

//        

//        builder.select().column().value(

//            builder.getAsGeometry(

//              builder.ST_ExtentAggregate(

//                builder.column("the_geom")

//              )

//            )

//        ).as("envelope");

//        builder.select().from().table().database("master").schema("dbo").name("test1");

//        builder.select().where().set(

//            builder.ST_Intersects(

//                builder.ST_Envelope(

//                    builder.column("the_geom")

//                ),

//                builder.geometry(limit, proj)

//            )

//        );

//        builder.select().where().and(

//                builder.custom("x = 27")

//        );

//        

//        // SELECT ST_AsBinary(ST_Extent("the_geom")) AS "envelope" FROM "master"."dbo"."test1" WHERE ST_Intersects((ST_Envelope("the_geom")), (ST_GeomFromText('POLYGON ((0 0, 0 100, 100 100, 100 0, 0 0))', (4326)))) AND x = 27

//        

//        System.out.println("# Test:: testCalulateEnvelope");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "SELECT ST_AsBinary(ST_Extent(\"the_geom\")) AS \"envelope\" FROM \"master\".\"dbo\".\"test1\" WHERE ST_Intersects((ST_Envelope(\"the_geom\")), (ST_GeomFromText('POLYGON ((0 0, 0 100, 100 100, 100 0, 0 0))', (4326)))) AND x = 27",

//                builder.toString()

//        );

//        assertEquals(

//                "[the_geom]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//    public void testCount() throws Exception {

//        SQLBuilder builder = new SQLBuilderBase();

//        

//        builder.select().column().value(builder.count().all());

//        builder.select().from().table().database("master").schema("dbo").name("test1");

//        builder.select().from().subquery(null);

//        builder.select().where().set( builder.custom("pp = 200"));

//

//        System.out.println("# Test:: testCount");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//

//        //# Test:: testCount

//        //# SQL:: SELECT COUNT(*) FROM "master"."dbo"."test1" WHERE pp = 200

//        //# Variables:: []

//        //# Parametros:: []

//

//        assertEquals(

//                "SELECT COUNT(*) FROM \"master\".\"dbo\".\"test1\" WHERE pp = 200",

//                builder.toString()

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//    

//    public void testCreateTable() throws Exception {

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.create_table().table().database("master").schema("dbo").name("test1");

//        builder.create_table().add_column(

//                "name",

//                DataTypes.STRING,

//                45,

//                0,

//                false,

//                false,

//                true,

//                false,

//                null

//        );

//        builder.create_table().add_column(

//                "id",

//                DataTypes.INT,

//                0,

//                0,

//                true,

//                false,

//                false,

//                true,

//                0

//        );

//        builder.create_table().add_column(

//                "geom",

//                DataTypes.GEOMETRY,

//                0,

//                0,

//                false,

//                false,

//                true,

//                false,

//                null

//        );

//

//        

//        // CREATE TABLE "master"."dbo"."test1" ("name" VARCHAR(45) DEFAULT NULL NULL, "id" SERIAL DEFAULT '0' NOT NULL PRIMARY KEY, "geom" TEXT DEFAULT NULL NULL )

//        System.out.println("# Test:: testCreateTable");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "CREATE TABLE \"master\".\"dbo\".\"test1\" (\"name\" VARCHAR(45) DEFAULT NULL NULL, \"id\" SERIAL DEFAULT '0' NOT NULL PRIMARY KEY, \"geom\" TEXT DEFAULT NULL NULL )",

//                builder.toString()

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//    public void testDropTable() throws Exception {

//        SQLBuilder builder = new SQLBuilderBase();

//        

//        builder.drop_table().table().database("master").schema("dbo").name("test1");

//

//        // DROP TABLE "master"."dbo"."test1"; DELETE FROM GEOMETRY_COLUMNS WHERE f_table_schema = 'dbo' AND f_table_name = 'test1'

//        

//        System.out.println("# Test:: testDropTable");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "DROP TABLE \"master\".\"dbo\".\"test1\"; DELETE FROM GEOMETRY_COLUMNS WHERE f_table_schema = 'dbo' AND f_table_name = 'test1'",

//                builder.toString()

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//    

//    public void testFetchFeatureProviderByReference() throws Exception {

//        SQLBuilder builder = new SQLBuilderBase();

//        

//        String value = "yoyo";

//        builder.select().column().name("name");

//        builder.select().column().name("id");

//        builder.select().column().name("geom").as_geometry();

//        builder.select().from().table().database("master").schema("dbo").name("test1");

//        builder.select().where().set(

//            builder.eq(

//                builder.column("name"),

//                builder.parameter(value).as_constant()

//            )

//        );

//        builder.select().limit(1);

//

//        // SELECT "name", "id", ST_AsBinary("geom") FROM "master"."dbo"."test1" WHERE ( ("name") = (?) ) LIMIT 1

//

//        System.out.println("# Test:: testFetchFeatureProviderByReference");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "SELECT \"name\", \"id\", ST_AsBinary(\"geom\") FROM \"master\".\"dbo\".\"test1\" WHERE ( (\"name\") = (?) ) LIMIT 1",

//                builder.toString()

//        );

//        assertEquals(

//                "[geom, id, name]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "['yoyo']",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//    

//    public void testFetchFeatureType() throws Exception {

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.select().column().all();

//        builder.select().from().table().database("master").schema("dbo").name("test1");

//        builder.select().limit(1);

//

//        System.out.println("# Test:: testFetchFeatureType");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        

//        //# Test:: testFetchFeatureType

//        //# SQL:: SELECT * FROM [master].[dbo].[test1] LIMMIT 1

//        //# Variables:: []

//        //# Parametros:: []        

//        

//        assertEquals(

//                "SELECT * FROM \"master\".\"dbo\".\"test1\" LIMIT 1",

//                builder.toString()

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//        

//    public void testPerformDeletes() throws Exception {

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.delete().table().database("master").schema("dbo").name("test1");

//        builder.delete().where().and(

//            builder.eq( 

//                builder.column("id1"),

//                builder.parameter("id1").as_variable()

//            )

//        );

//        builder.delete().where().and(

//            builder.eq( 

//                builder.column("id2"),

//                builder.parameter("id2").as_variable()

//            )

//        );

//

//        // DELETE FROM "master"."dbo"."test1" WHERE ( ("id1") = (?) ) AND ( ("id2") = (?) )

//

//        System.out.println("# Test:: testPerformDeletes");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "DELETE FROM \"master\".\"dbo\".\"test1\" WHERE ( (\"id1\") = (?) ) AND ( (\"id2\") = (?) )",

//                builder.toString()

//        );

//        assertEquals(

//                "[id1, id2]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[\"id1\", \"id2\"]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//    public void testPerformInserts1() throws Exception {

//        IProjection proj = CRSFactory.getCRS("EPSG:4326");

//

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.insert().table().database("master").schema("dbo").name("test1");

//        builder.insert().column().name("id").with_value(builder.parameter("id"));

//        builder.insert().column().name("name").with_value(builder.parameter("name"));

//        builder.insert().column().name("geom").with_value(builder.parameter("geom").as_geometry_variable().srs(proj));

//        

//        // INSERT INTO "master"."dbo"."test1" ( "id", "name", "geom" ) VALUES ( ?, ?, ST_GeomFromText(?, (4326)) )

//        

//        System.out.println("# Test:: testPerformInserts1");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "INSERT INTO \"master\".\"dbo\".\"test1\" ( \"id\", \"name\", \"geom\" ) VALUES ( ?, ?, ST_GeomFromText(?, (4326)) )",

//                builder.toString()

//        );

//        assertEquals(

//                "[geom, id, name]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[\"id\", \"name\", \"geom\"]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//    public void testPerformInserts2() throws Exception {

//        IProjection proj = CRSFactory.getCRS("EPSG:4326");

//

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.insert().table().database("master").schema("dbo").name("test1");

//        builder.insert().column().name("id").with_value(builder.parameter("id"));

//        builder.insert().column().name("name").with_value(builder.parameter("name"));

//        builder.insert().column().name("geom").with_value(builder.parameter("geom").as_geometry_variable().srs(builder.parameter().value(proj)));

//        

//        // INSERT INTO "master"."dbo"."test1" ( "id", "name", "geom" ) VALUES ( ?, ?, ST_GeomFromText(?, (?)) )

//        

//        System.out.println("# Test:: testPerformInserts2");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "INSERT INTO \"master\".\"dbo\".\"test1\" ( \"id\", \"name\", \"geom\" ) VALUES ( ?, ?, ST_GeomFromText(?, (?)) )",

//                builder.toString()

//        );

//        assertEquals(

//                "[geom, id, name]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[\"id\", \"name\", \"geom\", 4326]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//    public void testPerformUpdates() throws Exception {

//        IProjection proj = CRSFactory.getCRS("EPSG:4326");

//

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.update().table().database("master").schema("dbo").name("test1");

//        builder.update().where().and(

//            builder.eq(

//                builder.column("id"), 

//                builder.parameter("id").as_variable()

//            )

//        );

//        builder.update().column().name("name").with_value(builder.parameter("name"));

//        builder.update().column().name("geom").with_value(

//                builder.parameter("geom").as_geometry_variable().srs( builder.parameter().value(proj)) 

//        );

//

//        // UPDATE "master"."dbo"."test1" SET "name" = ?, "geom" = ST_GeomFromText(?, (?)) WHERE ( ("id") = (?) )

//

//        System.out.println("# Test:: testPerformUpdates");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "UPDATE \"master\".\"dbo\".\"test1\" SET \"name\" = ?, \"geom\" = ST_GeomFromText(?, (?)) WHERE ( (\"id\") = (?) )",

//                builder.toString()

//        );

//        assertEquals(

//                "[geom, id, name]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[\"name\", \"geom\", 4326, \"id\"]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//    public void testGrant1() throws Exception {

//

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.grant().table().database("master").schema("dbo").name("test1");

//        builder.grant().role("prueba").select().insert().update();

//        builder.grant().role("gis").all();

//                

//        

//        System.out.println("# Test:: testGrant1");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "",

//                builder.toString()

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//    public void testGrant2() throws Exception {

//

//        SQLBuilder builder = new SQLBuilderBase();

//

//        builder.grant().table().database("master").schema("dbo").name("test1");

//        builder.grant().role("prueba").privilege(Privilege.SELECT)

//                .privilege(Privilege.INSERT)

//                .privilege(Privilege.UPDATE);

//        builder.grant().role("gis").privilege(Privilege.ALL);

//                

//        

//        System.out.println("# Test:: testGrant2");

//        System.out.println("# SQL:: " + builder.toString());

//        System.out.println("# Variables:: " + ArrayUtils.toString(getVariableNames(builder)));

//        System.out.println("# Parametros:: " + ArrayUtils.toString(getParameterNames(builder)));

//        assertEquals(

//                "",

//                builder.toString()

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getVariableNames(builder))

//        );

//        assertEquals(

//                "[]",

//                ArrayUtils.toString(getParameterNames(builder))

//        );

//    }

//

//

//}

package org.gvsig.mssqlserver.dal;

import java.util.ArrayList;

import java.util.List;

import org.apache.commons.lang3.ArrayUtils;

import org.cresques.cts.IProjection;

import org.gvsig.fmap.crs.CRSFactory;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionBuilder.Parameter;

import org.gvsig.expressionevaluator.ExpressionBuilder.Variable;

import org.gvsig.fmap.dal.SQLBuilder;

import org.gvsig.fmap.dal.spi.DataManagerProviderServices;

import org.gvsig.fmap.dal.store.db.DBHelper;

import org.gvsig.fmap.geom.DataTypes;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryLocator;

import org.gvsig.fmap.geom.GeometryManager;

import org.gvsig.fmap.geom.primitive.Polygon;

import static org.gvsig.mssqlserver.dal.MSSQLServerLibrary.NAME;

import org.gvsig.tools.junit.AbstractLibraryAutoInitTestCase;

public class MSSQLServerSQLBuilderTest extends AbstractLibraryAutoInitTestCase {

    private MSSQLServerHelper helper;

    @Override

    protected void doSetUp() throws Exception {

        DataManagerProviderServices dataman = 

                (DataManagerProviderServices) DALLocator.getDataManager();

        DBHelper.registerParametersDefinition(

                NAME + "StoreParameters",

                MSSQLServerStoreParameters.class,

                dataman.getResourceAsStream(this, NAME + "Parameters.xml")

        );

        MSSQLServerStoreParameters params = new MSSQLServerStoreParameters();

        params.setHost("127.0.0.1");

        params.setDynValue("InstanceName", "SQLEXPRESS");

        params.setDBName("master");

        params.setSchema("dbo");

        params.setTable("test1");

        params.setPort(1433);

        params.setUser("sa");

        params.setPassword("123");

        helper = new MSSQLServerHelper(params);

    }

    public SQLBuilder createSQLBuilder() {

        return new MSSQLServerSQLBuilder(helper);

    }

    public void testCalulateEnvelope() throws Exception {

        GeometryManager geometryManager = GeometryLocator.getGeometryManager();

        IProjection proj = CRSFactory.getCRS("EPSG:4326");

        Polygon limit = geometryManager.createPolygon(Geometry.SUBTYPES.GEOM2D);

        limit.addVertex(0, 0);

        limit.addVertex(0, 100);

        limit.addVertex(100, 100);

        limit.addVertex(100, 0);

        limit.addVertex(0, 0);

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.select().column().value(

            expbuilder.as_geometry(

              expbuilder.ST_ExtentAggregate(

                expbuilder.column("the_geom")

              )

            )

        ).as("envelope");

        sqlbuilder.select().from().table().database("master").schema("dbo").name("test1");

        sqlbuilder.select().where().set(

            expbuilder.ST_Intersects(

                expbuilder.ST_Envelope(

                    expbuilder.column("the_geom")

                ),

                expbuilder.geometry(limit, proj)

            )

        );

        sqlbuilder.select().where().and(

                expbuilder.custom("x = 27").add( expbuilder.variable("x") )

        );

        System.out.println("# Test:: testCalulateEnvelope");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testCalulateEnvelope

        //# SQL:: SELECT (geometry::EnvelopeAggregate([the_geom])).STAsBinary() AS [envelope] FROM [master].[dbo].[test1] WHERE (([the_geom]).STEnvelope()).STIntersects(geometry::STGeomFromWKB(0x000000000300000001000000050000000000000000000000000000000000000000000000004059000000000000405900000000000040590000000000004059000000000000000000000000000000000000000000000000000000000000, 4326)) AND x = 27

        //# Variables:: [the_geom, x]

        //# Parametros:: []    

        assertEquals(

                "SELECT (geometry::EnvelopeAggregate([the_geom])).STAsBinary() AS [envelope] FROM [master].[dbo].[test1] WHERE (([the_geom]).STEnvelope()).STIntersects(geometry::STGeomFromWKB(0x000000000300000001000000050000000000000000000000000000000000000000000000004059000000000000405900000000000040590000000000004059000000000000000000000000000000000000000000000000000000000000, 4326)) AND x = 27",

                sqlbuilder.toString()

        );

        assertEquals(

                "[the_geom, x]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testCount() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.select().column().value(sqlbuilder.count().all());

        sqlbuilder.select().from().table().database("master").schema("dbo").name("test1");

        sqlbuilder.select().from().subquery(null);

        sqlbuilder.select().where().set( expbuilder.custom("pp = 200").add(expbuilder.variable("pp")));

        System.out.println("# Test:: testCount");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testCount

        //# SQL:: SELECT COUNT(*) FROM [master].[dbo].[test1] WHERE pp = 200

        //# Variables:: []

        //# Parametros:: []

        assertEquals(

                "SELECT COUNT(*) FROM [master].[dbo].[test1] WHERE pp = 200",

                sqlbuilder.toString()

        );

        assertEquals(

                "[pp]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testUpdateStatistics() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.update_table_statistics().table().database("master").schema("dbo").name("test1");

        System.out.println("# Test:: testUpdateStatistics");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testUpdateStatistics

        //# SQL:: UPDATE STATISTICS [master].[dbo].[test1]

        //# Variables:: []

        //# Parametros:: []

        assertEquals(

                "UPDATE STATISTICS [master].[dbo].[test1]",

                sqlbuilder.toString()

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testCreateTable() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.create_table().table().database("master").schema("dbo").name("test1");

        sqlbuilder.create_table().add_column(

                "name",

                DataTypes.STRING,

                45,

                0,

                false,

                false,

                true,

                false,

                null

        );

        sqlbuilder.create_table().add_column(

                "id",

                DataTypes.INT,

                0,

                0,

                true,

                false,

                false,

                true,

                0

        );

        sqlbuilder.create_table().add_column(

                "geom",

                DataTypes.GEOMETRY,

                0,

                0,

                false,

                false,

                true,

                false,

                null

        );

        System.out.println("# Test:: testCreateTable");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testCreateTable

        //# SQL:: CREATE TABLE [master].[dbo].[test1] ([name] VARCHAR(45) DEFAULT NULL NULL, [id] INT IDENTITY(1,1) DEFAULT '0' NOT NULL PRIMARY KEY, [geom] GEOMETRY DEFAULT NULL NULL )

        //# Variables:: []

        //# Parametros:: []

        assertEquals(

                "CREATE TABLE [master].[dbo].[test1] ([name] VARCHAR(45) DEFAULT NULL NULL, [id] INT IDENTITY(1,1) DEFAULT '0' NOT NULL PRIMARY KEY, [geom] GEOMETRY DEFAULT NULL NULL )",

                sqlbuilder.toString()

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testDropTable() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.drop_table().table().database("master").schema("dbo").name("test1");

        System.out.println("# Test:: testDropTable");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testDropTable

        //# SQL:: DROP TABLE [master].[dbo].[test1]

        //# Variables:: []

        //# Parametros:: []

        assertEquals(

                "DROP TABLE [master].[dbo].[test1]",

                sqlbuilder.toString()

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testFetchFeatureProviderByReference() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        String value = "yoyo";

        sqlbuilder.select().column().name("name");

        sqlbuilder.select().column().name("id");

        sqlbuilder.select().column().name("geom").as_geometry();

        sqlbuilder.select().from().table().database("master").schema("dbo").name("test1");

        sqlbuilder.select().where().set(

            expbuilder.eq(

                expbuilder.column("name"),

                expbuilder.parameter(value).as_constant()

            )

        );

        sqlbuilder.select().limit(1);

        System.out.println("# Test:: testFetchFeatureProviderByReference");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testFetchFeatureProviderByReference

        //# SQL:: SELECT TOP 1 [name], [id], ([geom]).STAsBinary() FROM [master].[dbo].[test1] WHERE ( ([name]) = (?) )

        //# Variables:: [geom, id, name]

        //# Parametros:: ['yoyo']

        assertEquals(

                "SELECT TOP 1 [name], [id], ([geom]).STAsBinary() FROM [master].[dbo].[test1] WHERE ( ([name]) = (?) )",

                sqlbuilder.toString()

        );

        assertEquals(

                "[geom, id, name]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "['yoyo']",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testIsNull() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.select().column().name("name");

        sqlbuilder.select().column().name("id");

        sqlbuilder.select().column().name("geom").as_geometry();

        sqlbuilder.select().from().table().database("master").schema("dbo").name("test1");

        sqlbuilder.select().where().set(

            expbuilder.and(

                expbuilder.is_null(

                    expbuilder.column("name")

                ),

                expbuilder.not_is_null(

                    expbuilder.column("id")

                )

            )

        );

        sqlbuilder.select().limit(2);

        System.out.println("# Test:: testIsNull");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testIsNull

        //# SQL:: SELECT TOP 2 [name], [id], ([geom]).STAsBinary() FROM [master].[dbo].[test1] WHERE ( ([name]) IS NULL ) AND ( ([id]) NOT IS NULL )

        //# Variables:: [geom, id, name]

        //# Parametros:: []

        assertEquals(

                "SELECT TOP 2 [name], [id], ([geom]).STAsBinary() FROM [master].[dbo].[test1] WHERE ( ([name]) IS NULL ) AND ( ([id]) NOT IS NULL )",

                sqlbuilder.toString()

        );

        assertEquals(

                "[geom, id, name]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testFetchFeatureType() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.select().column().all();

        sqlbuilder.select().from().table().database("master").schema("dbo").name("test1");

        sqlbuilder.select().limit(1);

        System.out.println("# Test:: testFetchFeatureType");

        System.out.println("# SQL:: " + sqlbuilder.toString());

         System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testFetchFeatureType

        //# SQL:: SELECT TOP 1 * FROM [master].[dbo].[test1]

        //# Variables:: []

        //# Parametros:: []

        assertEquals(

                "SELECT TOP 1 * FROM [master].[dbo].[test1]",

                sqlbuilder.toString()

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testPerformDeletes() throws Exception {

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.delete().table().database("master").schema("dbo").name("test1");

        sqlbuilder.delete().where().and(

            expbuilder.eq( 

                expbuilder.column("id1"),

                expbuilder.parameter("id1").as_variable()

            )

        );

        sqlbuilder.delete().where().and(

            expbuilder.eq( 

                expbuilder.column("id2"),

                expbuilder.parameter("id2").as_variable()

            )

        );

        System.out.println("# Test:: testPerformDeletes");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testPerformDeletes

        //# SQL:: DELETE FROM [master].[dbo].[test1] WHERE ( ([id1]) = (?) ) AND ( ([id2]) = (?) )

        //# Variables:: [id1, id2]

        //# Parametros:: ["id1", "id2"]

        assertEquals(

                "DELETE FROM [master].[dbo].[test1] WHERE ( ([id1]) = (?) ) AND ( ([id2]) = (?) )",

                sqlbuilder.toString()

        );

        assertEquals(

                "[id1, id2]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[\"id1\", \"id2\"]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testPerformInserts1() throws Exception {

        IProjection proj = CRSFactory.getCRS("EPSG:4326");

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.insert().table().database("master").schema("dbo").name("test1");

        sqlbuilder.insert().column().name("id").with_value(expbuilder.parameter("id"));

        sqlbuilder.insert().column().name("name").with_value(expbuilder.parameter("name"));

        sqlbuilder.insert().column().name("geom").with_value(expbuilder.parameter("geom").as_geometry_variable().srs(proj));

        System.out.println("# Test:: testPerformInserts1");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testPerformInserts1

        //# SQL:: INSERT INTO [master].[dbo].[test1] ( [id], [name], [geom] ) VALUES ( ?, ?, geometry::STGeomFromWKB(?, 4326) )

        //# Variables:: [geom, id, name]

        //# Parametros:: ["id", "name", "geom"]

        assertEquals(

                "INSERT INTO [master].[dbo].[test1] ( [id], [name], [geom] ) VALUES ( ?, ?, geometry::STGeomFromWKB(?, 4326) )",

                sqlbuilder.toString()

        );

        assertEquals(

                "[geom, id, name]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[\"id\", \"name\", \"geom\"]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testPerformInserts2() throws Exception {

        IProjection proj = CRSFactory.getCRS("EPSG:4326");

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.insert().table().database("master").schema("dbo").name("test1");

        sqlbuilder.insert().column().name("id").with_value(expbuilder.parameter("id"));

        sqlbuilder.insert().column().name("name").with_value(expbuilder.parameter("name"));

        sqlbuilder.insert().column().name("geom").with_value(expbuilder.parameter("geom").as_geometry_variable().srs(proj));

        System.out.println("# Test:: testPerformInserts2");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testPerformInserts2

        //# SQL:: INSERT INTO [master].[dbo].[test1] ( [id], [name], [geom] ) VALUES ( ?, ?, geometry::STGeomFromWKB(?, ?) )

        //# Variables:: [geom, id, name]

        //# Parametros:: ["id", "name", "geom", 4326]

        assertEquals(

                "INSERT INTO [master].[dbo].[test1] ( [id], [name], [geom] ) VALUES ( ?, ?, geometry::STGeomFromWKB(?, ?) )",

                sqlbuilder.toString()

        );

        assertEquals(

                "[geom, id, name]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[\"id\", \"name\", \"geom\", 4326]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

    public void testPerformUpdates() throws Exception {

        IProjection proj = CRSFactory.getCRS("EPSG:4326");

        SQLBuilder sqlbuilder = createSQLBuilder();

        ExpressionBuilder expbuilder = sqlbuilder.expression();

        sqlbuilder.update().table().database("master").schema("dbo").name("test1");

        sqlbuilder.update().where().and(

            expbuilder.eq(

                expbuilder.column("id"), 

                expbuilder.parameter("id").as_variable()

            )

        );

        sqlbuilder.update().column().name("name").with_value(expbuilder.parameter("name"));

        sqlbuilder.update().column().name("geom").with_value(

                expbuilder.parameter("geom").as_geometry_variable().srs(

                        expbuilder.parameter().value(proj))

        );

        System.out.println("# Test:: testPerformUpdates");

        System.out.println("# SQL:: " + sqlbuilder.toString());

        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));

        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));

        //# Test:: testPerformUpdates

        //# SQL:: UPDATE [master].[dbo].[test1] SET [name] = ?, [geom] = geometry::STGeomFromWKB(?, ?) WHERE ( ([id]) = (?) )

        //# Variables:: [geom, id, name]

        //# Parametros:: ["name", "geom", 4326, "id"]

        assertEquals(

                "UPDATE [master].[dbo].[test1] SET [name] = ?, [geom] = geometry::STGeomFromWKB(?, ?) WHERE ( ([id]) = (?) )",

                sqlbuilder.toString()

        );

        assertEquals(

                "[geom, id, name]",

                ArrayUtils.toString(sqlbuilder.variables_names())

        );

        assertEquals(

                "[\"name\", \"geom\", 4326, \"id\"]",

                ArrayUtils.toString(sqlbuilder.parameters_names())

        );

    }

}

<?xml version="1.0"?>

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2013 gvSIG Association.

    This program is free software; you can redistribute it and/or

    modify it under the terms of the GNU General Public License

    as published by the Free Software Foundation; either version 3

    of the License, or (at your option) any later version.

    This program is distributed in the hope that it will be useful,

    but WITHOUT ANY WARRANTY; without even the implied warranty of

    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License

    along with this program; if not, write to the Free Software

    Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

    MA  02110-1301, USA.

    For any additional information, do not hesitate to contact us

    at info AT gvsig.com, or visit our website www.gvsig.com.

-->

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBC2" namespace="Metadata">

      <extends>

      	<class name="SpatialProvider" namespace="Metadata"/>

      </extends>

      <description>Metadata of a JDBC store</description>

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2013 gvSIG Association.

    This program is free software; you can redistribute it and/or

    modify it under the terms of the GNU General Public License

    as published by the Free Software Foundation; either version 3

    of the License, or (at your option) any later version.

    This program is distributed in the hope that it will be useful,

    but WITHOUT ANY WARRANTY; without even the implied warranty of

    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License

    along with this program; if not, write to the Free Software

    Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

    MA  02110-1301, USA.

    For any additional information, do not hesitate to contact us

    at info AT gvsig.com, or visit our website www.gvsig.com.

-->

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBC2ResourceParameters">

      <description></description>

      <extends>

        <class>DBResourceParameters</class>

      </extends>

      <fields>

        <field name="JDBCDriverClass" type="string" mandatory="true" group="Advanced">

          <description>JDBC Driver class</description>

        </field>

        <field name="URL" type="string" mandatory="true" group="Connection">

          <description>JDBC url connection</description>

        </field>

        <field name="Catalog" type="string" mandatory="false" group="Basic">

          <description>Database catalog</description>

        </field>

        <field name="Schema" type="string" mandatory="false" group="Basic">

          <description>Database schema</description>

        </field>

      </fields>

    </class>

    <class name="JDBC2StoreParameters">

      <extends>

        <class>JDBC2ResourceParameters</class>

        <class>DBStoreParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

      </fields>

    </class>

    <class name="JDBC2NewStoreParameters">

      <description></description>

      <extends>

        <class>JDBC2ResourceParameters</class>

        <class>DBNewStoreParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

        <field name="selectRole" label="Roles for select" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have select privilegies</description>

        </field>

        <field name="insertRole" label="Roles for insert" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have insert privilegies</description>

        </field>

        <field name="updateRole" label="Roles for update" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have update privilegies</description>

        </field>

        <field name="deleteRole" label="Roles for delete" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have delete privilegies</description>

        </field>

        <field name="truncateRole" label="Roles for truncate" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have truncate privilegies</description>

        </field>

        <field name="referenceRole" label="Roles for reference" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have reference privilegies</description>

        </field>

        <field name="triggerRole" label="Roles for trigger" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have trigger privilegies</description>

        </field>

        <field name="allRole" label="Roles for all" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have all privilegies</description>

        </field>

        <field name="postCreatingStatement" label="Post-creating statement" type="String" mandatory="false" defaultValue="" group="Advanced">

          <description>Roles asigned to have all privilegies</description>

        </field>

      </fields>

    </class>

    <class name="JDBC2ServerExplorerParameters">

      <extends>

        <class>JDBC2ResourceParameters</class>

        <class>DBServerExplorerParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

        <field name="ShowInformationDBTables" type="boolean" 

            mandatory="false" defaultValue="false" group="Basic">

          <description>Show information tables</description>

        </field>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="MSSQLServer" namespace="Metadata">

      <extends>

      	<class name="JDBC2" namespace="Metadata"/>

      </extends>

      <description>Metadata for MSSQLServer</description>

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="MSSQLServerResourceParameters">

      <extends>

        <class>JDBC2ResourceParameters</class>

      </extends>

      <fields>

        <field name="JDBCDriverClass" type="string" mandatory="true"

          defaultValue="com.microsoft.sqlserver.jdbc.SQLServerDriver" group="Advanced">

          <description>JDBC driver class for MS-SQlServer</description>

        </field>

        <field name="port" type="integer" mandatory="false"

          defaultValue="1433" group="Connection">

          <description></description>

        </field>

        <field name="host" type="string" mandatory="false" 

            defaultValue="127.0.0.1" group="Connection">

          <description></description>

        </field>

        <field name="instanceName" type="string" mandatory="false" 

            defaultValue="SQLEXPRESS" group="Connection">

          <description></description>

        </field>     

        <field name="dbname" type="string" mandatory="false" defaultValue="master" group="Basic">

          <description></description>

        </field>

        <field name="dbuser" type="string" mandatory="false" defaultValue="sa" group="Basic">

          <description></description>

        </field>

        <field name="password" type="string" mandatory="false" defaultValue="123" group="Basic">

          <description></description>

        </field>           

      </fields>

    </class>

    <class name="MSSQLServerStoreParameters">

      <extends>

        <class>JDBC2StoreParameters</class>

        <class>MSSQLServerResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="MSSQLServerNewStoreParameters">

      <extends>

        <class>JDBC2NewStoreParameters</class>

        <class>MSSQLServerResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="MSSQLServerServerExplorerParameters">

      <extends>

        <class>MSSQLServerResourceParameters</class>

        <class>JDBC2ServerExplorerParameters</class>

      </extends>

      <fields/>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBC2">

      <extends>

      </extends>

      <fields>

        <field name="function_ST_AsWKB" type="string" group="functions" 

          defaultValue="ST_AsWKB({0})" >

          <description></description>

        </field>

        <field name="function_ST_envelope" type="string" group="functions" 

          defaultValue="ST_envelope({0})" >

          <description></description>

        </field>

        <field name="function_ST_Extent" type="string" group="functions" 

          defaultValue="ST_Extent({0})" >

          <description></description>

        </field>

        <field name="function_ST_intersects" type="string" group="functions" 

          defaultValue="ST_intersects({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromText" type="string" group="functions" 

          defaultValue="ST_GeomFromText({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromWKB" type="string" group="functions" 

          defaultValue="ST_GeomFromWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromEWKB" type="string" group="functions" 

          defaultValue="ST_GeomFromEWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_current_schema" type="string" group="functions" 

          defaultValue="current_schema()" >

          <description></description>

        </field>

        <field name="function_lcase" type="string" group="functions" 

          defaultValue="LCASE({0})" >

          <description></description>

        </field>

        <field name="function_count" type="string" group="functions" 

          defaultValue="count({0})" >

          <description></description>

        </field>

        <field name="function_crs" type="string" group="functions" 

          defaultValue="{0}" >

          <description>Use {0} for the abbreviature, {1} for the autority name and {2} for the autority code</description>

        </field>

        <!-- operators -->

        <field name="operator_isnull" type="string" group="operators" 

          defaultValue="{0} is null" >

          <description></description>

        </field>

        <field name="operator_eq" type="string" group="operators" 

          defaultValue="{0} = {1}" >

          <description></description>

        </field>

        <field name="operator_neq" type="string" group="operators" 

          defaultValue="{0} <> {1}" >

          <description></description>

        </field>

        <field name="operator_lt" type="string" group="operators" 

          defaultValue="{0} < {1}" >

          <description></description>

        </field>

        <field name="operator_le" type="string" group="operators" 

          defaultValue="{0} <= {1}" >

          <description></description>

        </field>

        <field name="operator_gt" type="string" group="operators" 

          defaultValue="{0} > {1}" >

          <description></description>

        </field>

        <field name="operator_ge" type="string" group="operators" 

          defaultValue="{0} >= {1}" >

          <description></description>

        </field>

        <field name="operator_and" type="string" group="operators" 

          defaultValue="{0} AND {1}" >

          <description></description>

        </field>

        <field name="operator_or" type="string" group="operators" 

          defaultValue="{0} OR {1}" >

          <description></description>

        </field>

        <field name="operator_like" type="string" group="operators" 

          defaultValue="{0} LIKE {1}" >

          <description></description>

        </field>

        <field name="operator_ilike" type="string" group="operators" 

          defaultValue="{0} ILIKE {1}" >

          <description></description>

        </field>

        <!-- properties -->

        <field name="AllowAutomaticValues" type="boolean" group="properties" 

          defaultValue="true" >

          <description></description>

        </field>

        <field name="QuoteForStrings" type="string" group="properties" 

          defaultValue="'" >

          <description></description>

        </field>

        <field name="QuoteForIdentifiers" type="string" group="properties" 

          defaultValue="" >

          <description></description>

        </field>

        <field name="GeometrySupportType" type="string" group="properties" 

            defaultValue="WKB" >

            <description></description>

            <availableValues>

                <value label="WKT">WKT</value>

                <value label="WKB">WKB</value>

                <value label="EWKB">EWKB</value>

            </availableValues>          

        </field>

      </fields>

    </class>

    <class name="MSSQLServer">

      <extends>

          <class>JDBC2</class>

      </extends>

      <fields>

        <field name="function_ST_AsWKB" type="string" group="functions" 

          defaultValue="({0}).STAsWKB" >

          <description></description>

        </field>

        <field name="function_ST_envelope" type="string" group="functions" 

          defaultValue="({0}).STEnvelope" >

          <description></description>

        </field>

        <field name="function_ST_Extent" type="string" group="functions" 

          defaultValue="({0}).STEnvelope" >

          <description></description>

        </field>

        <field name="function_ST_intersects" type="string" group="functions" 

          defaultValue="({0}).STIntersects({1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromText" type="string" group="functions" 

          defaultValue="geometry::STGeomFromText({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromWKB" type="string" group="functions" 

          defaultValue="geometry::STGeomFromWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromEWKB" type="string" group="functions" 

          defaultValue="geometry::STGeomFromWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_current_schema" type="string" group="functions" 

          defaultValue="current_schema()" >

          <description></description>

        </field>

        <field name="function_crs" type="string" group="functions" 

          defaultValue="{2}" >

          <description>Use {0} for the abbreviature, {1} for the autority name and {2} for the autority code</description>

        </field>

        <field name="function_lcase" type="string" group="functions" 

          defaultValue="LOWER({0})" >

          <description></description>

        </field>

        <!-- operators -->

        <field name="operator_ilike" type="string" group="operators" 

          defaultValue="{0} ILIKE {1}" >

          <description></description>

        </field>

  </classes>

</definitions>  

org.gvsig.fmap.dal.store.jdbc2.JDBCLibrary

org.gvsig.mssqlserver.dal.MSSQLServerLibrary