OracleSkipColumnTestSetup.java

package org.geotools.data.oracle;

import org.geotools.jdbc.JDBCSkipColumnTestSetup;

public class OracleSkipColumnTestSetup extends JDBCSkipColumnTestSetup {

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

    @Override
    protected void createSkipColumnTable() throws Exception {
        String sql = "CREATE TABLE skipcolumn (" 
            + "fid INT, id INT, geom MDSYS.SDO_GEOMETRY, weirdcolumn BFILE, "
            + "name VARCHAR(255), PRIMARY KEY(fid))";
        run(sql);
        sql = "CREATE SEQUENCE skipcolumn_fid_seq";
        run(sql);
        
        sql = "INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID ) " + 
         "VALUES ('skipcolumn','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(sql);
        
        sql = "CREATE INDEX SKIPCOLUMN_GEOM_IDX ON SKIPCOLUMN(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX" //
                        + " PARAMETERS ('SDO_INDX_DIMS=2 LAYER_GTYPE=\"POINT\"')";
        run(sql);
        
        sql = "INSERT INTO SKIPCOLUMN VALUES (skipcolumn_fid_seq.nextval, 0," +
            "MDSYS.SDO_GEOMETRY(2001,4326,SDO_POINT_TYPE(0.0,0.0,NULL),NULL,NULL), null, 'GeoTools')";
        run(sql);

    }

    @Override
    protected void dropSkipColumnTable() throws Exception {
        runSafe("DROP TRIGGER skipcolumn_pkey_trigger");
        runSafe("DROP TABLE skipcolumn purge");
        runSafe("DROP SEQUENCE skipcolumn_fid_seq");
     
        run("DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'SKIPCOLUMN'");

    }

}