/* | |
* 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.openjpa.persistence.datacache; | |
import java.util.Collection; | |
import java.util.HashMap; | |
import java.util.List; | |
import java.util.Map; | |
import javax.persistence.EntityManagerFactory; | |
import org.apache.openjpa.persistence.datacache.common.apps.CacheObjectAChild1; | |
import org.apache.openjpa.persistence.datacache.common.apps.CacheObjectE; | |
import org.apache.openjpa.persistence.datacache.common.apps.CacheObjectJ; | |
import org.apache.openjpa.persistence.datacache.common.apps.SelfReferencingCacheTestObject; | |
import org.apache.openjpa.persistence.common.utils.AbstractTestCase; | |
import org.apache.openjpa.kernel.Broker; | |
import org.apache.openjpa.kernel.BrokerFactory; | |
import org.apache.openjpa.kernel.Query; | |
import org.apache.openjpa.kernel.jpql.JPQLParser; | |
import org.apache.openjpa.persistence.JPAFacadeHelper; | |
import org.apache.openjpa.util.UserException; | |
public class TestJPQLRelationProjections | |
extends AbstractTestCase { | |
public TestJPQLRelationProjections(String test) { | |
super(test, "datacachecactusapp"); | |
} | |
private BrokerFactory _factory; | |
public void setUp() { | |
deleteAll(CacheObjectJ.class); | |
deleteAll(CacheObjectE.class); | |
deleteAll(SelfReferencingCacheTestObject.class); | |
Map propsMap = new HashMap(); | |
propsMap.put("openjpa.DataCache", "true"); | |
propsMap.put("openjpa.RemoteCommitProvider", "sjvm"); | |
propsMap.put("openjpa.BrokerImpl", CacheTestBroker.class.getName()); | |
EntityManagerFactory emf = getEmf(propsMap); | |
_factory = JPAFacadeHelper.toBrokerFactory(emf); | |
Broker broker = _factory.newBroker(); | |
try { | |
broker.begin(); | |
} catch (Exception e) { | |
fail("Set up failed due to exception : \n" + | |
getStackTrace(e)); | |
} | |
int j = 0; | |
for (int i = 0; i < 6; i++) { | |
CacheObjectE e; | |
if (i < 3) | |
e = new CacheObjectE(i + ""); | |
else | |
e = null; | |
// make some common names so that GROUP BY is useful. | |
if (i % 2 == 0) | |
j++; | |
broker.persist(new CacheObjectJ("projections-" + j, e), null); | |
} | |
broker.persist(new SelfReferencingCacheTestObject("foo", | |
new SelfReferencingCacheTestObject("bar", null)), null); | |
broker.commit(); | |
broker.close(); | |
CacheTestHelper.cacheManager(_factory).getSystemQueryCache().clear(); | |
} | |
public void tearDown() | |
throws Exception { | |
_factory.close(); | |
super.tearDown(); | |
} | |
public void testNullRelatedPCIsCached() { | |
Broker broker = _factory.newBroker(); | |
Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a.e FROM " + | |
CacheObjectJ.class.getSimpleName() + " a where a.e is null"); | |
Collection c = (Collection) q.execute(); | |
CacheTestHelper.iterate(c); | |
CacheTestHelper.assertInCache(this, q, Boolean.TRUE); | |
c = (Collection) q.execute(); | |
assertNull(c.iterator().next()); | |
} | |
public void testNullRelatedPCAndProjectionIsCached() { | |
Broker broker = _factory.newBroker(); | |
Query q = | |
broker.newQuery(JPQLParser.LANG_JPQL, "select a.str,a.e FROM " + | |
CacheObjectJ.class.getSimpleName() + " a where a.e is null"); | |
Collection c = (Collection) q.execute(); | |
CacheTestHelper.iterate(c); | |
CacheTestHelper.assertInCache(this, q, Boolean.TRUE); | |
c = (Collection) q.execute(); | |
Object[] result = (Object[]) c.iterator().next(); | |
assertEquals(2, result.length); | |
assertEquals(String.class, result[0].getClass()); | |
assertNull(result[1]); | |
} | |
public void testNonNullRelatedPCIsCached() { | |
Broker broker = _factory.newBroker(); | |
Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a.e FROM " + | |
CacheObjectJ.class.getSimpleName() + " a where a.e is not null"); | |
Collection c = (Collection) q.execute(); | |
CacheTestHelper.iterate(c); | |
CacheTestHelper.assertInCache(this, q, Boolean.TRUE); | |
c = (Collection) q.execute(); | |
assertEquals(CacheObjectE.class, c.iterator().next().getClass()); | |
} | |
public void testNonNullRelatedPCAndProjectionIsCached() { | |
Broker broker = _factory.newBroker(); | |
Query q = | |
broker.newQuery(JPQLParser.LANG_JPQL, "select a.str,a.e FROM " + | |
CacheObjectJ.class.getSimpleName() + | |
" a where a.e is not null"); | |
Collection c = (Collection) q.execute(); | |
CacheTestHelper.iterate(c); | |
CacheTestHelper.assertInCache(this, q, Boolean.TRUE); | |
c = (Collection) q.execute(); | |
Object[] result = (Object[]) c.iterator().next(); | |
assertEquals(2, result.length); | |
assertEquals(String.class, result[0].getClass()); | |
assertEquals(CacheObjectE.class, result[1].getClass()); | |
} | |
public void testEmbeddedFields() { | |
Broker broker = _factory.newBroker(); | |
Query q = | |
broker.newQuery(JPQLParser.LANG_JPQL, "select embedded FROM " + | |
SelfReferencingCacheTestObject.class.getSimpleName() + | |
" a where a.str='foo'"); | |
List l = null; | |
try { | |
l = (List) q.execute(); | |
assertEquals(CacheObjectAChild1.class, l.get(0).getClass()); | |
} catch (UserException ue) { | |
//bug(1150, "embedded-field projections cause exception"); | |
ue.printStackTrace(); | |
return; | |
} | |
CacheTestHelper.iterate(l); | |
CacheTestHelper.assertInCache(this, q, Boolean.TRUE); | |
l = (List) q.execute(); | |
assertEquals(CacheObjectAChild1.class, l.get(0).getClass()); | |
} | |
public void testNonNullRelationOfSameTypeAsCandidate() { | |
Broker broker = _factory.newBroker(); | |
Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a.o FROM " + | |
SelfReferencingCacheTestObject.class.getSimpleName() + | |
" a where a.o IS NOT NULL"); | |
List l = (List) q.execute(); | |
assertEquals(SelfReferencingCacheTestObject.class, | |
l.get(0).getClass()); | |
assertEquals("bar", | |
((SelfReferencingCacheTestObject) l.get(0)).getStr()); | |
CacheTestHelper.iterate(l); | |
CacheTestHelper.assertInCache(this, q, Boolean.TRUE); | |
l = (List) q.execute(); | |
assertEquals(SelfReferencingCacheTestObject.class, | |
l.get(0).getClass()); | |
assertEquals("bar", | |
((SelfReferencingCacheTestObject) l.get(0)).getStr()); | |
} | |
public void testNullRelationOfSameTypeAsCandidate() { | |
Broker broker = _factory.newBroker(); | |
Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a.o FROM " + | |
SelfReferencingCacheTestObject.class.getSimpleName() + | |
" a where a.o IS NULL"); | |
List l = (List) q.execute(); | |
assertNull(l.get(0)); | |
CacheTestHelper.iterate(l); | |
CacheTestHelper.assertInCache(this, q, Boolean.TRUE); | |
l = (List) q.execute(); | |
assertNull(l.get(0)); | |
} | |
} |