public void testHqlQueryPlanWithEnabledFilter() {
    Session s = openSession();
    QueryPlanCache cache = ((SessionImplementor) s).getFactory().getQueryPlanCache();

    HQLQueryPlan plan1A = cache.getHQLQueryPlan("from Person", true, getEnabledFilters(s));
    HQLQueryPlan plan1B = cache.getHQLQueryPlan("from Person", false, getEnabledFilters(s));

    s.enableFilter("sex").setParameter("sexCode", new Character('F'));
    HQLQueryPlan plan2A = cache.getHQLQueryPlan("from Person", true, getEnabledFilters(s));
    HQLQueryPlan plan2B = cache.getHQLQueryPlan("from Person", false, getEnabledFilters(s));

    s.disableFilter("sex");
    HQLQueryPlan plan3A = cache.getHQLQueryPlan("from Person", true, getEnabledFilters(s));
    HQLQueryPlan plan3B = cache.getHQLQueryPlan("from Person", false, getEnabledFilters(s));

    s.enableFilter("sex").setParameter("sexCode", new Character('M'));
    HQLQueryPlan plan4A = cache.getHQLQueryPlan("from Person", true, getEnabledFilters(s));
    HQLQueryPlan plan4B = cache.getHQLQueryPlan("from Person", false, getEnabledFilters(s));

    assertSame(plan1A, plan3A);
    assertSame(plan1B, plan3B);
    assertSame(plan2A, plan4A);
    assertSame(plan2B, plan4B);

    assertNotSame(plan1A, plan1B);
    assertNotSame(plan1A, plan2A);
    assertNotSame(plan1A, plan2B);
    assertNotSame(plan1B, plan2A);
    assertNotSame(plan1B, plan2B);

    s.close();
  }
  @Override
  public CommandResult execute(GetMonitoredPoints cmd, User user) throws CommandException {
    final ArrayList<MonitoredPointDTO> dtos = new ArrayList<MonitoredPointDTO>();

    final Session session = ((HibernateEntityManager) em).getSession();
    session.disableFilter("userVisible");

    // Use a set to be avoid duplicated entries.
    final HashSet<OrgUnit> units = new HashSet<OrgUnit>();

    // Crawl the org units hierarchy from the user root org unit.
    GetProjectHandler.crawlUnits(user.getOrgUnitWithProfiles().getOrgUnit(), units, false);

    // Retrieves all the corresponding org units.
    for (final OrgUnit unit : units) {

      // Builds and executes the query.
      final Query query =
          em.createQuery(
              "SELECT p.pointsList.points FROM Project p WHERE :unit MEMBER OF p.partners");
      query.setParameter("unit", unit);

      final List<MonitoredPoint> monitoredPoints = (List<MonitoredPoint>) query.getResultList();
      for (final MonitoredPoint monitoredPoint : monitoredPoints) {
        if (monitoredPoint.getCompletionDate() == null) // Not completed only
        {
          MonitoredPointDTO pointDTO = mapper.map(monitoredPoint, MonitoredPointDTO.class);
          pointDTO.setDeleted(monitoredPoint.isDeleted());
          dtos.add(pointDTO);
        }
      }
    }

    final MonitoredPointsResultList result = new MonitoredPointsResultList();
    result.setList(dtos);

    return result;
  }
Exemplo n.º 3
0
 public void disableFilter(String filterName) {
   session.disableFilter(filterName);
 }