Package it.eng.spagobi.commons.metadata

Examples of it.eng.spagobi.commons.metadata.SbiDomains



    List exportedDomains = importer.getAllExportedSbiObjects(sessionExpDB, "SbiDomains", null);
    Iterator iterSbiDomains = exportedDomains.iterator();
    while (iterSbiDomains.hasNext()) {
      SbiDomains dsExp = (SbiDomains) iterSbiDomains.next();
      String label = dsExp.getValueCd();
      Object existObj = importer.checkExistenceDomain(label, dsExp.getDomainCd(), sessionCurrDB, new SbiDomains());
      if (existObj != null) {
        SbiDomains dsCurr = (SbiDomains) existObj;
        metaAss.insertCoupleDomain(new Integer(dsExp.getValueId()), new Integer(dsCurr.getValueId()));
        metaLog.log("Found an existing domain" + dsCurr.getValueCd() + " with "
            + "the same label of one exported domain");
      }
    }


    // Alarm

    List exportedAlarms = importer.getAllExportedSbiObjects(sessionExpDB, "SbiAlarm", null);
    Iterator iterSbiAlarm = exportedAlarms.iterator();
    while (iterSbiAlarm.hasNext()) {
      SbiAlarm dsExp = (SbiAlarm) iterSbiAlarm.next();
      String label = dsExp.getLabel();
      Object existObj = importer.checkExistence(label, sessionCurrDB, new SbiAlarm());
      if (existObj != null) {
        SbiAlarm dsCurr = (SbiAlarm) existObj;
        metaAss.insertCoupleAlarm(dsExp.getId(), dsCurr.getId());
        metaLog.log("Found an existing alarm " + dsCurr.getLabel() + " with "
            + "the same label of one exported alarm");
      }
    }

    // Alarm Contact

    List exportedAlarmContacts = importer.getAllExportedSbiObjects(sessionExpDB, "SbiAlarmContact", null);
    Iterator iterSbiAlarmContacts = exportedAlarmContacts.iterator();
    while (iterSbiAlarmContacts.hasNext()) {
      SbiAlarmContact dsExp = (SbiAlarmContact) iterSbiAlarmContacts.next();
      String name = dsExp.getName();
      Object existObj = importer.checkExistence(name, sessionCurrDB, new SbiAlarmContact());
      if (existObj != null) {
        SbiAlarmContact dsCurr = (SbiAlarmContact) existObj;
        metaAss.insertCoupleAlarmContact(dsExp.getId(), dsCurr.getId());
        metaLog.log("Found an existing alarm contact " + dsCurr.getName() + " with "
            + "the same name of one exported alarm contact");
      }
    }

    // TODO cambiare con i nuovi UDP VAlues
