/*
* 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 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.
*/
package org.geotools.data.oracle;
import java.sql.SQLException;
import org.geotools.jdbc.JDBCGeometrylessTestSetup;
import org.geotools.jdbc.JDBCTestSetup;
public class OracleGeometrylessTestSetup extends JDBCGeometrylessTestSetup {
protected OracleGeometrylessTestSetup(JDBCTestSetup delegate) {
super(delegate);
}
@Override
protected void createPersonTable() throws Exception {
//set up table
run("CREATE TABLE person (fid int, id int, "
+ " name varchar(255), age int, PRIMARY KEY (fid) )");
run("CREATE SEQUENCE person_pkey_seq START WITH 0 MINVALUE 0");
run("CREATE TRIGGER person_pkey_trigger " +
"BEFORE INSERT ON person " +
"FOR EACH ROW " +
"BEGIN " +
"SELECT person_pkey_seq.nextval INTO :new.fid FROM dual; " +
"END;");
// insert data
run("INSERT INTO person(id,name,age) VALUES ( 0, 'Paul', 32)");
run("INSERT INTO person(id,name,age) VALUES ( 1, 'Anne', 40)");
}
@Override
protected void dropPersonTable() throws SQLException {
runSafe("DROP SEQUENCE person_pkey_seq");
runSafe("DROP TABLE person");
}
@Override
protected void dropZipCodeTable() throws SQLException {
runSafe("DROP TABLE zipcode");
}
}