Examples of javax.persistence.criteria.Root

javax.persistence.criteria.Root
A root type from a FROM clause. @since JPA 2.0

        }
        if (query.getReferenceClass() == null){
            if (this.where != null && ((InternalSelection) this.where).getCurrentNode() != null && ((InternalSelection) this.where).getCurrentNode().getBuilder() != null && ((InternalSelection) this.where).getCurrentNode().getBuilder().getQueryClass() != null) {
                query.setReferenceClass(((InternalSelection) this.where).getCurrentNode().getBuilder().getQueryClass());
            } else if (roots != null && ! roots.isEmpty()){
                Root root = this.getRoots().iterator().next();
                query.setReferenceClass(root.getJavaType());
            }
        }


        if (selection == null) {
            //the builder in the where clause  may not be the correct builder for this query.  Search for a root that matches the query type.
            if (roots != null && ! roots.isEmpty()){
                for (Root root : this.getRoots()){
                    if (root.getJavaType().equals(this.queryType)){
                        query.setExpressionBuilder(((RootImpl) root).getCurrentNode().getBuilder());
                        break;
                    }
                }
            }

View Full Code Here


    @SuppressWarnings({ "rawtypes", "unchecked" })
    public CriteriaQuery<JPAObject> buildQuery() {
        CriteriaQuery<JPAObject> criteriaQuery = builder.createQuery(JPAObject.class);
        criteriaQuery.distinct(!request.isAndJoined());
        Root from = criteriaQuery.from(JPAObject.class);


        Subquery<Long> subquery = criteriaQuery.subquery(Long.class);
        Root subFrom = subquery.from(JPAObject.class);
        Expression<Long> maxExpression = builder.max(subFrom.get("timestamp"));
        subquery.select(maxExpression);
        Predicate p1 = builder.equal(subFrom.get("oid"), from.get("oid"));
        Predicate p2 = builder.le(subFrom.get("timestamp"), request.getTimestamp());
        subquery.where(builder.and(p1, p2));


        List<Predicate> predicates = new ArrayList<>();
        if (request.getContextId() != null) {
            predicates.add(builder.like(from.get("oid"), request.getContextId() + "/%"));

View Full Code Here

    }


    @SuppressWarnings({ "unchecked", "rawtypes" })
    private Subquery buildJPAEntrySubquery(String key, Object value, Root<?> from, CriteriaQuery<?> query) {
        Subquery<JPAEntry> subquery = query.subquery(JPAEntry.class);
        Root subFrom = subquery.from(JPAEntry.class);
        subquery.select(subFrom);
        Predicate ownerPredicate = builder.equal(from, subFrom.get("owner"));
        Predicate keyPredicate = builder.like(subFrom.get("key"), key);
        Predicate valuePredicate =
            value instanceof Set ? buildValuePredicate((Set<Object>) value, subFrom) : builder.equal(
                subFrom.get("value"),
                value);
        subquery.where(builder.and(ownerPredicate, keyPredicate, valuePredicate));
        return subquery;
    }

View Full Code Here

            Root<JPAObject> from = query.from(JPAObject.class);


            query.select(from);


            Subquery<Number> subquery = query.subquery(Number.class);
            Root maxTime = subquery.from(JPAObject.class);
            subquery.select(criteriaBuilder.max(maxTime.get("timestamp")));
            Predicate subPredicate1 = criteriaBuilder.le(maxTime.get("timestamp"), timestamp);
            Predicate subPredicate2 = criteriaBuilder.equal(maxTime.get("oid"), from.get("oid"));
            subquery.where(criteriaBuilder.and(subPredicate1, subPredicate2));


            Predicate predicate1 = criteriaBuilder.equal(from.get("timestamp"), subquery);
            Predicate predicate2 = criteriaBuilder.notEqual(from.get("isDeleted"), Boolean.TRUE);
            query.where(criteriaBuilder.and(predicate1, predicate2));

View Full Code Here

    public List<JPAObject> getJPAObjectHistory(String oid) throws EDBException {
        synchronized (entityManager) {
            LOGGER.debug("Loading the history for the object {}", oid);
            CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
            CriteriaQuery<JPAObject> query = criteriaBuilder.createQuery(JPAObject.class);
            Root from = query.from(JPAObject.class);
            query.select(from);
            query.where(criteriaBuilder.equal(from.get("oid"), oid));
            query.orderBy(criteriaBuilder.asc(from.get("timestamp")));


            TypedQuery<JPAObject> typedQuery = entityManager.createQuery(query);
            return typedQuery.getResultList();
        }
    }

View Full Code Here

    public List<JPAObject> getJPAObjectHistory(String oid, long from, long to) throws EDBException {
        synchronized (entityManager) {
            LOGGER.debug("Loading the history for the object {} from {} to {}", new Object[]{ oid, from, to });
            CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
            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

    public JPAObject getJPAObject(String oid, long timestamp) throws EDBException {
        synchronized (entityManager) {
            LOGGER.debug("Loading object {} for the time {}", oid, timestamp);
            CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
            CriteriaQuery<JPAObject> query = criteriaBuilder.createQuery(JPAObject.class);
            Root from = query.from(JPAObject.class);


            query.select(from);


            Predicate predicate1 = criteriaBuilder.equal(from.get("oid"), oid);
            Predicate predicate2 = criteriaBuilder.le(from.get("timestamp"), timestamp);
            query.where(criteriaBuilder.and(predicate1, predicate2));
            query.orderBy(criteriaBuilder.desc(from.get("timestamp")));


            TypedQuery<JPAObject> typedQuery = entityManager.createQuery(query).setMaxResults(1);
            List<JPAObject> resultList = typedQuery.getResultList();


            if (resultList.size() < 1) {

View Full Code Here

            Root<JPAObject> from = query.from(JPAObject.class);


            query.select(from);


            Subquery<Number> subquery = query.subquery(Number.class);
            Root maxTime = subquery.from(JPAObject.class);
            subquery.select(criteriaBuilder.max(maxTime.get("timestamp")));
            subquery.where(criteriaBuilder.equal(from.get("oid"), maxTime.get("oid")));


            Predicate predicate1 = criteriaBuilder.in(from.get("oid")).value(oid);
            Predicate predicate2 = criteriaBuilder.equal(from.get("timestamp"), subquery);


            query.where(criteriaBuilder.and(predicate1, predicate2));

View Full Code Here

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


            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

        synchronized (entityManager) {
            LOGGER.debug("get resurrected JPA objects");


            CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
            CriteriaQuery<String> query = criteriaBuilder.createQuery(String.class);
            Root from = query.from(JPAObject.class);
            query.select(from.get("oid"));


            Subquery<JPAObject> sub = query.subquery(JPAObject.class);
            Root f = sub.from(JPAObject.class);
            sub.select(f);
            Predicate subPredicate1 = criteriaBuilder.equal(from.get("oid"), f.get("oid"));
            Predicate subPredicate2 = criteriaBuilder.equal(f.get("isDeleted"), Boolean.TRUE);
            Predicate subPredicate3 = criteriaBuilder.gt(from.get("timestamp"), f.get("timestamp"));
            sub.where(criteriaBuilder.and(subPredicate1, subPredicate2, subPredicate3));


            Predicate predicate1 = criteriaBuilder.notEqual(from.get("isDeleted"), Boolean.TRUE);
            Predicate predicate2 = criteriaBuilder.exists(sub);
            query.where(predicate1, predicate2);

View Full Code Here

0 1 2 3 4

TOP

Related Classes of javax.persistence.criteria.Root

br.edu.utfpr.cm.JGitMinerWeb.dao.GenericBichoDAO

br.edu.utfpr.cm.JGitMinerWeb.dao.GenericDao

com.ketayao.ketacustom.spring.DataControlInterceptor

com.ufis_as.ufisapp.ek.singleton.EntStartupInitSingleton

org.activejpa.entity.FilterTest

org.broadleafcommerce.core.util.dao.ResourcePurgeDaoImpl

org.broadleafcommerce.openadmin.server.service.persistence.module.criteria.FieldPathBuilder

org.eclipse.persistence.internal.jpa.querydef.AbstractQueryImpl

org.eclipse.persistence.internal.jpa.querydef.CriteriaQueryImpl

org.hibernate.ejb.criteria.CriteriaQueryImpl

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.