public void initializeCompanyDescriptor() {
MWTableDescriptor descriptor = getCompanyDescriptor();
MWTable table = tableNamed("COMPANY");
descriptor.setPrimaryTable(table);
descriptor.getCachingPolicy().setCacheType(MWCachingPolicy.CACHE_TYPE_FULL);
descriptor.getCachingPolicy().setCacheSize(100);
// sequencing
descriptor.setUsesSequencing(true);
descriptor.setSequenceNumberName("SEQ");
descriptor.setSequenceNumberTable(table);
descriptor.setSequenceNumberColumn(table.columnNamed("ID"));
// direct to field mapping
addDirectMapping(descriptor, "id", table, "ID");
addDirectMapping(descriptor, "name", table, "NAME");
// 1-many mappings
MWOneToManyMapping vehiclesMapping =
descriptor.addOneToManyMapping(descriptor.getMWClass().attributeNamed("vehicles"));
vehiclesMapping.setReferenceDescriptor(getVehicleDescriptor());
vehiclesMapping.setReference(
getVehicleDescriptor().getPrimaryTable().referenceNamed("VEHICLE_COMPANY"));
vehiclesMapping.setPrivateOwned(true);
}
public void initializePersonDescriptor() {
MWTableDescriptor descriptor = getPersonDescriptor();
MWTable table = tableNamed("PERSON2");
descriptor.setPrimaryTable(table);
descriptor.getCachingPolicy().setCacheType(MWCachingPolicy.CACHE_TYPE_FULL);
descriptor.getCachingPolicy().setCacheSize(100);
// sequencing
descriptor.setUsesSequencing(true);
descriptor.setSequenceNumberName("SEQ");
descriptor.setSequenceNumberTable(table);
descriptor.setSequenceNumberColumn(table.columnNamed("ID"));
descriptor.addInheritancePolicy();
MWRelationalDescriptorInheritancePolicy inheritancePolicy =
(MWRelationalDescriptorInheritancePolicy) descriptor.getInheritancePolicy();
inheritancePolicy.setReadSubclassesOnQuery(false);
((MWRelationalClassIndicatorFieldPolicy) inheritancePolicy.getClassIndicatorPolicy())
.setField(table.columnNamed("C_TYPE"));
((MWRelationalClassIndicatorFieldPolicy) inheritancePolicy.getClassIndicatorPolicy())
.setClassNameIsIndicator(true);
// direct to field mappings
addDirectMapping(descriptor, "id", table, "ID");
addDirectMapping(descriptor, "name", table, "NAME");
// 1-1 mappings
MWOneToOneMapping bestFriendMapping =
descriptor.addOneToOneMapping(descriptor.getMWClass().attributeNamed("bestFriend"));
bestFriendMapping.setReferenceDescriptor(getEngineerDescriptor());
bestFriendMapping.setReference(
getEngineerDescriptor().getPrimaryTable().referenceNamed("PERSON2_PERSON22"));
MWOneToOneMapping carMapping =
descriptor.addOneToOneMapping(descriptor.getMWClass().attributeNamed("car"));
carMapping.setReferenceDescriptor(getCarDescriptor());
carMapping.setReference(table.referenceNamed("PERSON2_CAR"));
carMapping.setPrivateOwned(true);
MWOneToOneMapping representitiveMapping =
descriptor.addOneToOneMapping(descriptor.getMWClass().attributeNamed("representitive"));
representitiveMapping.setReferenceDescriptor(getSalesRepDescriptor());
representitiveMapping.setReference(table.referenceNamed("PERSON2_PERSON23"));
}
protected void initializeExchangeRateDescriptor() {
MWClass exchangeRateClass =
refreshedTypeNamed(
"org.eclipse.persistence.tools.workbench.test.models.currency.ExchangeRate");
MWTable exchangeRateTable = getProject().getDatabase().tableNamed("EXCHANGE_RATE");
MWTableDescriptor descriptor;
try {
descriptor = (MWTableDescriptor) getProject().addDescriptorForType(exchangeRateClass);
} catch (InterfaceDescriptorCreationException e) {
throw new RuntimeException(e);
}
descriptor.setPrimaryTable(exchangeRateTable);
// Caching Policy
descriptor.getCachingPolicy().setCacheSize(405);
descriptor.getCachingPolicy().setCacheType(MWCachingPolicy.CACHE_TYPE_FULL);
descriptor
.getCachingPolicy()
.setExistenceChecking(MWCachingPolicy.EXISTENCE_CHECKING_CHECK_DATABASE);
// Direct to field mappings
addDirectMapping(descriptor, "id", exchangeRateTable, "ID");
addDirectMapping(descriptor, "periodLength", exchangeRateTable, "PERIOD");
// Aggregate mappings
MWAggregateMapping currencyRangeMapping =
descriptor.addAggregateMapping(descriptor.getMWClass().attributeNamed("currencyRange"));
MWClass currencyRangeClass =
refreshedTypeNamed(
"org.eclipse.persistence.tools.workbench.test.models.currency.CurrencyRange");
MWAggregateDescriptor currencyRangeDescriptor =
(MWAggregateDescriptor) getProject().descriptorForType(currencyRangeClass);
currencyRangeMapping.setReferenceDescriptor(currencyRangeDescriptor);
Iterator fieldAssociations =
CollectionTools.sort(currencyRangeMapping.pathsToFields()).iterator();
String[] fieldNames = new String[] {"HI_UNIT", "HI_VALUE", "LO_UNIT", "LO_VALUE", "TREND"};
for (int i = 0; i < fieldNames.length; i++) {
MWAggregatePathToColumn association = (MWAggregatePathToColumn) fieldAssociations.next();
association.setColumn(exchangeRateTable.columnNamed(fieldNames[i]));
}
}
public void initializeComputerDescriptor() {
MWTableDescriptor descriptor = getComputerDescriptor();
MWTable table = tableNamed("INH_COMP");
descriptor.setPrimaryTable(table);
descriptor.getCachingPolicy().setCacheType(MWCachingPolicy.CACHE_TYPE_FULL);
descriptor.getCachingPolicy().setCacheSize(100);
// sequencing
descriptor.setUsesSequencing(true);
descriptor.setSequenceNumberName("SEQ");
descriptor.setSequenceNumberTable(table);
descriptor.setSequenceNumberColumn(table.columnNamed("ID"));
// afterload policy
descriptor.addAfterLoadingPolicy();
MWClass postLoadClass =
typeNamed(
"org.eclipse.persistence.tools.workbench.test.models.complexinheritance.Computer");
((MWDescriptorAfterLoadingPolicy) descriptor.getAfterLoadingPolicy())
.setPostLoadMethodClass(postLoadClass);
((MWDescriptorAfterLoadingPolicy) descriptor.getAfterLoadingPolicy())
.setPostLoadMethod(methodNamed(postLoadClass, "addToDescriptor"));
// inheritance policy
descriptor.addInheritancePolicy();
MWRelationalDescriptorInheritancePolicy inheritancePolicy =
(MWRelationalDescriptorInheritancePolicy) descriptor.getInheritancePolicy();
inheritancePolicy.useClassExtractionMethodIndicatorPolicy();
((MWClassIndicatorExtractionMethodPolicy) inheritancePolicy.getClassIndicatorPolicy())
.setClassExtractionMethod(methodNamed(descriptor.getMWClass(), "getClassFromRow"));
// direct to field mapping
addDirectMapping(descriptor, "id", table, "ID");
addDirectMapping(descriptor, "manufacturer", table, "MANUFAC");
addDirectMapping(descriptor, "memory", table, "MEMORY");
addDirectMapping(descriptor, "processorMake", table, "MAKE");
addDirectMapping(descriptor, "processorSpeed", table, "SPEED");
}
protected void initializeCommodityPriceDescriptor() {
MWClass commodityPriceClass =
refreshedTypeNamed(
"org.eclipse.persistence.tools.workbench.test.models.currency.CommodityPrice");
MWTableDescriptor descriptor;
try {
descriptor = (MWTableDescriptor) getProject().addDescriptorForType(commodityPriceClass);
} catch (InterfaceDescriptorCreationException e) {
throw new RuntimeException(e);
}
MWTable table = tableNamed("COMMODITY_PRICE");
descriptor.setPrimaryTable(table);
descriptor.setActive(true);
// Direct to field mappings
addDirectMapping(descriptor, "id", table, "ID");
addDirectMapping(descriptor, "type", table, "TYPE");
addDirectMapping(descriptor, "periodLength", table, "PERIOD");
// Aggregate mappings
MWAggregateMapping currencyRangeMapping =
descriptor.addAggregateMapping(descriptor.getMWClass().attributeNamed("currencyRange"));
MWClass currencyRangeClass =
refreshedTypeNamed(
"org.eclipse.persistence.tools.workbench.test.models.currency.CurrencyRange");
currencyRangeMapping.setReferenceDescriptor(getProject().descriptorForType(currencyRangeClass));
Iterator fieldAssociations =
CollectionTools.sort(currencyRangeMapping.pathsToFields()).iterator();
String[] fieldNames =
new String[] {"HIGH_UNIT", "HIGH_VALUE", "LOW_UNIT", "LOW_VALUE", "TREND"};
for (int i = 0; i < fieldNames.length; i++) {
MWAggregatePathToColumn association = (MWAggregatePathToColumn) fieldAssociations.next();
association.setColumn(table.columnNamed(fieldNames[i]));
}
}
public void initializeVehicleDescriptor() {
MWTableDescriptor descriptor = getVehicleDescriptor();
MWTable table = tableNamed("VEHICLE");
descriptor.setPrimaryTable(table);
descriptor.getCachingPolicy().setCacheType(MWCachingPolicy.CACHE_TYPE_FULL);
descriptor.getCachingPolicy().setCacheSize(100);
// sequencing
descriptor.setUsesSequencing(true);
descriptor.setSequenceNumberName("SEQ");
descriptor.setSequenceNumberTable(table);
descriptor.setSequenceNumberColumn(table.columnNamed("ID"));
// inheritance policy
descriptor.addInheritancePolicy();
MWRelationalDescriptorInheritancePolicy inheritancePolicy =
(MWRelationalDescriptorInheritancePolicy) descriptor.getInheritancePolicy();
MWRelationalClassIndicatorFieldPolicy classIndicatorPolicy =
(MWRelationalClassIndicatorFieldPolicy) inheritancePolicy.getClassIndicatorPolicy();
classIndicatorPolicy.setIndicatorType(
new MWTypeDeclaration(classIndicatorPolicy, typeFor(java.lang.String.class)));
classIndicatorPolicy.setField(table.columnNamed("TYPE"));
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getVehicleDescriptor())
.setInclude(false);
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getNonFueledVehicleDescriptor())
.setIndicatorValue("2");
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getFueledVehicleDescriptor())
.setIndicatorValue("1");
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getBusDescriptor())
.setIndicatorValue("3");
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getCarDescriptor())
.setIndicatorValue("4");
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getBicycleDescriptor())
.setIndicatorValue("6");
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getSportsCarDescriptor())
.setIndicatorValue("5");
classIndicatorPolicy
.getClassIndicatorValueForDescriptor(getBoatDescriptor())
.setIndicatorValue("7");
// direct to field mappings
addDirectMapping(descriptor, "id", table, "ID");
addDirectMapping(descriptor, "passengerCapacity", table, "CAPACITY");
// 1-1 mappings
MWOneToOneMapping ownerMapping =
descriptor.addOneToOneMapping(descriptor.getMWClass().attributeNamed("owner"));
ownerMapping.setReferenceDescriptor(getCompanyDescriptor());
ownerMapping.setReference(table.referenceNamed("VEHICLE_COMPANY"));
}