OracleNoPrimaryKeyTestSetup.java

package org.geotools.data.oracle;

import org.geotools.jdbc.JDBCNoPrimaryKeyTestSetup;

public class OracleNoPrimaryKeyTestSetup extends JDBCNoPrimaryKeyTestSetup {

    protected OracleNoPrimaryKeyTestSetup() {
        super(new OracleTestSetup());
    }

    protected void createLakeTable() throws Exception {
        //set up table
        run("CREATE TABLE lake (id int, "
            + "geom MDSYS.SDO_GEOMETRY, name varchar(255))");
        run("INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)" 
                + " VALUES ('lake','geom',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',-180,180,0.5), " 
                + "MDSYS.SDO_DIM_ELEMENT('Y',-90,90,0.5)), 4326)");   
        run("CREATE INDEX LAKE_GEOM_IDX ON lake(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX" //
                + " PARAMETERS ('SDO_INDX_DIMS=2 LAYER_GTYPE=\"POLYGON\"')");
        
        //insert data
        run("INSERT INTO lake (id,geom,name) VALUES ( 0,"
            + "MDSYS.SDO_GEOMETRY( 2003, 4326, NULL, SDO_ELEM_INFO_ARRAY(1,1003,1), "
            + "SDO_ORDINATE_ARRAY(12,6, 14,8, 16,6, 16,4, 14,4, 12,6)), 'muddy')");
    }
    

    @Override
    protected void dropLakeTable() throws Exception {
        runSafe( "DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LAKE'" );
        runSafe( "DROP TABLE lake PURGE");
    }

}