sqlmaptestsuite.java

Java/J2EE application framework based on [Expert One-on-One J2EE Design and Development] by Rod John

/*
 * Copyright 2002-2004 the original author or authors.
 * 
 * Licensed 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.springframework.orm.ibatis;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.ibatis.db.sqlmap.MappedStatement;
import com.ibatis.db.sqlmap.SqlMap;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapExecutor;
import com.ibatis.sqlmap.client.SqlMapSession;
import junit.framework.TestCase;
import org.easymock.MockControl;

import org.springframework.core.io.ClassPathResource;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.orm.ibatis.support.SqlMapDaoSupport;

/**
 * @author Juergen Hoeller
 * @since 28.11.2003
 */
public class SqlMapTestSuite extends TestCase {

	public void testSqlMapFactoryBean() throws IOException {
		SqlMapFactoryBean factory = new SqlMapFactoryBean();
		factory.setConfigLocation(new ClassPathResource("sql-map-config.xml", getClass()));
		factory.afterPropertiesSet();
		assertTrue(factory.getObject() instanceof SqlMap);
		assertEquals(201, ((SqlMap) factory.getObject()).getStatementCacheSize());
	}

	public void testSqlMapFactoryBeanWithConfigNotFound() {
		SqlMapFactoryBean factory = new SqlMapFactoryBean();
		factory.setConfigLocation(new ClassPathResource("example/sql-map-config.xml"));
		try {
			factory.afterPropertiesSet();
			fail("Should have thrown IOException");
		}
		catch (IOException ex) {
			// expected
		}
	}
	
	public void testSqlMapClientFactoryBeanWithoutConfig() {
		SqlMapClientFactoryBean factory = new SqlMapClientFactoryBean();
		// explicitly set to null, don't know why ;-)
		factory.setConfigLocation(null);
		try {
			factory.afterPropertiesSet();
			fail("Should have thrown IllegalArgumentException");
		} catch (IllegalArgumentException e) {
			// expected
		} catch (IOException e) {
			fail("Should have thrown IllegalArgumentException");
		}
	}
	
	public void testSqlMapTemplate() throws SQLException {
		MockControl dsControl = MockControl.createControl(DataSource.class);
		DataSource ds = (DataSource) dsControl.getMock();
		MockControl conControl = MockControl.createControl(Connection.class);
		final Connection con = (Connection) conControl.getMock();
		ds.getConnection();
		dsControl.setReturnValue(con, 2);
		con.getMetaData();
		conControl.setReturnValue(null, 1);
		con.close();
		conControl.setVoidCallable(2);
		dsControl.replay();
		conControl.replay();

		final MappedStatement stmt = new MappedStatement();
		SqlMap map = new SqlMap() {
			public MappedStatement getMappedStatement(String name) {
				if ("stmt".equals(name)) {
					return stmt;
				}
				return null;
			}
		};

		SqlMapTemplate template = new SqlMapTemplate();
		template.setDataSource(ds);
		template.setSqlMap(map);
		template.afterPropertiesSet();
		Object result = template.execute("stmt", new SqlMapCallback() {
			public Object doInMappedStatement(MappedStatement s, Connection c) {
				assertTrue(stmt == s);
				assertTrue(con == c);
				return "done";
			}
		});
		assertEquals("done", result);
		dsControl.verify();
		conControl.verify();
	}
	
	public void testSqlMapClientTemplate() throws SQLException {
		MockControl dsControl = MockControl.createControl(DataSource.class);
		DataSource ds = (DataSource) dsControl.getMock();
		MockControl conControl = MockControl.createControl(Connection.class);
		final Connection con = (Connection) conControl.getMock();
		ds.getConnection();
		dsControl.setReturnValue(con, 2);
		con.getMetaData();
		conControl.setReturnValue(null, 1);
		con.close();
		conControl.setVoidCallable(2);
		dsControl.replay();
		conControl.replay();

		MockControl smsControl = MockControl.createControl(SqlMapSession.class);
		final SqlMapSession sms = (SqlMapSession) smsControl.getMock();
		MockControl smcControl = MockControl.createControl(SqlMapClient.class);
		SqlMapClient smc = (SqlMapClient) smcControl.getMock();
		smc.openSession();
		smcControl.setReturnValue(sms);
		sms.setUserConnection(con);
		smsControl.setVoidCallable();
		sms.close();
		smsControl.setVoidCallable();
		smsControl.replay();
		smcControl.replay();

		SqlMapClientTemplate template = new SqlMapClientTemplate();
		template.setDataSource(ds);
		template.setSqlMapClient(smc);
		template.afterPropertiesSet();
		Object result = template.execute(new SqlMapClientCallback() {
			public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
				assertTrue(executor == sms);
				return "done";
			}
		});
		assertEquals("done", result);
		dsControl.verify();
		conControl.verify();
		smsControl.verify();
		smcControl.verify();
	}

	public void testSqlMapDaoSupport() throws Exception {
		MockControl dsControl = MockControl.createControl(DataSource.class);
		DataSource ds = (DataSource) dsControl.getMock();
		TestSqlMapDaoSupport testDao = new TestSqlMapDaoSupport();
		testDao.setDataSource(ds);
		assertEquals(ds, testDao.getDSource());

		SqlMap map = new SqlMap();
		testDao.setSqlMap(map);
		assertEquals(map, testDao.getSMap());

		SqlMapTemplate template = new SqlMapTemplate();
		template.setDataSource(ds);
		template.setSqlMap(map);
		testDao.setSqlMapTemplate(template);
		assertEquals(template, testDao.getSMTemplate());

		testDao.afterPropertiesSet();
	}
	
	public void testSqlMapClientDaoSupport() throws Exception {
		MockControl dsControl = MockControl.createControl(DataSource.class);
		DataSource ds = (DataSource) dsControl.getMock();
		TestSqlMapClientDaoSupport testDao = new TestSqlMapClientDaoSupport();
		testDao.setDataSource(ds);
		assertEquals(ds, testDao.getDSource());

		MockControl smcControl = MockControl.createControl(SqlMapClient.class);
		SqlMapClient smc = (SqlMapClient) smcControl.getMock();
		smcControl.replay();

		testDao.setSqlMapClient(smc);
		assertEquals(smc, testDao.getSMap());

		SqlMapClientTemplate template = new SqlMapClientTemplate();
		template.setDataSource(ds);
		template.setSqlMapClient(smc);
		testDao.setSqlMapClientTemplate(template);
		assertEquals(template, testDao.getSMTemplate());

		testDao.afterPropertiesSet();
	}


	private class TestSqlMapDaoSupport extends SqlMapDaoSupport{
	
		public DataSource getDSource(){
			return super.getDataSource();
		}
	
		public SqlMap getSMap() {
			return super.getSqlMap();
		}
	
		public SqlMapTemplate getSMTemplate(){
			return super.getSqlMapTemplate();
		}
	}


	private class TestSqlMapClientDaoSupport extends SqlMapClientDaoSupport{

		public DataSource getDSource(){
			return super.getDataSource();
		}

		public SqlMapClient getSMap() {
			return super.getSqlMapClient();
		}

		public SqlMapClientTemplate getSMTemplate(){
			return super.getSqlMapClientTemplate();
		}
	}

}