Esempio n. 1
0
 /**
  * 构建星型模型
  *
  * @param cube 立方体定义
  * @return star mode 定义
  */
 public StarModel buildModel(MiniCube cube) {
   StarModel model = new StarModel();
   model.setCubeId(cube.getId());
   logger.info("current cube is : [{}]", cube);
   logger.info("current cube's schema is : [{}]", cube.getSchema());
   // 确认schema不为空
   if (cube.getSchema() != null) {
     model.setDsId(cube.getSchema().getDatasource());
     model.setSchemaId(cube.getSchema().getId());
   }
   model.setFactTable(buildFactTable(cube));
   model.setDimTables(buildDimTables(cube));
   return model;
 }
Esempio n. 2
0
 /**
  * 构建事实表
  *
  * @param cube cube定义
  * @return 事实表定义
  */
 private FactTableMetaDefine buildFactTable(MiniCube cube) {
   FactTableMetaDefine factTable = new FactTableMetaDefine();
   factTable.setCubeId(cube.getId());
   factTable.setMutilple(cube.isMutilple());
   if (factTable.isMutilple()) {
     // 分库分表导致多张表组成事实表
     factTable.setRegExp(cube.getSource());
     if (cube.getSource() != null) {
       List<String> regexTables = Lists.newArrayList();
       Collections.addAll(regexTables, cube.getSource().split(","));
       factTable.setRegExpTables(regexTables);
       if (regexTables != null && regexTables.size() > 0) {
         factTable.setName(regexTables.get(0));
       }
     }
     factTable.setDivideTableStrategyVo(cube.getDivideTableStrategyVo());
   } else {
     // 事实表名称
     factTable.setName(cube.getSource());
   }
   if (cube.getMeasures() == null || cube.getMeasures().isEmpty()) {
     logger.debug("measure is empty");
   } else {
     Collection<Measure> measures = cube.getMeasures().values();
     if (measures == null) {
       logger.debug("can't get measuers");
       return factTable;
     }
     measures.forEach(
         m -> {
           ColumnMetaDefine column = new ColumnMetaDefine();
           column.setCaption(m.getCaption());
           column.setName(m.getDefine());
           factTable.addColumn(column);
         });
     // 添加维度引用的列
     cube.getDimensions()
         .values()
         .forEach(
             dim -> {
               ColumnMetaDefine column = new ColumnMetaDefine();
               // modify by jiangyichao at 2014-10-09 修改维度caption
               column.setCaption(dim.getFacttableCaption());
               column.setName(dim.getFacttableColumn());
               factTable.addColumn(column);
             });
   }
   return factTable;
 }
