IngresSkipColumnTestSetup.java

package org.geotools.data.ingres;

import org.geotools.jdbc.JDBCSkipColumnTestSetup;

public class IngresSkipColumnTestSetup extends JDBCSkipColumnTestSetup {

    protected IngresSkipColumnTestSetup() {
        super(new IngresTestSetup());
    }

    @Override
    protected void createSkipColumnTable() throws Exception {
        run("CREATE TABLE \"skipcolumn\"(" //
                + "\"fid\" int primary key, " //
                + "\"id\" integer, " //
                + "\"geom\" POINT SRID 4326, " //
                + "\"weirdproperty\" NBR," //
                + "\"name\" varchar(256))");
        run("CREATE SEQUENCE skipcolumn_fid_sequence");
        
        run("INSERT INTO \"skipcolumn\" VALUES(NEXT VALUE FOR skipcolumn_fid_sequence, " +
        		"0, GeometryFromText('POINT(0 0)', 4326), null, 'GeoTools')"); 

    }

    @Override
    protected void dropSkipColumnTable() throws Exception {
        runSafe("DROP TABLE \"skipcolumn\"");
        runSafe("DROP SEQUENCE skipcolumn_fid_sequence");
    }

}