Examples of GuiDataSetDetail


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

    try {
      aSession = getSession();
      tx = aSession.beginTransaction();
      SbiDataSetHistory hibDataSet =null;
      if(dataSet!=null && dataSet.getActiveDetail()!=null){
        GuiDataSetDetail dataSetActiveDetail = dataSet.getActiveDetail();

        if(dataSetActiveDetail instanceof FileDataSetDetail){
          hibDataSet=new SbiFileDataSet();
          if(((FileDataSetDetail)dataSetActiveDetail).getFileName()!=null){
            ((SbiFileDataSet)hibDataSet).setFileName(((FileDataSetDetail)dataSetActiveDetail).getFileName());
          }
        }

        else if(dataSetActiveDetail instanceof QueryDataSetDetail){
          hibDataSet=new SbiQueryDataSet();
          if(((QueryDataSetDetail)dataSetActiveDetail).getQuery()!=null){
            ((SbiQueryDataSet)hibDataSet).setQuery(((QueryDataSetDetail)dataSetActiveDetail).getQuery().toString());
          }
          if(((QueryDataSetDetail)dataSetActiveDetail).getDataSourceLabel()!=null){
            SbiDataSource hibDataSource = null;
            String dataSourceLabel = ((QueryDataSetDetail)dataSetActiveDetail).getDataSourceLabel();
            Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
            Criteria criteria = aSession.createCriteria(SbiDataSource.class);
            criteria.add(labelCriterrion)
            hibDataSource = (SbiDataSource) criteria.uniqueResult();
            ((SbiQueryDataSet)hibDataSet).setDataSource(hibDataSource)
          }       
        } 
       
        else if(dataSetActiveDetail instanceof QbeDataSetDetail){
          hibDataSet = new SbiQbeDataSet();
          SbiQbeDataSet hibQbeDataSet = (SbiQbeDataSet) hibDataSet;
          QbeDataSetDetail qbeDataSet = (QbeDataSetDetail) dataSetActiveDetail;
          hibQbeDataSet.setSqlQuery(qbeDataSet.getSqlQuery());
          hibQbeDataSet.setJsonQuery(qbeDataSet.getJsonQuery());
          hibQbeDataSet.setDatamarts(qbeDataSet.getDatamarts());
          String dataSourceLabel = qbeDataSet.getDataSourceLabel();
          Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
          Criteria criteria = aSession.createCriteria(SbiDataSource.class);
          criteria.add(labelCriterrion)
          SbiDataSource hibDataSource = (SbiDataSource) criteria.uniqueResult();
          hibQbeDataSet.setDataSource(hibDataSource)
        }

        else if(dataSetActiveDetail instanceof WSDataSetDetail){
          hibDataSet=new SbiWSDataSet();
          if(((WSDataSetDetail)dataSetActiveDetail).getAddress()!=null){
            ((SbiWSDataSet)hibDataSet).setAdress(((WSDataSetDetail)dataSetActiveDetail).getAddress());
          }
          if(((WSDataSetDetail)dataSetActiveDetail).getOperation()!=null){
            ((SbiWSDataSet)hibDataSet).setOperation(((WSDataSetDetail)dataSetActiveDetail).getOperation());
         
        }

        else if(dataSetActiveDetail instanceof JClassDataSetDetail){
          hibDataSet=new SbiJClassDataSet();
          if(((JClassDataSetDetail)dataSetActiveDetail).getJavaClassName()!=null){
            ((SbiJClassDataSet)hibDataSet).setJavaClassName(((JClassDataSetDetail)dataSetActiveDetail).getJavaClassName());
          }
        }

        else if(dataSetActiveDetail instanceof ScriptDataSetDetail){
          hibDataSet=new SbiScriptDataSet();
          if(((ScriptDataSetDetail)dataSetActiveDetail).getScript()!=null){
            ((SbiScriptDataSet)hibDataSet).setScript(((ScriptDataSetDetail)dataSetActiveDetail).getScript());
          }
          if(((ScriptDataSetDetail)dataSetActiveDetail).getLanguageScript()!=null){
            ((SbiScriptDataSet)hibDataSet).setLanguageScript(((ScriptDataSetDetail)dataSetActiveDetail).getLanguageScript());
          }
        }

        SbiDomains transformer = null;
        if (dataSetActiveDetail.getTransformerId() != null){
          Criterion aCriterion = Expression.eq("valueId",  dataSetActiveDetail.getTransformerId());
          Criteria criteria = aSession.createCriteria(SbiDomains.class);
          criteria.add(aCriterion);

          transformer = (SbiDomains) criteria.uniqueResult();

          if (transformer == null){
            logger.error("The Domain with value_id= "+dataSetActiveDetail.getTransformerId()+" does not exist.");
            throw new EMFUserError(EMFErrorSeverity.ERROR, 1035);
          }
        }

        SbiDomains category = null;
        if (dataSetActiveDetail.getCategoryId()!= null){
          Criterion aCriterion = Expression.eq("valueId",  dataSetActiveDetail.getCategoryId());
          Criteria criteria = aSession.createCriteria(SbiDomains.class);
          criteria.add(aCriterion);

          category = (SbiDomains) criteria.uniqueResult();

          if (category == null){
            logger.error("The Domain with value_id= "+dataSetActiveDetail.getCategoryId()+" does not exist.");
            throw new EMFUserError(EMFErrorSeverity.ERROR, 1035);
          }
        }
        Date currentTStamp = new Date();
        SbiDataSetConfig dsConfig = new SbiDataSetConfig();     
        dsConfig.setLabel(dataSet.getLabel());
        dsConfig.setDescription(dataSet.getDescription());
        dsConfig.setName(dataSet.getName())
        updateSbiCommonInfo4Insert(dsConfig);

        String userIn = dsConfig.getCommonInfo().getUserIn();
        String sbiVersionIn = dsConfig.getCommonInfo().getSbiVersionIn();
        hibDataSet.setUserIn(userIn);
        hibDataSet.setSbiVersionIn(sbiVersionIn);   
        hibDataSet.setVersionNum(1);
        hibDataSet.setTimeIn(currentTStamp)
       
        hibDataSet.setActive(true);     

        hibDataSet.setTransformer(transformer);
        hibDataSet.setPivotColumnName(dataSetActiveDetail.getPivotColumnName());
        hibDataSet.setPivotRowName(dataSetActiveDetail.getPivotRowName());
        hibDataSet.setPivotColumnValue(dataSetActiveDetail.getPivotColumnValue());
        hibDataSet.setNumRows(dataSetActiveDetail.isNumRows());

        hibDataSet.setCategory(category);
        hibDataSet.setParameters(dataSetActiveDetail.getParameters());
        hibDataSet.setDsMetadata(dataSetActiveDetail.getDsMetadata());

        Integer dsId =(Integer) aSession.save(dsConfig);
        dsConfig.setDsId(dsId);
        hibDataSet.setSbiDsConfig(dsConfig);
View Full Code Here

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

      aSession = getSession();
      tx = aSession.beginTransaction();
      SbiDataSetHistory hibDataSet =null;
      if(dataSet!=null){
        Integer dsId = dataSet.getDsId();
        GuiDataSetDetail dsActiveDetailToSet = dataSet.getActiveDetail()

        if(dsActiveDetailToSet instanceof FileDataSetDetail){
          hibDataSet=new SbiFileDataSet();
          if(((FileDataSetDetail)dsActiveDetailToSet).getFileName()!=null){
            ((SbiFileDataSet)hibDataSet).setFileName(((FileDataSetDetail)dsActiveDetailToSet).getFileName());
          }
        }

        else if(dsActiveDetailToSet instanceof QueryDataSetDetail){
          hibDataSet=new SbiQueryDataSet();
          if(((QueryDataSetDetail)dsActiveDetailToSet).getQuery()!=null){
            ((SbiQueryDataSet)hibDataSet).setQuery(((QueryDataSetDetail)dsActiveDetailToSet).getQuery().toString());
          }
          if(((QueryDataSetDetail)dsActiveDetailToSet).getDataSourceLabel()!=null){
            SbiDataSource hibDataSource = null;
            String dataSourceLabel = ((QueryDataSetDetail)dsActiveDetailToSet).getDataSourceLabel();
            Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
            Criteria criteria = aSession.createCriteria(SbiDataSource.class);
            criteria.add(labelCriterrion)
            hibDataSource = (SbiDataSource) criteria.uniqueResult();
            ((SbiQueryDataSet)hibDataSet).setDataSource(hibDataSource)
          }       
        }
       
        else if (dsActiveDetailToSet instanceof QbeDataSetDetail) {
          hibDataSet = new SbiQbeDataSet();
          SbiQbeDataSet hibQbeDataSet = (SbiQbeDataSet) hibDataSet;
          QbeDataSetDetail qbeDataSet = (QbeDataSetDetail) dsActiveDetailToSet;
          hibQbeDataSet.setSqlQuery(qbeDataSet.getSqlQuery());
          hibQbeDataSet.setJsonQuery(qbeDataSet.getJsonQuery());
          hibQbeDataSet.setDatamarts(qbeDataSet.getDatamarts());
          String dataSourceLabel = qbeDataSet.getDataSourceLabel();
          Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);
          Criteria criteria = aSession.createCriteria(SbiDataSource.class);
          criteria.add(labelCriterrion)
          SbiDataSource hibDataSource = (SbiDataSource) criteria.uniqueResult();
          hibQbeDataSet.setDataSource(hibDataSource)
        }

        else if(dsActiveDetailToSet instanceof WSDataSetDetail){
          hibDataSet=new SbiWSDataSet();
          if(((WSDataSetDetail)dsActiveDetailToSet).getAddress()!=null){
            ((SbiWSDataSet)hibDataSet).setAdress(((WSDataSetDetail)dsActiveDetailToSet).getAddress());
          }
          if(((WSDataSetDetail)dsActiveDetailToSet).getOperation()!=null){
            ((SbiWSDataSet)hibDataSet).setOperation(((WSDataSetDetail)dsActiveDetailToSet).getOperation());
         
        }

        else if(dsActiveDetailToSet instanceof JClassDataSetDetail){
          hibDataSet=new SbiJClassDataSet();
          if(((JClassDataSetDetail)dsActiveDetailToSet).getJavaClassName()!=null){
            ((SbiJClassDataSet)hibDataSet).setJavaClassName(((JClassDataSetDetail)dsActiveDetailToSet).getJavaClassName());
          }
        }

        else if(dsActiveDetailToSet instanceof ScriptDataSetDetail){
          hibDataSet=new SbiScriptDataSet();
          if(((ScriptDataSetDetail)dsActiveDetailToSet).getScript()!=null){
            ((SbiScriptDataSet)hibDataSet).setScript(((ScriptDataSetDetail)dsActiveDetailToSet).getScript());
          }
          if(((ScriptDataSetDetail)dsActiveDetailToSet).getLanguageScript()!=null){
            ((SbiScriptDataSet)hibDataSet).setLanguageScript(((ScriptDataSetDetail)dsActiveDetailToSet).getLanguageScript());
          }
        }

        SbiDomains transformer = null;
        if (dsActiveDetailToSet.getTransformerId() != null){
          Criterion aCriterion = Expression.eq("valueId",  dsActiveDetailToSet.getTransformerId());
          Criteria criteria = aSession.createCriteria(SbiDomains.class);
          criteria.add(aCriterion);
          transformer = (SbiDomains) criteria.uniqueResult();
          if (transformer == null){
            logger.error("The Domain with value_id= "+dsActiveDetailToSet.getTransformerId()+" does not exist.");
            throw new EMFUserError(EMFErrorSeverity.ERROR, 1035);
          }
        }

        SbiDomains category = null;
        if (dsActiveDetailToSet.getCategoryId()!= null){
          Criterion aCriterion = Expression.eq("valueId",  dsActiveDetailToSet.getCategoryId());
          Criteria criteria = aSession.createCriteria(SbiDomains.class);
          criteria.add(aCriterion)
          category = (SbiDomains) criteria.uniqueResult()
          if (category == null){
            logger.error("The Domain with value_id= "+dsActiveDetailToSet.getCategoryId()+" does not exist.");
            throw new EMFUserError(EMFErrorSeverity.ERROR, 1035);
          }
        }
        Date currentTStamp = new Date();

        hibDataSet.setTimeIn(currentTStamp);   
        hibDataSet.setActive(true);     

        hibDataSet.setTransformer(transformer);
        hibDataSet.setPivotColumnName(dsActiveDetailToSet.getPivotColumnName());
        hibDataSet.setPivotRowName(dsActiveDetailToSet.getPivotRowName());
        hibDataSet.setPivotColumnValue(dsActiveDetailToSet.getPivotColumnValue());
        hibDataSet.setNumRows(dsActiveDetailToSet.isNumRows());

        hibDataSet.setCategory(category);
        hibDataSet.setParameters(dsActiveDetailToSet.getParameters());
        hibDataSet.setDsMetadata(dsActiveDetailToSet.getDsMetadata());

        SbiDataSetConfig hibGenericDataSet = (SbiDataSetConfig) aSession.load(SbiDataSetConfig.class,dsId);         
        hibGenericDataSet.setLabel(dataSet.getLabel());
        hibGenericDataSet.setDescription(dataSet.getDescription());
        hibGenericDataSet.setName(dataSet.getName())
View Full Code Here

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

            if(olderTemplates!=null && !olderTemplates.isEmpty()){
              Iterator it2 = olderTemplates.iterator();
              while(it2.hasNext()){
                SbiDataSetHistory hibOldDataSet = (SbiDataSetHistory) it2.next();
                if(hibOldDataSet!=null && !hibOldDataSet.isActive()){
                  GuiDataSetDetail dsD = toDataSetDetail(hibOldDataSet);   
                  oldDsVersion.add(dsD);
                }
              }
            }     
          }
View Full Code Here

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

            if(olderTemplates!=null && !olderTemplates.isEmpty()){
              Iterator it2 = olderTemplates.iterator();
              while(it2.hasNext()){
                SbiDataSetHistory hibOldDataSet = (SbiDataSetHistory) it2.next();
                if(hibOldDataSet!=null && !hibOldDataSet.isActive()){
                  GuiDataSetDetail dsD = toDataSetDetail(hibOldDataSet);   
                  oldDsVersion.add(dsD);
                }
              }
            }     
          }
View Full Code Here

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

  }

  public GuiGenericDataSet toDataSet(SbiDataSetHistory hibDataSet) throws EMFUserError{   
    logger.debug("IN");
    GuiGenericDataSet ds = new GuiGenericDataSet();
    GuiDataSetDetail dsActiveDetail = null;

    if(hibDataSet instanceof SbiFileDataSet){   
      dsActiveDetail = new FileDataSetDetail();
      ((FileDataSetDetail)dsActiveDetail).setFileName(((SbiFileDataSet)hibDataSet).getFileName());   
      dsActiveDetail.setDsType(FILE_DS_TYPE);
      logger.debug("File dataset");
    }

    if(hibDataSet instanceof SbiQueryDataSet){     
      dsActiveDetail=new QueryDataSetDetail();
      ((QueryDataSetDetail)dsActiveDetail).setQuery(((SbiQueryDataSet)hibDataSet).getQuery());
      SbiDataSource sbids=((SbiQueryDataSet)hibDataSet).getDataSource();
      if(sbids!=null){
        String dataSourceLabel = sbids.getLabel();
        ((QueryDataSetDetail)dsActiveDetail).setDataSourceLabel(dataSourceLabel);
      }
      dsActiveDetail.setDsType(JDBC_DS_TYPE);
      logger.debug("Jdbc dataset");
    }
   
    if(hibDataSet instanceof SbiQbeDataSet){     
      dsActiveDetail = new QbeDataSetDetail();
      QbeDataSetDetail aQbeDataSetDetail = (QbeDataSetDetail) dsActiveDetail;
      SbiQbeDataSet qbeHibDataSet = (SbiQbeDataSet) hibDataSet;
      aQbeDataSetDetail.setSqlQuery(qbeHibDataSet.getSqlQuery());
      aQbeDataSetDetail.setJsonQuery(qbeHibDataSet.getJsonQuery());
      aQbeDataSetDetail.setDatamarts(qbeHibDataSet.getDatamarts());
      SbiDataSource sbids = qbeHibDataSet.getDataSource();
      if (sbids!=null){
        aQbeDataSetDetail.setDataSourceLabel(sbids.getLabel());
      }
      dsActiveDetail.setDsType(QBE_DS_TYPE);
    }

    if(hibDataSet instanceof SbiWSDataSet){     
      dsActiveDetail=new WSDataSetDetail();
      ((WSDataSetDetail)dsActiveDetail).setAddress(((SbiWSDataSet)hibDataSet).getAdress());
      ((WSDataSetDetail)dsActiveDetail).setOperation(((SbiWSDataSet)hibDataSet).getOperation());
      dsActiveDetail.setDsType(WS_DS_TYPE);
      logger.debug("Ws dataset");
    }

    if(hibDataSet instanceof SbiScriptDataSet){     
      dsActiveDetail=new ScriptDataSetDetail();
      ((ScriptDataSetDetail)dsActiveDetail).setScript(((SbiScriptDataSet)hibDataSet).getScript());
      ((ScriptDataSetDetail)dsActiveDetail).setLanguageScript(((SbiScriptDataSet)hibDataSet).getLanguageScript());
      dsActiveDetail.setDsType(SCRIPT_DS_TYPE);
      logger.debug("Script dataset");
    }

    if(hibDataSet instanceof SbiJClassDataSet){     
      dsActiveDetail=new JClassDataSetDetail();
      ((JClassDataSetDetail)dsActiveDetail).setJavaClassName(((SbiJClassDataSet)hibDataSet).getJavaClassName());
      dsActiveDetail.setDsType(JCLASS_DS_TYPE);
      logger.debug("JClass dataset");
    }

    if(hibDataSet.getSbiDsConfig()!=null){
      ds.setDsId(hibDataSet.getSbiDsConfig().getDsId());
      ds.setName(hibDataSet.getSbiDsConfig().getName());
      ds.setLabel(hibDataSet.getSbiDsConfig().getLabel());
      ds.setDescription(hibDataSet.getSbiDsConfig().getDescription())
      ds.setMetaVersion(hibDataSet.getMetaVersion());
      ds.setUserIn(hibDataSet.getUserIn());
      ds.setTimeIn(new Date());
      dsActiveDetail.setDsId(hibDataSet.getSbiDsConfig().getDsId());

    }

    dsActiveDetail.setDsHId(hibDataSet.getDsHId());
    dsActiveDetail.setCategoryId((hibDataSet.getCategory()== null)? null:hibDataSet.getCategory().getValueId());
    dsActiveDetail.setCategoryValueName((hibDataSet.getCategory()== null)? null:hibDataSet.getCategory().getValueNm());
    dsActiveDetail.setTransformerId((hibDataSet.getTransformer()== null)? null:hibDataSet.getTransformer().getValueId());
    dsActiveDetail.setTransformerCd((hibDataSet.getTransformer()== null)? null:hibDataSet.getTransformer().getValueCd());
    dsActiveDetail.setPivotColumnName(hibDataSet.getPivotColumnName());
    dsActiveDetail.setPivotRowName(hibDataSet.getPivotRowName());
    dsActiveDetail.setPivotColumnValue(hibDataSet.getPivotColumnValue());
    dsActiveDetail.setNumRows(hibDataSet.isNumRows());     
    dsActiveDetail.setParameters(hibDataSet.getParameters());   
    dsActiveDetail.setDsMetadata(hibDataSet.getDsMetadata());   
    dsActiveDetail.setUserIn(hibDataSet.getUserIn());
    dsActiveDetail.setTimeIn(hibDataSet.getTimeIn());
    dsActiveDetail.setVersionNum(hibDataSet.getVersionNum());
    dsActiveDetail.setSbiVersionIn(hibDataSet.getSbiVersionIn());
    dsActiveDetail.setDsHId(hibDataSet.getDsHId());

    ds.setActiveDetail(dsActiveDetail);

    logger.debug("OUT");
    return ds;
View Full Code Here

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

    return ds;
  }

  public GuiDataSetDetail toDataSetDetail(SbiDataSetHistory hibDataSet) throws EMFUserError{   

    GuiDataSetDetail dsVersionDetail = null;

    if(hibDataSet instanceof SbiFileDataSet){   
      dsVersionDetail = new FileDataSetDetail();
      ((FileDataSetDetail)dsVersionDetail).setFileName(((SbiFileDataSet)hibDataSet).getFileName());   
      dsVersionDetail.setDsType(FILE_DS_TYPE);
    }

    if(hibDataSet instanceof SbiQueryDataSet){     
      dsVersionDetail=new QueryDataSetDetail();
      ((QueryDataSetDetail)dsVersionDetail).setQuery(((SbiQueryDataSet)hibDataSet).getQuery());
      SbiDataSource sbids=((SbiQueryDataSet)hibDataSet).getDataSource();
      if(sbids!=null){
        String dataSourceLabel = sbids.getLabel();
        ((QueryDataSetDetail)dsVersionDetail).setDataSourceLabel(dataSourceLabel);
      }
      dsVersionDetail.setDsType(JDBC_DS_TYPE);
    }
   
    if (hibDataSet instanceof SbiQbeDataSet){     
      dsVersionDetail = new QbeDataSetDetail();
      QbeDataSetDetail aQbeDataSetDetail = (QbeDataSetDetail) dsVersionDetail;
      SbiQbeDataSet qbeHibDataSet = (SbiQbeDataSet) hibDataSet;
      aQbeDataSetDetail.setSqlQuery(qbeHibDataSet.getSqlQuery());
      aQbeDataSetDetail.setJsonQuery(qbeHibDataSet.getJsonQuery());
      aQbeDataSetDetail.setDatamarts(qbeHibDataSet.getDatamarts());
      SbiDataSource sbids = qbeHibDataSet.getDataSource();
      if (sbids!=null) aQbeDataSetDetail.setDataSourceLabel(sbids.getLabel());
      dsVersionDetail.setDsType(QBE_DS_TYPE);
    }

    if(hibDataSet instanceof SbiWSDataSet){     
      dsVersionDetail=new WSDataSetDetail();
      ((WSDataSetDetail)dsVersionDetail).setAddress(((SbiWSDataSet)hibDataSet).getAdress());
      ((WSDataSetDetail)dsVersionDetail).setOperation(((SbiWSDataSet)hibDataSet).getOperation());
      dsVersionDetail.setDsType(WS_DS_TYPE);
    }

    if(hibDataSet instanceof SbiScriptDataSet){     
      dsVersionDetail=new ScriptDataSetDetail();
      ((ScriptDataSetDetail)dsVersionDetail).setScript(((SbiScriptDataSet)hibDataSet).getScript());
      ((ScriptDataSetDetail)dsVersionDetail).setLanguageScript(((SbiScriptDataSet)hibDataSet).getLanguageScript());
      dsVersionDetail.setDsType(SCRIPT_DS_TYPE);
    }

    if(hibDataSet instanceof SbiJClassDataSet){     
      dsVersionDetail=new JClassDataSetDetail();
      ((JClassDataSetDetail)dsVersionDetail).setJavaClassName(((SbiJClassDataSet)hibDataSet).getJavaClassName());
      dsVersionDetail.setDsType(JCLASS_DS_TYPE);
    }

    dsVersionDetail.setCategoryId((hibDataSet.getCategory()== null)? null:hibDataSet.getCategory().getValueId());
    dsVersionDetail.setCategoryValueName((hibDataSet.getCategory()== null)? null:hibDataSet.getCategory().getValueNm());
    dsVersionDetail.setTransformerId((hibDataSet.getTransformer()== null)? null:hibDataSet.getTransformer().getValueId());
    dsVersionDetail.setTransformerCd((hibDataSet.getTransformer()== null)? null:hibDataSet.getTransformer().getValueCd());
    dsVersionDetail.setPivotColumnName(hibDataSet.getPivotColumnName());
    dsVersionDetail.setPivotRowName(hibDataSet.getPivotRowName());
    dsVersionDetail.setPivotColumnValue(hibDataSet.getPivotColumnValue());
    dsVersionDetail.setNumRows(hibDataSet.isNumRows());     
    dsVersionDetail.setParameters(hibDataSet.getParameters());   
    dsVersionDetail.setDsMetadata(hibDataSet.getDsMetadata())

    dsVersionDetail.setUserIn(hibDataSet.getUserIn());
    dsVersionDetail.setTimeIn(hibDataSet.getTimeIn());
    dsVersionDetail.setVersionNum(hibDataSet.getVersionNum());
    dsVersionDetail.setSbiVersionIn(hibDataSet.getSbiVersionIn());
    dsVersionDetail.setDsHId(hibDataSet.getDsHId());

    return dsVersionDetail;
  }
View Full Code Here

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

   * @return The corrispondent <code>GuiGenericDataSet</code> object
   * @throws EMFUserError
   */
  public GuiGenericDataSet toDataSet(IDataSet iDataSet) throws EMFUserError{   
    GuiGenericDataSet ds = new GuiGenericDataSet();
    GuiDataSetDetail dsActiveDetail = null;

    if(iDataSet instanceof FileDataSet){   
      dsActiveDetail = new FileDataSetDetail();
      ((FileDataSetDetail)dsActiveDetail).setFileName(((FileDataSet)iDataSet).getFileName());   
      dsActiveDetail.setDsType(FILE_DS_TYPE);
    }

    if(iDataSet instanceof JDBCDataSet){     
      dsActiveDetail=new QueryDataSetDetail();
      ((QueryDataSetDetail)dsActiveDetail).setQuery((String)(((JDBCDataSet)iDataSet).getQuery()));
      IDataSource iDataSource=((JDBCDataSet)iDataSet).getDataSource();
      if(iDataSource!=null){
        String dataSourceLabel = iDataSource.getLabel();
        ((QueryDataSetDetail)dsActiveDetail).setDataSourceLabel(dataSourceLabel);
      }
      dsActiveDetail.setDsType(JDBC_DS_TYPE);
    }
   
    if(iDataSet instanceof QbeDataSet){     
      dsActiveDetail = new QbeDataSetDetail();
      QbeDataSetDetail aQbeDataSetDetail = (QbeDataSetDetail) dsActiveDetail;
      QbeDataSet aQbeDataSet = (QbeDataSet) iDataSet;
      aQbeDataSetDetail.setJsonQuery(aQbeDataSet.getJsonQuery());
      aQbeDataSetDetail.setDatamarts(aQbeDataSet.getDatamarts());
      IDataSource iDataSource = aQbeDataSet.getDataSource();
      if (iDataSource!=null){
        String dataSourceLabel = iDataSource.getLabel();
        aQbeDataSetDetail.setDataSourceLabel(dataSourceLabel);
      }
      dsActiveDetail.setDsType(QBE_DS_TYPE);
    }

    if(iDataSet instanceof WebServiceDataSet){     
      dsActiveDetail=new WSDataSetDetail();
      ((WSDataSetDetail)dsActiveDetail).setAddress(((WebServiceDataSet)iDataSet).getAddress());
      ((WSDataSetDetail)dsActiveDetail).setOperation(((WebServiceDataSet)iDataSet).getOperation());
      dsActiveDetail.setDsType(WS_DS_TYPE);
    }

    if(iDataSet instanceof ScriptDataSet){     
      dsActiveDetail=new ScriptDataSetDetail();
      ((ScriptDataSetDetail)dsActiveDetail).setScript(((ScriptDataSet)iDataSet).getScript());
      ((ScriptDataSetDetail)dsActiveDetail).setLanguageScript(((ScriptDataSet)iDataSet).getLanguageScript());
      dsActiveDetail.setDsType(SCRIPT_DS_TYPE);
    }

    if(iDataSet instanceof JavaClassDataSet){     
      dsActiveDetail=new JClassDataSetDetail();
      ((JClassDataSetDetail)dsActiveDetail).setJavaClassName(((JavaClassDataSet)iDataSet).getClassName());
      dsActiveDetail.setDsType(JCLASS_DS_TYPE);
    }

    ds.setDsId(iDataSet.getId());
    ds.setName(iDataSet.getName());
    ds.setLabel(iDataSet.getLabel());
    ds.setDescription(iDataSet.getDescription())

    // set detail dataset ID
    dsActiveDetail.setTransformerId((iDataSet.getTransformerId() == null)? null:iDataSet.getTransformerId());
    dsActiveDetail.setPivotColumnName(iDataSet.getPivotColumnName());
    dsActiveDetail.setPivotRowName(iDataSet.getPivotRowName());
    dsActiveDetail.setPivotColumnValue(iDataSet.getPivotColumnValue());
    dsActiveDetail.setNumRows(iDataSet.isNumRows());     
    dsActiveDetail.setParameters(iDataSet.getParameters());   
    dsActiveDetail.setDsMetadata(iDataSet.getDsMetadata());   

    ds.setActiveDetail(dsActiveDetail);

    return ds;
  }
View Full Code Here

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

          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);
