StoredProcPollingChannelAdapterParserTests.java example

Explorer
spring-integration-master
/*
 * Copyright 2002-2016 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.integration.jdbc.config;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertFalse;
import static org.junit.Assert.assertNotNull;
import static org.junit.Assert.assertNull;
import static org.junit.Assert.assertSame;
import static org.junit.Assert.assertTrue;

import java.sql.Types;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;

import org.junit.After;
import org.junit.Test;

import org.springframework.beans.DirectFieldAccessor;
import org.springframework.context.ConfigurableApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.expression.Expression;
import org.springframework.integration.endpoint.SourcePollingChannelAdapter;
import org.springframework.integration.jdbc.storedproc.PrimeMapper;
import org.springframework.integration.jdbc.storedproc.ProcedureParameter;
import org.springframework.integration.test.util.TestUtils;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.SingleColumnRowMapper;
import org.springframework.jdbc.core.SqlInOutParameter;
import org.springframework.jdbc.core.SqlOutParameter;
import org.springframework.jdbc.core.SqlParameter;
import org.springframework.messaging.MessageChannel;
import org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler;

/**
 * @author Gunnar Hillert
 * @author Gary Russell
 * @author Artem Bilan
 * @since 2.1
 */
public class StoredProcPollingChannelAdapterParserTests {

	private ConfigurableApplicationContext context;

	private SourcePollingChannelAdapter pollingAdapter;