/*
    List exportedKpiModelAttrs = importer.getAllExportedSbiObjects(sessionExpDB, "SbiKpiModelAttr", null);
    Iterator iterSbiKpiModelAttr = exportedKpiModelAttrs.iterator();
    while (iterSbiKpiModelAttr.hasNext()) {
      SbiKpiModelAttr attrExp = (SbiKpiModelAttr) iterSbiKpiModelAttr.next();
      SbiDomains sbiDomain  = attrExp.getSbiDomains();
      String kpiModelAttrCd  = attrExp.getKpiModelAttrCd();
      // get new sbi Domain ID
      Integer newIdDomain = (Integer)metaAss.getDomainIDAssociation().get(sbiDomain.getValueId());
      Object existObj = importer.checkExistenceKpiModelAttr(newIdDomain, kpiModelAttrCd, sessionCurrDB, new SbiKpiModelAttr());
      if (existObj != null) {
        SbiKpiModelAttr attrCurr = (SbiKpiModelAttr) existObj;
        metaAss.insertCoupleSbiKpiModelAttrID(attrExp.getKpiModelAttrId(), attrCurr.getKpiModelAttrId());
        metaLog.log("Found an existing model attr with code " + attrCurr.getKpiModelAttrCd() + " " +
            " and referring to domain "+ sbiDomain.getDomainCd()+" - "+ sbiDomain.getValueCd() +" with "
            + "the same name of one exported kpi model attr");
      }
    }


    // Model Attr Val

    List exportedKpiModelAttrVals = importer.getAllExportedSbiObjects(sessionExpDB, "SbiKpiModelAttrVal", null);
    Iterator iterSbiKpiModelAttrVal = exportedKpiModelAttrVals.iterator();
    while (iterSbiKpiModelAttrVal.hasNext()) {
      SbiKpiModelAttrVal attrValExp = (SbiKpiModelAttrVal) iterSbiKpiModelAttrVal.next();
      Integer kpiModelId = attrValExp.getSbiKpiModel().getKpiModelId();
      Integer kpiModelAttrId = attrValExp.getSbiKpiModelAttr().getKpiModelAttrId();

      // get the new Ids
      Integer newModelId = (Integer)metaAss.getModelIDAssociation().get(kpiModelId);
      Integer newModelAttrId = (Integer)metaAss.getSbiKpiModelAttrIDAssociation().get(kpiModelAttrId);

      // get new sbi Domain ID
      Object existObj = importer.checkExistenceKpiModelAttrVal(newModelAttrId, newModelId, sessionCurrDB, new SbiKpiModelAttrVal());
      if (existObj != null) {
        SbiKpiModelAttrVal attrValCurr = (SbiKpiModelAttrVal) existObj;
        metaAss.insertCoupleSbiKpiModelAttrValID(attrValExp.getKpiModelAttrValId(), attrValCurr.getKpiModelAttrValId());
        metaLog.log("Found an existing model attribute value referring to model" + attrValCurr.getSbiKpiModel().getKpiModelNm()+ " " +
            " and referring to attribute "+ attrValCurr.getSbiKpiModelAttr().getKpiModelAttrCd()+" with "
            + "the same name of one exported kpi model attr");
      }
    }
*/

    logger.debug("check existence of Object MetaContent, only for Objects!");
    List exportedMetaContent = importer.getAllExportedSbiObjects(sessionExpDB, "SbiObjMetacontents", null);
    Iterator iterSbiModMetaContent = exportedMetaContent.iterator();
    while (iterSbiModMetaContent.hasNext()) {
      SbiObjMetacontents contExp = (SbiObjMetacontents) iterSbiModMetaContent.next();
      String objectLabel = contExp.getSbiObjects().getLabel();
      // metacontent referring to subobjects not referred here because of a previous structure
      if( contExp.getSbiSubObjects() != null ){
        continue;
        //        SbiSubObjects sub = contExp.getSbiSubObjects();
        //        subObjectName = sub.getName();
      }
      Integer objMetaId = contExp.getObjmetaId();

      // I want metadata label
      String metaLabel = exportedMetadatasMap.get(objMetaId.toString());

      Object existObj = importer.checkExistenceObjMetacontent(objectLabel,metaLabel, sessionCurrDB, new SbiObjMetacontents());
      if (existObj != null) {
        SbiObjMetacontents contCurr = (SbiObjMetacontents) existObj;
        //metaAss.insertCoupleObjMeIDAssociation(metaExp.getKpiModelResourcesId(), metaCurr.getKpiModelResourcesId());       
        metaAss.insertCoupleObjMetacontentsIDAssociation(contExp.getObjMetacontentId(), contCurr.getObjMetacontentId());
        metaLog.log("Found an existing metacontents with id " + contCurr.getObjMetacontentId()+ "" +
            "referring to the same object label "+contCurr.getSbiObjects().getLabel()+", " +
            "referring to meta with id "+ contCurr.getObjmetaId()
        );
      }
    }
    // Kpi Relations
    List exportedKpiRelList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiKpiRel", null);
    Iterator iterKpiRel = exportedKpiRelList.iterator();
    while (iterKpiRel.hasNext()) {
      SbiKpiRel kpirel = (SbiKpiRel) iterKpiRel.next();
      // check if the association already exist
      Map uniqueMap = new HashMap();
      Map kpiAss = metaAss.getKpiIDAssociation();
      if(kpirel.getSbiKpiByKpiFatherId() != null){
        Integer newFatherId = (Integer)kpiAss.get(kpirel.getSbiKpiByKpiFatherId().getKpiId());
        uniqueMap.put("fatherId", newFatherId);
        if(kpirel.getSbiKpiByKpiChildId()!= null){
          Integer newChildId = (Integer)kpiAss.get(kpirel.getSbiKpiByKpiChildId().getKpiId());
          uniqueMap.put("childId", newChildId);
          uniqueMap.put("parameter", kpirel.getParameter());
        }
      }
      Object existObj = importer.checkExistence(uniqueMap, sessionCurrDB, new SbiKpiRel());
      if (existObj != null) {
        SbiKpiRel dsCurr = (SbiKpiRel) existObj;
        metaAss.insertCoupleKpiRelAssociation(kpirel.getKpiRelId(), dsCurr.getKpiRelId());
        metaLog.log("Found an existing kpi Relation");
      }
    }
    // Udp

    List exportedUdpList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiUdp", null);
    Iterator iterUdp = exportedUdpList.iterator();
    while (iterUdp.hasNext()) {
      SbiUdp udp = (SbiUdp) iterUdp.next();

      //logical unique key but table just looks for label
/*      Map uniqueMap = new HashMap();
      Map doaminAss = metaAss.getDomainIDAssociation();
      Integer newTypeId = (Integer)doaminAss.get(udp.getTypeId());
      uniqueMap.put("typeId", newTypeId);
      Integer newFamilyId = (Integer)doaminAss.get(udp.getFamilyId());
      uniqueMap.put("familyId", newFamilyId);
      uniqueMap.put("label", udp.getLabel());
      Object existObj = importer.checkExistence(uniqueMap, sessionCurrDB, new SbiUdp());*/
      String label = udp.getLabel();
      Object existObj = importer.checkExistence(label, sessionCurrDB, new SbiUdp());
      if (existObj != null) {
        SbiUdp dsCurr = (SbiUdp) existObj;
        metaAss.insertCoupleUdpAssociation(udp.getUdpId(), dsCurr.getUdpId());
        metaLog.log("Exported association between type id " + udp.getTypeId() + " "
            + " and family id " + udp.getFamilyId() + " with label "
            + udp.getLabel() + " not inserted"
            + " because already existing into the current database");
      }
    }
    // Udp Value

    List exportedUdpValList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiUdpValue", null);
    Iterator iterUdpVal = exportedUdpValList.iterator();
    while (iterUdpVal.hasNext()) {
      SbiUdpValue udpVal = (SbiUdpValue) iterUdpVal.next();
      // check if the association already exist
      Map uniqueMap = new HashMap();
      Map kpiAss = metaAss.getKpiIDAssociation();
      Map modelAss = metaAss.getModelIDAssociation();
      Map udpAss = metaAss.getUdpAssociation();
     
      if(udpVal.getSbiUdp() != null){
        Integer newUdpId = (Integer)udpAss.get(udpVal.getSbiUdp().getUdpId());
        uniqueMap.put("udpId", newUdpId);
        Integer newRefId = null;
        if(udpVal.getFamily().equalsIgnoreCase("Kpi")){
          newRefId = (Integer)kpiAss.get(udpVal.getReferenceId());
        }else{
          newRefId = (Integer)modelAss.get(udpVal.getReferenceId());
        }
        uniqueMap.put("referenceId", newRefId);
        uniqueMap.put("family", udpVal.getFamily());
      }
 
      Object existObj = importer.checkExistence(uniqueMap, sessionCurrDB, new SbiUdpValue());
      if (existObj != null) {
        SbiUdpValue dsCurr = (SbiUdpValue) existObj;
        metaAss.insertCoupleUdpValueAssociation(udpVal.getUdpValueId(), dsCurr.getUdpValueId());
        metaLog.log("Exported association udp value between udp with label " + udpVal.getSbiUdp().getLabel() + " "
            + " and family " + udpVal.getFamily() + " with reference id "
            +  udpVal.getReferenceId() + " not inserted"
            + " because already existing into the current database");
      }
    }
    // OU  SbiOrgUnit
    List exportedSbiOrgUnitList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiOrgUnit", null);
    Iterator iterOUVal = exportedSbiOrgUnitList.iterator();
    while (iterOUVal.hasNext()) {
      SbiOrgUnit ouVal = (SbiOrgUnit) iterOUVal.next();
      Map uniqueMap = new HashMap();
      String label = ouVal.getLabel();
      String name = ouVal.getName();
      uniqueMap.put("label", label);
      uniqueMap.put("name", name);
      Object existObj = importer.checkExistence(uniqueMap, sessionCurrDB, new SbiOrgUnit());
      if (existObj != null) {
        SbiOrgUnit dsCurr = (SbiOrgUnit) existObj;
        metaAss.insertCoupleIdOuAssociation(ouVal.getId(), dsCurr.getId());
        metaLog.log("Found an existing ou " + dsCurr.getName() + " with "
            + "the same label of one exported ou");
      }
    }// OU hierarchy SbiOrgUnitHierarchies
    List exportedSbiOuHierList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiOrgUnitHierarchies", null);
    Iterator iterOUHierVal = exportedSbiOuHierList.iterator();
    while (iterOUHierVal.hasNext()) {
      SbiOrgUnitHierarchies ouHierVal = (SbiOrgUnitHierarchies) iterOUHierVal.next();
      // check if the association already exist
      Map uniqueMap = new HashMap();
      String label = ouHierVal.getLabel();
      String company = ouHierVal.getCompany();
      uniqueMap.put("label", label);
      uniqueMap.put("company", company);
      Object existObj = importer.checkExistence(uniqueMap, sessionCurrDB, new SbiOrgUnitHierarchies());
      if (existObj != null) {
        SbiOrgUnitHierarchies dsCurr = (SbiOrgUnitHierarchies) existObj;
        metaAss.insertCoupleIdOuHierarchyAssociation(ouHierVal.getId(), dsCurr.getId());
        metaLog.log("Found an existing ou hierarchy " + dsCurr.getName() + " with "
            + "the same label of one exported ou hierarchy");
      }
      /*
      String label = ouHierVal.getLabel();
      Object existObj = importer.checkExistence(label, sessionCurrDB, new SbiOrgUnitHierarchies());
      if (existObj != null) {
        SbiOrgUnitHierarchies dsCurr = (SbiOrgUnitHierarchies) existObj;
        metaAss.insertCoupleIdOuHierarchyAssociation(ouHierVal.getId(), dsCurr.getId());
        metaLog.log("Found an existing ou hierarchy " + dsCurr.getName() + " with "
            + "the same label of one exported ou hierarchy");
      }
      */
    }// OU node  SbiOrgUnitNodes
    List exportedSbiOrgUnitNodeList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiOrgUnitNodes", null);
    Iterator iterOUNodeVal = exportedSbiOrgUnitNodeList.iterator();
    while (iterOUNodeVal.hasNext()) {
      SbiOrgUnitNodes ouVal = (SbiOrgUnitNodes) iterOUNodeVal.next();
      // check if the association already exist
      Map uniqueMap = new HashMap();
      Map ouAss = metaAss.getOuAssociation();
      Map hierAss = metaAss.getOuHierarchiesAssociation();
      if(ouVal.getSbiOrgUnit() != null){
        Integer newOuId = (Integer)ouAss.get(ouVal.getSbiOrgUnit().getId());
        uniqueMap.put("ouId", newOuId);
        Integer newHierId = (Integer)hierAss.get(ouVal.getSbiOrgUnitHierarchies().getId());
        uniqueMap.put("hierarchyId", newHierId);
      }
      Object existObj = importer.checkExistence(uniqueMap, sessionCurrDB, new SbiOrgUnitNodes());
      if (existObj != null) {
        SbiOrgUnitNodes dsCurr = (SbiOrgUnitNodes) existObj;
        metaAss.insertCoupleIdOuNodeAssociation(ouVal.getNodeId(), dsCurr.getNodeId());
        metaLog.log("Found an existing ou node " + dsCurr.getNodeId() + " with "
            + "the same organizational unit and hierarchy of one exported ou node");
      }
    }// OU grants  SbiOrgUnitGrant
    List exportedSbiOUGrantList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiOrgUnitGrant", null);
    Iterator iterOUGrantVal = exportedSbiOUGrantList.iterator();
    while (iterOUGrantVal.hasNext()) {
      SbiOrgUnitGrant ouGrantVal = (SbiOrgUnitGrant) iterOUGrantVal.next();
      String label = ouGrantVal.getLabel();
      Object existObj = importer.checkExistence(label, sessionCurrDB, new SbiOrgUnitGrant());
      if (existObj != null) {
        SbiOrgUnitGrant dsCurr = (SbiOrgUnitGrant) existObj;
        metaAss.insertCoupleIdOuGrantAssociation(ouGrantVal.getId(), dsCurr.getId());
        metaLog.log("Found an existing ou grant " + dsCurr.getId() + " with "
            + "the same label of one exported ou grant");
      }
    }// OU grant nodes  SbiOrgUnitGrantNodes
    List exportedSbiOUGrantNodeList = importer.getAllExportedSbiObjects(sessionExpDB, "SbiOrgUnitGrantNodes", null);
    Iterator iterOUGrantNodesVal = exportedSbiOUGrantNodeList.iterator();
    while (iterOUGrantNodesVal.hasNext()) {
      SbiOrgUnitGrantNodes ouGrantNode = (SbiOrgUnitGrantNodes) iterOUGrantNodesVal.next();
      Map uniqueMap = new HashMap();   
      Map nodeAss = metaAss.getOuNodeAssociation();
      Map miAss = metaAss.getModelInstanceIDAssociation();
      Map grantAss = metaAss.getOuGrantAssociation();
      if(ouGrantNode.getId() != null){
        Integer newGrantId = (Integer)grantAss.get(ouGrantNode.getId().getGrantId());
        uniqueMap.put("grantId", newGrantId );
        Integer newNodeId = (Integer)nodeAss.get(ouGrantNode.getId().getNodeId());
        uniqueMap.put("nodeId", newNodeId);
        Integer newMiId = (Integer)miAss.get(ouGrantNode.getId().getKpiModelInstNodeId());
        uniqueMap.put("modelInstId", newMiId);
      }
      Object existObj = importer.checkExistence(uniqueMap, sessionCurrDB, new SbiOrgUnitGrantNodes());
      if (existObj != null) {
        SbiOrgUnitGrantNodes dsCurr = (SbiOrgUnitGrantNodes) existObj;
        metaAss.insertCoupleIdOuGrantNodesAssociation(ouGrantNode.getId(), dsCurr.getId());
        metaLog.log("Found an existing ou grant node with grant id " + dsCurr.getId().getGrantId() + " with "
            + "the same id of one exported ou grant node");
      }
    }
    logger.debug("OUT");
  }
