SQLEncoderOracleTest.java

/*
 *    GeoTools - The Open Source Java GIS Toolkit
 *    http://geotools.org
 *
 *    (C) 2003-2008, Open Source Geospatial Foundation (OSGeo)
 *
 *    This library is free software; you can redistribute it and/or
 *    modify it under the terms of the GNU Lesser General Public
 *    License as published by the Free Software Foundation;
 *    version 2.1 of the License.
 *
 *    This library 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
 *    Lesser General Public License for more details.
 *    
 *    Created on 31/07/2003
 */
package org.geotools.filter;

import java.util.HashMap;
import java.util.logging.Logger;

import junit.framework.TestCase;

import org.geotools.test.TestData;

import com.vividsolutions.jts.geom.Coordinate;
import com.vividsolutions.jts.geom.Envelope;
import com.vividsolutions.jts.geom.GeometryFactory;


/**
 * DOCUMENT ME!
 *
 * @author Sean Geoghegan, Defence Science and Technology Organisation
 * @author $Author: seangeo $
 * @source $URL$
 * @version $Id$ Last Modified: $Date: 2003/11/26 22:57:45 $
 */
public class SQLEncoderOracleTest extends TestCase {
    private static final Logger LOGGER = org.geotools.util.logging.Logging.getLogger("org.geotools.filter");
    private static final FilterFactory filterFactory = FilterFactoryFinder.createFilterFactory();
    private static final GeometryFactory geometryFactory = new GeometryFactory();
    private SQLEncoder encoder;

    /**
     * Constructor for SQLEncoderOracleTest.
     *
     * @param arg0
     */
    public SQLEncoderOracleTest(String arg0) {
        super(arg0);
    }

    /*
     * @see TestCase#setUp()
     */
    protected void setUp() throws Exception {
        super.setUp();
    }

    /*
     * @see TestCase#tearDown()
     */
    protected void tearDown() throws Exception {
        super.tearDown();
    }

    public void testGeometryFilterEncoder() throws Exception {
        encoder = new SQLEncoderOracle("FID",new HashMap());

        GeometryFilter filter = filterFactory.createGeometryFilter(AbstractFilter.GEOMETRY_BBOX);
        filter.addLeftGeometry(filterFactory.createAttributeExpression(null, "GEOM"));
        filter.addRightGeometry(filterFactory.createBBoxExpression(
                new Envelope(-180.0, 180.0, -90.0, 90.0)));
        String value = encoder.encode(filter);
        assertEquals("WHERE SDO_RELATE(\"GEOM\","+
        		"MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),"+
        		"MDSYS.SDO_ORDINATE_ARRAY(-180.0,-90.0,180.0,90.0)),"+
        		"'mask=anyinteract querytype=WINDOW') = 'TRUE' ", value);

        filter = filterFactory.createGeometryFilter(AbstractFilter.GEOMETRY_CONTAINS);
        filter.addLeftGeometry(filterFactory.createAttributeExpression(null, "SHAPE"));
        filter.addRightGeometry(filterFactory.createLiteralExpression(geometryFactory.createPoint(
                    new Coordinate(10.0, -10.0))));
        value = encoder.encode(filter);
        LOGGER.fine(value);
        assertEquals("WHERE SDO_RELATE(\"SHAPE\",MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(10.0,-10.0,NULL),NULL,NULL),'mask=contains querytype=WINDOW') = 'TRUE' ",
            value);

        filter = filterFactory.createGeometryFilter(AbstractFilter.GEOMETRY_CROSSES);
        filter.addLeftGeometry(filterFactory.createAttributeExpression(null, "GEOM"));
        filter.addRightGeometry(filterFactory.createLiteralExpression(
                geometryFactory.createLineString(
                    new Coordinate[] { new Coordinate(-10.0d, -10.0d), new Coordinate(10d, 10d) })));
        value = encoder.encode(filter);
        assertEquals("WHERE SDO_RELATE(\"GEOM\",MDSYS.SDO_GEOMETRY(2002,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1),MDSYS.SDO_ORDINATE_ARRAY(-10.0,-10.0,10.0,10.0)),'mask=overlapbydisjoint querytype=WINDOW') = 'TRUE' ", value);
    }
    
    public void testFIDEncoding() throws Exception {
        encoder = new SQLEncoderOracle("FID",new HashMap());
        
        Filter filter = filterFactory.createFidFilter("FID.1");
        String value = encoder.encode(filter);
        assertEquals("WHERE FID = '1'",value);
        
        FidFilter fidFilter = filterFactory.createFidFilter();
        fidFilter.addFid("FID.1");
        fidFilter.addFid("FID.3");
        value = encoder.encode(fidFilter);
        // depending on the iterator order it may be swapped
        assertTrue("WHERE FID = '3' OR FID = '1'".equals(value) || "WHERE FID = '1' OR FID = '3'".equals(value));
    }
    
    public void testLikeEncoding() throws Exception {
        encoder = new SQLEncoderOracle("FID",new HashMap());
        assertTrue(encoder.getCapabilities().supports(Filter.LIKE));
        
        LikeFilter filter = filterFactory.createLikeFilter();
        filter.setValue(filterFactory.createAttributeExpression("name"));
        filter.setPattern("Cory%", "%", "?", "\\");
//        System.out.println(encoder.encode(filter));
        assertEquals("WHERE UPPER(\"name\") LIKE UPPER('Cory%')", encoder.encode(filter));
    }
    
    public void testIncludeEncoding() throws Exception {
        encoder = new SQLEncoderOracle("FID",new HashMap());
        assertTrue(encoder.getCapabilities().supports(org.opengis.filter.Filter.INCLUDE));
        
        // nothing to filter, no WHERE clause
        assertEquals("WHERE 1 = 1", encoder.encode(org.opengis.filter.Filter.INCLUDE));
    }
    
    public void testExcludeEncoding() throws Exception {
        encoder = new SQLEncoderOracle("FID",new HashMap());
        assertTrue(encoder.getCapabilities().supports(org.opengis.filter.Filter.EXCLUDE));
        
        assertEquals("WHERE 1 = 0", encoder.encode(org.opengis.filter.Filter.EXCLUDE));
    }
}