/*
 *    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.h2;

import java.sql.Connection;
import java.sql.PreparedStatement;

import org.geotools.jdbc.JDBCDataStore;
import org.geotools.jdbc.JDBCLobTestSetup;


public class H2LobTestSetup extends JDBCLobTestSetup {

    public H2LobTestSetup() {
        super(new H2TestSetup());
    }
    
    @Override
    protected void setUpDataStore(JDBCDataStore dataStore) {
        super.setUpDataStore(dataStore);
        dataStore.setDatabaseSchema( null );
    }
    
    @Override
    protected void createLobTable() throws Exception {
        
        run("CREATE TABLE \"testlob\" (\"fid\" INT AUTO_INCREMENT PRIMARY KEY, " +
            "\"blob_field\" BYTEA, \"clob_field\" TEXT, \"raw_field\" BYTEA)");
        
        Connection cx = getDataSource().getConnection();
        PreparedStatement ps = cx.prepareStatement("INSERT INTO \"testlob\" (\"blob_field\"," +
            "\"clob_field\",\"raw_field\") VALUES (?,?,?)");
        
        ps.setBytes(1, new byte[] {1,2,3,4,5});
        ps.setString(2, "small clob");
        ps.setBytes(3, new byte[] {6,7,8,9,10});
        ps.execute();
        ps.close();
        cx.close();
    }

    @Override
    protected void dropLobTable() throws Exception {
        runSafe("DROP TABLE \"testlob\"");
    }

}