Application: gvSIG desktop

import org.gvsig.fmap.geom.operation.GeometryOperationNotSupportedException;

    public void test6() throws Exception {

        ExpressionBuilder builder = new DefaultExpressionBuilder();

        GeometryManager geometryManager = GeometryLocator.getGeometryManager();

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

        Point point = geometryManager.createPoint(-0.1779813, 51.6122315, Geometry.SUBTYPES.GEOM2D);

        Geometry point_buffer = point.buffer(0.001);

        builder.or(

            builder.ST_Intersects(

                builder.function("ST_StartPoint", builder.column("geometry")),

                builder.geometry(point_buffer, proj)

            ),

            builder.ST_Intersects(

                builder.function("ST_EndPoint", builder.column("geometry")),

                builder.geometry(point_buffer, proj)

            )

        );

        System.out.println(builder.toString());

        assertEquals(

                "ST_Intersects((ST_StartPoint(\"geometry\")), (ST_GeomFromWKB((DECODE('00000000030000000100000021bfc6a752bfc074d04049ce5d9a0f0a5fbfc6a7f3ef0c44504049ce573585c39cbfc6a9d14b36039c4049ce510fe0a08dbfc6acd87c00e8e74049ce4b65990cbfbfc6b0ebb72658ed4049ce466e6aca60bfc6b5e2e568b7fa4049ce425b2fa4f0bfc6bb8d2cfc85e24049ce3f53feda0abfc6c1b2d21f95294049ce3d76a2b04bbfc6c8175b6658244049ce3cd573647cbfc6ce7be4ad1b1f4049ce3d76a2b04bbfc6d4a189d02a664049ce3f53feda0abfc6da4bd163f84e4049ce425b2fa4f0bfc6df42ffa6575b4049ce466e6aca60bfc6e3563acbc7614049ce4b65990cbfbfc6e65d6b96acac4049ce510fe0a08dbfc6e83ac7c06bf84049ce573585c39cbfc6e8dbf70c3b784049ce5d9a0f0a5fbfc6e83ac7c06bf84049ce63fe985122bfc6e65d6b96acac4049ce6a243d7431bfc6e3563acbc7614049ce6fce8507ffbfc6df42ffa6575b4049ce74c5b34a5ebfc6da4bd163f84e4049ce78d8ee6fcebfc6d4a189d02a664049ce7be01f3ab4bfc6ce7be4ad1b1f4049ce7dbd7b6473bfc6c8175b6658244049ce7e5eaab042bfc6c1b2d21f95294049ce7dbd7b6473bfc6bb8d2cfc85e24049ce7be01f3ab4bfc6b5e2e568b7fa4049ce78d8ee6fcebfc6b0ebb72658ed4049ce74c5b34a5ebfc6acd87c00e8e74049ce6fce8507ffbfc6a9d14b36039b4049ce6a243d7431bfc6a7f3ef0c44504049ce63fe985122bfc6a752bfc074d04049ce5d9a0f0a5f','hex')), (4326)))) OR ST_Intersects((ST_EndPoint(\"geometry\")), (ST_GeomFromWKB((DECODE('00000000030000000100000021bfc6a752bfc074d04049ce5d9a0f0a5fbfc6a7f3ef0c44504049ce573585c39cbfc6a9d14b36039c4049ce510fe0a08dbfc6acd87c00e8e74049ce4b65990cbfbfc6b0ebb72658ed4049ce466e6aca60bfc6b5e2e568b7fa4049ce425b2fa4f0bfc6bb8d2cfc85e24049ce3f53feda0abfc6c1b2d21f95294049ce3d76a2b04bbfc6c8175b6658244049ce3cd573647cbfc6ce7be4ad1b1f4049ce3d76a2b04bbfc6d4a189d02a664049ce3f53feda0abfc6da4bd163f84e4049ce425b2fa4f0bfc6df42ffa6575b4049ce466e6aca60bfc6e3563acbc7614049ce4b65990cbfbfc6e65d6b96acac4049ce510fe0a08dbfc6e83ac7c06bf84049ce573585c39cbfc6e8dbf70c3b784049ce5d9a0f0a5fbfc6e83ac7c06bf84049ce63fe985122bfc6e65d6b96acac4049ce6a243d7431bfc6e3563acbc7614049ce6fce8507ffbfc6df42ffa6575b4049ce74c5b34a5ebfc6da4bd163f84e4049ce78d8ee6fcebfc6d4a189d02a664049ce7be01f3ab4bfc6ce7be4ad1b1f4049ce7dbd7b6473bfc6c8175b6658244049ce7e5eaab042bfc6c1b2d21f95294049ce7dbd7b6473bfc6bb8d2cfc85e24049ce7be01f3ab4bfc6b5e2e568b7fa4049ce78d8ee6fcebfc6b0ebb72658ed4049ce74c5b34a5ebfc6acd87c00e8e74049ce6fce8507ffbfc6a9d14b36039b4049ce6a243d7431bfc6a7f3ef0c44504049ce63fe985122bfc6a752bfc074d04049ce5d9a0f0a5f','hex')), (4326))))",

                builder.toString()

        );

        assertEquals(

                "[geometry]",

                ArrayUtils.toString(builder.variables_names())

        );

        assertEquals(

                "[]",

                ArrayUtils.toString(builder.parameters_names())

        );

    }

    public Function ST_Area(Value geom) {

        return function("ST_Area", geom);

    }

    @Override

    public Function ST_Buffer(Value geom) {

        return function("ST_Buffer", geom);

    }

    @Override

    public Function ST_Centroid(Value geom) {

        return function("ST_Centroid", geom);

    }

    @Override

    public Function ST_CoveredBy(Value geom1, Value geom2) {

        return function("ST_CoveredBy", geom1, geom2);

    }

    @Override

    public Function ST_Covers(Value geom1, Value geom2) {

        return function("ST_Covers", geom1, geom2);

    }

    @Override

    public Function ST_Diference(Value geom1, Value geom2) {

        return function("ST_Diference", geom1, geom2);

    }

    @Override

    public Function ST_Dimension(Value geom) {

        return function("ST_Dimension", geom);

    }

    @Override

    public Function ST_Distance(Value geom1, Value geom2) {

        return function("ST_Distance", geom1, geom2);

    }

    @Override

    public Function ST_EndPoint(Value geom) {

        return function("ST_EndPoint", geom);

    }

    @Override

    public Function ST_Intersection(Value geom1, Value geom2) {

        return function("ST_Intersection", geom1, geom2);

    }

    @Override

    public Function ST_IsSimple(Value geom) {

        return function("ST_IsSimple", geom);

    }

    @Override

    public Function ST_IsValid(Value geom) {

        return function("ST_IsValid", geom);

    }

    @Override

    public Function ST_NumGeometries(Value geom) {

        return function("ST_NumGeometries", geom);

    }

    @Override

    public Function ST_NumPoints(Value geom) {

        return function("ST_NumPoints", geom);

    }

    @Override

    public Function ST_Perimeter(Value geom) {

        return function("ST_Perimeter", geom);

    }

    @Override

    public Function ST_PointN(Value geom, Value n) {

        return function("ST_PointN", geom, n);

    }

    @Override

    public Function ST_StartPoint(Value geom) {

        return function("ST_StartPoint", geom);

    }

    @Override

    public Function ST_Union(Value geom1, Value geom2) {

        return function("ST_Union", geom1, geom2);

    }

    @Override

    public Function ST_X(Value geom) {

        return function("ST_X", geom);

    }

    @Override

    public Function ST_Y(Value geom) {

        return function("ST_Y", geom);

    }

    @Override

    public Function ST_Z(Value geom) {

        return function("ST_Z", geom);

    }

    @Override

    public Function ST_Area(Value geom);

    public Function ST_AsText(Value geom);

    public Function ST_Buffer(Value geom);

    public Function ST_Centroid(Value geom);

    public Function ST_Contains(Value geom1, Value geom2);

    public Function ST_CoveredBy(Value geom1, Value geom2);

    public Function ST_Covers(Value geom1, Value geom2);

    public Function ST_Crosses(Value geom1, Value geom2);

    public Function ST_Diference(Value geom1, Value geom2);

    public Function ST_Dimension(Value geom1);

    public Function ST_Disjoint(Value geom1, Value geom2);

    public Function ST_Distance(Value geom1, Value geom2);

    public Function ST_EndPoint(Value geom1);

    public Function ST_Equals(Value geom1, Value geom2);

    public Function ST_Intersection(Value geom1, Value geom2);

    public Function ST_IsClosed(Value geom);

    public Function ST_IsSimple(Value geom);

    public Function ST_IsValid(Value geom);

    public Function ST_NumGeometries(Value geom);

    public Function ST_NumPoints(Value geom);

    public Function ST_Perimeter(Value geom);

    public Function ST_Point(Value x, Value y);

    public Function ST_PointN(Value geom, Value n);

    public Function ST_SRID(Value geom);

    public Function ST_SetSRID(Value geom, Value srid);

    public Function ST_StartPoint(Value geom);

    public Function ST_Simplify(Value geom, Value tolerance);

    public Function ST_Union(Value geom1, Value geom2);

    public Function ST_X(Value geom);

    public Function ST_Y(Value geom);

    public Function ST_Z(Value geom);