Examples of SbiDataSetHistory


Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

    try {
      aSession = getSession();
      tx = aSession.beginTransaction();

      if(dsVerionID!=null){
        SbiDataSetHistory hibDataSet = (SbiDataSetHistory) aSession.load(SbiDataSetHistory.class,dsVerionID);
        if(hibDataSet!=null && !hibDataSet.isActive()){
          aSession.delete(hibDataSet);
          tx.commit()
          deleted = true;
       
      }
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

        hibQuery.setInteger(1, dsID)
        List toBeDeleted = hibQuery.list();
        if(toBeDeleted!=null && !toBeDeleted.isEmpty()){
          Iterator it = toBeDeleted.iterator();
          while(it.hasNext()){
            SbiDataSetHistory hibDataSet = (SbiDataSetHistory) it.next();
            if(hibDataSet!=null && !hibDataSet.isActive()){
              aSession.delete(hibDataSet);     
            }
          }
          tx.commit();
       
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

    Transaction tx = null;
    Integer idToReturn = null;
    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);

        aSession.save(hibDataSet);

        idToReturn = dsId;
        tx.commit();
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

      if(dsId!=null && dsVersion!=null){

        Query hibQuery = aSession.createQuery("from SbiDataSetHistory h where h.active = ? and h.sbiDsConfig = ?" );
        hibQuery.setBoolean(0, true);
        hibQuery.setInteger(1, dsId)
        SbiDataSetHistory dsActiveDetail =(SbiDataSetHistory)hibQuery.uniqueResult();
        dsActiveDetail.setActive(false);

        Query hibernateQuery = aSession.createQuery("from SbiDataSetHistory h where h.versionNum = ? and h.sbiDsConfig = ?" );
        hibernateQuery.setInteger(0, dsVersion);
        hibernateQuery.setInteger(1, dsId)
        SbiDataSetHistory dsDetail =(SbiDataSetHistory)hibernateQuery.uniqueResult();
        dsDetail.setActive(true);
       
        if(dsActiveDetail.getSbiDsConfig()!=null){
          SbiDataSetConfig hibDs = dsActiveDetail.getSbiDsConfig();
          updateSbiCommonInfo4Update(hibDs);
          aSession.update(hibDs);
        }
       
        if(dsDetail.getSbiDsConfig()!=null){
          SbiDataSetConfig hibDs = dsDetail.getSbiDsConfig();
          updateSbiCommonInfo4Update(hibDs);
          aSession.update(hibDs);
        }

        aSession.update(dsActiveDetail);
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

    Session aSession = null;
    Transaction tx = null;
    try {
      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())
       
        updateSbiCommonInfo4Update(hibGenericDataSet);

        String userUp = hibGenericDataSet.getCommonInfo().getUserUp();
        String sbiVersionUp = hibGenericDataSet.getCommonInfo().getSbiVersionUp();
        hibDataSet.setUserIn(userUp);
        hibDataSet.setSbiVersionIn(sbiVersionUp)
        hibDataSet.setTimeIn(currentTStamp);

        Integer currenthigherVersion = getHigherVersionNumForDS(dsId);
        Integer newVersion = currenthigherVersion+1;
        hibDataSet.setVersionNum(newVersion);

        Query hibQuery = aSession.createQuery("from SbiDataSetHistory h where h.active = ? and h.sbiDsConfig = ?" );
        hibQuery.setBoolean(0, true);
        hibQuery.setInteger(1, dsId)
        SbiDataSetHistory dsActiveDetail =(SbiDataSetHistory)hibQuery.uniqueResult();
        dsActiveDetail.setActive(false);
        aSession.update(dsActiveDetail);

        aSession.update(hibGenericDataSet);
        hibDataSet.setSbiDsConfig(hibGenericDataSet);       
        aSession.save(hibDataSet);
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

      List sbiActiveDatasetsList = hibernateQuery.list()

      if(sbiActiveDatasetsList!=null && !sbiActiveDatasetsList.isEmpty()){
        Iterator it = sbiActiveDatasetsList.iterator();   
        while (it.hasNext()) {
          SbiDataSetHistory hibDataSet = (SbiDataSetHistory)it.next();
          GuiGenericDataSet ds = toDataSet(hibDataSet);
          List<GuiDataSetDetail> oldDsVersion = new ArrayList();

          if(hibDataSet.getSbiDsConfig()!=null){
            Integer dsId = hibDataSet.getSbiDsConfig().getDsId();
            Query hibQuery = aSession.createQuery("from SbiDataSetHistory h where h.active = ? and h.sbiDsConfig = ?" );
            hibQuery.setBoolean(0, false);
            hibQuery.setInteger(1, dsId)

            List<SbiDataSetHistory> olderTemplates = hibQuery.list();
            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.metadata.SbiDataSetHistory

      List sbiActiveDatasetsList = hibernateQuery.list()

      if(sbiActiveDatasetsList!=null && !sbiActiveDatasetsList.isEmpty()){
        Iterator it = sbiActiveDatasetsList.iterator();   
        while (it.hasNext()) {
          SbiDataSetHistory hibDataSet = (SbiDataSetHistory)it.next();
          GuiGenericDataSet ds = toDataSet(hibDataSet);
          List<GuiDataSetDetail> oldDsVersion = new ArrayList();

          if(hibDataSet.getSbiDsConfig()!=null){
            Integer dsId = hibDataSet.getSbiDsConfig().getDsId();
            Query hibQuery = aSession.createQuery("from SbiDataSetHistory h where h.active = ? and h.sbiDsConfig = ?" );
            hibQuery.setBoolean(0, false);
            hibQuery.setInteger(1, dsId)

            List<SbiDataSetHistory> olderTemplates = hibQuery.list();
            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.metadata.SbiDataSetHistory

   */

  public SbiDataSetHistory copyDataSetHistory(SbiDataSetHistory hibDataSet) throws EMFUserError{   

    logger.debug("IN");
    SbiDataSetHistory hibNew = null;

    if(hibDataSet instanceof SbiFileDataSet){   
      hibNew  = new SbiFileDataSet();
      ((SbiFileDataSet)hibNew).setFileName(((SbiFileDataSet)hibDataSet).getFileName());   
    }

    if(hibDataSet instanceof SbiQueryDataSet){     
      hibNew  = new SbiQueryDataSet();
      ((SbiQueryDataSet)hibNew).setQuery(((SbiQueryDataSet)hibDataSet).getQuery());
    }

    if(hibDataSet instanceof SbiWSDataSet){     
      hibNew  = new SbiWSDataSet();
      ((SbiWSDataSet)hibNew ).setAdress(((SbiWSDataSet)hibDataSet).getAdress());
      ((SbiWSDataSet)hibNew ).setOperation(((SbiWSDataSet)hibDataSet).getOperation());
    }

    if(hibDataSet instanceof SbiScriptDataSet){     
      hibNew =new SbiScriptDataSet();
      ((SbiScriptDataSethibNew ).setScript(((SbiScriptDataSet)hibDataSet).getScript());
      ((SbiScriptDataSethibNew ).setLanguageScript(((SbiScriptDataSet)hibDataSet).getLanguageScript());

    }

    if(hibDataSet instanceof SbiJClassDataSet){     
      hibNew =new SbiJClassDataSet();
      ((SbiJClassDataSethibNew ).setJavaClassName(((SbiJClassDataSet)hibDataSet).getJavaClassName());
    }

    hibNew.setCategory(hibDataSet.getCategory());
    hibNew.setDsMetadata(hibDataSet.getDsMetadata());
    hibNew.setMetaVersion(hibDataSet.getMetaVersion());
    hibNew.setParameters(hibDataSet.getParameters());
    hibNew.setPivotColumnName(hibDataSet.getPivotColumnName());
    hibNew.setPivotColumnValue(hibDataSet.getPivotColumnValue());
    hibNew.setPivotRowName(hibDataSet.getPivotRowName());
    hibNew.setTransformer(hibDataSet.getTransformer());
    hibNew.setSbiVersionIn(hibDataSet.getSbiVersionIn());
    hibNew.setUserIn(hibDataSet.getUserIn());
    hibNew.setTimeIn(hibDataSet.getTimeIn());
    hibNew.setVersionNum(hibDataSet.getVersionNum());
    hibNew.setDsHId(hibDataSet.getDsHId());

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

Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

      tx = aSession.beginTransaction();

      Query hibQueryHistory = aSession.createQuery("from SbiDataSetHistory h where h.active = ? and h.sbiDsConfig = ?" );
      hibQueryHistory.setBoolean(0, true);
      hibQueryHistory.setInteger(1, dsId)
      SbiDataSetHistory sbiDataSetHistory =(SbiDataSetHistory)hibQueryHistory.uniqueResult();
      if(sbiDataSetHistory!=null){
        toReturn = toDataSet(sbiDataSetHistory);
     
      tx.commit();
View Full Code Here

Examples of it.eng.spagobi.tools.dataset.metadata.SbiDataSetHistory

      tx = aSession.beginTransaction();

      Query hibQueryHistory = aSession.createQuery("from SbiDataSetHistory h where h.active = ? and h.sbiDsConfig.label = ? " );
      hibQueryHistory.setBoolean(0, true);
      hibQueryHistory.setString(1, dsLabel)
      SbiDataSetHistory sbiDataSetHistory =(SbiDataSetHistory)hibQueryHistory.uniqueResult();
      if(sbiDataSetHistory!=null){
        detail = toDataSetDetail(sbiDataSetHistory);
        toReturn = toDataSet(sbiDataSetHistory);
        }
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.