/*******************************************************************************
* Copyright (c) 1998, 2015 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 v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* Contributors:
* Oracle - initial API and implementation from Oracle TopLink
******************************************************************************/
package org.eclipse.persistence.testing.oxm.mappings.onetomany.keyonsource.eis.nogroupingelement.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/nogroupingelement/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.setIsForeignKeyRelationship(true);
projectMapping.dontUseIndirection();
XQueryInteraction projectInteraction = new XQueryInteraction();
projectInteraction.setFunctionName("read-projects");
projectInteraction.setProperty("fileName", "project.xml");
projectInteraction.setXQueryString("project[@id='#project-id/text()']");
projectInteraction.setOutputResultPath("result");
projectMapping.setSelectionCall(projectInteraction);
projectMapping.addForeignKeyFieldName("project-id/text()","@id");
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;
}
}