/*
* 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.SQLException;
import java.sql.Statement;
import org.geotools.data.Query;
import org.geotools.data.simple.SimpleFeatureSource;
import org.geotools.jdbc.ConnectionLifecycleListener;
import org.geotools.jdbc.JDBCConnectionLifecycleTest;
import org.geotools.jdbc.JDBCDataStore;
import org.geotools.jdbc.JDBCTestSetup;
import org.geotools.jdbc.VirtualTable;
public class H2ConnectionLifecycleTest extends JDBCConnectionLifecycleTest {
private class SetVariableListener implements ConnectionLifecycleListener {
double value;
public void onBorrow(JDBCDataStore store, Connection cx) throws SQLException {
Statement st = null;
try {
st = cx.createStatement();
st.execute("SET @MYVAR = " + value);
} finally {
store.closeSafe(st);
}
}
public void onRelease(JDBCDataStore store, Connection cx) throws SQLException {
// nothing to do
}
public void onCommit(JDBCDataStore store, Connection cx) throws SQLException {
// nothing to do
}
public void onRollback(JDBCDataStore store, Connection cx) throws SQLException {
// nothing to do
}
}
protected JDBCTestSetup createTestSetup() {
return new H2TestSetup();
}
public void testVariableListener() throws Exception {
// setup a virtual table using the user variable
VirtualTable vt = new VirtualTable("ft1var", "select * from \"geotools\".\"ft1\" where \"doubleProperty\" > @MYVAR");
dataStore.addVirtualTable(vt);
// setup a listener that uses said variable
SetVariableListener listener = new SetVariableListener();
dataStore.getConnectionLifecycleListeners().add(listener);
// set the value and test
listener.value = 1.0;
SimpleFeatureSource fs = dataStore.getFeatureSource("ft1var");
assertEquals(2, fs.getCount(Query.ALL));
listener.value = 10;
assertEquals(0, fs.getCount(Query.ALL));
}
}