| /* |
| * Copyright (c) 1998, 2020 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.oxm.mappings.onetomany.keyonsource.eis.compositekey.nestedownedtoexternalroot; |
| |
| import org.eclipse.persistence.eis.EISDescriptor; |
| import org.eclipse.persistence.eis.EISLogin; |
| import org.eclipse.persistence.eis.interactions.XQueryInteraction; |
| import org.eclipse.persistence.eis.adapters.xmlfile.XMLFilePlatform; |
| import org.eclipse.persistence.eis.adapters.xmlfile.XMLFileEISConnectionSpec; |
| |
| import org.eclipse.persistence.descriptors.ClassDescriptor; |
| import org.eclipse.persistence.eis.mappings.EISCompositeCollectionMapping; |
| import org.eclipse.persistence.eis.mappings.EISDirectMapping; |
| import org.eclipse.persistence.eis.mappings.EISOneToManyMapping; |
| |
| import org.eclipse.persistence.testing.oxm.mappings.onetomany.keyonsource.*; |
| |
| public class NestedOwnedToExternalRootProject extends org.eclipse.persistence.sessions.Project { |
| |
| public NestedOwnedToExternalRootProject() { |
| |
| addDescriptor(getCompanyDescriptor()); |
| addDescriptor(getDepartmentDescriptor()); |
| addDescriptor(getEmployeeDescriptor()); |
| addDescriptor(getProjectDescriptor()); |
| |
| EISLogin login = new EISLogin(new XMLFilePlatform()); |
| login.setConnectionSpec(new XMLFileEISConnectionSpec()); |
| login.setProperty("directory", "./org/eclipse/persistence/testing/oxm/mappings/onetomany/keyonsource/eis/compositekey/nestedownedtoexternalroot/"); |
| setLogin(login); |
| } |
| |
| private EISDescriptor getCompanyDescriptor() { |
| EISDescriptor descriptor = new EISDescriptor(); |
| descriptor.setJavaClass(Company.class); |
| descriptor.setDataTypeName("company"); |
| descriptor.setPrimaryKeyFieldName("name/text()"); |
| |
| EISDirectMapping nameMapping = new EISDirectMapping(); |
| nameMapping.setAttributeName("name"); |
| nameMapping.setXPath("name/text()"); |
| descriptor.addMapping(nameMapping); |
| |
| EISCompositeCollectionMapping departmentsMapping = new EISCompositeCollectionMapping(); |
| departmentsMapping.setAttributeName("departments"); |
| departmentsMapping.useCollectionClass(java.util.Vector.class); |
| departmentsMapping.setReferenceClass(Department.class); |
| departmentsMapping.setXPath("department"); |
| descriptor.addMapping(departmentsMapping); |
| |
| // Insert |
| XQueryInteraction insertCall = new XQueryInteraction(); |
| insertCall.setFunctionName("insert"); |
| insertCall.setProperty("fileName", "company.xml"); |
| insertCall.setXQueryString("company"); |
| descriptor.getQueryManager().setInsertCall(insertCall); |
| |
| // Read object |
| XQueryInteraction readObjectCall = new XQueryInteraction(); |
| readObjectCall.setFunctionName("read"); |
| readObjectCall.setProperty("fileName", "company.xml"); |
| readObjectCall.setXQueryString("company[name/text()='#name/text()']"); |
| readObjectCall.setOutputResultPath("result"); |
| descriptor.getQueryManager().setReadObjectCall(readObjectCall); |
| |
| // Read all |
| XQueryInteraction readAllCall = new XQueryInteraction(); |
| readAllCall.setFunctionName("read-all"); |
| readAllCall.setProperty("fileName", "company.xml"); |
| readAllCall.setXQueryString("company"); |
| readAllCall.setOutputResultPath("result"); |
| descriptor.getQueryManager().setReadAllCall(readAllCall); |
| |
| // Delete |
| XQueryInteraction deleteCall = new XQueryInteraction(); |
| deleteCall.setFunctionName("delete"); |
| deleteCall.setProperty("fileName", "company.xml"); |
| deleteCall.setXQueryString("company[name/text()='#name/text()']"); |
| descriptor.getQueryManager().setDeleteCall(deleteCall); |
| |
| //Update |
| XQueryInteraction updateCall = new XQueryInteraction(); |
| updateCall.setFunctionName("update"); |
| updateCall.setProperty("fileName", "company.xml"); |
| updateCall.setXQueryString("company[name/text()='#name/text()']"); |
| descriptor.getQueryManager().setUpdateCall(updateCall); |
| return descriptor; |
| } |
| |
| private EISDescriptor getDepartmentDescriptor() { |
| EISDescriptor descriptor = new EISDescriptor(); |
| descriptor.setJavaClass(Department.class); |
| descriptor.setDataTypeName("department"); |
| descriptor.descriptorIsAggregate(); |
| |
| EISDirectMapping nameMapping = new EISDirectMapping(); |
| nameMapping.setAttributeName("deptName"); |
| nameMapping.setXPath("name/text()"); |
| descriptor.addMapping(nameMapping); |
| |
| EISCompositeCollectionMapping employeesMapping = new EISCompositeCollectionMapping(); |
| employeesMapping.setAttributeName("employees"); |
| employeesMapping.useCollectionClass(java.util.Vector.class); |
| employeesMapping.setReferenceClass(Employee.class); |
| employeesMapping.setXPath("employee"); |
| descriptor.addMapping(employeesMapping); |
| |
| return descriptor; |
| } |
| |
| |
| private EISDescriptor getEmployeeDescriptor() { |
| EISDescriptor descriptor = new EISDescriptor(); |
| descriptor.setJavaClass(Employee.class); |
| descriptor.setDataTypeName("employee"); |
| descriptor.descriptorIsAggregate(); |
| |
| EISDirectMapping firstNameMapping = new EISDirectMapping(); |
| firstNameMapping.setAttributeName("firstName"); |
| firstNameMapping.setXPath("first-name/text()"); |
| descriptor.addMapping(firstNameMapping); |
| |
| EISOneToManyMapping projectMapping = new EISOneToManyMapping(); |
| projectMapping.setReferenceClass(Project.class); |
| projectMapping.setAttributeName("projects"); |
| projectMapping.setForeignKeyGroupingElement("project"); |
| projectMapping.dontUseIndirection(); |
| projectMapping.setIsForeignKeyRelationship(true); |
| XQueryInteraction projectInteraction = new XQueryInteraction(); |
| projectInteraction.setFunctionName("read-projects"); |
| projectInteraction.setProperty("fileName", "project.xml"); |
| //projectInteraction.setXQueryString("project[@id='#project-id']"); |
| projectInteraction.setXQueryString("project[@id='#project-id/text()' and name/text()='#project-name/text()']"); |
| projectInteraction.setOutputResultPath("result"); |
| projectMapping.setSelectionCall(projectInteraction); |
| //projectMapping.addSourceForeignKeyFieldName("project-id","@id"); |
| //projectMapping.addSourceForeignKeyFieldName("project-name", "name"); |
| projectMapping.addForeignKeyFieldName("project-id/text()","@id"); |
| projectMapping.addForeignKeyFieldName("project-name/text()", "name/text()"); |
| |
| descriptor.addMapping(projectMapping); |
| return descriptor; |
| } |
| |
| private ClassDescriptor getProjectDescriptor() { |
| EISDescriptor descriptor = new EISDescriptor(); |
| descriptor.setJavaClass(Project.class); |
| descriptor.setDataTypeName("project"); |
| descriptor.setPrimaryKeyFieldName("@id"); |
| |
| EISDirectMapping nameMapping = new EISDirectMapping(); |
| nameMapping.setAttributeName("name"); |
| nameMapping.setXPath("name/text()"); |
| descriptor.addMapping(nameMapping); |
| |
| EISDirectMapping idMapping = new EISDirectMapping(); |
| idMapping.setAttributeName("id"); |
| idMapping.setXPath("@id"); |
| descriptor.addMapping(idMapping); |
| |
| // Insert |
| XQueryInteraction insertCall = new XQueryInteraction(); |
| insertCall.setXQueryString("project"); |
| insertCall.setFunctionName("insert"); |
| insertCall.setProperty("fileName", "project.xml"); |
| descriptor.getQueryManager().setInsertCall(insertCall); |
| |
| // Read object |
| XQueryInteraction readObjectCall = new XQueryInteraction(); |
| readObjectCall.setFunctionName("read"); |
| readObjectCall.setProperty("fileName", "project.xml"); |
| readObjectCall.setXQueryString("project[@id='#@id']"); |
| readObjectCall.setOutputResultPath("result"); |
| descriptor.getQueryManager().setReadObjectCall(readObjectCall); |
| |
| // Read all |
| XQueryInteraction readAllCall = new XQueryInteraction(); |
| readAllCall.setFunctionName("read-all"); |
| readAllCall.setProperty("fileName", "project.xml"); |
| readAllCall.setXQueryString("project"); |
| readAllCall.setOutputResultPath("result"); |
| descriptor.getQueryManager().setReadAllCall(readAllCall); |
| |
| // Delete |
| XQueryInteraction deleteCall = new XQueryInteraction(); |
| deleteCall.setFunctionName("delete"); |
| readAllCall.setProperty("fileName", "project.xml"); |
| readObjectCall.setXQueryString("project[@id='#@id']"); |
| descriptor.getQueryManager().setDeleteCall(deleteCall); |
| |
| //Update |
| XQueryInteraction updateCall = new XQueryInteraction(); |
| updateCall.setFunctionName("update"); |
| readAllCall.setProperty("fileName", "project.xml"); |
| readObjectCall.setXQueryString("project[@id='#@id']"); |
| descriptor.getQueryManager().setUpdateCall(updateCall); |
| |
| return descriptor; |
| } |
| } |
| |