/*
* GeoTools - The Open Source Java GIS Toolkit
* http://geotools.org
*
* (C) 2002-2011, 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.util.List;
import org.geotools.jdbc.JDBCTypeNamesTestSetup;
public class OracleTypeNamesTestSetup extends JDBCTypeNamesTestSetup {
protected OracleTypeNamesTestSetup() {
super(new OracleTestSetup());
}
@Override
protected void createTypes() throws Exception {
run("CREATE TABLE ftntable ("
+ "id INT, name VARCHAR(255), geom MDSYS.SDO_GEOMETRY)");
run("CREATE VIEW ftnview AS SELECT id, geom FROM ftntable");
run("CREATE SYNONYM ftnsyn FOR ftntable");
}
@Override
protected void dropTypes() throws Exception {
runSafe("DROP SYNONYM ftnsyn");
runSafe("DROP VIEW ftnview");
runSafe("DROP TABLE ftntable purge");
}
@Override
protected List<String> getExpectedTypeNames() {
List<String> ret = super.getExpectedTypeNames();
ret.add("ftnsyn");
return ret;
}
}