Examples of GuiGenericDataSet


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

        if (ds != null) insertDataSource(ds, session);
      }

     
      Transaction tx = session.beginTransaction();
      GuiGenericDataSet ds = DAOFactory.getDataSetDAO().toDataSet(dataset);
      if(ds!=null){
        insertDataSet(ds,session);
      }
    } catch (Exception e) {
      logger.error("Error while inserting dataSet into export database " , e);
View Full Code Here

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

      if (dataSetId != null) {
        // if the transaction is new insert dataset if missing  
        IDataSetDAO datasetDao=DAOFactory.getDataSetDAO();
        // insert dataset if parameter insertDataSet is true (in case of KPI export)
        if(insertDataSet){
          GuiGenericDataSet guiGenericDataSet = datasetDao.loadDataSetById(dataSetId);
          if(guiGenericDataSet!=null){
            insertDataSet(guiGenericDataSet, session);
          }
        }
        SbiDataSetConfig dataset = (SbiDataSetConfig) session.load(SbiDataSetConfig.class, dataSetId);
View Full Code Here

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

      }

      // load dataset
      if (kpi.getKpiDsId() != null) {   
        Integer dsID = kpi.getKpiDsId();       
        GuiGenericDataSet guiGenericDataSet = DAOFactory.getDataSetDAO().loadDataSetById(dsID);
        if(guiGenericDataSet!=null){
          insertDataSet(guiGenericDataSet, session);
          SbiDataSetConfig sbiDs= (SbiDataSetConfig) session.load(SbiDataSetConfig.class, guiGenericDataSet.getDsId());
          hibKpi.setSbiDataSet(sbiDs);
        }
      }

      // load threshold
View Full Code Here

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

      }

      // load dataset
      if (kpi.getKpiDsId() != null) {   
        Integer dsID = kpi.getKpiDsId();       
        GuiGenericDataSet guiGenericDataSet = DAOFactory.getDataSetDAO().loadDataSetById(dsID);
        if(guiGenericDataSet!=null){
          insertDataSet(guiGenericDataSet, session);
          SbiDataSetConfig sbiDs= (SbiDataSetConfig) session.load(SbiDataSetConfig.class, guiGenericDataSet.getDsId());
          hibKpi.setSbiDataSet(sbiDs);
        }
      }

      // load threshold
