| /* |
| * 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.keyontarget.eis.ownedtoexternalroot; |
| |
| import org.eclipse.persistence.descriptors.ClassDescriptor; |
| 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.eis.mappings.EISCompositeCollectionMapping; |
| import org.eclipse.persistence.eis.mappings.EISDirectMapping; |
| import org.eclipse.persistence.eis.mappings.EISOneToManyMapping; |
| import org.eclipse.persistence.eis.mappings.EISOneToOneMapping; |
| |
| import org.eclipse.persistence.testing.oxm.mappings.onetomany.keyontarget.*; |
| |
| public class OwnedToExternalRootProject extends org.eclipse.persistence.sessions.Project { |
| |
| public OwnedToExternalRootProject() { |
| addDescriptor(getTeamDescriptor()); |
| addDescriptor(getEmployeeDescriptor()); |
| addDescriptor(getProjectDescriptor()); |
| |
| EISLogin login = new EISLogin(new XMLFilePlatform()); |
| login.setConnectionSpec(new XMLFileEISConnectionSpec()); |
| login.setProperty("directory", "./org/eclipse/persistence/testing/oxm/mappings/onetomany/keyontarget/eis/ownedtoexternalroot/"); |
| setLogin(login); |
| } |
| |
| private EISDescriptor getTeamDescriptor() { |
| EISDescriptor descriptor = new EISDescriptor(); |
| descriptor.setJavaClass(Team.class); |
| descriptor.setDataTypeName("team"); |
| descriptor.setPrimaryKeyFieldName("@id"); |
| |
| EISDirectMapping idMapping = new EISDirectMapping(); |
| idMapping.setAttributeName("id"); |
| idMapping.setXPath("@id"); |
| descriptor.addMapping(idMapping); |
| |
| EISCompositeCollectionMapping employeesMapping = new EISCompositeCollectionMapping(); |
| employeesMapping.setAttributeName("employees"); |
| employeesMapping.useCollectionClass(java.util.Vector.class); |
| employeesMapping.setReferenceClass(Employee.class); |
| employeesMapping.setXPath("employee"); |
| descriptor.addMapping(employeesMapping); |
| |
| // Insert |
| XQueryInteraction insertCall = new XQueryInteraction(); |
| insertCall.setFunctionName("insert"); |
| insertCall.setProperty("fileName", "team.xml"); |
| insertCall.setXQueryString("team"); |
| descriptor.getQueryManager().setInsertCall(insertCall); |
| |
| // Read object |
| XQueryInteraction readObjectCall = new XQueryInteraction(); |
| readObjectCall.setFunctionName("read"); |
| readObjectCall.setProperty("fileName", "team.xml"); |
| readObjectCall.setXQueryString("team[@id='#@id']"); |
| readObjectCall.setOutputResultPath("result"); |
| descriptor.getQueryManager().setReadObjectCall(readObjectCall); |
| |
| // Read all |
| XQueryInteraction readAllCall = new XQueryInteraction(); |
| readAllCall.setFunctionName("read-all"); |
| readAllCall.setProperty("fileName", "team.xml"); |
| readAllCall.setXQueryString("team"); |
| readAllCall.setOutputResultPath("result"); |
| descriptor.getQueryManager().setReadAllCall(readAllCall); |
| |
| // Delete |
| XQueryInteraction deleteCall = new XQueryInteraction(); |
| deleteCall.setFunctionName("delete"); |
| deleteCall.setProperty("fileName", "team.xml"); |
| deleteCall.setXQueryString("team[@id='#@id']"); |
| descriptor.getQueryManager().setDeleteCall(deleteCall); |
| |
| //Update |
| XQueryInteraction updateCall = new XQueryInteraction(); |
| updateCall.setFunctionName("update"); |
| updateCall.setProperty("fileName", "team.xml"); |
| updateCall.setXQueryString("team[@id='#@id']"); |
| descriptor.getQueryManager().setUpdateCall(updateCall); |
| |
| return descriptor; |
| } |
| |
| private EISDescriptor getEmployeeDescriptor() { |
| EISDescriptor descriptor = new EISDescriptor(); |
| descriptor.setJavaClass(Employee.class); |
| descriptor.descriptorIsAggregate(); |
| descriptor.setDataTypeName("employee"); |
| descriptor.setPrimaryKeyFieldName("first-name/text()"); |
| |
| 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.dontUseIndirection(); |
| XQueryInteraction projectInteraction = new XQueryInteraction(); |
| projectInteraction.setFunctionName("read-projects"); |
| projectInteraction.setProperty("fileName", "project.xml"); |
| projectInteraction.setXQueryString("project[leader/text()='#first-name/text()']"); |
| projectInteraction.setOutputResultPath("result"); |
| projectMapping.setSelectionCall(projectInteraction); |
| |
| 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); |
| |
| /* can't have backpointer since leader is composite |
| EISOneToOneMapping leaderMapping = new EISOneToOneMapping(); |
| leaderMapping.setReferenceClass(Employee.class); |
| leaderMapping.setAttributeName("leader"); |
| leaderMapping.dontUseIndirection(); |
| |
| XQueryInteraction leaderInteraction = new XQueryInteraction(); |
| leaderInteraction.setFunctionName("read-leader"); |
| leaderInteraction.setProperty("fileName", "employee.xml"); |
| leaderInteraction.setXQueryString("employee[first-name='#leader']"); |
| leaderInteraction.setOutputResultPath("result"); |
| leaderMapping.setSelectionCall(leaderInteraction); |
| leaderMapping.addForeignKeyFieldName("leader","first-name"); |
| |
| descriptor.addMapping(leaderMapping); |
| */ |
| |
| |
| // 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.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", "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; |
| } |
| } |
| |