	@Test
	public void testProcedureNameIsSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());

		DirectFieldAccessor accessor = new DirectFieldAccessor(this.pollingAdapter);
		Object source = accessor.getPropertyValue("source");
		accessor = new DirectFieldAccessor(source);
		source = accessor.getPropertyValue("executor");
		accessor = new DirectFieldAccessor(source);
		Expression storedProcedureName = (Expression) accessor.getPropertyValue("storedProcedureNameExpression");
		assertEquals("Wrong stored procedure name", "GET_PRIME_NUMBERS", storedProcedureName.getValue());
	}

	@Test
	public void testProcedureNameExpressionIsSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest2.xml", getClass());

		Expression storedProcedureNameExpression =
				TestUtils.getPropertyValue(this.pollingAdapter,
						"source.executor.storedProcedureNameExpression",
						Expression.class);

		assertEquals("Wrong stored procedure name", "'GET_PRIME_NUMBERS'",
				storedProcedureNameExpression.getExpressionString());
	}

	@Test
	public void testDefaultJdbcCallOperationsCacheSizeIsSet() {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());

		Integer cacheSize =
				TestUtils.getPropertyValue(this.pollingAdapter,
						"source.executor.jdbcCallOperationsCacheSize",
						Integer.class);

		assertEquals("Wrong Default JdbcCallOperations Cache Size", Integer.valueOf(10),
				cacheSize);
	}


	@Test
	public void testJdbcCallOperationsCacheSizeIsSet() {
		setUp("storedProcPollingChannelAdapterParserTest2.xml", getClass());

		Integer cacheSize = TestUtils.getPropertyValue(this.pollingAdapter,
						"source.executor.jdbcCallOperationsCacheSize",
						Integer.class);

		assertEquals("Wrong JdbcCallOperations Cache Size", Integer.valueOf(77), cacheSize);
	}

	@Test
	public void testSkipUndeclaredResultsAttributeSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());

		DirectFieldAccessor accessor = new DirectFieldAccessor(this.pollingAdapter);
		Object source = accessor.getPropertyValue("source");
		accessor = new DirectFieldAccessor(source);
		source = accessor.getPropertyValue("executor");
		accessor = new DirectFieldAccessor(source);
		boolean skipUndeclaredResults = (Boolean) accessor.getPropertyValue("skipUndeclaredResults");
		assertTrue("skipUndeclaredResults was not set and should default to 'true'", skipUndeclaredResults);
	}

	@Test
	public void testReturnValueRequiredAttributeSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());

		DirectFieldAccessor accessor = new DirectFieldAccessor(this.pollingAdapter);
		Object source = accessor.getPropertyValue("source");
		accessor = new DirectFieldAccessor(source);
		source = accessor.getPropertyValue("executor");
		accessor = new DirectFieldAccessor(source);
		boolean returnValueRequired = (Boolean) accessor.getPropertyValue("returnValueRequired");
		assertTrue(returnValueRequired);
	}

	@Test
	public void testIsFunctionAttributeSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());
		DirectFieldAccessor accessor = new DirectFieldAccessor(this.pollingAdapter);
		Object source = accessor.getPropertyValue("source");
		accessor = new DirectFieldAccessor(source);
		source = accessor.getPropertyValue("executor");
		accessor = new DirectFieldAccessor(source);
		boolean isFunction = (Boolean) accessor.getPropertyValue("isFunction");
		assertTrue(isFunction);
	}

	@SuppressWarnings("unchecked")
	@Test
	public void testProcedureParametersAreSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());

		DirectFieldAccessor accessor = new DirectFieldAccessor(this.pollingAdapter);
		Object source = accessor.getPropertyValue("source");
		accessor = new DirectFieldAccessor(source);
		source = accessor.getPropertyValue("executor");
		accessor = new DirectFieldAccessor(source);
		Object procedureParameters = accessor.getPropertyValue("procedureParameters");
		assertNotNull(procedureParameters);
		assertTrue(procedureParameters instanceof List);

		List<ProcedureParameter> procedureParametersAsList = (List<ProcedureParameter>) procedureParameters;

		assertTrue(procedureParametersAsList.size() == 4);

		ProcedureParameter parameter1 = procedureParametersAsList.get(0);
		ProcedureParameter parameter2 = procedureParametersAsList.get(1);
		ProcedureParameter parameter3 = procedureParametersAsList.get(2);
		ProcedureParameter parameter4 = procedureParametersAsList.get(3);

		assertEquals("username", parameter1.getName());
		assertEquals("description", parameter2.getName());
		assertEquals("password", parameter3.getName());
		assertEquals("age", parameter4.getName());

		assertEquals("kenny", parameter1.getValue());
		assertEquals("Who killed Kenny?", parameter2.getValue());
		assertNull(parameter3.getValue());
		assertEquals(30, parameter4.getValue());

		assertNull(parameter1.getExpression());
		assertNull(parameter2.getExpression());
		assertEquals("payload.username", parameter3.getExpression());
		assertNull(parameter4.getExpression());

	}

	@SuppressWarnings("unchecked")
	@Test
	public void testReturningResultSetRowMappersAreSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());

		DirectFieldAccessor accessor = new DirectFieldAccessor(this.pollingAdapter);
		Object source = accessor.getPropertyValue("source");
		accessor = new DirectFieldAccessor(source);
		source = accessor.getPropertyValue("executor");
		accessor = new DirectFieldAccessor(source);
		Object returningResultSetRowMappers = accessor.getPropertyValue("returningResultSetRowMappers");
		assertNotNull(returningResultSetRowMappers);
		assertTrue(returningResultSetRowMappers instanceof Map);

		Map<String, RowMapper<?>> returningResultSetRowMappersAsMap =
				(Map<String, RowMapper<?>>) returningResultSetRowMappers;

		assertTrue("The rowmapper was not set. Expected returningResultSetRowMappersAsMap.size() == 2",
				returningResultSetRowMappersAsMap.size() == 2);

		Iterator<Entry<String, RowMapper<?>>> iterator = returningResultSetRowMappersAsMap.entrySet().iterator();

		Entry<String, ?> mapEntry = iterator.next();
		assertEquals("out", mapEntry.getKey());
		assertTrue(mapEntry.getValue() instanceof PrimeMapper);

		mapEntry = iterator.next();
		assertEquals("out2", mapEntry.getKey());
		assertTrue(mapEntry.getValue() instanceof SingleColumnRowMapper);

	}


	@SuppressWarnings("unchecked")
	@Test
	public void testSqlParametersAreSet() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());

		DirectFieldAccessor accessor = new DirectFieldAccessor(this.pollingAdapter);
		Object source = accessor.getPropertyValue("source");
		accessor = new DirectFieldAccessor(source);
		source = accessor.getPropertyValue("executor");
		accessor = new DirectFieldAccessor(source);
		Object sqlParameters = accessor.getPropertyValue("sqlParameters");
		assertNotNull(sqlParameters);
		assertTrue(sqlParameters instanceof List);

		List<SqlParameter> sqlParametersAsList = (List<SqlParameter>) sqlParameters;

		assertTrue(sqlParametersAsList.size() == 4);

		SqlParameter parameter1 = sqlParametersAsList.get(0);
		SqlParameter parameter2 = sqlParametersAsList.get(1);
		SqlParameter parameter3 = sqlParametersAsList.get(2);
		SqlParameter parameter4 = sqlParametersAsList.get(3);

		assertEquals("username", parameter1.getName());
		assertEquals("password", parameter2.getName());
		assertEquals("age", parameter3.getName());
		assertEquals("description", parameter4.getName());

		assertNull("Expect that the scale is null.", parameter1.getScale());
		assertNull("Expect that the scale is null.", parameter2.getScale());
		assertEquals("Expect that the scale is 5.", Integer.valueOf(5), parameter3.getScale());
		assertNull("Expect that the scale is null.", parameter4.getScale());

		assertEquals("SqlType is ", Types.VARCHAR, parameter1.getSqlType());
		assertEquals("SqlType is ", Types.VARCHAR, parameter2.getSqlType());
		assertEquals("SqlType is ", Types.INTEGER, parameter3.getSqlType());
		assertEquals("SqlType is ", Types.VARCHAR, parameter4.getSqlType());

		assertTrue(parameter2 instanceof SqlOutParameter);
		assertTrue(parameter3 instanceof SqlInOutParameter);

	}

	@Test
	public void testAutoChannel() throws Exception {
		setUp("storedProcPollingChannelAdapterParserTest.xml", getClass());
		MessageChannel autoChannel = context.getBean("autoChannel", MessageChannel.class);
		SourcePollingChannelAdapter autoChannelAdapter =
				context.getBean("autoChannel.adapter", SourcePollingChannelAdapter.class);
		assertSame(autoChannel, TestUtils.getPropertyValue(autoChannelAdapter, "outputChannel"));
		assertFalse(TestUtils.getPropertyValue(autoChannelAdapter, "source.executor.returnValueRequired", Boolean.class));
		assertFalse(TestUtils.getPropertyValue(autoChannelAdapter, "source.executor.isFunction", Boolean.class));
		autoChannelAdapter.stop();
	}

	@After
	public void tearDown() {
		this.pollingAdapter.stop();
		ThreadPoolTaskScheduler taskScheduler = context.getBean(ThreadPoolTaskScheduler.class);
		taskScheduler.setAwaitTerminationSeconds(10);
		taskScheduler.destroy();
		if (context != null) {
			context.close();
		}
	}

	public void setUp(String name, Class<?> cls) {
		this.context = new ClassPathXmlApplicationContext(name, cls);
		this.pollingAdapter =
				this.context.getBean("storedProcedurePollingChannelAdapter", SourcePollingChannelAdapter.class);
	}

}