| /* |
| * 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.sessionbroker; |
| |
| import org.eclipse.persistence.internal.sessions.DatabaseSessionImpl; |
| import org.eclipse.persistence.mappings.ManyToManyMapping; |
| import org.eclipse.persistence.mappings.OneToOneMapping; |
| import org.eclipse.persistence.sessions.broker.SessionBroker; |
| import org.eclipse.persistence.sessions.DatabaseLogin; |
| import org.eclipse.persistence.sessions.DatabaseSession; |
| import org.eclipse.persistence.sessions.Session; |
| import org.eclipse.persistence.testing.framework.InsertObjectTest; |
| import org.eclipse.persistence.testing.framework.OracleDBPlatformHelper; |
| import org.eclipse.persistence.testing.framework.ReadAllTest; |
| import org.eclipse.persistence.testing.framework.ReadObjectTest; |
| import org.eclipse.persistence.testing.framework.TestModel; |
| import org.eclipse.persistence.testing.framework.TestSuite; |
| import org.eclipse.persistence.testing.framework.WriteObjectTest; |
| import org.eclipse.persistence.testing.models.employee.domain.Employee; |
| import org.eclipse.persistence.testing.models.employee.domain.LargeProject; |
| import org.eclipse.persistence.testing.models.employee.domain.SmallProject; |
| import org.eclipse.persistence.testing.tests.employee.EmployeeDeleteTest; |
| import org.eclipse.persistence.testing.tests.employee.ProjectDeleteTest; |
| import org.eclipse.persistence.tools.schemaframework.PopulationManager; |
| import org.eclipse.persistence.tools.schemaframework.SchemaManager; |
| |
| |
| public class BrokerTestModel extends TestModel { |
| public Session oldSession; |
| |
| public BrokerTestModel() { |
| setDescription("This model tests reading/writing/deleting using the session broker with the employee demo."); |
| } |
| |
| @Override |
| public void addTests() { |
| addTest(getInitializationTestSuite()); |
| addTest(getReadObjectTestSuite()); |
| addTest(getUpdateObjectTestSuite()); |
| addTest(getReadAllTestSuite()); |
| addTest(getInsertObjectTestSuite()); |
| addTest(getDeleteObjectTestSuite()); |
| } |
| |
| /** |
| * Build the session broker, this assume two data-sources Broker1 and Broker2 (JConnect). |
| */ |
| public SessionBroker buildBroker() { |
| SessionBroker broker = new SessionBroker(); |
| |
| DatabaseSession session1 = new DatabaseSessionImpl(getLogin1()); |
| DatabaseSession session2 = new DatabaseSessionImpl(getLogin2()); |
| |
| session1.addDescriptors(new EmployeeProject1()); |
| |
| session2.addDescriptors(new EmployeeProject2()); |
| |
| broker.registerSession("broker1", session1); |
| broker.registerSession("broker2", session2); |
| |
| broker.setSessionLog(oldSession.getSessionLog()); |
| |
| broker.login(); |
| |
| // Set session for join table. |
| ((ManyToManyMapping)session1.getDescriptor(Employee.class).getObjectBuilder().getMappingForAttributeName("projects")).setSessionName("broker2"); |
| // Disable delete verify. |
| ((OneToOneMapping)session1.getDescriptor(Employee.class).getObjectBuilder().getMappingForAttributeName("address")).setShouldVerifyDelete(false); |
| |
| org.eclipse.persistence.testing.models.employee.relational.EmployeeTableCreator tables = |
| new org.eclipse.persistence.testing.models.employee.relational.EmployeeTableCreator(); |
| tables.replaceTables(session1); |
| tables.replaceTables(session2); |
| tables.dropConstraints(session1); |
| tables.dropConstraints(session2); |
| new SchemaManager(session1).createSequences(); |
| new SchemaManager(session2).createSequences(); |
| |
| new org.eclipse.persistence.testing.models.employee.relational.EmployeeSystem().populate(broker); |
| |
| return broker; |
| } |
| |
| public static TestSuite getDeleteObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("BrokerDeleteObjectTestSuite"); |
| suite.setDescription("This suite tests delete SQL."); |
| |
| PopulationManager manager = PopulationManager.getDefaultManager(); |
| |
| suite.addTest(new EmployeeDeleteTest(manager.getObject(Employee.class, "0001"))); |
| suite.addTest(new EmployeeDeleteTest(manager.getObject(Employee.class, "0002"))); |
| suite.addTest(new ProjectDeleteTest(manager.getObject(LargeProject.class, "0001"))); |
| suite.addTest(new ProjectDeleteTest(manager.getObject(SmallProject.class, "0002"))); |
| |
| return suite; |
| } |
| |
| public static TestSuite getInitializationTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("BrokerInitializationTestSuite"); |
| suite.setDescription("This suite tests Session Broker initialization."); |
| |
| suite.addTest(new ExternalTransactionControllerInitializationTest()); |
| |
| return suite; |
| } |
| |
| |
| public static TestSuite getInsertObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("BrokerInsertObjectTestSuite"); |
| suite.setDescription("This suite tests insert SQL."); |
| org.eclipse.persistence.testing.models.employee.domain.EmployeePopulator system = |
| new org.eclipse.persistence.testing.models.employee.domain.EmployeePopulator(); |
| |
| suite.addTest(new InsertObjectTest(system.basicEmployeeExample4())); |
| suite.addTest(new InsertObjectTest(system.basicEmployeeExample5())); |
| suite.addTest(new InsertObjectTest(system.basicSmallProjectExample5())); |
| suite.addTest(new InsertObjectTest(system.basicLargeProjectExample5())); |
| |
| return suite; |
| } |
| |
| public static DatabaseLogin getLogin1() { |
| //Oracle 11.1 |
| DatabaseLogin login = new DatabaseLogin(); |
| try { |
| login.usePlatform(OracleDBPlatformHelper.getInstance().getOracle9Platform()); |
| } catch (Exception e) { |
| } |
| login.useOracleThinJDBCDriver(); |
| login.setDatabaseURL("ottvm028.ca.oracle.com:1521:toplink"); |
| login.setUserName("QA7"); |
| login.setPassword("password"); |
| login.useNativeSequencing(); |
| login.getDefaultSequence().setPreallocationSize(1); |
| |
| return login; |
| } |
| |
| public static DatabaseLogin getLogin2() { |
| return ServerBrokerTestModel.getLogin2(); |
| } |
| |
| public static TestSuite getReadAllTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("BrokerReadAllTestSuite"); |
| suite.setDescription("This suite tests read all sql."); |
| |
| suite.addTest(new ReadAllTest(Employee.class, 12)); |
| suite.addTest(new ReadAllTest(org.eclipse.persistence.testing.models.employee.domain.Project.class, 15)); |
| suite.addTest(new ReadAllTest(LargeProject.class, 5)); |
| suite.addTest(new ReadAllTest(SmallProject.class, 10)); |
| |
| return suite; |
| } |
| |
| public static TestSuite getReadObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("BrokerReadObjectTestSuite"); |
| suite.setDescription("This suite test read sql."); |
| |
| PopulationManager manager = PopulationManager.getDefaultManager(); |
| |
| suite.addTest(new ReadObjectTest(manager.getObject(Employee.class, "0001"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(Employee.class, "0004"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(LargeProject.class, "0001"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(SmallProject.class, "0004"))); |
| |
| return suite; |
| } |
| |
| public static TestSuite getUpdateObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("BrokerUpdateObjectTestSuite"); |
| suite.setDescription("This suite tests update sql."); |
| |
| PopulationManager manager = PopulationManager.getDefaultManager(); |
| |
| suite.addTest(new WriteObjectTest(manager.getObject(Employee.class, "0001"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(Employee.class, "0005"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(SmallProject.class, "0001"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(LargeProject.class, "0005"))); |
| |
| suite.addTest(new BatchWritingWithSessionBrokerTest()); |
| |
| return suite; |
| } |
| |
| /** |
| * Replace the executor with the old session. |
| */ |
| @Override |
| public void reset() { |
| try { |
| if (getExecutor().getSession() instanceof SessionBroker) { |
| ((DatabaseSession)getExecutor().getSession()).logout(); |
| } |
| } finally { |
| getExecutor().setSession(oldSession); |
| } |
| } |
| |
| /** |
| * Replace the executor with the broker session. |
| */ |
| @Override |
| public void setup() { |
| oldSession = getSession(); |
| getExecutor().setSession(buildBroker()); |
| } |
| } |