Examples of between()


Examples of javax.persistence.criteria.CriteriaBuilder.between()

          + "  ufisCalendarTo after adding Offset:"
          + ufisCalendarTo.getCedaString());
      if (adid != null) {
        // time range
        if (ADID.A.equals(adid)) {
          filters.add(cb.between(root.<String> get("stoa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
        } else {
          filters.add(cb.between(root.<String> get("stod"),
              ufisCalendarFrom.getCedaString(),
View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder.between()

        if (ADID.A.equals(adid)) {
          filters.add(cb.between(root.<String> get("stoa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
        } else {
          filters.add(cb.between(root.<String> get("stod"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
        }

      }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder.between()

      if (HpUfisUtils.isNotEmptyStr(params.getSTOD())) {
        filters.add(cb.equal(
            cb.trim(Trimspec.BOTH, ' ', root.<String> get("stod")),
            params.getSTOD().trim()));
      }
      filters.add(cb.between(root.<String> get("tifd"),
          ufisCalendarFrom.getCedaString(),
          ufisCalendarTo.getCedaString()));
      filters.add(cb.not(cb.in(root.get("ftyp")).value('T').value('G')));

      cq.where(cb.and(filters.toArray(new Predicate[0])));
View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder.between()

            Subquery<JPAObject> subquery = query.subquery(JPAObject.class);
            Root fromJPAObject = subquery.from(JPAObject.class);
            subquery.select(fromJPAObject.get("timestamp"));
            Predicate predicate1 = criteriaBuilder.equal(fromJPAObject.get("oid"), oid);
            Predicate predicate2 = criteriaBuilder.between(fromJPAObject.get("timestamp"), from, to);
            subquery.where(criteriaBuilder.and(predicate1, predicate2));

            query.where(criteriaBuilder.in(f.get("timestamp")).value(subquery));
            query.orderBy(criteriaBuilder.asc(f.get("timestamp")));
View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder.between()

            CriteriaQuery<JPAObject> query = criteriaBuilder.createQuery(JPAObject.class);
            Root f = query.from(JPAObject.class);
            query.select(f);

            Predicate predicate1 = criteriaBuilder.equal(f.get("oid"), oid);
            Predicate predicate2 = criteriaBuilder.between(f.get("timestamp"), from, to);
            query.where(criteriaBuilder.and(predicate1, predicate2));
            query.orderBy(criteriaBuilder.asc(f.get("timestamp")));

            TypedQuery<JPAObject> typedQuery = entityManager.createQuery(query);
            return typedQuery.getResultList();
View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder.between()

        CriteriaQuery<E> query = criteriaBuilder.createQuery(clazz);
        Root<E> from = query.from(clazz);
        query.select(from.alias("p"));
        query.where(criteriaBuilder.and(
                criteriaBuilder.equal(from.get(fieldName), name),
                criteriaBuilder.between((Expression) from.get("age"), Integer.parseInt(minVal),
                        Integer.parseInt(maxVal))));

        TypedQuery<E> q = em.createQuery(query);
        List<E> results = q.getResultList();
View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder.between()

    {
        CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
        CriteriaQuery<E> query = criteriaBuilder.createQuery(clazz);
        Root<E> from = query.from(clazz);
        query.select(from.alias("p"));
        query.where(criteriaBuilder.between((Expression) from.get(fieldName), Integer.parseInt(minVal),
                Integer.parseInt(maxVal)));

        TypedQuery<E> q = em.createQuery(query);
        List<E> results = q.getResultList();
View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder.between()

        String expected = "Select p from Person p where p.age BETWEEN 10 AND 20";
        CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
        CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
        Root<Person> from = personQuery.from(Person.class);
        personQuery.select(from.alias("p"));
        personQuery.where(criteriaBuilder.between((Expression) from.get("age"), 10, 20));
        String actual = CriteriaQueryTranslator.translate(personQuery);
        Assert.assertEquals(expected.trim(), actual.trim());
    }

    @Test
View Full Code Here

Examples of org.hivedb.teamcity.plugin.commands.LogCommand.between()

    if (from.equals(to)) {
      return modifications;
    }
    GitConfiguration configuration = GitConfiguration.createServerConfiguration(root);
    LogCommand logCommand = new LogCommand(configuration);
    for (Commit commit : logCommand.between(from, to)) {
      log.info(commit);
      List<VcsChange> vcsChanged = new ArrayList<VcsChange>();
      for (NameAndStatus change : commit.getChanges()) {
        log.info(change);
        vcsChanged.add(createChange(change, fromVersion, toVersion));
View Full Code Here

Examples of org.opengis.filter.FilterFactory.between()

    }

    public void testGetFeaturesWithBetweenFilter() throws Exception {
        init();
        FilterFactory ff = dataStore.getFilterFactory();
        PropertyIsBetween between = ff.between(ff.property("speed_is"), ff.literal(0),
                ff.literal(150));
        SimpleFeatureCollection features = featureSource.getFeatures(between);
        assertEquals(9, features.size());
        SimpleFeatureIterator iterator = features.features();
        while (iterator.hasNext()) {
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.