/*****************************************************************
* 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.cayenne.query;
import static org.hamcrest.CoreMatchers.instanceOf;
import static org.junit.Assert.*;
import static org.mockito.Mockito.mock;
import org.apache.cayenne.DataRow;
import org.apache.cayenne.map.EntityResolver;
import org.junit.Test;
public class SQLSelectTest {
@Test
public void testCacheStrategy() {
SQLSelect<DataRow> q = SQLSelect.dataRowQuery("bla");
assertNull(q.getCacheStrategy());
assertNull(q.getCacheGroup());
q.cacheStrategy(QueryCacheStrategy.LOCAL_CACHE, "a");
assertSame(QueryCacheStrategy.LOCAL_CACHE, q.getCacheStrategy());
assertEquals("a", q.getCacheGroup());
q.cacheStrategy(QueryCacheStrategy.SHARED_CACHE);
assertSame(QueryCacheStrategy.SHARED_CACHE, q.getCacheStrategy());
assertNull(q.getCacheGroup());
}
@Test
public void testLocalCache() {
SQLSelect<DataRow> q = SQLSelect.dataRowQuery("bla");
assertNull(q.getCacheStrategy());
assertNull(q.getCacheGroup());
q.localCache("a");
assertSame(QueryCacheStrategy.LOCAL_CACHE, q.getCacheStrategy());
assertEquals("a", q.getCacheGroup());
q.localCache();
assertSame(QueryCacheStrategy.LOCAL_CACHE, q.getCacheStrategy());
assertNull(q.getCacheGroup());
}
@Test
public void testSharedCache() {
SQLSelect<DataRow> q = SQLSelect.dataRowQuery("bla");
assertNull(q.getCacheStrategy());
assertNull(q.getCacheGroup());
q.sharedCache("a");
assertSame(QueryCacheStrategy.SHARED_CACHE, q.getCacheStrategy());
assertEquals("a", q.getCacheGroup());
q.sharedCache();
assertSame(QueryCacheStrategy.SHARED_CACHE, q.getCacheStrategy());
assertNull(q.getCacheGroup());
}
@Test
public void testCreateReplacementQuery() {
SQLSelect<DataRow> q = SQLSelect.dataRowQuery("bla");
Query replacement = q.createReplacementQuery(mock(EntityResolver.class));
assertThat(replacement, instanceOf(SQLTemplate.class));
}
@Test
public void testCreateReplacementQuery_ParamsArray_Single() {
SQLSelect<DataRow> q = SQLSelect.dataRowQuery("bla").paramsArray("a");
SQLTemplate replacement = (SQLTemplate) q.createReplacementQuery(mock(EntityResolver.class));
assertArrayEquals(new Object[] { "a" }, replacement.getPositionalParams().toArray());
}
@Test
public void testCreateReplacementQuery_ParamsArray_Multiple() {
SQLSelect<DataRow> q = SQLSelect.dataRowQuery("bla").paramsArray("a", "b");
SQLTemplate replacement = (SQLTemplate) q.createReplacementQuery(mock(EntityResolver.class));
assertArrayEquals(new Object[] { "a", "b" }, replacement.getPositionalParams().toArray());
}
@Test
public void testGetMetadata_ParamsArray_Multiple_Cache() {
EntityResolver resolver = mock(EntityResolver.class);
QueryMetadata md0 = SQLSelect.dataRowQuery("bla").localCache().getMetaData(resolver);
QueryMetadata md1 = SQLSelect.dataRowQuery("bla").localCache().paramsArray("a").getMetaData(resolver);
QueryMetadata md2 = SQLSelect.dataRowQuery("bla").localCache().paramsArray("a", "b").getMetaData(resolver);
QueryMetadata md3 = SQLSelect.dataRowQuery("bla").localCache().paramsArray(null, "b").getMetaData(resolver);
assertNotNull(md0.getCacheKey());
assertNotNull(md1.getCacheKey());
assertNotNull(md2.getCacheKey());
assertNotNull(md3.getCacheKey());
assertNotEquals(md0.getCacheKey(), md1.getCacheKey());
assertNotEquals(md0.getCacheKey(), md2.getCacheKey());
assertNotEquals(md1.getCacheKey(), md2.getCacheKey());
assertNotEquals(md3.getCacheKey(), md2.getCacheKey());
}
}