/**
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.camel.component.ibatis;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import org.apache.camel.test.junit4.CamelTestSupport;
import org.apache.derby.jdbc.EmbeddedDriver;
import org.junit.After;
import org.junit.Before;
public class IBatisTestSupport extends CamelTestSupport {
protected boolean createTestData() {
return true;
}
protected String getStatement() {
return "create table ACCOUNT ( ACC_ID INTEGER , ACC_FIRST_NAME VARCHAR(255), ACC_LAST_NAME VARCHAR(255), ACC_EMAIL VARCHAR(255) )";
}
@Override
@Before
public void setUp() throws Exception {
super.setUp();
// lets create the database...
Connection connection = createConnection();
Statement statement = connection.createStatement();
statement.execute(getStatement());
connection.commit();
connection.close();
if (createTestData()) {
Account account1 = new Account();
account1.setId(123);
account1.setFirstName("James");
account1.setLastName("Strachan");
account1.setEmailAddress("TryGuessing@gmail.com");
Account account2 = new Account();
account2.setId(456);
account2.setFirstName("Claus");
account2.setLastName("Ibsen");
account2.setEmailAddress("Noname@gmail.com");
template.sendBody("ibatis:insertAccount?statementType=Insert", new Account[]{account1, account2});
}
}
@Override
@After
public void tearDown() throws Exception {
super.tearDown();
try {
new EmbeddedDriver().connect("jdbc:derby:memory:ibatis;drop=true", new Properties());
} catch (SQLException ex) {
if (!"08006".equals(ex.getSQLState())) {
throw ex;
}
}
}
private Connection createConnection() throws Exception {
IBatisEndpoint endpoint = resolveMandatoryEndpoint("ibatis:Account", IBatisEndpoint.class);
return endpoint.getSqlMapClient().getDataSource().getConnection();
}
}