use of org.obeonetwork.dsl.database.Table in project InformationSystem by ObeoNetwork.
the class TableServicesTest method allColumnTest.
@Test
public void allColumnTest() {
Table table = getGSSerieTable();
System.out.println(table.getName());
assertEquals(10, new TableServices().allColumns(table).size());
}
use of org.obeonetwork.dsl.database.Table in project InformationSystem by ObeoNetwork.
the class TableServicesTest method noPrimaryKeyNameTest.
@Test
public void noPrimaryKeyNameTest() {
Table table = (Table) EcoreUtil.create(DatabasePackage.eINSTANCE.getTable());
assertEquals("", new TableServices().primaryKeyName(table));
}
use of org.obeonetwork.dsl.database.Table in project InformationSystem by ObeoNetwork.
the class EntityToMLD method processNamespaceAndCreateAdditionalFields.
private void processNamespaceAndCreateAdditionalFields(Namespace namespace) {
// create tables
for (Entity entity : EntityUtils.getEntitiesInNamespace(namespace)) {
// Create technical fields
Table table = getFromOutputTraceabilityMap(entity, DatabasePackage.Literals.TABLE);
createAdditionalFields(table);
}
// process sub-namespaces
for (Namespace subnamespace : namespace.getOwnedNamespaces()) {
processNamespaceAndCreateAdditionalFields(subnamespace);
}
}
use of org.obeonetwork.dsl.database.Table in project InformationSystem by ObeoNetwork.
the class EntityToMLD method createIndices.
private void createIndices(Entity entity) {
Table table = getFromOutputTraceabilityMap(entity, DatabasePackage.Literals.TABLE);
// We collect unique and non unique indices, all indices will be kept unchanged
Collection<Index> existingUniqueIndices = new ArrayList<Index>();
Collection<Index> existingNonUniqueIndices = new ArrayList<Index>();
for (Index index : table.getIndexes()) {
if (index.isUnique()) {
existingUniqueIndices.add(index);
} else {
existingNonUniqueIndices.add(index);
}
}
// Handle indexes on attributes
for (Attribute attribute : entity.getOwnedAttributes()) {
String unicity = AnnotationHelper.getPhysicalUnique(attribute);
if (unicity != null) {
List<Column> columns = new ArrayList<Column>();
Column column = getFromOutputTraceabilityMap(attribute, DatabasePackage.Literals.COLUMN);
columns.add(column);
Index index = findIndex(existingUniqueIndices, columns);
if (index != null) {
// We reuse the existing index
index.getElements().get(0).setAsc(isIndexAsc(unicity));
} else {
// We have to create a new index
index = DatabaseFactory.eINSTANCE.createIndex();
table.getIndexes().add(index);
existingUniqueIndices.add(index);
index.setUnique(true);
IndexElement indexElement = DatabaseFactory.eINSTANCE.createIndexElement();
index.getElements().add(indexElement);
indexElement.setAsc(isIndexAsc(unicity));
indexElement.setColumn(column);
}
index.setName(getUniqueIndexName(index));
index.setComments(getUniqueIndexComments(index));
addToObjectsToBeKept(index);
}
}
// Handle indexes on entity
String tableUnicity = AnnotationHelper.getPhysicalUnique(entity);
if (tableUnicity != null) {
List<Map<String, Boolean>> listOfIndexInfos = getInfosFromTableUnicity(tableUnicity);
for (Map<String, Boolean> indexInfos : listOfIndexInfos) {
List<Column> columns = new ArrayList<Column>();
for (String columnName : indexInfos.keySet()) {
for (Column column : table.getColumns()) {
if (column.getName().equalsIgnoreCase(columnName)) {
columns.add(column);
break;
}
}
}
// Check if all columns were found
if (columns.size() != indexInfos.size()) {
String msg = "Could not understand PHYSICAL_UNIQUE annotation for Entity: " + entity.getName() + " - annotation: \"" + tableUnicity + "\"";
Activator.getDefault().getLog().log(new Status(IStatus.ERROR, Activator.PLUGIN_ID, msg));
}
// Try to retrieve an existing index on these columns
Index index = findIndex(existingUniqueIndices, columns);
if (index != null) {
// Update sort orders
for (IndexElement element : index.getElements()) {
element.setAsc(indexInfos.get(element.getColumn().getName().toUpperCase()));
}
} else {
// We have to create a new index
index = DatabaseFactory.eINSTANCE.createIndex();
table.getIndexes().add(index);
existingUniqueIndices.add(index);
index.setUnique(true);
for (Column targetColumn : columns) {
IndexElement indexElement = DatabaseFactory.eINSTANCE.createIndexElement();
index.getElements().add(indexElement);
String s = targetColumn.getName();
indexElement.setAsc(indexInfos.get(targetColumn.getName().toUpperCase()));
indexElement.setColumn(targetColumn);
}
}
index.setName(getUniqueIndexName(index));
index.setComments(getUniqueIndexComments(index));
addToObjectsToBeKept(index);
}
}
// Handle indexes on references
for (Reference reference : getReferencesForIndexCreation(entity)) {
boolean indexShouldBeUnique = false;
// if (isMultiplicitySimple(reference)) {
// indexShouldBeUnique = true;
// } else if (isMultiplicityMany(reference)) {
// indexShouldBeUnique = false;
// }
String unicity = AnnotationHelper.getPhysicalUnique(reference);
if (unicity == null) {
unicity = "ASC";
} else {
indexShouldBeUnique = true;
}
List<Column> columns = new ArrayList<Column>();
ForeignKey fk = getFromOutputTraceabilityMap(reference, DatabasePackage.Literals.FOREIGN_KEY);
// Get columns for FK
if (fk != null) {
for (ForeignKeyElement fkElt : fk.getElements()) {
columns.add(fkElt.getFkColumn());
}
Index index = null;
if (indexShouldBeUnique) {
index = findIndex(existingUniqueIndices, columns);
} else {
index = findIndex(existingNonUniqueIndices, columns);
}
if (index != null) {
// Ensure the index is of the right kind
index.setUnique(indexShouldBeUnique);
// We reuse the existing index
for (IndexElement indexElt : index.getElements()) {
indexElt.setAsc(isIndexAsc(unicity));
}
} else {
// We have to create a new index
index = DatabaseFactory.eINSTANCE.createIndex();
table.getIndexes().add(index);
if (indexShouldBeUnique) {
existingUniqueIndices.add(index);
} else {
existingNonUniqueIndices.add(index);
}
index.setUnique(indexShouldBeUnique);
for (ForeignKeyElement fkElt : fk.getElements()) {
IndexElement indexElement = DatabaseFactory.eINSTANCE.createIndexElement();
index.getElements().add(indexElement);
indexElement.setAsc(isIndexAsc(unicity));
indexElement.setColumn(fkElt.getFkColumn());
}
}
index.setName(fk.getName());
index.setComments(getFKIndexComments(index));
addToObjectsToBeKept(index);
}
}
}
use of org.obeonetwork.dsl.database.Table in project InformationSystem by ObeoNetwork.
the class EntityToMLD method handleMultipleForeignKeys.
private void handleMultipleForeignKeys(Table table) {
// multipleFKs contains foreign keys targetting a same table (the table is used as key)
Map<Table, List<ForeignKey>> multipleFKs = new HashMap<Table, List<ForeignKey>>();
for (ForeignKey fk : table.getForeignKeys()) {
for (ForeignKey otherFK : table.getForeignKeys()) {
Table targetTable = fk.getTargetTable();
if (fk != otherFK && targetTable == otherFK.getTargetTable()) {
if (multipleFKs.get(targetTable) == null) {
multipleFKs.put(targetTable, new ArrayList<ForeignKey>());
}
if (!multipleFKs.get(targetTable).contains(otherFK)) {
multipleFKs.get(targetTable).add(otherFK);
}
}
}
}
// Rename columns targetted by the FKs
for (List<ForeignKey> fks : multipleFKs.values()) {
int counter = 0;
// Sort FKs
List<ForeignKey> sortedFks = new ArrayList<ForeignKey>(fks);
Collections.sort(sortedFks, new Comparator<ForeignKey>() {
@Override
public int compare(ForeignKey fk1, ForeignKey fk2) {
return columnIndex(fk1.getElements().get(0).getFkColumn()) - columnIndex(fk2.getElements().get(0).getFkColumn());
}
private int columnIndex(Column column) {
return column.getOwner().getColumns().indexOf(column);
}
});
for (ForeignKey fk : sortedFks) {
counter = counter + 1;
for (ForeignKeyElement fkElt : fk.getElements()) {
fkElt.getFkColumn().getOwner().getColumns().indexOf(fkElt.getFkColumn());
fkElt.getFkColumn().setName(getFKColumnName(fkElt, counter));
}
}
}
}
Aggregations