View Full Code Here


      String interpretation = kpi.getInterpretation();
      String inputAttribute = kpi.getInputAttribute();
      String modelReference = kpi.getModelReference();
      String targetAudience = kpi.getTargetAudience();

      SbiDomains kpiType = null;
      if (kpi.getKpiTypeId() != null) {
        Integer kpiTypeId = kpi.getKpiTypeId();
        kpiType = (SbiDomains) aSession.load(SbiDomains.class, kpiTypeId);
      }

      SbiDomains metricScaleType = null;
      if (kpi.getMetricScaleId() != null) {
        Integer metricScaleId = kpi.getMetricScaleId();
        metricScaleType = (SbiDomains) aSession.load(SbiDomains.class, metricScaleId);
      }

      SbiDomains measureType = null;
      if (kpi.getMeasureTypeId() != null) {
        Integer measureTypeId = kpi.getMeasureTypeId();
        measureType = (SbiDomains) aSession.load(SbiDomains.class, measureTypeId);
      }
View Full Code Here

      Integer thresholdTypeId = threshold.getThresholdTypeId();

      SbiThreshold sbiThreshold = (SbiThreshold) aSession.load(
          SbiThreshold.class, threshold.getId());

      SbiDomains newThresholdType = null;
      if (thresholdTypeId != null) {
        newThresholdType = (SbiDomains) aSession.load(SbiDomains.class,
            thresholdTypeId);
      }
      SbiDomains oldThrType = sbiThreshold.getThresholdType();
      if(!oldThrType.getValueCd().equalsIgnoreCase(newThresholdType.getValueCd())){
        //If the type of threshold is changed all old threshold need to be deleted
        Set set = sbiThreshold.getSbiThresholdValues();
        ArrayList thValues=new ArrayList();
        for (Iterator iterator = set.iterator(); iterator.hasNext();) {
          SbiThresholdValue sbiThValue = (SbiThresholdValue) iterator.next();
View Full Code Here

      String code = threshold.getCode();
      Integer thresholdTypeId = threshold.getThresholdTypeId();

      SbiThreshold sbiThreshold = new SbiThreshold();

      SbiDomains thresholdType = null;
      if (thresholdTypeId != null) {
        thresholdType = (SbiDomains) aSession.load(SbiDomains.class,
            thresholdTypeId);
      }
View Full Code Here

    Integer id=t.getThresholdId();
    String name=t.getName();
    String description=t.getDescription();
    String code=t.getCode();
    SbiDomains d=t.getThresholdType();

    toReturn.setId(id);
    toReturn.setName(name);
    toReturn.setDescription(description);
    toReturn.setCode(code);
    toReturn.setThresholdTypeId(d.getValueId());
    toReturn.setThresholdTypeCode(d.getValueCd());
   
    // get all the threshold Values
    IThresholdValueDAO thValuesDao=(IThresholdValueDAO)DAOFactory.getThresholdValueDAO();
    Set set=t.getSbiThresholdValues();
    ArrayList thValues=new ArrayList();
View Full Code Here

      Integer parentId = model.getParentId();
      Integer kpiId = model.getKpiId();

      // get the domains
      SbiDomains sbiDomains = (SbiDomains) aSession.load(
          SbiDomains.class, modelTypeId);
      // set the sbiKpiModel
      SbiKpiModel sbiKpiModel = new SbiKpiModel();
      sbiKpiModel.setKpiModelNm(model.getName());
      sbiKpiModel.setKpiModelDesc(model.getDescription());
View Full Code Here

      Integer parentId = model.getParentId();
      Integer kpiId = model.getKpiId();

      // get the domains
      SbiDomains sbiDomains = (SbiDomains) aSession.load(
          SbiDomains.class, model.getTypeId());
      // set the sbiKpiModel
      SbiKpiModel sbiKpiModel = new SbiKpiModel();
      sbiKpiModel.setKpiModelNm(model.getName());
      sbiKpiModel.setKpiModelDesc(model.getDescription());
View Full Code Here

     
      Criterion domainCriterrion = Expression.eq("valueId",config.getValueTypeId());
      Criteria domainCriteria = aSession.createCriteria(SbiDomains.class);
      domainCriteria.add(domainCriterrion)
     
      SbiDomains hibDomains = (SbiDomains) domainCriteria.uniqueResult()
     
      if(id!=null){
        //modification
        logger.debug("Update Config");
        hibConfig = (SbiConfig) aSession.load(SbiConfig.class, id);
View Full Code Here

      alarm.setText(text);
      alarm.setUrl(url)

      try {
      if(modality!=null){
        SbiDomains dModality = DAOFactory.getDomainDAO().loadSbiDomainByCodeAndValue(DOMAIN_CD, modality);
       
        alarm.setModality(dModality);
      }
      if(kpiInstId != null){
        SbiKpiInstance sbiKpiInstance = DAOFactory.getKpiInstanceDAO().loadSbiKpiInstanceById(kpiInstId);
View Full Code Here

    try {
      aSession = getSession();
      tx = aSession.beginTransaction();
      SbiKpiInstance hibSbiKpiInstance = (SbiKpiInstance) aSession.load(
          SbiKpiInstance.class, kpiInstanceID);
      SbiDomains d = hibSbiKpiInstance.getChartType();
      if (d != null) {
        chartType = d.getValueCd();
        logger.debug("Gotten chartType:" + chartType);
      }

    } catch (HibernateException he) {
      logger.error(
View Full Code Here

TOP

Related Classes of it.eng.spagobi.commons.metadata.SbiDomains

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.