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);
EISOneToOneMapping projectMapping = new EISOneToOneMapping();
projectMapping.setReferenceClass(Project.class);
projectMapping.setAttributeName("project");
projectMapping.dontUseIndirection();
XQueryInteraction projectInteraction = new XQueryInteraction();
projectInteraction.setFunctionName("read-project");
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;
}
protected void createTables() {
// Drop tables
XQueryInteraction interaction = new XQueryInteraction();
XMLFileInteractionSpec spec = new XMLFileInteractionSpec();
interaction = new XQueryInteraction();
interaction.setFunctionName("drop-PROJECT");
spec = new XMLFileInteractionSpec();
spec.setFileName("project.xml");
spec.setInteractionType(XMLFileInteractionSpec.DELETE);
interaction.setInteractionSpec(spec);
session.executeNonSelectingCall(interaction);
interaction = new XQueryInteraction();
interaction.setFunctionName("drop-EMPLOYEE");
spec = new XMLFileInteractionSpec();
spec.setFileName("employee.xml");
spec.setInteractionType(XMLFileInteractionSpec.DELETE);
interaction.setInteractionSpec(spec);
session.executeNonSelectingCall(interaction);
}
private EISDescriptor getEmployeeDescriptor() {
EISDescriptor descriptor = new EISDescriptor();
descriptor.setJavaClass(Employee.class);
descriptor.setDataTypeName("ns1: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);
NamespaceResolver resolver = new NamespaceResolver();
resolver.put("ns1", "myNamespace");
descriptor.setNamespaceResolver(resolver);
// Insert
XQueryInteraction insertCall = new XQueryInteraction();
insertCall.setFunctionName("insert");
insertCall.setProperty("fileName", "employee.xml");
insertCall.setXQueryString("ns1:employee");
descriptor.getQueryManager().setInsertCall(insertCall);
// Read object
XQueryInteraction readObjectCall = new XQueryInteraction();
readObjectCall.setFunctionName("read");
readObjectCall.setProperty("fileName", "employee.xml");
readObjectCall.setXQueryString("ns1:employee[first-name='#first-name/text()']");
readObjectCall.setOutputResultPath("result");
descriptor.getQueryManager().setReadObjectCall(readObjectCall);
// Read all
XQueryInteraction readAllCall = new XQueryInteraction();
readAllCall.setFunctionName("read-all");
readAllCall.setProperty("fileName", "employee.xml");
readAllCall.setXQueryString("ns1:employee");
readAllCall.setOutputResultPath("result");
descriptor.getQueryManager().setReadAllCall(readAllCall);
// Delete
XQueryInteraction deleteCall = new XQueryInteraction();
deleteCall.setFunctionName("delete");
deleteCall.setProperty("fileName", "employee.xml");
deleteCall.setXQueryString("ns1:employee[first-name='#first-name/text()']");
descriptor.getQueryManager().setDeleteCall(deleteCall);
// Update
XQueryInteraction updateCall = new XQueryInteraction();
updateCall.setFunctionName("update");
updateCall.setProperty("fileName", "employee.xml");
updateCall.setXQueryString("ns1:employee[first-name='#first-name/text()']");
descriptor.getQueryManager().setUpdateCall(updateCall);
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);
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("ns1:employee[first-name/text()='#leader/text()']");
leaderInteraction.setOutputResultPath("result");
leaderMapping.setSelectionCall(leaderInteraction);
leaderMapping.addForeignKeyFieldName("leader/text()", "first-name/text()");
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.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;
}
public static void addToOrderDescriptor(ClassDescriptor descriptor) {
// Insert
XQueryInteraction insertCall = new XQueryInteraction();
insertCall.setXQueryString("order");
insertCall.setFunctionName("insert");
insertCall.setProperty("fileName", "orders.xml");
descriptor.getQueryManager().setInsertCall(insertCall);
// Update
XQueryInteraction updateCall = new XQueryInteraction();
updateCall.setFunctionName("update");
updateCall.setProperty("fileName", "orders.xml");
updateCall.setXQueryString("order[@id='#@id']");
descriptor.getQueryManager().setUpdateCall(updateCall);
// Delete
XQueryInteraction deleteCall = new XQueryInteraction();
deleteCall.setFunctionName("delete");
deleteCall.setProperty("fileName", "orders.xml");
deleteCall.setXQueryString("order[@id='#@id']");
descriptor.getQueryManager().setDeleteCall(deleteCall);
// Read object
XQueryInteraction readObjectCall = new XQueryInteraction();
readObjectCall.setFunctionName("read");
readObjectCall.setProperty("fileName", "orders.xml");
readObjectCall.setXQueryString("order[@id='#@id']");
readObjectCall.setOutputResultPath("result");
descriptor.getQueryManager().setReadObjectCall(readObjectCall);
// Read all
XQueryInteraction readAllCall = new XQueryInteraction();
readAllCall.setFunctionName("read-all");
readAllCall.setProperty("fileName", "orders.xml");
readAllCall.setXQueryString("order");
readAllCall.setOutputResultPath("result");
descriptor.getQueryManager().setReadAllCall(readAllCall);
}
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 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;
}
private EISDescriptor getEmployeeDescriptor() {
EISDescriptor descriptor = new EISDescriptor();
descriptor.setJavaClass(Employee.class);
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.setAttributeName("projects");
projectMapping.setReferenceClass(Project.class);
projectMapping.setForeignKeyGroupingElement("project");
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");
// do not set a selection call on this mapping...
/* projectMapping.setSelectionCall(projectInteraction); */
projectMapping.addForeignKeyFieldName("project-id/text()", "@id");
descriptor.addMapping(projectMapping);
// Insert
XQueryInteraction insertCall = new XQueryInteraction();
insertCall.setFunctionName("insert");
insertCall.setProperty("fileName", "employee.xml");
insertCall.setXQueryString("employee");
descriptor.getQueryManager().setInsertCall(insertCall);
// Read object
XQueryInteraction readObjectCall = new XQueryInteraction();
readObjectCall.setFunctionName("read");
readObjectCall.setProperty("fileName", "employee.xml");
readObjectCall.setXQueryString("employee[first-name='#first-name/text()']");
readObjectCall.setOutputResultPath("result");
descriptor.getQueryManager().setReadObjectCall(readObjectCall);
// Read all
XQueryInteraction readAllCall = new XQueryInteraction();
readAllCall.setFunctionName("read-all");
readAllCall.setProperty("fileName", "employee.xml");
readAllCall.setXQueryString("employee");
readAllCall.setOutputResultPath("result");
descriptor.getQueryManager().setReadAllCall(readAllCall);
// Delete
XQueryInteraction deleteCall = new XQueryInteraction();
deleteCall.setFunctionName("delete");
deleteCall.setProperty("fileName", "employee.xml");
deleteCall.setXQueryString("employee[first-name='#first-name/text()']");
descriptor.getQueryManager().setDeleteCall(deleteCall);
// Update
XQueryInteraction updateCall = new XQueryInteraction();
updateCall.setFunctionName("update");
updateCall.setProperty("fileName", "employee.xml");
updateCall.setXQueryString("employee[first-name='#first-name/text()']");
descriptor.getQueryManager().setUpdateCall(updateCall);
return descriptor;
}