| /* |
| * 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.workbenchintegration; |
| |
| import org.eclipse.persistence.descriptors.ClassDescriptor; |
| import org.eclipse.persistence.sessions.Project; |
| import org.eclipse.persistence.testing.framework.AutoVerifyTestCase; |
| import org.eclipse.persistence.testing.framework.TestErrorException; |
| import org.eclipse.persistence.testing.models.employee.domain.Address; |
| import org.eclipse.persistence.testing.models.employee.relational.EmployeeProject; |
| import org.eclipse.persistence.sessions.factories.XMLProjectReader; |
| import org.eclipse.persistence.sessions.factories.XMLProjectWriter; |
| |
| |
| public class RuntimeCustomSQLQueriesTest extends AutoVerifyTestCase { |
| public static final String PROJECT_FILE = "CustomSQLQueriesProject.xml"; |
| public static final String INSERT_SQL = "INSERT TEST"; |
| public static final String READ_OBJECT_SQL = "READ OBJECT TEST"; |
| public static final String READ_ALL_SQL = "READ ALL TEST"; |
| public static final String UPDATE_SQL = "UPDATE TEST"; |
| public static final String DELETE_SQL = "DELETE TEST"; |
| |
| public RuntimeCustomSQLQueriesTest() { |
| this.setDescription("Validate custom defined SQL queries by reading from an XML project"); |
| } |
| |
| @Override |
| protected void setup() { |
| // Modify the employee project to use custom SQL queries |
| EmployeeProject project = new EmployeeProject(); |
| ClassDescriptor addressDescriptor = project.getDescriptors().get(Address.class); |
| |
| addressDescriptor.getQueryManager().setInsertSQLString(INSERT_SQL); |
| addressDescriptor.getQueryManager().setReadObjectSQLString(READ_OBJECT_SQL); |
| addressDescriptor.getQueryManager().setReadAllSQLString(READ_ALL_SQL); |
| addressDescriptor.getQueryManager().setUpdateSQLString(UPDATE_SQL); |
| addressDescriptor.getQueryManager().setDeleteSQLString(DELETE_SQL); |
| |
| // write project to an XMLl project file |
| XMLProjectWriter.write(PROJECT_FILE, project); |
| } |
| |
| @Override |
| protected void test() { |
| // test run time project that should contains cusomtom sql queries |
| Project project = XMLProjectReader.read(PROJECT_FILE, getClass().getClassLoader()); |
| ClassDescriptor addressDescriptor = project.getDescriptors().get(Address.class); |
| |
| if (!addressDescriptor.getQueryManager().getInsertSQLString().equals(RuntimeCustomSQLQueriesTest.INSERT_SQL)) { |
| throw new TestErrorException("Custom insert SQL for Address is not equal to " + RuntimeCustomSQLQueriesTest.INSERT_SQL); |
| } |
| |
| if (!addressDescriptor.getQueryManager().getReadObjectSQLString().equals(RuntimeCustomSQLQueriesTest.READ_OBJECT_SQL)) { |
| throw new TestErrorException("Custom read object SQL for Address is not equal to " + |
| RuntimeCustomSQLQueriesTest.READ_OBJECT_SQL); |
| } |
| |
| if (!addressDescriptor.getQueryManager().getReadAllSQLString().equals(RuntimeCustomSQLQueriesTest.READ_ALL_SQL)) { |
| throw new TestErrorException("Custom read all SQL for Address is not equal to " + RuntimeCustomSQLQueriesTest.READ_ALL_SQL); |
| } |
| |
| if (!addressDescriptor.getQueryManager().getUpdateSQLString().equals(RuntimeCustomSQLQueriesTest.UPDATE_SQL)) { |
| throw new TestErrorException("Custom update SQL for Address is not equal to " + RuntimeCustomSQLQueriesTest.UPDATE_SQL); |
| } |
| |
| if (!addressDescriptor.getQueryManager().getDeleteSQLString().equals(RuntimeCustomSQLQueriesTest.DELETE_SQL)) { |
| throw new TestErrorException("Custom delete SQL for Address is not equal to " + RuntimeCustomSQLQueriesTest.DELETE_SQL); |
| } |
| } |
| } |