DB2NoPrimaryKeyTestSetup.java

/*
 *    GeoTools - The Open Source Java GIS Toolkit
 *    http://geotools.org
 *
 *    (C) 2002-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 
 *    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  License for more details.
 */
package org.geotools.data.db2;

import java.sql.Connection;
import java.sql.SQLException;

import org.geotools.jdbc.JDBCNoPrimaryKeyTestSetup;

public class DB2NoPrimaryKeyTestSetup extends JDBCNoPrimaryKeyTestSetup {

    protected DB2NoPrimaryKeyTestSetup() {
        super(new DB2TestSetup());
    }

    protected void createLakeTable() throws Exception {
    	
    	Connection con = getDataSource().getConnection();
    	con.prepareStatement("create table "+DB2TestUtil.SCHEMA_QUOTED+
    			".\"lake\" (\"id\" int  , \"geom\" DB2GSE.ST_POLYGON , \"name\" varchar(255))").execute();
    	DB2Util.executeRegister(DB2TestUtil.SCHEMA, "lake", "geom", DB2TestUtil.SRSNAME, con);
    	
        con.prepareStatement( "INSERT INTO "+DB2TestUtil.SCHEMA_QUOTED+".\"lake\" VALUES (0," +
        		"db2gse.ST_PolyFromText('POLYGON((12 6, 14 8, 16 6, 16 4, 14 4, 12 6))',"+DB2TestUtil.SRID+"),'muddy')").execute();        
        con.close();
    	
    	
    }
    

    @Override
    protected void dropLakeTable() throws Exception {
    	
    	Connection con = getDataSource().getConnection();
    	try {
    		DB2Util.executeUnRegister(DB2TestUtil.SCHEMA, "lake", "goem", con);
    		DB2TestUtil.dropTable(DB2TestUtil.SCHEMA, "lake", con);
    	} catch (SQLException e) {    		
    	}
    	
        con.close();
    }

}