View Full Code Here

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

        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.GuiDataSetDetail

    }   
    return ds;
  }
 
  private GuiDataSetDetail constructDataSetDetail(String dsType){
    GuiDataSetDetail dsActiveDetail = instantiateCorrectDsDetail(dsType);
   
    if(dsActiveDetail!=null){
      dsActiveDetail.setDsType(dsType);
     
      String catTypeCd = getAttributeAsString(DataSetConstants.CATEGORY_TYPE_VN);     
      JSONArray parsJSON = getAttributeAsJSONArray(DataSetConstants.PARS);
      String meta = getAttributeAsString(DataSetConstants.METADATA);         
      String trasfTypeCd = getAttributeAsString(DataSetConstants.TRASFORMER_TYPE_CD);
     
      List<Domain> domainsCat = (List<Domain>)getSessionContainer().getAttribute("catTypesList");     
      HashMap<String, Integer> domainIds = new HashMap<String, Integer> ();
        if(domainsCat != null){
          for(int i=0; i< domainsCat.size(); i++){
            domainIds.put(domainsCat.get(i).getValueName(), domainsCat.get(i).getValueId());
          }
        }
        Integer catTypeID = domainIds.get(catTypeCd);
        if(catTypeID!=null){
        dsActiveDetail.setCategoryValueName(catTypeCd);
        dsActiveDetail.setCategoryId(catTypeID);
      }

      if(meta != null && !meta.equals("")){
        dsActiveDetail.setDsMetadata(meta);
      }
     
      if(parsJSON != null){
        String pars;
        try {
          pars = deserializeParsListJSONArray(parsJSON);
          dsActiveDetail.setParameters(pars);
        } catch (JSONException e) {
          logger.error("Error in deserializing parameter",e);
          e.printStackTrace();
        } catch (SourceBeanException e) {
          logger.error("Source Bean Exception",e);
          e.printStackTrace();
        }
      }

      if(trasfTypeCd!=null && !trasfTypeCd.equals("")){
        dsActiveDetail = setTransformer(dsActiveDetail, trasfTypeCd);
      }
     
      IDataSet ds = null;   
      try {
        if ( dsType!=null && !dsType.equals("")) {
         
          ds = instantiateCorrectIDataSetType(dsType);   
          if(ds!=null){                 
            if(trasfTypeCd!=null && !trasfTypeCd.equals("")){
              ds = setTransformer(ds, trasfTypeCd);
            }
            HashMap h = new HashMap();
            if(parsJSON!=null){
              h = deserializeParValuesListJSONArray(parsJSON);
            }
            IEngUserProfile profile = getUserProfile();
            String dsMetadata = getDatasetTestMetadata(ds, h, profile)
            dsActiveDetail.setDsMetadata(dsMetadata);
          }             
        }else{
          logger.error("DataSet type is not existent");
          throw new SpagoBIServiceException(SERVICE_NAME,  "sbi.ds.dsTypeError");
        }
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.