View Full Code Here

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

     
      // Data set if present
      Integer objDataSetId = biobj.getDataSetId();
      if (objDataSetId != null) {

        GuiGenericDataSet genericDs = dataSetDao.loadDataSetById(objDataSetId);
        if(genericDs!=null){
          exporter.insertDataSet(genericDs, session);
        }

      }     

      // Engine if present, and data source if engine uses data source
      Engine engine = biobj.getEngine();
      if (engine.getUseDataSource() && engine.getDataSourceId() != null) {
        Integer engineDataSourceId = engine.getDataSourceId();
        IDataSource ds = dataSourceDao.loadDataSourceByID(engineDataSourceId);
        exporter.insertDataSource(ds, session);
      }

      exporter.insertEngine(engine, session);  
      exporter.insertBIObject(biobj, session, false); // do not insert dataset


      logger.debug("Export metadata associated to the object");
      IObjMetacontentDAO objMetacontentDAO = DAOFactory.getObjMetacontentDAO();
      //  get metacontents associated to object
      List metacontents = objMetacontentDAO.loadObjOrSubObjMetacontents(biobj.getId(), null);
      for (Iterator iterator = metacontents.iterator(); iterator.hasNext();) {
        ObjMetacontent metacontent = (ObjMetacontent) iterator.next();
        exporter.insertObjMetacontent(metacontent, session);
      }


      // if the document is a chart, export the relevant dataset that is referenced by the template
      boolean isChart = false;
      if (biobj.getBiObjectTypeCode().equalsIgnoreCase("DASH")
          && engine.getClassName() != null && engine.getClassName().equals("it.eng.spagobi.engines.chart.SpagoBIChartInternalEngine")) {
        isChart = true;
      }

      if (isChart) {
        ObjTemplate template = biobj.getActiveTemplate();
        if (template != null) {
          try {
            byte[] tempFileCont = template.getContent();
            String tempFileStr = new String(tempFileCont);
            SourceBean tempFileSB = SourceBean.fromXMLString(tempFileStr);
            SourceBean datasetnameSB = (SourceBean) tempFileSB.getFilteredSourceBeanAttribute("CONF.PARAMETER", "name", "confdataset");
            if (datasetnameSB != null) {
              String datasetLabel = (String) datasetnameSB.getAttribute("value");
              IDataSetDAO datasetDao = DAOFactory.getDataSetDAO();
              IDataSet dataset = datasetDao.loadActiveDataSetByLabel(datasetLabel);
              GuiGenericDataSet guiGenericDataSet = datasetDao.loadDataSetByLabel(datasetLabel);



              if (dataset == null) {
                logger.warn("Error while exporting dashboard with id " + idObj + " and label " + biobj.getLabel() + " : " +
View Full Code Here

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

        // insert all datasets
        IDataSetDAO dataSetDAO = DAOFactory.getDataSetDAO();
        for (Iterator iterator = dsLabels.iterator(); iterator.hasNext();) {
          String string = (String) iterator.next();
          logger.debug("get dataset with label " + string);
          GuiGenericDataSet ds = dataSetDAO.loadDataSetByLabel(string);
          // insert dataset if parameter insertDataSet is true (in case of KPI export)
          if(ds != null){
            logger.debug("found dataset with label " + string);
            exporter.insertDataSet(ds, session);
          }
          else {
            logger.error("could not find dataset with label "+string+" : ignore it");
          }

          // search for xxxErrors dataset
          String labelErrors = string+"Errors";
          logger.debug("get dataset with label " + labelErrors+" if present");
          GuiGenericDataSet datasetErrors = dataSetDAO.loadDataSetByLabel(labelErrors);
          if(datasetErrors != null){
            logger.debug("found dataset with label " + labelErrors+"");
            exporter.insertDataSet(datasetErrors, session);
          }
          else {
            logger.warn("could not find dataset with label "+labelErrors);
          }

          // search for xxxAlarms dataset
          String labelAlarms = string+"Alarms";
          logger.debug("get dataset with label " + labelAlarms+" if present");
          GuiGenericDataSet datasetAlarms = dataSetDAO.loadDataSetByLabel(labelAlarms);
          if(datasetAlarms != null){
            logger.debug("found dataset with label " + labelAlarms+"");
            exporter.insertDataSet(datasetAlarms, session);
          }
          else {
View Full Code Here

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

      } catch (Throwable e) {
        logger.error("Exception occurred while retrieving items", e);
        throw new SpagoBIServiceException(SERVICE_NAME,  "sbi.general.retrieveItemsError", e);
      }
    } else if (serviceType != null  && serviceType.equalsIgnoreCase(DataSetConstants.DATASET_INSERT)) {     
      GuiGenericDataSet ds = getGuiGenericDatasetToInsert();   
      if(ds!=null){
        String id = getAttributeAsString(DataSetConstants.ID);
        try {
          if(id != null && !id.equals("") && !id.equals("0")){             
            ds.setDsId(Integer.valueOf(id));
            dsDao.modifyDataSet(ds);
            logger.debug("Resource "+id+" updated");
            JSONObject attributesResponseSuccessJSON = new JSONObject();
            attributesResponseSuccessJSON.put("success", true);
            attributesResponseSuccessJSON.put("responseText", "Operation succeded");
            attributesResponseSuccessJSON.put("id", id);
            writeBackToClient( new JSONSuccess(attributesResponseSuccessJSON) );
          }else{
            Integer dsID = dsDao.insertDataSet(ds);
            GuiGenericDataSet dsSaved = dsDao.loadDataSetById(dsID);
            logger.debug("New Resource inserted");
            JSONObject attributesResponseSuccessJSON = new JSONObject();
            attributesResponseSuccessJSON.put("success", true);
            attributesResponseSuccessJSON.put("responseText", "Operation succeded");
            attributesResponseSuccessJSON.put("id", dsID);
            if(dsSaved!=null){
              GuiDataSetDetail dsDetailSaved = dsSaved.getActiveDetail();
              attributesResponseSuccessJSON.put("dateIn", dsDetailSaved.getTimeIn());
              attributesResponseSuccessJSON.put("userIn", dsDetailSaved.getUserIn());
              attributesResponseSuccessJSON.put("versId", dsDetailSaved.getDsHId());
              attributesResponseSuccessJSON.put("versNum", dsDetailSaved.getVersionNum());
            }
            writeBackToClient( new JSONSuccess(attributesResponseSuccessJSON) );
          }
        } catch (Throwable e) {
          logger.error(e.getMessage(), e);
          throw new SpagoBIServiceException(SERVICE_NAME,"sbi.ds.saveDsError", e);
        }
      }else{
        logger.error("DataSet name, label or type are missing");
        throw new SpagoBIServiceException(SERVICE_NAME,  "sbi.ds.fillFieldsError");
      }
    } else if (serviceType != null  && serviceType.equalsIgnoreCase(DataSetConstants.DATASET_TEST)) {     
      try {
        JSONObject dataSetJSON = datasetTest();
        if(dataSetJSON!=null){
          try {
            writeBackToClient( new JSONSuccess( dataSetJSON ) );
          } catch (IOException e) {
            throw new SpagoBIServiceException("Impossible to write back the responce to the client", e);
          }
        }else{
          throw new SpagoBIServiceException(SERVICE_NAME,"sbi.ds.testError");
        }
      } catch (Throwable e) {
        logger.error(e.getMessage(), e);
        throw new SpagoBIServiceException(SERVICE_NAME,"sbi.ds.testError", e);
      }
    } else if (serviceType != null  && serviceType.equalsIgnoreCase(DataSetConstants.DATASET_DELETE)) {
      Integer dsID = getAttributeAsInteger(DataSetConstants.ID);
      try {
        dsDao.deleteDataSet(dsID);
        logger.debug("Dataset deleted");
        writeBackToClient( new JSONAcknowledge("Operation succeded") );
      } catch (Throwable e) {
        logger.error("Exception occurred while retrieving dataset to delete", e);
        throw new SpagoBIServiceException(SERVICE_NAME,"sbi.ds.deleteDsError", e);
      }
    }else if (serviceType != null  && serviceType.equalsIgnoreCase(DataSetConstants.DATASET_VERSION_DELETE)) {
      Integer dsVersionID = getAttributeAsInteger(DataSetConstants.VERSION_ID);
      try {
        boolean deleted = dsDao.deleteInactiveDataSetVersion(dsVersionID)
        if(deleted){
          logger.debug("Dataset Version deleted");
          writeBackToClient( new JSONAcknowledge("Operation succeded") );
        }else{
          throw new SpagoBIServiceException(SERVICE_NAME,"sbi.ds.deleteVersion");
        }
      } catch (Throwable e) {
        logger.error("Exception occurred while retrieving dataset version to delete", e);
        throw new SpagoBIServiceException(SERVICE_NAME,"sbi.ds.deleteVersion", e);
      }
    }else if (serviceType != null  && serviceType.equalsIgnoreCase(DataSetConstants.DATASET_ALL_VERSIONS_DELETE)) {
      Integer dsID = getAttributeAsInteger(DataSetConstants.DS_ID);
      try {
        dsDao.deleteAllInactiveDataSetVersions(dsID);
        logger.debug("All Older Dataset versions deleted");
        writeBackToClient( new JSONAcknowledge("Operation succeded") );
      } catch (Throwable e) {
        logger.error("Exception occurred while retrieving dataset to delete", e);
        throw new SpagoBIServiceException(SERVICE_NAME,"sbi.ds.deleteVersion", e);
      }
    }else if (serviceType != null  && serviceType.equalsIgnoreCase(DataSetConstants.DATASET_VERSION_RESTORE)) {
      Integer dsID = getAttributeAsInteger(DataSetConstants.DS_ID);
      Integer dsVersionNum = getAttributeAsInteger(DataSetConstants.VERSION_NUM);
      try {
        GuiGenericDataSet dsNewDetail= dsDao.restoreOlderDataSetVersion(dsID, dsVersionNum);
        logger.debug("Dataset Version correctly Restored");
        List temp = new ArrayList();
        temp.add(dsNewDetail);
        JSONArray itemJSON = (JSONArray) SerializerFactory.getSerializer("application/json").serialize(temp, locale)
        JSONObject version = itemJSON.getJSONObject(0);
View Full Code Here

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

    return items;
  }
 
  private GuiGenericDataSet getGuiGenericDatasetToInsert() {
   
    GuiGenericDataSet ds = null;
   
    String label = getAttributeAsString(DataSetConstants.LABEL);
    String name = getAttributeAsString(DataSetConstants.NAME);
    String description = getAttributeAsString(DataSetConstants.DESCRIPTION);   
    String dsTypeCd = getAttributeAsString(DataSetConstants.DS_TYPE_CD);

    List<Domain> domainsDs = (List<Domain>)getSessionContainer().getAttribute("dsTypesList");   
    String dsType = "";
    if(domainsDs!=null && !domainsDs.isEmpty()){
      Iterator it = domainsDs.iterator();
      while(it.hasNext()){
        Domain d = (Domain)it.next();
        if(d!=null && d.getValueCd().equalsIgnoreCase(dsTypeCd)){
          dsType = d.getValueName();
          break;
        }
      }
    }     
   
      if (name != null && label != null && dsType!=null && !dsType.equals("")) {
     
        ds = new GuiGenericDataSet();   
      if(ds!=null){
        ds.setLabel(label);
        ds.setName(name);
       
        if(description != null && !description.equals("")){
          ds.setDescription(description);
        }
        GuiDataSetDetail dsActiveDetail = constructDataSetDetail(dsType);
        ds.setActiveDetail(dsActiveDetail)
      }else{
        logger.error("DataSet type is not existent");
        throw new SpagoBIServiceException(SERVICE_NAME,  "sbi.ds.dsTypeError");
      }
    }   
View Full Code Here

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

    logger.debug("IN");
    if (dataset == null) {
      logger.warn("SDKDataSet in input is null!!");
      return null;
    }
    GuiGenericDataSet ds = null;
    GuiDataSetDetail dsDetail = null;
    try {
      ds = new GuiGenericDataSet();
      if (dataset.getId() != null){
        ds.setDsId(dataset.getId());
      }
      ds.setLabel(dataset.getLabel());
      ds.setName(dataset.getName());
      ds.setDescription(dataset.getDescription())

      //defines correct dataset detail
      if(dataset.getType().equalsIgnoreCase(DataSetConstants.DS_FILE)){
        dsDetail = new FileDataSetDetail();
        String fileName = dataset.getFileName();
        if(fileName!=null && !fileName.equals("")){
          ((FileDataSetDetail)dsDetail).setFileName(fileName);
        }
      }else if(dataset.getType().equalsIgnoreCase(DataSetConstants.DS_JCLASS)){
        dsDetail = new JClassDataSetDetail();
        String jclassName = dataset.getJavaClassName();
        if(jclassName!=null && !jclassName.equals("")){
          ((JClassDataSetDetail)dsDetail).setJavaClassName(jclassName);
        }
      }else if(dataset.getType().equalsIgnoreCase(DataSetConstants.DS_QUERY)){
        dsDetail = new QueryDataSetDetail();
        String query = dataset.getJdbcQuery();
        Integer dataSourceId = dataset.getJdbcDataSourceId();
        if(query!=null && !query.equals("")){
          ((QueryDataSetDetail)dsDetail).setQuery(query);
        }
        if(dataSourceId!=null){
          IDataSource dataSource = DAOFactory.getDataSourceDAO().loadDataSourceByID(dataSourceId);
          if(dataSource!=null){
            ((QueryDataSetDetail)dsDetail).setDataSourceLabel(dataSource.getLabel());
          }
         
        }
      }else if(dataset.getType().equalsIgnoreCase(DataSetConstants.DS_QBE)){
        dsDetail = new QbeDataSetDetail();
        String sqlQuery = dataset.getJdbcQuery();
        String jsonQuery = dataset.getJsonQuery();
        Integer dataSourceId = dataset.getJdbcDataSourceId();
        String datamarts = dataset.getDatamarts();       
        ((QbeDataSetDetail) dsDetail).setSqlQuery(sqlQuery);
        ((QbeDataSetDetail) dsDetail).setJsonQuery(jsonQuery);
        ((QbeDataSetDetail) dsDetail).setDatamarts(datamarts);
        IDataSource dataSource = DAOFactory.getDataSourceDAO().loadDataSourceByID(dataSourceId);
        if(dataSource!=null){
          ((QbeDataSetDetail)dsDetail).setDataSourceLabel(dataSource.getLabel());
        }
      }else if(dataset.getType().equalsIgnoreCase(DataSetConstants.DS_SCRIPT)){
        dsDetail = new ScriptDataSetDetail();
        String script = dataset.getScriptText();
        String scriptLanguage = dataset.getScriptLanguage();
        if(scriptLanguage!=null && !scriptLanguage.equals("")){
          ((ScriptDataSetDetail)dsDetail).setLanguageScript(scriptLanguage);
        }
        if(script!=null && !script.equals("")){
          ((ScriptDataSetDetail)dsDetail).setScript(script);
        }
      }else if(dataset.getType().equalsIgnoreCase(DataSetConstants.DS_WS)){
        dsDetail = new WSDataSetDetail();
        String wsAddress = dataset.getWebServiceAddress();
        String wsOperation = dataset.getWebServiceOperation();
        if(wsOperation!=null && !wsOperation.equals("")){
          ((WSDataSetDetail)dsDetail).setOperation(wsOperation);
        }
        if(wsAddress!=null && !wsAddress.equals("")){
          ((WSDataSetDetail)dsDetail).setAddress(wsAddress);
        }
      }
      //sets other general GuiDetailDataset object's fields
      if(dataset.getPivotColumnName()!=null && !dataset.getPivotColumnName().equals("")){
        dsDetail.setPivotColumnName(dataset.getPivotColumnName());
      }
      if(dataset.getPivotRowName()!=null && !dataset.getPivotRowName().equals("")){
        dsDetail.setPivotRowName(dataset.getPivotRowName());
      }
      if(dataset.getPivotColumnValue()!=null && !dataset.getPivotColumnValue().equals("")){
        dsDetail.setPivotColumnValue(dataset.getPivotColumnValue());
      }
      if(dataset.getNumberingRows()!=null){
        dsDetail.setNumRows(dataset.getNumberingRows());
      }

      //dsDetail.setDsMetadata(dataset.getXXX);
     
      //sets dataset's parameters     
      String parameters = null;
      if (dataset.getParameters() != null) {       
        parameters = this.fromSDKDataSetParameterArrayToBIDataSetParameterList(dataset.getParameters());
      }
      dsDetail.setParameters(parameters);

     
      /*
      private String dsMetadata=null;
       */
     
      IDomainDAO domainDAO = DAOFactory.getDomainDAO();
      // sets dataset's transformer type domain
      if (dataset.getTransformer() != null) {
        Domain transformer = domainDAO.loadDomainByCodeAndValue("TRANSFORMER_TYPE", dataset.getTransformer());
        dsDetail.setTransformerCd(transformer.getValueCd());
        dsDetail.setTransformerId(transformer.getValueId());
      }
      // sets dataset's category domain
      if (dataset.getCategory() != null){
        Domain category = domainDAO.loadDomainByCodeAndValue("CATEGORY_TYPE", dataset.getCategory());
        dsDetail.setCategoryValueName(category.getValueCd());
        dsDetail.setCategoryId(category.getValueId());
      }
      ds.setActiveDetail(dsDetail);

    } catch (Exception e) {
      logger.error("Error while converting SDKDataSet into GuiGenericDataSet.", e);
      logger.debug("Returning null.");
      return null;
View Full Code Here

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

    if( !(o instanceof GuiGenericDataSet) ) {
      throw new SerializationException("DataSetJSONSerializer is unable to serialize object of type: " + o.getClass().getName());
    }
   
    try {
      GuiGenericDataSet ds = (GuiGenericDataSet)o;
      result = new JSONObject();
      Integer dsId = ds.getDsId();
      result.put(ID, dsId);
      result.put(LABEL, ds.getLabel() )
      result.put(NAME, ds.getName() );
      result.put(DESCRIPTION, ds.getDescription() );
      Integer numObjAssociated = DAOFactory.getDataSetDAO().countBIObjAssociated(new Integer(ds.getDsId()));
      if(numObjAssociated!=null){
        result.put(USED_BY_N_DOCS, numObjAssociated );
      }
     
      GuiDataSetDetail dsDetail = ds.getActiveDetail();
     
      result.put(CATEGORY_TYPE_VN, dsDetail.getCategoryValueName());

      JSONArray parsListJSON = new JSONArray();
      String pars = dsDetail.getParameters();
      if(pars!=null && !pars.equals("")){
        SourceBean source = SourceBean.fromXMLString(pars);
        if(source!=null && source.getName().equals("PARAMETERSLIST")){
          List<SourceBean> rows = source.getAttributeAsList("ROWS.ROW");
          for(int i=0; i< rows.size(); i++){
            SourceBean row = rows.get(i);
            String name = (String)row.getAttribute("NAME");
            String type = (String)row.getAttribute("TYPE");
            JSONObject jsonPar = new JSONObject();
            jsonPar.put("name", name);
            jsonPar.put("type", type);
            parsListJSON.put(jsonPar);
          }       
        }
      }
      result.put(PARS, parsListJSON)
     
      JSONArray metaListJSON = new JSONArray();
      String meta = dsDetail.getDsMetadata();
      if(meta!=null && !meta.equals("")){
        SourceBean source = SourceBean.fromXMLString(meta);
        if(source!=null && source.getName().equals("METADATALIST")){
          List<SourceBean> rows = source.getAttributeAsList("ROWS.ROW");
          for(int i=0; i< rows.size(); i++){
            SourceBean row = rows.get(i);
            String name = (String)row.getAttribute("NAME");
            String type = (String)row.getAttribute("TYPE");
            JSONObject jsonMeta = new JSONObject();
            jsonMeta.put("name", name);
            jsonMeta.put("type", type);
            metaListJSON.put(jsonMeta);
          }       
        }
      }
      result.put(METADATA, metaListJSON)
     
      JSONArray versionsListJSON = new JSONArray();
      List<GuiDataSetDetail> nonActiveDetails = ds.getNonActiveDetails();
      if(nonActiveDetails!=null && !nonActiveDetails.isEmpty()){
        Iterator it = nonActiveDetails.iterator();
        while(it.hasNext()){
          GuiDataSetDetail tempDetail = (GuiDataSetDetail)it.next();
          String dsType = tempDetail.getDsType();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.