protected String buildFieldOperand(Operand operand, Query query, Map entityAliasesMaps) {
String operandElement;
IModelField datamartField;
IModelEntity rootEntity;
String queryName;
String rootEntityAlias;
Map targetQueryEntityAliasesMap;
logger.debug("IN");
try {
targetQueryEntityAliasesMap = (Map) entityAliasesMaps.get(query.getId());
Assert.assertNotNull(
targetQueryEntityAliasesMap,
"Entity aliases map for query ["
+ query.getId()
+ "] cannot be null in order to execute method [buildUserProvidedWhereField]");
datamartField =
parentStatement.getDataSource().getModelStructure().getField(operand.values[0]);
Assert.assertNotNull(
datamartField, "DataMart does not cantain a field named [" + operand.values[0] + "]");
Couple queryNameAndRoot = datamartField.getQueryName();
queryName = (String) queryNameAndRoot.getFirst();
logger.debug("select field query name [" + queryName + "]");
if (queryNameAndRoot.getSecond() != null) {
rootEntity = (IModelEntity) queryNameAndRoot.getSecond();
} else {
rootEntity = datamartField.getParent().getRoot();
}
logger.debug("where field query name [" + queryName + "]");
logger.debug("where field root entity unique name [" + rootEntity.getUniqueName() + "]");
if (!targetQueryEntityAliasesMap.containsKey(rootEntity.getUniqueName())) {
logger.debug("Entity [" + rootEntity.getUniqueName() + "] require a new alias");
rootEntityAlias =
getEntityAlias(rootEntity, targetQueryEntityAliasesMap, entityAliasesMaps);
logger.debug("A new alias has been generated [" + rootEntityAlias + "]");
}
rootEntityAlias = (String) targetQueryEntityAliasesMap.get(rootEntity.getUniqueName());
logger.debug("where field root entity alias [" + rootEntityAlias + "]");
if (operand instanceof HavingField.Operand) {
HavingField.Operand havingFieldOperand = (HavingField.Operand) operand;
IAggregationFunction function = havingFieldOperand.function;
operandElement = function.apply(parentStatement.getFieldAlias(rootEntityAlias, queryName));
} else {
operandElement = parentStatement.getFieldAlias(rootEntityAlias, queryName);
}
logger.debug("where element operand value [" + operandElement + "]");
} finally {
logger.debug("OUT");
}
return operandElement;
}
protected String buildParentFieldOperand(Operand operand, Query query, Map entityAliasesMaps) {
String operandElement;
String[] chunks;
String parentQueryId;
String fieldName;
IModelField datamartField;
IModelEntity rootEntity;
String queryName;
String rootEntityAlias;
logger.debug("IN");
try {
// it comes directly from the client side GUI. It is a composition of the parent query id and
// filed name,
// separated by a space
logger.debug("operand is equals to [" + operand.values[0] + "]");
chunks = operand.values[0].split(" ");
Assert.assertTrue(
chunks.length >= 2,
"Operand ["
+ chunks.toString()
+ "] does not contains enougth informations in order to resolve the reference to parent field");
parentQueryId = chunks[0];
logger.debug("where right-hand field belonging query [" + parentQueryId + "]");
fieldName = chunks[1];
logger.debug("where right-hand field unique name [" + fieldName + "]");
datamartField = parentStatement.getDataSource().getModelStructure().getField(fieldName);
Assert.assertNotNull(
datamartField, "DataMart does not cantain a field named [" + fieldName + "]");
Couple queryNameAndRoot = datamartField.getQueryName();
queryName = (String) queryNameAndRoot.getFirst();
logger.debug("select field query name [" + queryName + "]");
if (queryNameAndRoot.getSecond() != null) {
rootEntity = (IModelEntity) queryNameAndRoot.getSecond();
} else {
rootEntity = datamartField.getParent().getRoot();
}
logger.debug("where right-hand field query name [" + queryName + "]");
logger.debug(
"where right-hand field root entity unique name [" + rootEntity.getUniqueName() + "]");
Map parentEntityAliases = (Map) entityAliasesMaps.get(parentQueryId);
if (parentEntityAliases != null) {
if (!parentEntityAliases.containsKey(rootEntity.getUniqueName())) {
Assert.assertUnreachable(
"Filter of subquery ["
+ query.getId()
+ "] refers to a non "
+ "existing parent query ["
+ parentQueryId
+ "] entity ["
+ rootEntity.getUniqueName()
+ "]");
}
rootEntityAlias = (String) parentEntityAliases.get(rootEntity.getUniqueName());
} else {
rootEntityAlias = "unresoved_alias";
logger.warn(
"Impossible to get aliases map for parent query ["
+ parentQueryId
+ "]. Probably the parent query ha not been compiled yet");
logger.warn(
"Query ["
+ query.getId()
+ "] refers entities of its parent query ["
+ parentQueryId
+ "] so the generated statement wont be executable until the parent query will be compiled");
}
logger.debug("where right-hand field root entity alias [" + rootEntityAlias + "]");
operandElement = parentStatement.getFieldAlias(rootEntityAlias, queryName);
logger.debug("where element right-hand field value [" + operandElement + "]");
} finally {
logger.debug("OUT");
}
return operandElement;
}