org.plasma.text.ddl.DDLModelAssembler Maven / Gradle / Ivy
/**
* PlasmaSDO™ License
*
* This is a community release of PlasmaSDO™, a dual-license
* Service Data Object (SDO) 2.1 implementation.
* This particular copy of the software is released under the
* version 2 of the GNU General Public License. PlasmaSDO™ was developed by
* TerraMeta Software, Inc.
*
* Copyright (c) 2013, TerraMeta Software, Inc. All rights reserved.
*
* General License information can be found below.
*
* This distribution may include materials developed by third
* parties. For license and attribution notices for these
* materials, please refer to the documentation that accompanies
* this distribution (see the "Licenses for Third-Party Components"
* appendix) or view the online documentation at
* > schemaMap = new HashMap>();
public DDLModelAssembler() {
this(PlasmaRepository.getInstance().getAllNamespaces());
}
public DDLModelAssembler(List namespaces) {
schemas = new Schemas();
// load maps
for (Namespace namespace : namespaces) {
log.debug("processing namespace: " + namespace.getUri());
if (!PlasmaConfig.getInstance().hasNamespace(DataStoreType.RDBMS))
{
log.debug("ignoring non "+DataStoreType.RDBMS.name()+" namespace: " + namespace.getUri());
continue;
}
List types = PlasmaTypeHelper.INSTANCE.getTypes(namespace.getUri());
for (Type type : types) {
PlasmaType plasmaType = (PlasmaType)type;
if (plasmaType.getPhysicalName() == null || plasmaType.getPhysicalName().length() == 0)
continue;
Map typeMap = schemaMap.get(namespace.getPhysicalName());
if (typeMap == null) {
typeMap = new HashMap();
schemaMap.put(namespace.getPhysicalName(), typeMap);
}
typeMap.put(plasmaType.getPhysicalName(), plasmaType);
}
}
// create
for (String schemaName : schemaMap.keySet()) {
Schema schema = createSchema(schemaName);
Map typeMap = schemaMap.get(schemaName);
for (PlasmaType type : typeMap.values()) {
Table table = createTable(schema, type);
schema.getTables().add(table);
List properties = type.getProperties(); // returns all base type(s) props as well
Map map = new HashMap();
for (Property p : properties)
map.put(p, p);
createColumns(schema, table, type, map.values());
createPriKey(table, map.values());
Class_ repositoryClass = (Class_)type.getClassifier();
List ddlBehaviors = repositoryClass.getOpaqueBehaviors("DDL");
createBehaviors(table, ddlBehaviors);
List sqlBehaviors = repositoryClass.getOpaqueBehaviors("SQL");
createBehaviors(table, sqlBehaviors);
createForeignConstraints(table, type, map.values());
createUniqueConstraints(table, map.values());
createCheckConstraints(table, map.values());
createIndexes(table, map.values());
}
}
}
private void createIndexes(Table table, Collection properties)
{
int i = 1;
for (Property prop : properties) {
PlasmaProperty plasmaProperty = (PlasmaProperty)prop;
if (plasmaProperty.getPhysicalName() == null)
continue;
if (plasmaProperty.getType().isDataType())
continue;
Index index = new Index();
index.setName("I_" + table.getName() + String.valueOf(i));
index.setColumn(plasmaProperty.getPhysicalName());
table.getIndices().add(index);
i++;
}
}
private void createCheckConstraints(Table table, Collection properties)
{
int i = 1;
for (Property prop : properties) {
PlasmaProperty plasmaProperty = (PlasmaProperty)prop;
if (plasmaProperty.getPhysicalName() == null)
continue;
if (!plasmaProperty.getType().isDataType())
continue;
if (plasmaProperty.getRestriction() == null)
continue;
Check check = new Check();
check.setName("CK_" + table.getName() + "_" + String.valueOf(i));
check.setColumn(plasmaProperty.getPhysicalName());
table.getChecks().add(check);
Enumeration restriction = plasmaProperty.getRestriction();
for (EnumerationLiteral lit : restriction.getOwnedLiteral()) {
check.getValues().add(lit.getPhysicalName());
}
i++;
}
}
private void createUniqueConstraints(Table table, Collection properties)
{
int uniqueCount = 0;
for (Property prop : properties) {
PlasmaProperty plasmaProperty = (PlasmaProperty)prop;
if (plasmaProperty.getPhysicalName() == null)
continue;
if (plasmaProperty.getKey() != null &&
plasmaProperty.getKey().getType().ordinal() == KeyType.primary.ordinal()) {
continue; // already unique
}
Boolean isUnique = (Boolean)plasmaProperty.get(PlasmaProperty.INSTANCE_PROPERTY_BOOLEAN_ISUNIQUE);
if (isUnique != null && isUnique.booleanValue())
uniqueCount++;
}
if (uniqueCount > 0) {
Unique unique = new Unique();
unique.setName("UK_" + table.getName());
table.getUniques().add(unique);
int i = 1;
for (Property prop : properties) {
PlasmaProperty plasmaProperty = (PlasmaProperty)prop;
if (plasmaProperty.getPhysicalName() == null)
continue;
if (plasmaProperty.getKey() != null &&
plasmaProperty.getKey().getType().ordinal() == KeyType.primary.ordinal()) {
continue; // already unique
}
Boolean isUnique = (Boolean)plasmaProperty.get(PlasmaProperty.INSTANCE_PROPERTY_BOOLEAN_ISUNIQUE);
if (isUnique == null || !isUnique.booleanValue())
continue;
On on = new On();
on.setColumn(plasmaProperty.getPhysicalName());
unique.getOns().add(on);
i++;
}
}
}
private void createForeignConstraints(Table table, PlasmaType plasmaType,
Collection properties)
{
int i = 1;
for (Property prop : properties) {
PlasmaProperty plasmaProperty = (PlasmaProperty)prop;
if (plasmaProperty.getPhysicalName() == null) {
if (!plasmaProperty.isMany())
log.warn("no physical name found for singular property, "
+ plasmaProperty.getContainingType().getURI() + "#"
+ plasmaProperty.getContainingType().getName() + "."
+ plasmaProperty.getName());
continue;
}
if (plasmaProperty.getType().isDataType())
continue;
Fk fk = new Fk();
fk.setName("FK_" + table.getName() + String.valueOf(i));
fk.setColumn(plasmaProperty.getPhysicalName());
Type oppositeType = plasmaProperty.getType();
if (!oppositeType.isAbstract()) {
fk.setToTable(((PlasmaType)oppositeType).getPhysicalName());
}
else // FIXME: collapse all references in abstract classes into subclass
{
fk.setToTable(plasmaType.getPhysicalName());
}
table.getFks().add(fk);
i++;
}
}
private void createBehaviors(Table table, List behaviors)
{
for (OpaqueBehavior behavior : behaviors) {
BehaviorType type = null;
try {
type = BehaviorType.fromValue(behavior.getName());
}
catch (IllegalArgumentException e) {
throw new DDLException("unknown behavior name '"
+ behavior.getName()
+ "' - expected one of ["
+ BehaviorType.values() + "]");
}
Behavior ddlBehavior = new Behavior();
ddlBehavior.setType(type);
ddlBehavior.setValue(behavior.getBody());
table.getBehaviors().add(ddlBehavior);
}
}
private void createColumns(Schema schema, Table table, PlasmaType plasmaType,
Collection properties)
{
for (Property prop : properties) {
PlasmaProperty plasmaProperty = (PlasmaProperty)prop;
if (plasmaProperty.getPhysicalName() == null) {
if (!plasmaProperty.isMany())
log.warn("no physical name found for singular property, "
+ plasmaProperty.getContainingType().getURI() + "#"
+ plasmaProperty.getContainingType().getName() + "."
+ plasmaProperty.getName());
continue;
}
Column column = createColumn(schema, table,
plasmaType,
plasmaProperty);
table.getColumns().add(column);
}
}
private void createPriKey(Table table, Collection properties) {
for (Property prop : properties) {
PlasmaProperty plasmaProperty = (PlasmaProperty)prop;
if (plasmaProperty.getPhysicalName() == null)
continue;
if (!plasmaProperty.isKey(KeyType.primary))
continue;
Pk pk = table.getPk();
if (pk == null) {
pk = createPk(table, plasmaProperty);
table.setPk(pk);
}
On on = new On();
on.setColumn(plasmaProperty.getPhysicalName());
table.getPk().getOns().add(on);
}
}
private Pk createPk(Table table, PlasmaProperty plasmaProperty) {
Pk pk = new Pk();
pk.setName("PK_" + table.getName());
return pk;
}
private Column createColumn(Schema schema, Table table, PlasmaType plasmaType,
PlasmaProperty plasmaProperty) {
Column column = new Column();
column.setName(plasmaProperty.getPhysicalName());
column.setNullable(plasmaProperty.isNullable());
if (plasmaProperty.getMaxLength() > 0)
column.setSize(plasmaProperty.getMaxLength());
else
column.setSize(-1);
if (plasmaProperty.getType().isDataType()) {
DataType sdoType = DataType.valueOf(plasmaProperty.getType().getName());
column.setType(sdoType.name());
}
else {
PlasmaProperty oppositePkProp = null;
// FIXME: assumes a single PK !!
if (!plasmaProperty.getType().isAbstract()) {
for (Property p : plasmaProperty.getType().getProperties()) {
PlasmaProperty oppositeProp = (PlasmaProperty)p;
if (oppositeProp.isKey(KeyType.primary)) {
if (oppositePkProp != null)
throw new DDLException("multiple opposite pri-key propertys found for '"
+ plasmaProperty.getContainingType().getURI() + "#"
+ plasmaProperty.getContainingType().getName() + "."
+ plasmaProperty.getName() + "'");
oppositePkProp = (PlasmaProperty)oppositeProp;
}
}
}
else {
oppositePkProp = (PlasmaProperty)plasmaType.findProperty(
KeyType.primary);
}
if (oppositePkProp == null)
throw new DDLException("could not find opposite pri-key property for '"
+ plasmaProperty.getContainingType().getURI() + "#"
+ plasmaProperty.getContainingType().getName() + "."
+ plasmaProperty.getName() + "'");
DataType sdoType = DataType.valueOf(oppositePkProp.getType().getName());
column.setType(sdoType.name());
}
return column;
}
private Table createTable(Schema schema, PlasmaType plasmaType) {
Table table = new Table();
table.setName(plasmaType.getPhysicalName());
return table;
}
private Schema createSchema(String name) {
Schema schema = new Schema();
this.schemas.getSchemas().add(schema);
schema.setName(name);
return schema;
}
public Schemas getSchemas() {
return this.schemas;
}
/*
private JDBCType mapType(DataType dataType) {
switch (dataType) {
case Boolean:
return JDBCType.BOOLEAN;
case Byte:
return JDBCType.TINYINT;
case Bytes:
return JDBCType.VARBINARY;
case Character:
return JDBCType.CHAR;
case Decimal:
return JDBCType.DECIMAL;
case Double:
return JDBCType.DOUBLE;
case Float:
return JDBCType.FLOAT;
case Short:
return JDBCType.SMALLINT;
case Int:
return JDBCType.INTEGER;
case Integer:
case Long:
return JDBCType.BIGINT;
case String:
case Strings:
case URI:
return JDBCType.VARCHAR;
case Object:
return JDBCType.VARBINARY;
case Date:
return JDBCType.DATE;
case DateTime:
return JDBCType.TIMESTAMP;
case Time:
return JDBCType.TIME;
case Day:
case Duration:
case Month:
case MonthDay:
case Year:
case YearMonth:
case YearMonthDay:
default:
throw new DDLException("unsupported SDO type, "
+ dataType.toString());
}
}
*/
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy