SimpleDbQueryMethodWithWhereClauseTest.java

package org.springframework.data.simpledb.query;

import static org.junit.Assert.assertEquals;
import static org.mockito.Mockito.when;

import java.lang.reflect.Method;
import java.util.List;

import org.junit.Test;
import org.mockito.Mockito;
import org.springframework.data.repository.core.RepositoryMetadata;
import org.springframework.data.simpledb.annotation.Query;
import org.springframework.data.simpledb.core.SimpleDbDomain;

public class SimpleDbQueryMethodWithWhereClauseTest {

	@Test
	public void getAnnotatedQuery_should_returned_completed_where_clause_in_query() throws Exception {
		SimpleDbQueryMethod repositoryMethod = prepareQueryMethodToTest("selectWithWhereClause", SampleEntity.class);

		// @Query(where = "sampleAttribute<='3' or sampleList is ''")
		final String expectedQuery = "select * from `testDB.sampleEntity` where sampleAttribute<='3' or sampleList is ''";

		assertEquals(expectedQuery, repositoryMethod.getAnnotatedQuery());
	}

	@Test
	public void getAnnotatedQuery_should_change_id_in_where_clause() throws Exception {
		SimpleDbQueryMethod repositoryMethod = prepareQueryMethodToTest("selectChangeId", SampleEntity.class);

		final String expectedQuery = "select * from `testDB.sampleEntity` where item_id ='Item_0'";
		assertEquals(expectedQuery, repositoryMethod.getAnnotatedQuery());
	}

	public interface AnnotatedQueryRepository {

		@Query(where = "sampleAttribute<='3' or sampleList is ''")
		List<SampleEntity> selectWithWhereClause();

		@Query(where = "item_id ='Item_0'")
		List<SampleEntity> selectChangeId();
	}

	@SuppressWarnings({ "rawtypes", "unchecked" })
	private SimpleDbQueryMethod prepareQueryMethodToTest(String methodName, Class<?> entityClass) throws Exception {
		RepositoryMetadata repositoryMetadata = Mockito.mock(RepositoryMetadata.class);
		when(repositoryMetadata.getDomainType()).thenReturn((Class) entityClass);

		Method testMethod = AnnotatedQueryRepository.class.getMethod(methodName);
		when(repositoryMetadata.getReturnedDomainClass(testMethod)).thenReturn((Class) entityClass);
		SimpleDbDomain simpleDbDomain = new SimpleDbDomain();
		return new SimpleDbQueryMethod(testMethod, repositoryMetadata, simpleDbDomain);
	}

}