Package it.eng.spagobi.tools.dataset.bo

Examples of it.eng.spagobi.tools.dataset.bo.IDataSet

264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
        logger.warn("SDKDataSet in input is null!");
        return null;
      }
      dataSetId = sdkDataSet.getId();
      logger.debug("Looking for dataset with id = " + dataSetId);
      IDataSet dataSet = DAOFactory.getDataSetDAO().loadActiveIDataSetByID(dataSetId);
      if (dataSet == null) {
        logger.warn("DataSet with identifier [" + dataSetId + "] not found.");
        return null;
      }
      Map parameters = new HashMap();
      //List parametersToFill = DetailDataSetModule.getParametersToFill(dataSet.toSpagoBiDataSet());
      //TODO da cambiare con il nuovo metodo
      List parametersToFill = new ArrayList();
      if (parametersToFill != null && parametersToFill.size() > 0) {
        Iterator it = parametersToFill.iterator();
        while (it.hasNext()) {
          DataSetParameterItem aDataSetParameterItem = (DataSetParameterItem) it.next();
          SDKDataSetParameter sdkParameter = findRelevantSDKDataSetParameter(aDataSetParameterItem, sdkDataSet);
          if (sdkParameter == null) {
            logger.error("SDKDataSetParameter for DataSetParameterItem with name [" + aDataSetParameterItem.getName() + "] not found!!");
            throw new MissingParameterValue(aDataSetParameterItem.getName());
          }
          String[] values = sdkParameter.getValues();
          logger.debug("Values set for parameter [" + aDataSetParameterItem.getName() + "] are: " + values);
          if (values == null || values.length == 0) {
            logger.error("SDKDataSetParameter contains no values for DataSetParameterItem with name [" + aDataSetParameterItem.getName() + "]!!");
            throw new MissingParameterValue(aDataSetParameterItem.getName());
          }
          checkParameterValues(values, aDataSetParameterItem);
          String parameterValues = getParameterValues(values, aDataSetParameterItem);
          logger.debug("Setting values [" + parameterValues + "] for parameter with name = [" + aDataSetParameterItem.getName() + "]");
          parameters.put(aDataSetParameterItem.getName(), parameterValues);
        }
      }
      dataSet.setParamsMap(parameters);
      dataSet.loadData();
      IDataStore dataStore = dataSet.getDataStore();
      DataStoreMetaData dataStoreMetadata = (DataStoreMetaData) dataStore.getMetaData();
      toReturn = new SDKObjectsConverter().fromDataStoreMetadataToSDKDataStoreMetadata(dataStoreMetadata);
    } catch(NotAllowedOperationException e) {
      throw e;
    } catch(MissingParameterValue e) {
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
        e.printStackTrace();
      }
    }else{//in case all the kpi children don't have to be calculated
      try {
        KpiInstance kpiI = mI.getKpiInstanceAssociated();
        IDataSet dataSet = DAOFactory.getKpiDAO().getDsFromKpiId(kpiI.getKpi());
        KpiValue value = new KpiValue();
        if (this.resources == null || this.resources.isEmpty()) {
          logger.debug("There are no resources assigned to the Model Instance");
          logger.debug("Retrieved the Dataset to be calculated: " + dataSet.getId());
          value = getNewKpiValue(dataSet, kpiI, null,mI.getModelInstanceNodeId(), null);
          logger.debug("New value calculated");
        } else {
          Iterator resourcesIt = this.resources.iterator();
          while (resourcesIt.hasNext()) {
            Resource r = (Resource) resourcesIt.next();
            logger.debug("Resource: " + r.getName());
            logger.debug("Retrieved the Dataset to be calculated: " + dataSet.getId());
            value = getNewKpiValue(dataSet, kpiI, r,mI.getModelInstanceNodeId(), null);         
          }
        }
        logger.debug("New value calculated");
        // Insert new Value into the DB
View Full Code Here
656
657
658
659
660
661
662
663
664
665
666
667
    if (kpiI != null) {
      KpiValue kVal = new KpiValue();
      logger.info("Got KpiInstance with ID: " + kpiI.getKpiInstanceId().toString());

     
      IDataSet dataSet = DAOFactory.getKpiDAO().getDsFromKpiId(kpiI.getKpi()); 
      logger.info("Retrieved the Dataset to be calculated: " + (dataSet!=null ? dataSet.getId():"null"));
      Integer kpiInstanceID = kpiI.getKpiInstanceId();
      Date kpiInstBegDt = kpiI.getD();

      kVal = setTimeAttributes(kVal, kpiI);   
      kVal.setKpiInstanceId(kpiInstanceID);
View Full Code Here
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
    }else{ 
      if(behaviour.equalsIgnoreCase("timeIntervalDefault")){
        if(dateIntervalFrom!=null && dateIntervalTo!=null){
          value = DAOFactory.getKpiDAO().getKpiValueFromInterval(kpiI.getKpiInstanceId(), dateIntervalFrom, dateIntervalTo, r, grantNodeToUse);
          if (value==null){
            IDataSet dataSet = DAOFactory.getKpiDAO().getDsFromKpiId(kpiI.getKpi()); 
            logger.info("Retrieved the Dataset to be calculated: " + (dataSet!=null ? dataSet.getId():"null"));
            value = getNewKpiValue(dataSet, kpiI, r, miId, grantNodeToUse);   
          }
        }else{
          value = null;
        }
      }else if(behaviour.equalsIgnoreCase("timeIntervalForceRecalculation")){
        if(dateIntervalFrom!=null && dateIntervalTo!=null){
          DAOFactory.getKpiDAO().deleteKpiValueFromInterval(kpiI.getKpiInstanceId(), dateIntervalFrom, dateIntervalTo, r, grantNodeToUse);
          IDataSet dataSet = DAOFactory.getKpiDAO().getDsFromKpiId(kpiI.getKpi()); 
          logger.info("Retrieved the Dataset to be calculated: " + (dataSet!=null ? dataSet.getId():"null"));
          value = getNewKpiValue(dataSet, kpiI, r, miId, grantNodeToUse);   
        }else{
          value = null;
        }
      }else{
        if(behaviour.equalsIgnoreCase("default") || //If the behaviour is default
            (behaviour.equalsIgnoreCase("recalculate") && kpiI.getPeriodicityId()!=null)){//or the behaviour is recalculate and the kpiinstance has a setted periodicity
          // the old value still valid is retrieved
          logger.debug("Trying to retrieve the old value still valid");
          value = DAOFactory.getKpiDAO().getKpiValue(kpiI.getKpiInstanceId(), dateOfKPI, r, grantNodeToUse);
          logger.debug("Old KpiValue retrieved");   
        }
        if(value!=null && value.getEndDate()!=null && kpiI.getPeriodicityId()!=null){
          GregorianCalendar c2 = new GregorianCalendar();   
          c2.setTime(value.getEndDate());
          int year = c2.get(1);
          if(year==9999){
            no_period_to_period = true;
            logger.debug("The periodicity was null and now exists");
          }
        }
        if (value==null || //If the retrieved value is null
            no_period_to_period || //or the periodicity was before null and now is setted
            behaviour.equalsIgnoreCase("force_recalculation") || //or the  behaviour is force_recalculation
            (behaviour.equalsIgnoreCase("recalculate") && kpiI.getPeriodicityId()==null) ) {// or the behaviour is recalculate and the kpiinstance hasn't a setted periodicity
          //a new value is calculated
          logger.debug("Old value not valid anymore or recalculation forced");
          IDataSet dataSet = DAOFactory.getKpiDAO().getDsFromKpiId(kpiI.getKpi()); 
          logger.info("Retrieved the Dataset to be calculated: " + (dataSet!=null ? dataSet.getId():"null"));
          value = getNewKpiValue(dataSet, kpiI, r, miId, grantNodeToUse);   

        }else if(behaviour.equalsIgnoreCase("display")){//diplay behaviour
          logger.debug("Display behaviour");
          value = DAOFactory.getKpiDAO().getDisplayKpiValue(kpiI.getKpiInstanceId(), dateOfKPI, r, grantNodeToUse);
View Full Code Here
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
    }
    logger.debug("kpi inst id= "+kVal.getKpiInstanceId()+" parent kpi is "+ kpiParent.getKpiName()+" and OU :"+ ouLabel);
    for(int i= 0; i< relations.size(); i++){
      KpiRel rel = relations.get(i);
      Kpi child = rel.getKpiChild();
      IDataSet chDataSet = kpiDao.getDsFromKpiId(child.getKpiId());
      HashMap chPars  = new HashMap();
      chPars.putAll(pars);
      //then the one in rel table
      String parameter = rel.getParameter();
      KpiValue kpiVal = recursiveGetKpiValueFromKpiRel(child, chDataSet, chPars, kVal, begD, endDate, modInstNodeId);
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
    logger.debug("IN");
    JSONObject dataSetJSON = null;   
    //Integer id = obj.getDataSetId(); 
    //gets the dataset object informations   
    try {
      IDataSet dataset = DAOFactory.getDataSetDAO().loadActiveIDataSetByID(dsId);
      if (dataset.getParameters() != null){
        //JSONArray parsJSON = serializeJSONArrayParsList(dataset.getParameters());
        JSONArray parsJSON = getAttributeAsJSONArray(DataSetConstants.PARS);
        HashMap h = new HashMap();
        if(parsJSON!=null && parsJSON.length()>0){
          h = deserializeParValuesListJSONArray(parsJSON);
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
      String jpaQueryStr = statement.getQueryString();
    //  String sqlQuery = statement.getSqlQueryString();
      logger.debug("Validating query (HQL/JPQL): [" +  jpaQueryStr+ "]");
    //  logger.debug("Validating query (SQL): [" + sqlQuery + "]");
      try {
        IDataSet dataSet = QbeDatasetFactory.createDataSet(statement);
       
        Map userAttributes = new HashMap();
        UserProfile profile = (UserProfile)this.getEnv().get(EngineConstants.ENV_USER_PROFILE);
        Iterator it = profile.getUserAttributeNames().iterator();
        while(it.hasNext()) {
          String attributeName = (String)it.next();
          Object attributeValue = profile.getUserAttribute(attributeName);
          userAttributes.put(attributeName, attributeValue);
        }
        dataSet.addBinding("attributes", userAttributes);
        dataSet.addBinding("parameters", this.getEnv());
        dataSet.loadData(0, 1, 1);
       
        logger.info("Query execution did not throw any exception. Validation successful.");
        validationResult = true;
      } catch (Throwable t) {
        logger.info("Query execution thrown an exception. Validation failed.");
View Full Code Here
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
  }
 
 
  public IDataStore executeQuery(IStatement statement, Integer start, Integer limit){
    IDataStore dataStore = null;
    IDataSet dataSet = null;
    String jpaQueryStr = statement.getQueryString();
    Integer maxSize = QbeEngineConfig.getInstance().getResultLimit();     
    logger.debug("Configuration setting  [" + "QBE.QBE-SQL-RESULT-LIMIT.value" + "] is equals to [" + (maxSize != null? maxSize: "none") + "]");
    boolean isMaxResultsLimitBlocking = QbeEngineConfig.getInstance().isMaxResultLimitBlocking();
    logger.debug("Executable query (HQL/JPQL): [" +  jpaQueryStr+ "]");
    UserProfile userProfile = (UserProfile)getEnv().get(EngineConstants.ENV_USER_PROFILE);
    auditlogger.info("[" + userProfile.getUserId() + "]:: HQL/JPQL: " + jpaQueryStr); 
   
    try {
      logger.debug("Executing query ...");
      dataSet = QbeDatasetFactory.createDataSet(statement);
      dataSet.setAbortOnOverflow(isMaxResultsLimitBlocking);
     
      Map userAttributes = new HashMap();
      UserProfile profile = (UserProfile)this.getEnv().get(EngineConstants.ENV_USER_PROFILE);
      Iterator it = profile.getUserAttributeNames().iterator();
      while(it.hasNext()) {
        String attributeName = (String)it.next();
        Object attributeValue = profile.getUserAttribute(attributeName);
        userAttributes.put(attributeName, attributeValue);
      }
      dataSet.addBinding("attributes", userAttributes);
      dataSet.addBinding("parameters", this.getEnv());
      dataSet.loadData(start, limit, (maxSize == null? -1: maxSize.intValue()));
     
      dataStore = dataSet.getDataStore();
      Assert.assertNotNull(dataStore, "The dataStore returned by loadData method of the class [" + dataSet.getClass().getName()+ "] cannot be null");
    } catch (Exception e) {
      logger.debug("Query execution aborted because of an internal exceptian");
      SpagoBIEngineServiceException exception;
      String message;
     
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
108
      }
      HashMap parameters=new HashMap();

        try{
      // if dataset needs parameter I must recover them from request
       IDataSet dataSet=DAOFactory.getDataSetDAO().loadActiveIDataSetByID(Integer.valueOf(dataName));
       if(dataSet!=null){ 
         Object parametersO=dataSet.getParameters();
         if(parametersO!=null){
           String parametersXML=parametersO.toString();
         DataSetParametersList dsList=new DataSetParametersList(parametersXML);
         for (Iterator iterator = dsList.getItems().iterator(); iterator.hasNext();) {
          DataSetParameterItem item = (DataSetParameterItem) iterator.next();
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
        retrieveParametersValues(biobj);

        //gets the dataset data about the email address
        IDataStore emailDispatchDataStore = null;
        if (saveInfo.isUseDataSet()) {
          IDataSet dataSet = DAOFactory.getDataSetDAO().loadActiveDataSetByLabel(saveInfo.getDataSetLabel());
          dataSet.setUserProfileAttributes(UserProfileUtils.getProfileAttributes(profile));
          dataSet.loadData();
          emailDispatchDataStore = dataSet.getDataStore();
        }
        //gets the dataset data about the folder for the document save
        IDataStore folderDispatchDataSotre = null;
        if (saveInfo.isUseFolderDataSet()) {
          IDataSet dataSet = DAOFactory.getDataSetDAO().loadActiveDataSetByLabel(saveInfo.getDataSetFolderLabel());
            dataSet.setUserProfileAttributes(UserProfileUtils.getProfileAttributes(profile));
          dataSet.loadData();
           folderDispatchDataSotre = dataSet.getDataStore();
        }
       
        eventManager = EventsManager.getInstance();
        List roles = DAOFactory.getBIObjectDAO().getCorrectRolesForExecution(biobj.getId());
       
View Full Code Here
TOP

Related Classes of it.eng.spagobi.tools.dataset.bo.IDataSet

  • it.eng.qbe.datasource.AbstractDataSourceTestCase
  • it.eng.qbe.statement.QbeDatasetFactory
  • it.eng.spagobi.analiticalmodel.document.utils.DetBIObjModHelper
  • it.eng.spagobi.engines.accessibility.servlet.AccessibilityServlet
  • it.eng.spagobi.engines.chart.service.GetChartDataAction
  • it.eng.spagobi.engines.chart.SpagoBIChartInternalEngine
  • it.eng.spagobi.engines.chart.utils.DataSetAccessFunctions
  • it.eng.spagobi.engines.console.exporter.ExportAction
  • it.eng.spagobi.engines.console.services.ExecuteDataSetAction
  • it.eng.spagobi.engines.console.services.GetConsoleDataAction
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.