| /* |
| * Copyright (c) 1998, 2021 Oracle and/or its affiliates. All rights reserved. |
| * |
| * This program and the accompanying materials are made available under the |
| * terms of the Eclipse Public License v. 2.0 which is available at |
| * http://www.eclipse.org/legal/epl-2.0, |
| * or the Eclipse Distribution License v. 1.0 which is available at |
| * http://www.eclipse.org/org/documents/edl-v10.php. |
| * |
| * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause |
| */ |
| |
| // Contributors: |
| // Oracle - initial API and implementation from Oracle TopLink |
| |
| |
| package org.eclipse.persistence.testing.tests.jpa.advanced; |
| |
| import java.util.ArrayList; |
| import java.util.Collection; |
| import java.util.Iterator; |
| import java.util.List; |
| import java.util.Vector; |
| |
| import junit.framework.*; |
| |
| import org.eclipse.persistence.descriptors.ClassDescriptor; |
| import org.eclipse.persistence.expressions.Expression; |
| import org.eclipse.persistence.expressions.ExpressionBuilder; |
| import org.eclipse.persistence.internal.sessions.AbstractSession; |
| import org.eclipse.persistence.internal.sessions.UnitOfWorkImpl; |
| import org.eclipse.persistence.queries.DeleteAllQuery; |
| import org.eclipse.persistence.queries.ObjectLevelReadQuery; |
| import org.eclipse.persistence.queries.ReportQuery; |
| import org.eclipse.persistence.queries.UpdateAllQuery; |
| import org.eclipse.persistence.sessions.DatabaseSession; |
| import org.eclipse.persistence.sessions.UnitOfWork; |
| import org.eclipse.persistence.testing.framework.JoinedAttributeTestHelper; |
| import org.eclipse.persistence.testing.framework.junit.JUnitTestCase; |
| import org.eclipse.persistence.testing.models.jpa.advanced.*; |
| import org.eclipse.persistence.queries.ReadAllQuery; |
| |
| public class JoinedAttributeAdvancedJunitTest extends JUnitTestCase { |
| |
| static protected Class[] classes = {Employee.class, Address.class, PhoneNumber.class, Project.class}; |
| static protected Vector[] objectVectors = {null, null, null, null}; |
| |
| static protected EmployeePopulator populator = new EmployeePopulator(); |
| protected DatabaseSession dbSession; |
| |
| public JoinedAttributeAdvancedJunitTest() { |
| super(); |
| } |
| |
| public JoinedAttributeAdvancedJunitTest(String name) { |
| super(name); |
| } |
| |
| // the session is cached to avoid extra dealing with SessionManager - |
| // without session caching each test caused at least 5 ClientSessins being acquired / released. |
| protected DatabaseSession getDbSession() { |
| if(dbSession == null) { |
| dbSession = getServerSession(); |
| } |
| return dbSession; |
| } |
| |
| protected UnitOfWork acquireUnitOfWork() { |
| return getDbSession().acquireUnitOfWork(); |
| } |
| |
| protected void clear() { |
| UnitOfWork uow = acquireUnitOfWork(); |
| |
| // use alternate way for Symfoware as it doesn't support UpdateAll/DeleteAll on multi-table objects (see rfe 298193) |
| if (!(JUnitTestCase.getServerSession()).getPlatform().isSymfoware()) { |
| UpdateAllQuery updateEmployees = new UpdateAllQuery(Employee.class); |
| updateEmployees.addUpdate("manager", null); |
| updateEmployees.addUpdate("address", null); |
| uow.executeQuery(updateEmployees); |
| |
| uow.executeQuery(new DeleteAllQuery(Employee.class)); |
| } else { |
| Iterator<Employee> emps = uow.readAllObjects(Employee.class).iterator(); |
| while (emps.hasNext()){ |
| Employee emp = emps.next(); |
| emp.setManager(null); |
| emp.setAddress((String)null); |
| uow.deleteObject(emp); |
| }; |
| } |
| |
| UpdateAllQuery updateProjects = new UpdateAllQuery(Project.class); |
| updateProjects.addUpdate("teamLeader", null); |
| uow.executeQuery(updateProjects); |
| |
| uow.executeQuery(new DeleteAllQuery(PhoneNumber.class)); |
| uow.executeQuery(new DeleteAllQuery(Address.class)); |
| uow.executeQuery(new DeleteAllQuery(Project.class)); |
| |
| uow.commit(); |
| dbSessionClearCache(); |
| } |
| |
| protected void populate() { |
| populator.buildExamples(); |
| populator.persistExample(getDbSession()); |
| dbSessionClearCache(); |
| for(int i=0; i < classes.length; i++) { |
| objectVectors[i] = getDbSession().readAllObjects(classes[i]); |
| } |
| } |
| |
| public static Test suite() { |
| TestSuite suite = (TestSuite) suiteSpring(); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectOuterJoinTeamMembersOuterJoinAddress")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectOuterJoinTeamMembersOuterJoinAddress_NoBase")); |
| return suite; |
| } |
| |
| public static Test suiteSpring() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("JoinedAttributeAdvancedJunitTest"); |
| |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testSetup")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectJoinTeamMembers")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectJoinTeamMembersJoinAddress")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectJoinTeamMembersJoinAddress_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectOuterJoinTeamMembersJoinAddress")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectOuterJoinTeamMembersJoinAddress_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectJoinTeamMembersOuterJoinAddress")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectJoinTeamMembersOuterJoinAddress_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProblemReporterProjectJoinTeamMembersJoinAddress")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProblemReporterProjectJoinTeamMembersJoinAddress_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeJoinProjects")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeJoinProjectsOnUOW")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeJoinManagerAddressOuterJoinManagerAddress")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployeeJoinManagerAddressOuterJoinManagerAddress_NoBase")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testTwoUnrelatedResultWithOneToManyJoins")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testMultipleUnrelatedResultWithOneToManyJoins")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testTwoUnrelatedResultWithOneToOneJoins")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem")); |
| // test for Bug 305713 - OuterJoinExpressionHolder order can be incorrect during ansi joins |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testOuterJoinSortingWithOneToOneJoins")); |
| // test for Bug 305713 - OuterJoinExpressionHolder order can be incorrect during ansi joins |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testFetchOuterJoinSubClass")); |
| |
| // tests for Bug 274436: Custom QueryKeys fail to auto join. |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testAddressQK")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testManagedProjects")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testManagedLargeProjects")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testProjectsQK")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testLargeProjects")); |
| // suite.addTest(new JoinedAttributeAdvancedJunitTest("testResponsibilitiesQK")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testOwner")); |
| suite.addTest(new JoinedAttributeAdvancedJunitTest("testEmployees")); |
| |
| return suite; |
| } |
| |
| /** |
| * The setup is done as a test, both to record its failure, and to allow execution in the server. |
| */ |
| public void testSetup() { |
| clearCache(); |
| new AdvancedTableCreator().replaceTables(JUnitTestCase.getServerSession()); |
| populate(); |
| clearCache(); |
| } |
| |
| @Override |
| public void tearDown() { |
| dbSessionClearCache(); |
| dbSession = null; |
| super.tearDown(); |
| } |
| |
| public void testProjectJoinTeamMembers() { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| query.addJoinedAttribute(query.getExpressionBuilder().anyOf("teamMembers")); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull() { |
| internalProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull(false); |
| } |
| public void testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull_NoBase() { |
| internalProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull(true); |
| } |
| protected void internalProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| Expression teamLeader = query.getExpressionBuilder().get("teamLeader"); |
| query.setSelectionCriteria(teamLeader.notNull()); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| if(!noBase) { |
| query.addJoinedAttribute(teamLeader); |
| } |
| Expression teamLeaderAddress = teamLeader.get("address"); |
| query.addJoinedAttribute(teamLeaderAddress); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testProjectJoinTeamMembersJoinAddress() { |
| internalProjectJoinTeamMembersJoinAddress(false); |
| } |
| public void testProjectJoinTeamMembersJoinAddress_NoBase() { |
| internalProjectJoinTeamMembersJoinAddress(true); |
| } |
| protected void internalProjectJoinTeamMembersJoinAddress(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| Expression teamMembers = query.getExpressionBuilder().anyOf("teamMembers"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersAddress = teamMembers.get("address"); |
| query.addJoinedAttribute(teamMembersAddress); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testProjectOuterJoinTeamMembersJoinAddress() { |
| internalProjectOuterJoinTeamMembersJoinAddress(false); |
| } |
| public void testProjectOuterJoinTeamMembersJoinAddress_NoBase() { |
| internalProjectOuterJoinTeamMembersJoinAddress(true); |
| } |
| protected void internalProjectOuterJoinTeamMembersJoinAddress(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| Expression teamMembers = query.getExpressionBuilder().anyOfAllowingNone("teamMembers"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersAddress = teamMembers.get("address"); |
| query.addJoinedAttribute(teamMembersAddress); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testProjectOuterJoinTeamMembersOuterJoinAddress() { |
| internalProjectOuterJoinTeamMembersOuterJoinAddress(false); |
| } |
| public void testProjectOuterJoinTeamMembersOuterJoinAddress_NoBase() { |
| internalProjectOuterJoinTeamMembersOuterJoinAddress(true); |
| } |
| protected void internalProjectOuterJoinTeamMembersOuterJoinAddress(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| Expression teamMembers = query.getExpressionBuilder().anyOfAllowingNone("teamMembers"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersAddress = teamMembers.getAllowingNull("address"); |
| query.addJoinedAttribute(teamMembersAddress); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testProjectJoinTeamMembersOuterJoinAddress() { |
| internalProjectJoinTeamMembersOuterJoinAddress(false); |
| } |
| public void testProjectJoinTeamMembersOuterJoinAddress_NoBase() { |
| internalProjectJoinTeamMembersOuterJoinAddress(true); |
| } |
| protected void internalProjectJoinTeamMembersOuterJoinAddress(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| Expression teamMembers = query.getExpressionBuilder().anyOf("teamMembers"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersAddress = teamMembers.getAllowingNull("address"); |
| query.addJoinedAttribute(teamMembersAddress); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testProblemReporterProjectJoinTeamMembersJoinAddress() { |
| internalProblemReporterProjectJoinTeamMembersJoinAddress(false); |
| } |
| public void testProblemReporterProjectJoinTeamMembersJoinAddress_NoBase() { |
| internalProblemReporterProjectJoinTeamMembersJoinAddress(true); |
| } |
| protected void internalProblemReporterProjectJoinTeamMembersJoinAddress(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| query.setSelectionCriteria(query.getExpressionBuilder().get("name").equal("Problem Reporter")); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| Expression teamMembers = query.getExpressionBuilder().anyOf("teamMembers"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersAddress = teamMembers.get("address"); |
| query.addJoinedAttribute(teamMembersAddress); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testEmployeeJoinProjects() { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Employee.class); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| query.addJoinedAttribute(query.getExpressionBuilder().anyOf("projects")); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| //bug 6130550: test fetch join works in a uow as well as the session. |
| public void testEmployeeJoinProjectsOnUOW() { |
| if (usesSOP()) { |
| // SOP always instantiates all the indirection inside sopObject in session cache, but not in uow clone, |
| // therefore the test would fail due to lots of indirections been instantiated in controledResult, but not in result. |
| // Note that even if queryWithJoins is set to not use SOP when executed on the session, still there would be some extra instantiations, like: |
| // PK = 17271: Employee.projectsPK = 19069: LargeProject.teamLeader.projectsPK = 19048: LargeProject.teamLeader.responsibilities |
| // That's because even shouldUseSOP==false flag is passed to the fetch join query (for Projects) |
| // cascading farther, the EAGER teamMember mapping's selectionQuery uses SOP (that's the default setting). |
| // To fix that (if it's really a problem), Eclipselink could either always cascade shouldUseSOP flag, |
| // or alternatively a new shouldCascadeSOP flag may be defined on ObjectLevelReadQuery. |
| return; |
| } |
| ReadAllQuery controlQuery = new ReadAllQuery(); |
| controlQuery.setReferenceClass(Employee.class); |
| |
| ReadAllQuery queryWithJoins = (ReadAllQuery)controlQuery.clone(); |
| queryWithJoins.addJoinedAttribute(queryWithJoins.getExpressionBuilder().anyOf("projects")); |
| |
| UnitOfWork uow = acquireUnitOfWork(); |
| //loads objects into cache without using joins |
| uow.executeQuery(controlQuery); |
| uow.commit(); |
| ((UnitOfWorkImpl)uow).setShouldCascadeCloneToJoinedRelationship(true); |
| Collection results = (Collection)uow.executeQuery(queryWithJoins); |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| if (usesSOP()) { |
| queryWithJoins.setShouldUseSerializedObjectPolicy(false); |
| } |
| Collection controlledResults = (Collection)getDbSession().executeQuery(queryWithJoins); |
| String errorMsg = JoinedAttributeTestHelper.compareCollections(controlledResults, results, controlQuery.getDescriptor(), (AbstractSession)getDbSession()); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull() { |
| internalEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull(false); |
| } |
| |
| public void testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull_NoBase() { |
| internalEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull(true); |
| } |
| protected void internalEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Employee.class); |
| query.setSelectionCriteria(query.getExpressionBuilder().get("manager").isNull()); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| Expression projects = query.getExpressionBuilder().anyOf("projects"); |
| if(!noBase) { |
| query.addJoinedAttribute(projects); |
| } |
| Expression teamLeader = projects.get("teamLeader"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamLeader); |
| } |
| Expression teamLeaderAddress = teamLeader.get("address"); |
| query.addJoinedAttribute(teamLeaderAddress); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName() { |
| internalProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName(false); |
| } |
| public void testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName_NoBase() { |
| internalProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName(true); |
| } |
| protected void internalProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Project.class); |
| query.setSelectionCriteria(query.getExpressionBuilder().get("name").equal("Problem Reporting System"). |
| or(query.getExpressionBuilder().get("name").equal("Bleep Blob"))); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| Expression teamLeader = query.getExpressionBuilder().getAllowingNull("teamLeader"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamLeader); |
| } |
| Expression teamLeaderAddress = teamLeader.getAllowingNull("address"); |
| query.addJoinedAttribute(teamLeaderAddress); |
| Expression teamMembers = query.getExpressionBuilder().anyOfAllowingNone("teamMembers"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersAddress = teamMembers.getAllowingNull("address"); |
| query.addJoinedAttribute(teamMembersAddress); |
| Expression teamMembersPhones = teamMembers.anyOfAllowingNone("phoneNumbers"); |
| query.addJoinedAttribute(teamMembersPhones); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones() { |
| internalEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones(false); |
| } |
| public void testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones_NoBase() { |
| internalEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones(true); |
| } |
| protected void internalEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Employee.class); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| // Note that without the following two lines address and phones are not read not for all Employees: |
| // once an Employee is built (without Address and Phones) |
| // it's not going to be rebuilt (get Address and Phones) when it's |
| // up again either as a teamLeader or teamMember. |
| // That means that only Employees read first indirectly (either as teamLeaders or |
| // teamMembers would've got Phones and Addresses). |
| query.addJoinedAttribute(query.getExpressionBuilder().getAllowingNull("address")); |
| query.addJoinedAttribute(query.getExpressionBuilder().anyOfAllowingNone("phoneNumbers")); |
| |
| Expression projects = query.getExpressionBuilder().anyOfAllowingNone("projects"); |
| if(!noBase) { |
| query.addJoinedAttribute(projects); |
| } |
| Expression teamLeader = projects.getAllowingNull("teamLeader"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamLeader); |
| } |
| Expression teamLeaderAddress = teamLeader.getAllowingNull("address"); |
| query.addJoinedAttribute(teamLeaderAddress); |
| Expression teamMembers = projects.anyOfAllowingNone("teamMembers"); |
| if(!noBase) { |
| query.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersPhones = teamMembers.anyOfAllowingNone("phoneNumbers"); |
| query.addJoinedAttribute(teamMembersPhones); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| //bug 6130550: test fetch join works in a uow as well as the session. |
| public void testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW() { |
| internalEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW(false); |
| } |
| public void testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW_NoBase() { |
| internalEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW(true); |
| } |
| protected void internalEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW(boolean noBase) { |
| ReadAllQuery controlQuery = new ReadAllQuery(); |
| controlQuery.setReferenceClass(Employee.class); |
| |
| ReadAllQuery queryWithJoins = (ReadAllQuery)controlQuery.clone(); |
| |
| // Note that without the following two lines address and phones are not read not for all Employees: |
| // once an Employee is built (without Address and Phones) |
| // it's not going to be rebuilt (get Address and Phones) when it's |
| // up again either as a teamLeader or teamMember. |
| // That means that only Employees read first indirectly (either as teamLeaders or |
| // teamMembers would've got Phones and Addresses). |
| queryWithJoins.addJoinedAttribute(queryWithJoins.getExpressionBuilder().getAllowingNull("address")); |
| queryWithJoins.addJoinedAttribute(queryWithJoins.getExpressionBuilder().anyOfAllowingNone("phoneNumbers")); |
| |
| Expression projects = queryWithJoins.getExpressionBuilder().anyOfAllowingNone("projects"); |
| if(!noBase) { |
| queryWithJoins.addJoinedAttribute(projects); |
| } |
| Expression teamLeader = projects.getAllowingNull("teamLeader"); |
| if(!noBase) { |
| queryWithJoins.addJoinedAttribute(teamLeader); |
| } |
| Expression teamLeaderAddress = teamLeader.getAllowingNull("address"); |
| queryWithJoins.addJoinedAttribute(teamLeaderAddress); |
| Expression teamMembers = projects.anyOfAllowingNone("teamMembers"); |
| if(!noBase) { |
| queryWithJoins.addJoinedAttribute(teamMembers); |
| } |
| Expression teamMembersPhones = teamMembers.anyOfAllowingNone("phoneNumbers"); |
| queryWithJoins.addJoinedAttribute(teamMembersPhones); |
| |
| UnitOfWork uow = acquireUnitOfWork(); |
| //loads objects into cache without using joins |
| uow.commit(); |
| uow.executeQuery(controlQuery); |
| ((UnitOfWorkImpl)uow).setShouldCascadeCloneToJoinedRelationship(true); |
| Collection results = (Collection)uow.executeQuery(queryWithJoins); |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| Collection controlledResults = (Collection)JoinedAttributeTestHelper.getControlResultsFromControlQuery(controlQuery, queryWithJoins, (AbstractSession)uow); |
| |
| String errorMsg = JoinedAttributeTestHelper.compareCollections(controlledResults, results, controlQuery.getDescriptor(), (AbstractSession)getDbSession()); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testEmployeeJoinManagerAddressOuterJoinManagerAddress() { |
| internalEmployeeJoinManagerAddressOuterJoinManagerAddress(false); |
| } |
| public void testEmployeeJoinManagerAddressOuterJoinManagerAddress_NoBase() { |
| internalEmployeeJoinManagerAddressOuterJoinManagerAddress(true); |
| } |
| protected void internalEmployeeJoinManagerAddressOuterJoinManagerAddress(boolean noBase) { |
| ReadAllQuery query = new ReadAllQuery(); |
| query.setReferenceClass(Employee.class); |
| query.setSelectionCriteria(query.getExpressionBuilder().get("lastName").equal("Way"). |
| or(query.getExpressionBuilder().get("lastName").equal("Jones"))); |
| |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| Expression manager = query.getExpressionBuilder().get("manager"); |
| if(!noBase) { |
| query.addJoinedAttribute(manager); |
| } |
| query.addJoinedAttribute(manager.get("address")); |
| Expression managersManager = manager.getAllowingNull("manager"); |
| if(!noBase) { |
| query.addJoinedAttribute(managersManager); |
| } |
| query.addJoinedAttribute(managersManager.get("address")); |
| |
| String errorMsg = executeQueriesAndCompareResults(controlQuery, query); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testTwoUnrelatedResultWithOneToManyJoins() { |
| if (getServerSession().getPlatform().isSymfoware()) { |
| getServerSession().logMessage("Test testTwoUnrelatedResultWithOneToManyJoins skipped for this platform, " |
| + "Symfoware doesn't support UpdateAll/DeleteAll on multi-table objects (see rfe 298193)."); |
| return; |
| } |
| ReadAllQuery raq = new ReadAllQuery(Employee.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().get("lastName").equal("Way").or(raq.getExpressionBuilder().get("lastName").equal("Jones"))); |
| Employee emp = (Employee)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| emp.getPhoneNumbers(); |
| for (Iterator<PhoneNumber> iterator = emp.getPhoneNumbers().iterator(); iterator.hasNext();){ |
| iterator.next().getOwner(); |
| } |
| |
| raq = new ReadAllQuery(Address.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().get("city").like("%ttawa%")); |
| Address addr = (Address)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| addr.getEmployees(); |
| for (Iterator<Employee> iterator = addr.getEmployees().iterator(); iterator.hasNext();){ |
| iterator.next().getAddress(); |
| } |
| |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| |
| ReportQuery query = new ReportQuery(); |
| query.setShouldReturnWithoutReportQueryResult(true); |
| query.setReferenceClass(Employee.class); |
| |
| ExpressionBuilder eb = new ExpressionBuilder(Address.class); |
| query.setSelectionCriteria(query.getExpressionBuilder().get("id").equal(emp.getId()).and(eb.get("ID").equal(addr.getID()))); |
| |
| List list = new ArrayList(); |
| list.add(query.getExpressionBuilder().anyOf("phoneNumbers")); |
| query.addItem("employee", query.getExpressionBuilder(), list); |
| |
| list = new ArrayList(); |
| list.add(eb.anyOf("employees")); |
| query.addItem("address", eb, list); |
| |
| Vector result = (Vector)getDbSession().executeQuery(query); |
| |
| DeleteAllQuery deleteAll = new DeleteAllQuery(PhoneNumber.class); |
| deleteAll.setSelectionCriteria(deleteAll.getExpressionBuilder().get("owner").get("id").equal(emp.getId())); |
| UnitOfWork uow = getDbSession().acquireUnitOfWork(); |
| uow.executeQuery(deleteAll); |
| |
| UpdateAllQuery updall = new UpdateAllQuery(Employee.class); |
| updall.addUpdate("address", null); |
| updall.setSelectionCriteria(updall.getExpressionBuilder().get("address").get("ID").equal(addr.getID())); |
| uow.executeQuery(updall); |
| |
| uow.commit(); |
| |
| try { |
| Employee emp2 = (Employee)((Object[])result.firstElement())[0]; |
| Address addr2 = (Address)((Object[])result.firstElement())[1]; |
| |
| assertTrue("PhoneNumbers were not joined correctly, emp.getPhoneNumbers().size = " + emp.getPhoneNumbers().size() + " emp2.getPhoneNumbers().size = " + emp2.getPhoneNumbers().size(), (emp.getPhoneNumbers().size() == emp2.getPhoneNumbers().size())); |
| assertTrue("Employees were not joined correctly, addr.employees.size = " + addr.getEmployees().size() + "addr2.employees.size = " + addr2.getEmployees().size(), (addr.getEmployees().size() == addr2.getEmployees().size())); |
| } finally { |
| testSetup(); |
| } |
| |
| } |
| |
| public void testMultipleUnrelatedResultWithOneToManyJoins() { |
| if (getServerSession().getPlatform().isSymfoware()) { |
| getServerSession().logMessage("Test testMultipleUnrelatedResultWithOneToManyJoins skipped for this platform, " |
| + "Symfoware doesn't support UpdateAll/DeleteAll on multi-table objects (see rfe 298193)."); |
| return; |
| } |
| ReadAllQuery raq = new ReadAllQuery(Employee.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().notEmpty("phoneNumbers")); |
| Employee emp = (Employee)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| emp.getPhoneNumbers(); |
| for (Iterator<PhoneNumber> iterator = emp.getPhoneNumbers().iterator(); iterator.hasNext();){ |
| iterator.next().getOwner(); |
| } |
| |
| raq = new ReadAllQuery(Address.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().get("city").like("%ttawa%")); |
| Address addr = (Address)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| addr.getEmployees(); |
| for (Iterator<Employee> iterator = addr.getEmployees().iterator(); iterator.hasNext();){ |
| Employee addrEmp = iterator.next(); |
| addrEmp.getAddress(); |
| addrEmp.getPhoneNumbers().size(); // as the report query will join in all phones to all emps, make sure we can compare. |
| } |
| |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| |
| ReportQuery query = new ReportQuery(); |
| query.setShouldReturnWithoutReportQueryResult(true); |
| query.setReferenceClass(Address.class); |
| |
| ExpressionBuilder eb = new ExpressionBuilder(Employee.class); |
| |
| List list = new ArrayList(); |
| list.add(eb.anyOf("phoneNumbers")); |
| query.addItem("employee", eb, list); |
| |
| list = new ArrayList(); |
| list.add(query.getExpressionBuilder().anyOf("employees")); |
| query.addItem("address", query.getExpressionBuilder(), list); |
| |
| query.setSelectionCriteria(query.getExpressionBuilder().get("ID").equal(addr.getID())); |
| |
| |
| Vector result = (Vector)getDbSession().executeQuery(query); |
| |
| DeleteAllQuery deleteAll = new DeleteAllQuery(PhoneNumber.class); |
| deleteAll.setSelectionCriteria(deleteAll.getExpressionBuilder().get("owner").get("id").equal(emp.getId())); |
| UnitOfWork uow = getDbSession().acquireUnitOfWork(); |
| uow.executeQuery(deleteAll); |
| |
| UpdateAllQuery updall = new UpdateAllQuery(Employee.class); |
| updall.addUpdate("address", null); |
| updall.setSelectionCriteria(updall.getExpressionBuilder().get("address").get("ID").equal(addr.getID())); |
| uow.executeQuery(updall); |
| |
| uow.commit(); |
| |
| try { |
| Employee emp2 = null; |
| Address addr2 = null; |
| for (Iterator iterator = result.iterator(); iterator.hasNext();){ |
| Object [] items = (Object[])iterator.next(); |
| emp2 = (Employee)items[0]; |
| if (emp2.getId().equals(emp.getId())){ |
| addr2 = (Address)items[1]; |
| break; |
| } |
| } |
| assertTrue("PhoneNumbers were not joined correctly, emp.getPhoneNumbers().size = " + emp.getPhoneNumbers().size() + " emp2.getPhoneNumbers().size = " + emp2.getPhoneNumbers().size(), (emp.getPhoneNumbers().size() == emp2.getPhoneNumbers().size())); |
| assertTrue("Employees were not joined correctly, addr.employees.size = " + addr.getEmployees().size() + "addr2.employees.size = " + addr2.getEmployees().size(), (addr.getEmployees().size() == addr2.getEmployees().size())); |
| } finally { |
| testSetup(); |
| } |
| |
| } |
| |
| public void testTwoUnrelatedResultWithOneToOneJoins() { |
| if (getServerSession().getPlatform().isSymfoware()) { |
| getServerSession().logMessage("Test testTwoUnrelatedResultWithOneToOneJoins skipped for this platform, " |
| + "Symfoware doesn't support UpdateAll/DeleteAll on multi-table objects (see rfe 298193)."); |
| return; |
| } |
| ReadAllQuery raq = new ReadAllQuery(Employee.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().get("lastName").equal("Way").or(raq.getExpressionBuilder().get("lastName").equal("Jones"))); |
| Employee emp = (Employee)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| emp.getAddress(); |
| |
| raq = new ReadAllQuery(Address.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().get("city").like("%ttawa%")); |
| Address addr = (Address)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| addr.getEmployees(); |
| for (Iterator<Employee> iterator = addr.getEmployees().iterator(); iterator.hasNext();){ |
| iterator.next().getAddress(); |
| } |
| |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| |
| ReportQuery query = new ReportQuery(); |
| query.setShouldReturnWithoutReportQueryResult(true); |
| query.setReferenceClass(Employee.class); |
| |
| ExpressionBuilder eb = new ExpressionBuilder(Address.class); |
| query.setSelectionCriteria(query.getExpressionBuilder().get("id").equal(emp.getId()).and(eb.get("ID").equal(addr.getID()))); |
| |
| List list = new ArrayList(); |
| list.add(query.getExpressionBuilder().get("address")); |
| query.addItem("employee", query.getExpressionBuilder(), list); |
| |
| list = new ArrayList(); |
| list.add(eb.anyOf("employees")); |
| query.addItem("address", eb, list); |
| |
| List result = (List)getDbSession().executeQuery(query); |
| |
| UpdateAllQuery updall = new UpdateAllQuery(Employee.class); |
| updall.addUpdate("address", null); |
| updall.setSelectionCriteria(updall.getExpressionBuilder().get("id").equal(emp.getId())); |
| UnitOfWork uow = getDbSession().acquireUnitOfWork(); |
| uow.executeQuery(updall); |
| |
| updall = new UpdateAllQuery(Employee.class); |
| updall.addUpdate("address", null); |
| updall.setSelectionCriteria(updall.getExpressionBuilder().get("address").get("ID").equal(addr.getID())); |
| uow.executeQuery(updall); |
| |
| uow.commit(); |
| |
| try { |
| Employee emp2 = (Employee)((Object[])result.get(0))[0]; |
| Address addr2 = (Address)((Object[])result.get(0))[1]; |
| |
| assertTrue("Address were not joined correctly, emp.getAddress() = null", (emp2.getAddress() != null)); |
| assertTrue("Employees were not joined correctly, addr.employees.size = " + addr.getEmployees().size() + "addr2.employees.size = " + addr2.getEmployees().size(), (addr.getEmployees().size() == addr2.getEmployees().size())); |
| |
| } finally { |
| testSetup(); |
| } |
| } |
| |
| // Bug 305713 - OuterJoinExpressionHolder linearization order can be incorrect during ansi joins |
| public void testOuterJoinSortingWithOneToOneJoins() { |
| ReadAllQuery controlQuery = new ReadAllQuery(Employee.class); |
| ExpressionBuilder controlBuilder = controlQuery.getExpressionBuilder(); |
| Expression dept = controlBuilder.get("department"); |
| controlQuery.setSelectionCriteria(dept.notNull().and(dept.get("departmentHead").isNull())); |
| List<Employee> controlResults = (List)getDbSession().executeQuery(controlQuery); |
| |
| assertNotNull("Control query results should be non-null", controlResults); |
| assertFalse("Control query results should be non-empty", controlResults.isEmpty()); |
| |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ExpressionBuilder builder = query.getExpressionBuilder(); |
| |
| Expression expression = builder.get("department"); |
| query.addJoinedAttribute(expression); |
| |
| expression = expression.getAllowingNull("departmentHead"); |
| query.addJoinedAttribute(expression); |
| |
| expression = expression.getAllowingNull("manager"); |
| query.addJoinedAttribute(expression); |
| |
| expression = expression.getAllowingNull("address"); |
| query.addJoinedAttribute(expression); |
| |
| List<Employee> actualResults = (List)getDbSession().executeQuery(query); |
| |
| assertNotNull("Query results should be non-null.", actualResults); |
| assertFalse("Query results should be non-empty.", actualResults.isEmpty()); |
| |
| assertEquals("Query results should be the same.", controlResults.size(), actualResults.size()); |
| |
| for (Employee emp : controlResults) { |
| if (!actualResults.contains(emp)) { |
| fail("Actual results do not contain employee with id " + emp.getId()); |
| } |
| } |
| } |
| |
| // Bug 305713 - OuterJoinExpressionHolder linearization order can be incorrect during ansi joins |
| // Before the fix generated wrong sql: |
| // SELECT ... FROM CMP3_EMPLOYEE t1 |
| // LEFT OUTER JOIN CMP3_ADDRESS t0 ON (t0.ADDRESS_ID = t1.ADDR_ID) |
| // LEFT OUTER JOIN (CMP3_PROJECT t6 JOIN CMP3_HPROJECT t8 ON (t8.PROJ_ID = t6.PROJ_ID)) ON (t6.PROJ_ID = t1.HUGE_PROJ_ID) |
| // LEFT OUTER JOIN CMP3_DEPT t11 ON (t11.ID = t1.DEPT_ID), |
| // CMP3_EMPLOYEE t3 |
| // LEFT OUTER JOIN CMP3_ADDRESS t5 ON (t5.ADDRESS_ID = t3.ADDR_ID) |
| // LEFT OUTER JOIN (CMP3_EMPLOYEE t9 JOIN CMP3_SALARY t10 ON (t10.EMP_ID = t9.EMP_ID)) ON (t9.EMP_ID = t8.EVANGELIST_ID), |
| // CMP3_LPROJECT t7, CMP3_SALARY t4, CMP3_SALARY t2 |
| // WHERE ((t2.EMP_ID = t1.EMP_ID) AND ((t3.EMP_ID = t1.MANAGER_EMP_ID) AND (t4.EMP_ID = t3.EMP_ID))) |
| // that failed with: java.sql.SQLSyntaxErrorException: ORA-00904: "T8"."EVANGELIST_ID": invalid identifier. |
| // |
| // After the fix generates correct sql (the only difference is order: LEFT OUTER JOIN on t8.EVANGELIST_ID has moved up): |
| // SELECT ... FROM CMP3_EMPLOYEE t1 |
| // LEFT OUTER JOIN CMP3_ADDRESS t0 ON (t0.ADDRESS_ID = t1.ADDR_ID) |
| // LEFT OUTER JOIN (CMP3_PROJECT t6 JOIN CMP3_HPROJECT t8 ON (t8.PROJ_ID = t6.PROJ_ID)) ON (t6.PROJ_ID = t1.HUGE_PROJ_ID) |
| // LEFT OUTER JOIN (CMP3_EMPLOYEE t9 JOIN CMP3_SALARY t10 ON (t10.EMP_ID = t9.EMP_ID)) ON (t9.EMP_ID = t8.EVANGELIST_ID) |
| // LEFT OUTER JOIN CMP3_DEPT t11 ON (t11.ID = t1.DEPT_ID), |
| // CMP3_EMPLOYEE t3 |
| // LEFT OUTER JOIN CMP3_ADDRESS t5 ON (t5.ADDRESS_ID = t3.ADDR_ID), |
| // CMP3_LPROJECT t7, CMP3_SALARY t4, CMP3_SALARY t2 |
| // WHERE ((t2.EMP_ID = t1.EMP_ID) AND ((t3.EMP_ID = t1.MANAGER_EMP_ID) AND (t4.EMP_ID = t3.EMP_ID))) |
| public void testFetchOuterJoinSubClass() { |
| // TODO: currently the test verifies that the query doesn't blow up. |
| // Add control query so that the results could be verified. |
| // Unfortunately executeQueriesAndCompareResults method doesn't work correctly when outer joins mixed with inner joins |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ReadAllQuery controlQuery = (ReadAllQuery)query.clone(); |
| |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| Expression expression = eb.getAllowingNull("address"); |
| query.addJoinedAttribute(expression); |
| |
| expression = eb.get("manager"); |
| query.addJoinedAttribute(expression); |
| expression = expression.getAllowingNull("address"); |
| query.addJoinedAttribute(expression); |
| |
| expression = eb.getAllowingNull("hugeProject"); |
| query.addJoinedAttribute(expression); |
| expression = expression.getAllowingNull("evangelist"); |
| query.addJoinedAttribute(expression); |
| |
| List results = (List)getDbSession().executeQuery(query); |
| System.out.println(); |
| } |
| |
| public void testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem() { |
| if (getServerSession().getPlatform().isSymfoware()) { |
| getServerSession().logMessage("Test testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem skipped for this platform, " |
| + "Symfoware doesn't support UpdateAll/DeleteAll on multi-table objects (see rfe 298193)."); |
| return; |
| } |
| ReadAllQuery raq = new ReadAllQuery(Employee.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().get("lastName").equal("Way").or(raq.getExpressionBuilder().get("lastName").equal("Jones"))); |
| Employee emp = (Employee)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| emp.getAddress(); |
| |
| raq = new ReadAllQuery(Address.class); |
| raq.setSelectionCriteria(raq.getExpressionBuilder().get("city").like("%ttawa%")); |
| Address addr = (Address)((Vector)getDbSession().executeQuery(raq)).firstElement(); |
| addr.getEmployees(); |
| for (Iterator<Employee> iterator = addr.getEmployees().iterator(); iterator.hasNext();){ |
| iterator.next().getAddress(); |
| } |
| |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| |
| ReportQuery query = new ReportQuery(); |
| query.setShouldReturnWithoutReportQueryResult(true); |
| query.setReferenceClass(Employee.class); |
| |
| ExpressionBuilder eb = new ExpressionBuilder(Address.class); |
| query.setSelectionCriteria(query.getExpressionBuilder().get("id").equal(emp.getId()).and(eb.get("ID").equal(addr.getID()))); |
| |
| List list = new ArrayList(); |
| list.add(query.getExpressionBuilder().get("address")); |
| query.addItem("employee", query.getExpressionBuilder(), list); |
| query.addItem("employee_name", query.getExpressionBuilder().get("firstName")); |
| |
| list = new ArrayList(); |
| list.add(eb.anyOf("employees")); |
| query.addItem("address", eb, list); |
| |
| List result = (List)getDbSession().executeQuery(query); |
| |
| UpdateAllQuery updall = new UpdateAllQuery(Employee.class); |
| updall.addUpdate("address", null); |
| updall.setSelectionCriteria(updall.getExpressionBuilder().get("id").equal(emp.getId())); |
| UnitOfWork uow = getDbSession().acquireUnitOfWork(); |
| uow.executeQuery(updall); |
| |
| updall = new UpdateAllQuery(Employee.class); |
| updall.addUpdate("address", null); |
| updall.setSelectionCriteria(updall.getExpressionBuilder().get("address").get("ID").equal(addr.getID())); |
| uow.executeQuery(updall); |
| |
| uow.commit(); |
| |
| try { |
| Employee emp2 = (Employee)((Object[])result.get(0))[0]; |
| Address addr2 = (Address)((Object[])result.get(0))[2]; |
| assertTrue("Address were not joined correctly, emp.getAddress() = null", (emp2.getAddress() != null)); |
| assertTrue("Employees were not joined correctly, addr.employees.size = " + addr.getEmployees().size() + "addr2.employees.size = " + addr2.getEmployees().size(), (addr.getEmployees().size() == addr2.getEmployees().size())); |
| if (!emp2.getFirstName().equals(((Object[])result.get(0))[1])) { |
| fail("Failed to return employee name as an separate item"); |
| } |
| |
| } finally { |
| testSetup(); |
| } |
| } |
| |
| public void testAddressQK() { |
| // control query - it's results should be the same as results of the tested query |
| ReadAllQuery controlQuery = new ReadAllQuery(Employee.class); |
| ExpressionBuilder controlEb = controlQuery.getExpressionBuilder(); |
| controlQuery.setSelectionCriteria(controlEb.getAllowingNull("address").get("city").like("O%")); |
| List<Employee> controlEmps = (List)getDbSession().executeQuery(controlQuery); |
| |
| // choose example that actually selects something |
| if(controlEmps.isEmpty()) { |
| fail("Test setup problem: control query result is empty. Choose selection criteria such that something is actually selected"); |
| } |
| |
| // clear cache |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| |
| // execute the tested query |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.getAllowingNull("addressQK").get("city").like("O%")); |
| List<Employee> emps = (List)getDbSession().executeQuery(query); |
| |
| // compare results with control query |
| String errorMsg = JoinedAttributeTestHelper.compareCollections(controlEmps, emps, getDbSession().getDescriptor(Employee.class), (AbstractSession)getDbSession()); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testManagedProjects() { |
| // TODO: currently the test verifies that the query doesn't blow up. |
| // Add control query so that the results could be verified. |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.anyOfAllowingNone("managedProjects").get("name").containsSubstring("Enterprise")); |
| List<Employee> emps = (List)getDbSession().executeQuery(query); |
| |
| // choose example that actually selects something |
| if(emps.isEmpty()) { |
| fail(); |
| } |
| } |
| |
| public void testManagedLargeProjects() { |
| // TODO: currently the test verifies that the query doesn't blow up. |
| // Add control query so that the results could be verified. |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.anyOfAllowingNone("managedLargeProjects").get("name").containsSubstring("Enterprise")); |
| List<Employee> emps = (List)getDbSession().executeQuery(query); |
| |
| // choose example that actually selects something |
| if(emps.isEmpty()) { |
| fail(); |
| } |
| } |
| |
| public void testProjectsQK() { |
| // control query - it's results should be the same as results of the tested query |
| ReadAllQuery controlQuery = new ReadAllQuery(Employee.class); |
| ExpressionBuilder controlEb = controlQuery.getExpressionBuilder(); |
| controlQuery.setSelectionCriteria(controlEb.anyOfAllowingNone("projects").get("name").containsSubstring("Enterprise")); |
| List<Employee> controlEmps = (List)getDbSession().executeQuery(controlQuery); |
| |
| // choose example that actually selects something |
| if(controlEmps.isEmpty()) { |
| fail("Test setup problem: control query result is empty. Choose selection criteria such that something is actually selected"); |
| } |
| |
| // clear cache |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| |
| // execute the tested query |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.anyOfAllowingNone("projectsQK").get("name").containsSubstring("Enterprise")); |
| List<Employee> emps = (List)getDbSession().executeQuery(query); |
| |
| // choose example that actually selects something |
| if(emps.isEmpty()) { |
| fail(); |
| } |
| } |
| |
| public void testLargeProjects() { |
| // TODO: currently the test verifies that the query doesn't blow up. |
| // Add control query so that the results could be verified. |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.anyOfAllowingNone("largeProjects").get("name").containsSubstring("Enterprise")); |
| List<Employee> emps = (List)getDbSession().executeQuery(query); |
| |
| // choose example that actually selects something |
| if(emps.isEmpty()) { |
| fail(); |
| } |
| } |
| |
| // doesn't work yet |
| public void testResponsibilitiesQK() { |
| ReadAllQuery controlQuery = new ReadAllQuery(Employee.class); |
| ExpressionBuilder controlEb = controlQuery.getExpressionBuilder(); |
| controlQuery.setSelectionCriteria(controlEb.anyOfAllowingNone("responsibilities").equal("Make the coffee.")); |
| List<Employee> controlEmps = (List)getDbSession().executeQuery(controlQuery); |
| |
| // choose example that actually selects something |
| if(controlEmps.isEmpty()) { |
| fail("Test setup problem: control query result is empty. Choose selection criteria such that something is actually selected"); |
| } |
| |
| ReadAllQuery query = new ReadAllQuery(Employee.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.anyOfAllowingNone("responsibilitiesQK").equal("Make the coffee.")); |
| List<Employee> emps = (List)getDbSession().executeQuery(query); |
| |
| String errorMsg = JoinedAttributeTestHelper.compareCollections(controlEmps, emps, getDbSession().getDescriptor(Employee.class), (AbstractSession)getDbSession()); |
| if(errorMsg.length() > 0) { |
| fail(errorMsg); |
| } |
| } |
| |
| public void testOwner() { |
| // TODO: currently the test verifies that the query doesn't blow up. |
| // Add control query so that the results could be verified. |
| ReadAllQuery query = new ReadAllQuery(Address.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.getAllowingNull("owner").get("firstName").like("J%")); |
| List<Address> addresses = (List)getDbSession().executeQuery(query); |
| |
| // choose example that actually selects something |
| if(addresses.isEmpty()) { |
| fail(); |
| } |
| } |
| |
| public void testEmployees() { |
| // TODO: currently the test verifies that the query doesn't blow up. |
| // Add control query so that the results could be verified. |
| ReadAllQuery query = new ReadAllQuery(Project.class); |
| ExpressionBuilder eb = query.getExpressionBuilder(); |
| query.setSelectionCriteria(eb.anyOfAllowingNone("employees").get("firstName").equal("John")); |
| List<Project> projects = (List)getDbSession().executeQuery(query); |
| |
| // choose example that actually selects something |
| if(projects.isEmpty()) { |
| fail(); |
| } |
| } |
| |
| protected String executeQueriesAndCompareResults(ObjectLevelReadQuery controlQuery, ObjectLevelReadQuery queryWithJoins) { |
| return JoinedAttributeTestHelper.executeQueriesAndCompareResults(controlQuery, queryWithJoins, (AbstractSession)getDbSession()); |
| } |
| |
| protected boolean compare() { |
| for(int i=0; i < classes.length; i++) { |
| if(!compare(i)) { |
| return false; |
| } |
| } |
| return true; |
| } |
| |
| protected boolean compare(int i) { |
| if(objectVectors[i] == null) { |
| return false; |
| } |
| Vector currentVector = getDbSession().readAllObjects(classes[i]); |
| |
| if(currentVector.size() != objectVectors[i].size()) { |
| return false; |
| } |
| ClassDescriptor descriptor = getDbSession().getDescriptor(classes[i]); |
| for(int j=0; j < currentVector.size(); j++) { |
| Object obj1 = objectVectors[i].elementAt(j); |
| Object obj2 = currentVector.elementAt(j); |
| if(!descriptor.getObjectBuilder().compareObjects(obj1, obj2, (org.eclipse.persistence.internal.sessions.AbstractSession)getDbSession())) { |
| return false; |
| } |
| } |
| return true; |
| } |
| |
| public void dbSessionClearCache() { |
| getDbSession().getIdentityMapAccessor().initializeAllIdentityMaps(); |
| } |
| } |