Esempio n. 3
0
  /**
   * 将查询动作转化成问题模型
   *
   * @param dsDefine
   * @param queryAction 查询动作
   * @return 问题模型
   * @throws QueryModelBuildException 构建失败异常
   */
  public static QuestionModel convert2QuestionModel(
      DataSourceDefine dsDefine,
      ReportDesignModel reportModel,
      QueryAction queryAction,
      Map<String, Object> requestParams,
      PageInfo pageInfo,
      String securityKey)
      throws QueryModelBuildException {
    if (queryAction == null) {
      throw new QueryModelBuildException("query action is null");
    }
    ConfigQuestionModel questionModel = new ConfigQuestionModel();
    String areaId = queryAction.getExtendAreaId();
    if (StringUtils.isEmpty(areaId)) {
      throw new QueryModelBuildException("area id is empty");
    }
    ExtendArea area = reportModel.getExtendById(areaId);
    if (area == null) {
      throw new QueryModelBuildException("can not get area with id : " + areaId);
    }
    Cube cube = getCubeFromReportModel(reportModel, area);
    if (cube == null) {
      throw new QueryModelBuildException("can not get cube define in area : " + areaId);
    }
    if (area.getType() == ExtendAreaType.PLANE_TABLE) {
      cube = transformCube(cube);
      MiniCube miniCube = (MiniCube) cube;
      DivideTableStrategyVo divideVo = miniCube.getDivideTableStrategyVo();
      DivideTableContext divideContext = new DivideTableContext();
      DivideTableService divideTableService = null;
      if (divideVo != null) {
        switch (divideVo.getCondition()) {
          case "yyyyMMdd":
            divideTableService = new DayDivideTableStrategyServiceImpl();
            break;
          case "yyyyMM":
            divideTableService = new MonthDivideTableStrategyServiceImpl();
            break;
          case "yyyy":
            divideTableService = new YearDivideTableStrategyServiceImpl();
            break;
          default:
            throw new UnsupportedOperationException("暂时不支持该分表策略");
        }
        divideContext.setDivideTableService(divideTableService);
        if (divideContext.getAllFactTableName(divideVo, requestParams) != null) {
          miniCube.setSource(divideContext.getAllFactTableName(divideVo, requestParams));
        }
        MiniCubeSchema schema = (MiniCubeSchema) reportModel.getSchema();
        schema.getCubes().put(miniCube.getId(), miniCube);
        reportModel.setSchema(schema);
      }
      miniCube.setProductLine(dsDefine.getProductLine());
      questionModel.setCube(miniCube);
    } else {
      cube = getCubeWithExtendArea(reportModel, area);
      ((MiniCube) cube).setProductLine(dsDefine.getProductLine());
      questionModel.setCube(cube);
    }
    // 设置轴信息
    questionModel.setAxisMetas(buildAxisMeta(reportModel.getSchema(), area, queryAction));

    questionModel.setCubeId(area.getCubeId());
    // TODO 动态更新cube 针对查询过程中动态添加的属性 需要仔细考虑此处逻辑
    Set<Item> tmp = Sets.newHashSet();
    tmp.addAll(queryAction.getSlices().keySet());
    tmp.addAll(queryAction.getRows().keySet());
    try {
      DataSourceInfo dataSource =
          DataSourceConnectionServiceFactory.getDataSourceConnectionServiceInstance(
                  dsDefine.getDataSourceType().name())
              .parseToDataSourceInfo(dsDefine, securityKey);
      questionModel.setDataSourceInfo(dataSource);
    } catch (Exception e) {
      throw new RuntimeException(e);
    }
    OrderDesc orderDesc = queryAction.getOrderDesc();
    if (orderDesc != null) {
      SortType sortType = SortType.valueOf(orderDesc.getOrderType());
      String uniqueName = "";
      if (DataModelUtils.isMeasure(orderDesc.getName(), cube)) {
        uniqueName = uniqueName + "[Measure].";
      } else {
        uniqueName = uniqueName + "[Dimension].";
      }
      uniqueName = uniqueName + "[" + orderDesc.getName() + "]";
      SortRecord sortRecord = new SortRecord(sortType, uniqueName, orderDesc.getRecordSize());
      questionModel.setSortRecord(sortRecord);
    }
    // TODO 此处没有考虑指标、维度交叉情况,如后续有指标维度交叉情况,此处需要调整
    questionModel.getQueryConditionLimit().setWarningAtOverFlow(false);
    if (queryAction.isNeedOthers()) {
      // TODO 需要开发通用工具包 将常量定义到通用工具包中
      questionModel.getRequestParams().put("NEED_OTHERS", "1");
    }
    // 设置请求参数信息
    if (requestParams != null) {
      for (String key : requestParams.keySet()) {
        Object value = requestParams.get(key);
        if (value != null && value instanceof String) {
          questionModel.getRequestParams().put(key, (String) value);
        }
      }
      // 设计器中, 设置分页信息
      if (requestParams.get(Constants.IN_EDITOR) != null
          && Boolean.valueOf(requestParams.get(Constants.IN_EDITOR).toString())) {
        questionModel.setPageInfo(pageInfo);
      }
    }
    if (area.getType() == ExtendAreaType.PLANE_TABLE) {
      questionModel.setQuerySource("SQL");
      // 对于平面表不使用汇总方式
      questionModel.setNeedSummary(false);
      // 设置分页信息
      questionModel.setPageInfo(pageInfo);
      // 针对平面表构建查询条件
      Map<String, MetaCondition> conditionsForPlaneTable =
          QueryConditionUtils.buildQueryConditionsForPlaneTable(reportModel, area, queryAction);
      questionModel.setQueryConditions(conditionsForPlaneTable);
    } else {
      questionModel.setQuerySource("TESSERACT");
      // 针对其他情况构建查询条件
      Map<String, MetaCondition> conditionsForPivotTable =
          QueryConditionUtils.buildQueryConditionsForPivotTable(reportModel, area, queryAction);
      questionModel.setQueryConditions(conditionsForPivotTable);
      if (queryAction.getDrillDimValues() == null
          || !queryAction.getDrillDimValues().isEmpty()
          || queryAction.isChartQuery()) {
        questionModel.setNeedSummary(false);
      } else {
        ExtendAreaType areaType =
            reportModel.getExtendById(queryAction.getExtendAreaId()).getType();
        if (areaType != ExtendAreaType.TABLE) {
          questionModel.setNeedSummary(false);
        } else {
          questionModel.setNeedSummary(needSummary(questionModel));
        }
      }

      if (questionModel.isNeedSummary()
          && "false".equals(area.getOtherSetting().get("needSummary"))) {
        questionModel.setNeedSummary(false);
      }
    }
    questionModel.setUseIndex(true);

    putSliceConditionIntoParams(queryAction, questionModel);
    questionModel.setFilterBlank(queryAction.isFilterBlank());
    return questionModel;
  }