| /* |
| * 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.Date; |
| import java.util.HashMap; |
| import java.util.List; |
| import java.util.Map; |
| |
| import javax.persistence.EntityManagerFactory; |
| |
| 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.persistence.common.utils.AbstractTestCase; |
| import org.apache.openjpa.persistence.datacache.common.apps.CacheObjectA; |
| import org.apache.openjpa.persistence.datacache.common.apps.CacheObjectAChild1; |
| import org.apache.openjpa.persistence.datacache.common.apps.CacheObjectB; |
| import org.apache.openjpa.persistence.datacache.common.apps. |
| CacheObjectWithExternalizedFields; |
| import org.apache.openjpa.persistence.test.AllowFailure; |
| |
| @AllowFailure(message="surefire excluded") |
| public class TestJPQL2ResultsAndResultClasses |
| extends AbstractTestCase { |
| |
| public TestJPQL2ResultsAndResultClasses(String test) { |
| super(test, "datacachecactusapp"); |
| } |
| |
| private BrokerFactory _factory; |
| |
| @Override |
| public void setUp() { |
| deleteAll(CacheObjectA.class); |
| deleteAll(CacheObjectWithExternalizedFields.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) { |
| System.out.println( |
| "Exception in TestJPQL2ResultsAndResultClasses setup : \n" + |
| getStackTrace(e)); |
| } |
| |
| int j = 0; |
| for (int i = 0; i < 10; i++) { |
| // make some common names so that GROUP BY is useful. |
| if (i % 2 == 0) |
| j++; |
| CacheObjectA o; |
| broker.persist(o = new CacheObjectAChild1("", "results-" + j, i), |
| null); |
| |
| o.setDate(new Date()); |
| o.setDateArray(new Date[]{ new Date(10), new Date(20) }); |
| |
| if (i < 5) |
| o.setRelatedB(new CacheObjectB()); |
| } |
| |
| //Seetha Oct 30,2006 |
| //deleteAll closes the TX. So use the local |
| //deleteAll fn. |
| //deleteAll(CacheObjectWithExternalizedFields.class,()); |
| //deleteAll(broker,CacheObjectWithExternalizedFields.class,true); |
| |
| CacheObjectWithExternalizedFields o = |
| new CacheObjectWithExternalizedFields(); |
| broker.persist(o, null); |
| o.setCls(Broker.class); |
| |
| broker.commit(); |
| broker.close(); |
| |
| CacheTestHelper.cacheManager(_factory).getSystemQueryCache().clear(); |
| } |
| |
| @Override |
| public void tearDown() |
| throws Exception { |
| _factory.close(); |
| _factory = null; |
| super.tearDown(); |
| } |
| |
| public void testAggregateResultIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select max(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| |
| Object o = q.execute(); |
| assertEquals(Long.class, o.getClass()); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| o = q.execute(); |
| assertEquals(Long.class, o.getClass()); |
| } |
| |
| public void testAggregateNonUniqueResultIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select max(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| q.setUnique(false); |
| List res = (List) q.execute(); |
| assertEquals(1, res.size()); |
| Object o = res.get(0); |
| assertEquals(Long.class, o.getClass()); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| res = (List) q.execute(); |
| assertEquals(1, res.size()); |
| o = res.get(0); |
| assertEquals(Long.class, o.getClass()); |
| } |
| |
| public void testProjectionResultIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a.age FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| Collection c = (Collection) q.execute(); |
| CacheTestHelper.iterate(c); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| c = (Collection) q.execute(); |
| Object o = c.iterator().next(); |
| assertEquals(Long.class, o.getClass()); |
| } |
| |
| public void testProjectionOfThisIsCached() { |
| // ##### need to test single projection |
| Broker broker = _factory.newBroker(); |
| Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| //CacheObjectAChild1.class, "select this"); |
| Collection c = (Collection) q.execute(); |
| CacheTestHelper.iterate(c); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| c = (Collection) q.execute(); |
| Object o = c.iterator().next(); |
| assertEquals(CacheObjectAChild1.class, o.getClass()); |
| assertNotNull(broker.getObjectId(o)); |
| } |
| |
| public void testProjectionResultWithThisIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select a.name,a FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| 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(CacheObjectAChild1.class, result[1].getClass()); |
| assertNotNull(broker.getObjectId(result[1])); |
| } |
| |
| public void testNullProjectionValues() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select a.locale FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| Collection c = (Collection) q.execute(); |
| CacheTestHelper.iterate(c); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| c = (Collection) q.execute(); |
| assertNull(c.iterator().next()); |
| } |
| |
| public void testNullAndNotNullProjectionValues() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker |
| .newQuery(JPQLParser.LANG_JPQL, "select a.name,a.locale FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| |
| 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 XXXtestNullAggregateValues() { |
| // ??? |
| } |
| |
| public void testMultipleAggregateResultIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, |
| "select max(a.age), avg(a.age), count(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| |
| Object o = q.execute(); |
| assertEquals(Object[].class, o.getClass()); |
| assertEquals(3, ((Object[]) o).length); |
| assertEquals(Long.class, ((Object[]) o)[0].getClass()); |
| |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| o = q.execute(); |
| assertEquals(Object[].class, o.getClass()); |
| assertEquals(3, ((Object[]) o).length); |
| assertEquals(Long.class, ((Object[]) o)[0].getClass()); |
| } |
| |
| public void testFieldUsedTwice() { |
| // Postgres bug |
| Broker broker = _factory.newBroker(); |
| // group avoids postgres bug |
| Query q = broker |
| .newQuery(JPQLParser.LANG_JPQL, "select a.age, avg(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + |
| " a group by a.age"); |
| Collection c = (Collection) q.execute(); |
| CacheTestHelper.iterate(c); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| } |
| |
| public void testAggregateAndProjection() { |
| // Postgres bug |
| Broker broker = _factory.newBroker(); |
| // group avoids postgres bug |
| Query q = broker |
| .newQuery(JPQLParser.LANG_JPQL, "select a.name, avg(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + |
| " a group by a.name"); |
| |
| List l = (List) q.execute(); |
| CacheTestHelper.iterate(l); |
| assertEquals(Object[].class, l.get(0).getClass()); |
| assertEquals(2, ((Object[]) l.get(0)).length); |
| assertEquals(String.class, ((Object[]) l.get(0))[0].getClass()); |
| |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| l = (List) q.execute(); |
| assertEquals(Object[].class, l.get(0).getClass()); |
| assertEquals(2, ((Object[]) l.get(0)).length); |
| assertEquals(String.class, ((Object[]) l.get(0))[0].getClass()); |
| } |
| |
| //FIXME Seetha Dec 19,2006 |
| /*public void testMath() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL,"select avg(a.age) FROM "+ |
| CacheObjectAChild1.class.getSimpleName()+" a"); |
| Number n = (Number) q.execute(); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| n = (Number) q.execute(); |
| }*/ |
| |
| public void testResultClassIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = broker.newQuery(JPQLParser.LANG_JPQL, "Select a FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| q.setResultType(Object.class); |
| Collection c = (Collection) q.execute(); |
| CacheTestHelper.iterate(c); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| } |
| |
| public void testGroupingIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select max(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + |
| " a group by a.name"); |
| |
| Collection c = (Collection) q.execute(); |
| CacheTestHelper.iterate(c); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| c = (Collection) q.execute(); |
| Object o = c.iterator().next(); |
| assertEquals(Long.class, o.getClass()); |
| } |
| |
| public void testAggregateProjectionGroupingIsCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, |
| "select a.name, max(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + |
| " a group by a.name"); |
| |
| 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(Long.class, result[1].getClass()); |
| } |
| |
| public void testUniqueResultsAreCachedAndConsistent() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select a FROM " + |
| CacheObjectAChild1.class.getSimpleName() + |
| " a where a.age =1"); |
| |
| q.setUnique(true); |
| CacheObjectAChild1 a = (CacheObjectAChild1) q.execute(); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| CacheObjectAChild1 a2 = (CacheObjectAChild1) q.execute(); |
| assertTrue(a == a2); |
| } |
| |
| public void testMutableProjectionFieldsAreCopied() { |
| Broker broker = _factory.newBroker(); |
| Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a.date FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a where a.age=1"); |
| |
| q.setUnique(true); |
| Date d0 = (Date) q.execute(); // get it in cache |
| Date d1 = (Date) q.execute(); |
| assertNotSame(d0, d1); |
| |
| Date d2 = (Date) q.execute(); |
| assertNotSame(d1, d2); |
| } |
| |
| public void testArrayProjectionFieldsAreNotCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select a.dateArray FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| |
| try { |
| q.execute(); |
| fail("Allowed array projection query."); |
| } catch (Exception e) { |
| } |
| } |
| |
| public void testCollectionProjectionFieldsAreNotCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, "select a.stringColl FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a"); |
| |
| try { |
| q.execute(); |
| fail("Allowed array projection query."); |
| } catch (Exception e) { |
| } |
| } |
| |
| public void testExternalizedSingleValueFieldIsNotCached() { |
| Broker broker = _factory.newBroker(); |
| Query q = broker.newQuery(JPQLParser.LANG_JPQL, "select a.cls FROM " + |
| CacheObjectWithExternalizedFields.class.getSimpleName() + " a"); |
| |
| q.setUnique(true); |
| Object o = q.execute(); // get it in cache |
| // ##### assertEquals (Class.class, o); |
| CacheTestHelper.assertInCache(this, q, Boolean.FALSE); |
| } |
| |
| public void testMutatedQueryReturnsNewResults() { |
| Broker broker = _factory.newBroker(); |
| Query q = |
| broker.newQuery(JPQLParser.LANG_JPQL, |
| "select a.name, max(a.age) FROM " + |
| CacheObjectAChild1.class.getSimpleName() + |
| " a group by a.name"); |
| |
| List l = (List) q.execute(); |
| CacheTestHelper.iterate(l); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| l = (List) q.execute(); |
| Object[] result = (Object[]) l.get(0); |
| assertEquals(2, result.length); |
| assertEquals(String.class, result[0].getClass()); |
| assertEquals(Long.class, result[1].getClass()); |
| |
| // now, mutate the query and see what happens |
| q.setQuery("select max(a.age),a.name FROM " + |
| CacheObjectAChild1.class.getSimpleName() + " a group by a.name"); |
| CacheTestHelper.assertInCache(this, q, Boolean.FALSE); |
| l = (List) q.execute(); |
| result = (Object[]) l.get(0); |
| assertEquals(2, result.length); |
| assertEquals(Long.class, result[0].getClass()); |
| assertEquals(String.class, result[1].getClass()); |
| CacheTestHelper.iterate(l); |
| CacheTestHelper.assertInCache(this, q, Boolean.TRUE); |
| |
| l = (List) q.execute(); |
| result = (Object[]) l.get(0); |
| assertEquals(2, result.length); |
| assertEquals(Long.class, result[0].getClass()); |
| assertEquals(String.class, result[1].getClass()); |
| } |
| |
| public void XXXtestExternalizedContainerFieldIsExternalized() { |
| } |
| |
| public void XXXtestSerializedSingleValueFieldIsSerialized() { |
| } |
| |
| public void XXXtestSerializedContainerFieldIsSerialized() { |
| } |
| |
| public void XXXtestCustomMappedSingleValueFieldIsHandled() { |
| } |
| |
| public void XXXtestCustomMappedContainerFieldIsHandled() { |
| } |
| |
| private static int deleteAll(Broker broker, Class clazz, |
| boolean subclasses) { |
| final boolean useDeleteByQuery = false; |
| |
| if (useDeleteByQuery) { |
| org.apache.openjpa.kernel.Query query = |
| broker.newQuery(JPQLParser.LANG_JPQL, "Select a FROM " + |
| clazz.getSimpleName() + " a"); |
| query.setCandidateType(clazz, subclasses); |
| return (int) query.deleteAll(); |
| } else { |
| org.apache.openjpa.kernel.Extent extent = |
| broker.newExtent(clazz, subclasses); |
| List list = extent.list(); |
| int size = list.size(); |
| broker.deleteAll(list, null); |
| return size; |
| } |
| } |
| } |