| /* |
| * 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.tableswithspacesmodel; |
| |
| import org.eclipse.persistence.testing.framework.*; |
| import org.eclipse.persistence.testing.models.employee.domain.*; |
| import org.eclipse.persistence.tools.schemaframework.PopulationManager; |
| import org.eclipse.persistence.queries.SQLCall; |
| |
| /** |
| * This model tests reading/writing/deleting through using the employee demo. |
| */ |
| public class EmployeeWithSpacesTestModel extends TestModel { |
| public EmployeeWithSpacesTestModel() { |
| setDescription("This model tests reading/writing/deleting using the employee demo. Includes table names with spaces"); |
| } |
| |
| public EmployeeWithSpacesTestModel(boolean isSRG) { |
| this(); |
| this.isSRG = isSRG; |
| } |
| |
| @Override |
| public void addRequiredSystems() { |
| addRequiredSystem(new EmployeeWithSpacesSystem()); |
| } |
| |
| @Override |
| public void addTests() { |
| addTest(getReadObjectTestSuite()); |
| addTest(getUpdateObjectTestSuite()); |
| addTest(getInsertObjectTestSuite()); |
| addTest(getDeleteObjectTestSuite()); |
| // EL bug 382420 |
| addTest(new QuotedTableNameInitializationTest()); |
| } |
| //SRG test set is maintained by QA only, do NOT add any new tests into it. |
| |
| @Override |
| public void addSRGTests() { |
| addTest(getSRGReadObjectTestSuite()); |
| addTest(getSRGUpdateObjectTestSuite()); |
| addTest(getSRGInsertObjectTestSuite()); |
| addTest(getSRGDeleteObjectTestSuite()); |
| } |
| |
| public static TestSuite getDeleteObjectTestSuite() { |
| TestSuite suite = getSRGDeleteObjectTestSuite(); |
| //Add new tests here ... |
| |
| return suite; |
| } |
| |
| //SRG test set is maintained by QA only, do NOT add any new tests into it. |
| |
| public static TestSuite getSRGDeleteObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("EmployeeDeleteObjectTestSuite"); |
| suite.setDescription("This suite tests the deletion of each object in the employee demo."); |
| |
| Class<Employee> employeeClass = Employee.class; |
| Class<LargeProject> largeProjectClass = LargeProject.class; |
| Class<SmallProject> smallProjectClass = SmallProject.class; |
| PopulationManager manager = PopulationManager.getDefaultManager(); |
| |
| suite.addTest(new EmployeeWithSpacesDeleteTest(manager.getObject(employeeClass, "0001"))); |
| suite.addTest(new EmployeeWithSpacesDeleteTest(manager.getObject(employeeClass, "0002"))); |
| suite.addTest(new EmployeeWithSpacesDeleteTest(manager.getObject(employeeClass, "0003"))); |
| suite.addTest(new EmployeeWithSpacesDeleteTest(manager.getObject(employeeClass, "0004"))); |
| suite.addTest(new EmployeeWithSpacesDeleteTest(manager.getObject(employeeClass, "0005"))); |
| |
| suite.addTest(new ProjectWithSpacesDeleteTest(manager.getObject(smallProjectClass, "0001"))); |
| suite.addTest(new ProjectWithSpacesDeleteTest(manager.getObject(smallProjectClass, "0002"))); |
| suite.addTest(new ProjectWithSpacesDeleteTest(manager.getObject(smallProjectClass, "0003"))); |
| |
| suite.addTest(new ProjectWithSpacesDeleteTest(manager.getObject(largeProjectClass, "0001"))); |
| suite.addTest(new ProjectWithSpacesDeleteTest(manager.getObject(largeProjectClass, "0002"))); |
| suite.addTest(new ProjectWithSpacesDeleteTest(manager.getObject(largeProjectClass, "0003"))); |
| |
| return suite; |
| |
| } |
| |
| public static TestSuite getInsertObjectTestSuite() { |
| TestSuite suite = getSRGInsertObjectTestSuite(); |
| //Add new tests here ... |
| |
| return suite; |
| } |
| |
| //SRG test set is maintained by QA only, do NOT add any new tests into it. |
| |
| public static TestSuite getSRGInsertObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("EmployeeInsertObjectTestSuite"); |
| suite.setDescription("This suite tests the insertion of each object in the employee demo."); |
| EmployeePopulator system = new EmployeePopulator(); |
| |
| suite.addTest(new InsertObjectTest(system.basicEmployeeExample1())); |
| suite.addTest(new InsertObjectTest(system.basicEmployeeExample2())); |
| suite.addTest(new InsertObjectTest(system.basicEmployeeExample3())); |
| suite.addTest(new InsertObjectTest(system.basicEmployeeExample4())); |
| suite.addTest(new InsertObjectTest(system.basicEmployeeExample5())); |
| |
| suite.addTest(new InsertObjectTest(system.basicSmallProjectExample1())); |
| suite.addTest(new InsertObjectTest(system.basicSmallProjectExample2())); |
| suite.addTest(new InsertObjectTest(system.basicSmallProjectExample3())); |
| |
| suite.addTest(new InsertObjectTest(system.basicLargeProjectExample1())); |
| suite.addTest(new InsertObjectTest(system.basicLargeProjectExample2())); |
| suite.addTest(new InsertObjectTest(system.basicLargeProjectExample3())); |
| |
| return suite; |
| } |
| |
| public static TestSuite getReadAllTestSuite() { |
| TestSuite suite = getSRGReadAllTestSuite(); |
| //Add new tests here ... |
| return suite; |
| } |
| |
| //SRG test set is maintained by QA only, do NOT add any new tests into it. |
| |
| public static TestSuite getSRGReadAllTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("EmployeeReadAllTestSuite"); |
| suite.setDescription("This suite tests the reading of all the objects of each class in the employee demo."); |
| |
| suite.addTest(new ReadAllTest(Employee.class, 12)); |
| suite.addTest(new ReadAllTest(Project.class, 15)); |
| suite.addTest(new ReadAllTest(LargeProject.class, 5)); |
| suite.addTest(new ReadAllTest(SmallProject.class, 10)); |
| |
| suite.addTest(new ReadAllCallTest(Employee.class, 12, new SQLCall("SELECT t0.VERSION, t1.EMP_ID, t0.L_NAME, t0.F_NAME, t1.SALARY, t0.EMP_ID, t0.GENDER, t0.END_DATE, t0.START_DATE, t0.MANAGER_ID, t0.END_TIME, t0.START_TIME, t0.ADDR_ID FROM EMPLOYEE t0, SALARY t1 WHERE t1.EMP_ID = t0.EMP_ID"))); |
| |
| return suite; |
| } |
| |
| public static TestSuite getReadObjectTestSuite() { |
| TestSuite suite = getSRGReadObjectTestSuite(); |
| //Add new tests here ... |
| |
| return suite; |
| } |
| |
| //SRG test set is maintained by QA only, do NOT add any new tests into it. |
| |
| public static TestSuite getSRGReadObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("EmployeeReadObjectTestSuite"); |
| suite.setDescription("This suite test the reading of each object in the employee demo."); |
| |
| Class<Employee> employeeClass = Employee.class; |
| Class<LargeProject> largeProjectClass = LargeProject.class; |
| Class<SmallProject> smallProjectClass = SmallProject.class; |
| PopulationManager manager = PopulationManager.getDefaultManager(); |
| |
| suite.addTest(new ReadObjectTest(manager.getObject(employeeClass, "0001"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(employeeClass, "0002"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(employeeClass, "0003"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(employeeClass, "0004"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(employeeClass, "0005"))); |
| |
| Project project = (Project)manager.getObject(largeProjectClass, "0001"); |
| ReadObjectTest test = new ReadObjectTest(project); |
| test.setQuery(new org.eclipse.persistence.queries.ReadObjectQuery(Project.class, new org.eclipse.persistence.expressions.ExpressionBuilder().get("id").equal(project.getId()))); |
| suite.addTest(test); |
| |
| suite.addTest(new ReadObjectTest(manager.getObject(smallProjectClass, "0001"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(smallProjectClass, "0002"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(smallProjectClass, "0003"))); |
| |
| suite.addTest(new ReadObjectTest(manager.getObject(largeProjectClass, "0001"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(largeProjectClass, "0002"))); |
| suite.addTest(new ReadObjectTest(manager.getObject(largeProjectClass, "0003"))); |
| |
| return suite; |
| } |
| |
| public static TestSuite getUpdateObjectTestSuite() { |
| TestSuite suite = getSRGUpdateObjectTestSuite(); |
| //Add new tests here ... |
| |
| return suite; |
| } |
| |
| //SRG test set is maintained by QA only, do NOT add any new tests into it. |
| |
| public static TestSuite getSRGUpdateObjectTestSuite() { |
| TestSuite suite = new TestSuite(); |
| suite.setName("EmployeeUpdateObjectTestSuite"); |
| suite.setDescription("This suite tests the updating of each object in the employee demo."); |
| |
| Class<Employee> employeeClass = Employee.class; |
| Class<LargeProject> largeProjectClass = LargeProject.class; |
| Class<SmallProject> smallProjectClass = SmallProject.class; |
| PopulationManager manager = PopulationManager.getDefaultManager(); |
| |
| suite.addTest(new WriteObjectTest(manager.getObject(employeeClass, "0001"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(employeeClass, "0002"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(employeeClass, "0003"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(employeeClass, "0004"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(employeeClass, "0005"))); |
| |
| suite.addTest(new WriteObjectTest(manager.getObject(smallProjectClass, "0001"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(smallProjectClass, "0002"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(smallProjectClass, "0003"))); |
| |
| suite.addTest(new WriteObjectTest(manager.getObject(largeProjectClass, "0001"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(largeProjectClass, "0002"))); |
| suite.addTest(new WriteObjectTest(manager.getObject(largeProjectClass, "0003"))); |
| |
| return suite; |
| } |
| |
| } |
