Package it.eng.spagobi.behaviouralmodel.analyticaldriver.bo

Examples of it.eng.spagobi.behaviouralmodel.analyticaldriver.bo.ObjParuse


            // for each correlation column name chechs if the column is still present
            Iterator correlationsIt = correlations.iterator();
            boolean columnNoMorePresent = false;
            List columnsNoMorePresent = new ArrayList();
            while (correlationsIt.hasNext()) {
              ObjParuse aObjParuse = (ObjParuse) correlationsIt.next();
              String filterColumn = aObjParuse.getFilterColumn();
              // because spago put all sourcebean attribute to Uppercase
              //filterColumn = filterColumn.toUpperCase();
              if (!columns.contains(filterColumn)) {
                columnNoMorePresent = true;
                columnsNoMorePresent.add(filterColumn);
View Full Code Here


   */
  private void buildWhereClause(StringBuffer buffer,
      List<ObjParuse> dependencies, ExecutionInstance executionInstance) {
    buffer.append(" WHERE ");
    if (dependencies.size() == 1) {
      ObjParuse dependency = (ObjParuse) dependencies.get(0);
      addFilter(buffer, dependency, executionInstance);
    } else if (dependencies.size() == 2) {
      ObjParuse leftPart = (ObjParuse) dependencies.get(0);
      ObjParuse rightPart = (ObjParuse) dependencies.get(1);
      String lo = leftPart.getLogicOperator();
      addFilter(buffer, leftPart, executionInstance);
      buffer.append(" " + lo + " ");
      addFilter(buffer, rightPart, executionInstance);
    } else {
      // build the expression
      Iterator iterOps = dependencies.iterator();
      while(iterOps.hasNext())  {
        ObjParuse op = (ObjParuse) iterOps.next();
        buffer.append(" " + op.getPreCondition() + " ");
        addFilter(buffer, op, executionInstance);
        buffer.append(" " + op.getPostCondition() + " " + op.getLogicOperator());
      }
    }
  }
View Full Code Here

   * @return the list filtered considering the dependencies
   */
  public List processDependencies(List rows, Map selectedParameterValues, List<ObjParuse> dependencies) {
    if (selectedParameterValues != null && dependencies != null && dependencies.size() > 0) {
      if (dependencies.size() == 1) {
        ObjParuse biParameterExecDependency = (ObjParuse) dependencies.get(0);
        rows = filterForCorrelation(rows, biParameterExecDependency, selectedParameterValues);
      } else if (dependencies.size()==2) {
        ObjParuse biParameterExecDependency1 = (ObjParuse) dependencies.get(0);
        ObjParuse biParameterExecDependency2 = (ObjParuse) dependencies.get(1);
        rows = evaluateSingleLogicOperation(rows, biParameterExecDependency1, biParameterExecDependency2, selectedParameterValues);
      } else {
        // build the expression
        int posinlist = 0;
        String expr = "";
        Iterator iterOps = dependencies.iterator();
        while(iterOps.hasNext())  {
          ObjParuse op = (ObjParuse) iterOps.next();
          expr += op.getPreCondition() + posinlist + op.getPostCondition() + op.getLogicOperator();
          posinlist ++;
        }
        expr = expr.trim();
        expr = "(" + expr;
        expr = expr + ")";
View Full Code Here

      // calculate the list filtered based on each objparuse setting
      Map calculatedLists = new HashMap();
      int posinlist = 0;
      Iterator opsIter = ops.iterator();
      while(opsIter.hasNext()) {
        ObjParuse op = (ObjParuse)opsIter.next();
        List listop = filterForCorrelation(list, op, selectedParameterValues);
        calculatedLists.put(String.valueOf(posinlist), listop);
        posinlist ++;
      }
     
View Full Code Here

        BIObjectParameter biparam = (BIObjectParameter)iterBIParams.next();         
        IObjParuseDAO objparuseDao = DAOFactory.getObjParuseDAO();
        List objparlist = objparuseDao.loadObjParuses(biparam.getId());
        Iterator iterObjParuse = objparlist.iterator();
        while(iterObjParuse.hasNext()) {
          ObjParuse objparuse = (ObjParuse)iterObjParuse.next();
          Transaction tx = session.beginTransaction();
          // TODO controllare perch� serve questo controllo: le dipendenze non dovrebbero essere riutilizzabili, per
          // cui vengono inseriti una sola volta
          Query hibQuery = session.createQuery(" from SbiObjParuse where id.sbiObjPar.objParId = " + objparuse.getObjParId() +
              " and id.sbiParuse.useId = " + objparuse.getParuseId() +
              " and id.sbiObjParFather.objParId = " + objparuse.getObjParFatherId() +
              " and id.filterOperation = '" + objparuse.getFilterOperation() + "'" );
          List hibList = hibQuery.list();
          if(!hibList.isEmpty()) {
            continue;
          }
          // built key
          SbiObjParuseId hibObjParuseId = new SbiObjParuseId();
          SbiObjPar hibObjPar = (SbiObjPar)session.load(SbiObjPar.class, objparuse.getObjParId());
          SbiParuse hibParuse = (SbiParuse)session.load(SbiParuse.class, objparuse.getParuseId());
          SbiObjPar objparfather = (SbiObjPar)session.load(SbiObjPar.class, objparuse.getObjParFatherId());
          hibObjParuseId.setSbiObjPar(hibObjPar);
          hibObjParuseId.setSbiParuse(hibParuse);
          hibObjParuseId.setFilterOperation(objparuse.getFilterOperation());
          hibObjParuseId.setSbiObjParFather(objparfather);
          SbiObjParuse hibObjParuse = new SbiObjParuse(hibObjParuseId);
          hibObjParuse.setFilterColumn(objparuse.getFilterColumn());
          hibObjParuse.setProg(objparuse.getProg());
          hibObjParuse.setPreCondition(objparuse.getPreCondition());
          hibObjParuse.setPostCondition(objparuse.getPostCondition());
          hibObjParuse.setLogicOperator(objparuse.getLogicOperator());
          session.save(hibObjParuse);
          tx.commit()
        }
      }
View Full Code Here

    // deletes all ObjParuse object (dependencies) of the biObjectParameter
    ObjParuseDAOHibImpl objParuseDAO = new ObjParuseDAOHibImpl();
    List objParuses = objParuseDAO.loadObjParuses(hibObjPar.getObjParId());
    Iterator itObjParuses = objParuses.iterator();
    while (itObjParuses.hasNext()) {
      ObjParuse aObjParuse = (ObjParuse) itObjParuses.next();
      objParuseDAO.eraseObjParuse(aObjParuse, aSession);
    }
   
    aSession.delete(hibObjPar);
   
View Full Code Here

   *
   * @return The corrispondent <code>ObjParuse</code>
   */
  public ObjParuse toObjParuse (SbiObjParuse aSbiObjParuse) {
    if (aSbiObjParuse == null) return null;
    ObjParuse toReturn = new ObjParuse();
    toReturn.setObjParId(aSbiObjParuse.getId().getSbiObjPar().getObjParId());
    toReturn.setParuseId(aSbiObjParuse.getId().getSbiParuse().getUseId());
    toReturn.setProg(aSbiObjParuse.getProg());
    toReturn.setObjParFatherId(aSbiObjParuse.getId().getSbiObjParFather().getObjParId());
    toReturn.setFilterColumn(aSbiObjParuse.getFilterColumn());
    toReturn.setFilterOperation(aSbiObjParuse.getId().getFilterOperation());
    toReturn.setPreCondition(aSbiObjParuse.getPreCondition());
    toReturn.setPostCondition(aSbiObjParuse.getPostCondition());
    toReturn.setLogicOperator(aSbiObjParuse.getLogicOperator());
    return toReturn;
  }
View Full Code Here

   *
   * @see it.eng.spagobi.behaviouralmodel.analyticaldriver.dao.IObjParuseDAO#loadObjParuse(java.lang.Integer, java.lang.Integer)
   */
  public List loadObjParuse(Integer objParId, Integer paruseId) throws EMFUserError {
    List objparuses = new ArrayList();
    ObjParuse toReturn = null;
    Session aSession = null;
    Transaction tx = null;
    try {
      aSession = getSession();
      tx = aSession.beginTransaction();
      /*
      Criterion aCriterion = Expression.and(
                        Expression.eq("id.sbiObjPar.objParId", objParId),
                        Expression.eq("id.sbiParuse.useId", paruseId));
      Criteria aCriteria = aSession.createCriteria(SbiObjParuse.class);
      aCriteria.add(aCriterion);
      List sbiObjParuses = (List) aCriteria.list();
      */
      /*String hql = "from SbiObjParuse s where s.id.sbiObjPar.objParId=" + objParId +
                   " and s.id.sbiParuse.useId=" +  paruseId +
                   " order by s.prog";
      */
      String hql = "from SbiObjParuse s where s.id.sbiObjPar.objParId=? "+
            " and s.id.sbiParuse.useId=? " +
            " order by s.prog";
     
      Query query = aSession.createQuery(hql);
      query.setInteger(0, objParId.intValue());
      query.setInteger(1, paruseId.intValue());
     
      List sbiObjParuses = query.list();
      if(sbiObjParuses==null)
        return objparuses;
      Iterator itersbiOP = sbiObjParuses.iterator();
      while(itersbiOP.hasNext()) {
        SbiObjParuse sbiop = (SbiObjParuse)itersbiOP.next();
          ObjParuse op = toObjParuse(sbiop);
          objparuses.add(op);
      }
      tx.commit();
    } catch (HibernateException he) {
      logException(he);
View Full Code Here

          SourceBean paruseSetSB = (SourceBean)iterPUS.next();
          String active = (String)paruseSetSB.getAttribute("active");
          String paruseidStr = (String)paruseSetSB.getAttribute("paruseid");
          String oncolumn = (String)paruseSetSB.getAttribute("oncolumn");
          Integer paruseid = new Integer(paruseidStr);
          ObjParuse correlation = new ObjParuse();
          correlation.setFilterColumn(oncolumn);
          correlation.setFilterOperation(condition);
          correlation.setLogicOperator(logicOperator);
          correlation.setObjParFatherId(idParFather);
          correlation.setObjParId(biParamId);
          correlation.setParuseId(paruseid);
          correlation.setPostCondition(postCondition);
          correlation.setPreCondition(preCondition);
          correlation.setProg(new Integer(prog));
          newCorrelations.add(correlation);
        }
        prog ++;
      }   
      // load the previous saved correlations
View Full Code Here

    IEngUserProfile profile = (IEngUserProfile)permSess.getAttribute(IEngUserProfile.ENG_USER_PROFILE);   
    IObjParuseDAO corrDao = DAOFactory.getObjParuseDAO();
    corrDao.setUserProfile(profile);
    Iterator iterOldCorr = oldCorrelations.iterator();
    while(iterOldCorr.hasNext()) {
      ObjParuse oldCorr = (ObjParuse)iterOldCorr.next();
      corrDao.eraseObjParuse(oldCorr);
    }
    Iterator iterNewCorr = newCorrelations.iterator();
    while(iterNewCorr.hasNext()) {
      ObjParuse newCorr = (ObjParuse)iterNewCorr.next();
      corrDao.insertObjParuse(newCorr);
    }
  }
View Full Code Here

TOP

Related Classes of it.eng.spagobi.behaviouralmodel.analyticaldriver.bo.ObjParuse

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.