package org.geotools.data.postgis;
import java.sql.Connection;
import java.sql.PreparedStatement;
import org.geotools.jdbc.JDBCLobTestSetup;
import org.geotools.jdbc.JDBCTestSetup;
public class PostgisLobTestSetup extends JDBCLobTestSetup {
public PostgisLobTestSetup(JDBCTestSetup delegate) {
super(delegate);
}
@Override
protected void createLobTable() throws Exception {
Connection con = getDataSource().getConnection();
con.prepareStatement("create table \"testlob\" (\"fid\" serial primary key, " +
"\"blob_field\" BYTEA, \"clob_field\" TEXT)").execute();
PreparedStatement ps =con.prepareStatement( "INSERT INTO \"testlob\" (\"blob_field\",\"clob_field\") VALUES (?,?)");
ps.setBytes(1, new byte[] {1,2,3,4,5});
ps.setString(2, "small clob");
ps.execute();
ps.close();
con.close();
}
@Override
protected void dropLobTable() throws Exception {
runSafe("DROP TABLE \"testlob\"");
}
}