private IModelField getColumnModelField(Column column, IModelEntity entity) { if (column.getSubEntity() != null) { // in case it is a subEntity attribute, look for the field inside it // In order to recover subentities the new way if DEFAULT_MAX_RECURSION_LEVEL is set to zero /* QbeEngineInstance engineInstance = getEngineInstance(); QbeTemplate template = engineInstance.getTemplate(); // takes the only datamart's name configured String modelName = (String) template.getDatamartNames().get(0); IModelStructure md = getDataSource().getModelStructure(); IModelEntity subEntity = md.getEntity(column.getSubEntity()); */ String entityUName = entity.getUniqueName(); String subEntityKey = entityUName.substring(0, entityUName.lastIndexOf("::")) + "::" + column.getSubEntity() + "(" + column.getForeignKey() + ")"; IModelEntity subEntity = entity.getSubEntity(subEntityKey); if (subEntity == null) { throw new SpagoBIEngineServiceException( getActionName(), "Sub-entity [" + column.getSubEntity() + "] not found in entity [" + entity.getName() + "]!"); } entity = subEntity; } logger.debug( "Looking for attribute " + column.getField() + " in entity " + entity.getName() + " ..."); List<IModelField> fields = entity.getAllFields(); Iterator<IModelField> it = fields.iterator(); while (it.hasNext()) { IModelField field = it.next(); if (field.getName().equals(column.getField())) { return field; } } return null; }
private void getMandatoryMetadata(Column column) { try { // mandatory management String mandatoryColumn = column.getMandatoryColumn(); String mandatoryValue = column.getMandatoryValue(); JSONObject mandatory = new JSONObject(); if (mandatoryColumn != null && mandatoryValue != null) { mandatory.put("mandatoryColumn", mandatoryColumn); mandatory.put("mandatoryValue", mandatoryValue); mandatory.put("column", column.getField()); mandatories.put(mandatory); } } catch (JSONException e) { logger.error("Error getting mandatory informations from template " + e.getMessage()); } }
private void getColumnsInfos(Column column) { try { Integer size = column.getSize(); String sizeColumn = column.getField(); boolean unsigned = column.isUnsigned(); JSONObject infoObj = new JSONObject(); infoObj.putOpt("sizeColumn", sizeColumn); infoObj.putOpt("size", size); infoObj.putOpt("unsigned", unsigned); if (size != null || unsigned != false) { columnsInfos.put(infoObj); } } catch (JSONException e) { logger.error("Error getting size column informations from template " + e.getMessage()); } }
private Query buildQuery() { logger.debug("IN"); Query query = null; try { QbeEngineInstance qbeEngineInstance = getEngineInstance(); Map env = qbeEngineInstance.getEnv(); query = new Query(); query.setDistinctClauseEnabled(false); IModelEntity entity = getSelectedEntity(); QbeEngineInstance engineInstance = getEngineInstance(); QbeTemplate template = engineInstance.getTemplate(); registryConfig = (RegistryConfiguration) template.getProperty("registryConfiguration"); List<Column> columns = registryConfig.getColumns(); columnMaxSize = registryConfig.getColumnsMaxSize(); Iterator<Column> it = columns.iterator(); Map<String, String> fieldNameIdMap = new HashMap<String, String>(); while (it.hasNext()) { Column column = it.next(); getMandatoryMetadata(column); getColumnsInfos(column); IModelField field = getColumnModelField(column, entity); if (field == null) { logger.error("Field " + column.getField() + " not found!!"); } else { String name = field.getPropertyAsString("label"); if (name == null || name.length() == 0) { name = field.getName(); } String sorter = column.getSorter() != null && (column.getSorter().equalsIgnoreCase("ASC") || column.getSorter().equalsIgnoreCase("DESC")) ? column.getSorter().toUpperCase() : null; query.addSelectFiled( field.getUniqueName(), "NONE", field.getName(), true, true, false, sorter, field.getPropertyAsString("format")); fieldNameIdMap.put(column.getField(), field.getUniqueName()); } } // get Drivers and filters List<RegistryConfiguration.Filter> filters = registryConfig.getFilters(); int i = 0; ArrayList<ExpressionNode> expressionNodes = new ArrayList<ExpressionNode>(); for (Iterator iterator = filters.iterator(); iterator.hasNext(); ) { Filter filter = (Filter) iterator.next(); addFilter(i, query, env, fieldNameIdMap, filter, expressionNodes); i++; } // put together expression nodes if (expressionNodes.size() == 1) { query.setWhereClauseStructure(expressionNodes.get(0)); } else if (expressionNodes.size() > 1) { ExpressionNode exprNodeAnd = new ExpressionNode("NODE_OP", "AND"); exprNodeAnd.setChildNodes(expressionNodes); query.setWhereClauseStructure(exprNodeAnd); } } finally { logger.debug("OUT"); } return query; }