/**
* Generates DatabaseTableVos for DirectDatabaseAccessor to create Aggregation-Tables as defined
* in aggregation-definition.
*
* @param aggregationDefinition aggregationDefinition binding object.
* @return Collection Returns Collection with DatabaseTableVo.
* @throws SqlDatabaseSystemException e
*/
private Collection<DatabaseTableVo> generateAggregationDatabaseTableVos(
final AggregationDefinition aggregationDefinition) throws SqlDatabaseSystemException {
final Collection<DatabaseTableVo> databaseTableVos = new ArrayList<DatabaseTableVo>();
for (final AggregationTable aggregationTable : aggregationDefinition.getAggregationTables()) {
final DatabaseTableVo databaseTableVo = new DatabaseTableVo();
databaseTableVo.setTableName(aggregationTable.getName().toLowerCase(Locale.ENGLISH));
// Generate Fields
final Collection<DatabaseTableFieldVo> databaseFieldVos =
new ArrayList<DatabaseTableFieldVo>();
// sort AggregationTableFields
final Collection<AggregationTableField> sortedAggregationTableFields =
new TreeSet<AggregationTableField>(new AggregationTableFieldComparator());
sortedAggregationTableFields.addAll(aggregationTable.getAggregationTableFields());
for (final AggregationTableField field : sortedAggregationTableFields) {
final DatabaseTableFieldVo databaseTableFieldVo = new DatabaseTableFieldVo();
if (field.getFieldTypeId() == Constants.COUNT_CUMULATION_FIELD_ID
|| field.getFieldTypeId() == Constants.DIFFERENCE_CUMULATION_FIELD_ID
|| field.getFieldTypeId() == Constants.TIME_REDUCTION_FIELD_ID) {
dbAccessor.checkReservedExpressions(field.getName());
databaseTableFieldVo.setFieldName(field.getName().toLowerCase(Locale.ENGLISH));
databaseTableFieldVo.setFieldType(Constants.DATABASE_FIELD_TYPE_NUMERIC);
} else if (field.getFieldTypeId() == Constants.INFO_FIELD_ID) {
dbAccessor.checkReservedExpressions(field.getName());
databaseTableFieldVo.setFieldName(field.getName().toLowerCase(Locale.ENGLISH));
databaseTableFieldVo.setFieldType(field.getDataType());
} else {
throw new SqlDatabaseSystemException(
"Table-Fields may not be empty in aggregation definition");
}
databaseFieldVos.add(databaseTableFieldVo);
}
databaseTableVo.setDatabaseFieldVos(databaseFieldVos);
// Generate Indexes
if (aggregationTable.getAggregationTableIndexes() != null
&& !aggregationTable.getAggregationTableIndexes().isEmpty()) {
final Collection<DatabaseIndexVo> databaseIndexVos = new ArrayList<DatabaseIndexVo>();
for (final AggregationTableIndexe index : aggregationTable.getAggregationTableIndexes()) {
final DatabaseIndexVo databaseIndexVo = new DatabaseIndexVo();
databaseIndexVo.setIndexName(index.getName().toLowerCase(Locale.ENGLISH));
final Collection<String> indexFields = new ArrayList<String>();
if (index.getAggregationTableIndexFields() != null) {
// sort AggregationTableIndexFields
final Collection<AggregationTableIndexField> sortedAggregationTableIndexFields =
new TreeSet<AggregationTableIndexField>(new AggregationTableIndexFieldComparator());
sortedAggregationTableIndexFields.addAll(index.getAggregationTableIndexFields());
for (final AggregationTableIndexField indexField : sortedAggregationTableIndexFields) {
indexFields.add(indexField.getField());
}
}
databaseIndexVo.setFields(indexFields);
databaseIndexVos.add(databaseIndexVo);
}
databaseTableVo.setDatabaseIndexVos(databaseIndexVos);
}
databaseTableVos.add(databaseTableVo);
}
return databaseTableVos;
}
