Package javax.persistence.criteria

Examples of javax.persistence.criteria.CriteriaBuilder


        return criteriaQuery;
    }

    private CriteriaQuery<T> createSelectCriteriaQuery() {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
        CriteriaQuery<T> criteriaQuery = criteriaBuilder.createQuery(entityClass);
        Root<T> root = criteriaQuery.from(entityClass);

        if (arrangeableState != null) {

            List<Order> orders = createOrders(criteriaBuilder, root);
View Full Code Here


    private EntityManager entityManager;

    @Override
    public List<ScheduleJob> findAllByClusterGroup(long clusterGroupId) {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();

        CriteriaQuery<ScheduleJob> criteriaQuery = criteriaBuilder.createQuery(ScheduleJob.class);
        Root<ScheduleJob> root = criteriaQuery.from(ScheduleJob.class);

        // CHECKSTYLE-OFF: NestedMethodCall
        criteriaQuery.where(
            criteriaBuilder.equal(root.get(ScheduleJob_.cluster).get(ClusterGroup_.id), clusterGroupId)
        );
        // CHECKSTYLE-ON: NestedMethodCall

        TypedQuery<ScheduleJob> typedQuery = entityManager.createQuery(criteriaQuery);
View Full Code Here

    private EntityManager entityManager;

    @Override
    public List<ScheduleExecution> findAll(Extraction extraction) {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();

        CriteriaQuery<ScheduleExecution> criteriaQuery = criteriaBuilder.createQuery(ScheduleExecution.class);
        Root<ScheduleExecution> root = criteriaQuery.from(ScheduleExecution.class);
        root.fetch(ScheduleExecution_.job, JoinType.LEFT);

        // CHECKSTYLE-OFF: NestedMethodCall
        criteriaQuery.orderBy(
            criteriaBuilder.desc(root.get(ScheduleExecution_.fired))
        );
        // CHECKSTYLE-ON: NestedMethodCall

        TypedQuery<ScheduleExecution> typedQuery = entityManager.createQuery(criteriaQuery);
        if (Extraction.isRequired(extraction)) {
View Full Code Here

        return typedQuery.getResultList();
    }

    @Override
    public List<ScheduleExecution> findFinished(Extraction extraction) {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();

        CriteriaQuery<ScheduleExecution> criteriaQuery = criteriaBuilder.createQuery(ScheduleExecution.class);
        Root<ScheduleExecution> root = criteriaQuery.from(ScheduleExecution.class);
        root.fetch(ScheduleExecution_.job, JoinType.LEFT);

        // CHECKSTYLE-OFF: NestedMethodCall
        criteriaQuery.where(
            criteriaBuilder.isNotNull(root.get(ScheduleExecution_.finished))
        );

        criteriaQuery.orderBy(
            criteriaBuilder.desc(root.get(ScheduleExecution_.fired))
        );
        // CHECKSTYLE-ON: NestedMethodCall

        TypedQuery<ScheduleExecution> typedQuery = entityManager.createQuery(criteriaQuery);
        if (Extraction.isRequired(extraction)) {
View Full Code Here

        return typedQuery.getResultList();
    }

    @Override
    public List<ScheduleExecution> findEngaged(Extraction extraction) {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();

        CriteriaQuery<ScheduleExecution> criteriaQuery = criteriaBuilder.createQuery(ScheduleExecution.class);
        Root<ScheduleExecution> root = criteriaQuery.from(ScheduleExecution.class);
        root.fetch(ScheduleExecution_.job, JoinType.LEFT);

        // CHECKSTYLE-OFF: NestedMethodCall
        criteriaQuery.where(
            criteriaBuilder.isNull(root.get(ScheduleExecution_.finished))
        );

        criteriaQuery.orderBy(
            criteriaBuilder.desc(root.get(ScheduleExecution_.fired))
        );
        // CHECKSTYLE-ON: NestedMethodCall

        TypedQuery<ScheduleExecution> typedQuery = entityManager.createQuery(criteriaQuery);
        if (Extraction.isRequired(extraction)) {
View Full Code Here

        return typedQuery.getResultList();
    }

    @Override
    public List<ScheduleExecution> findByJob(long scheduleJobId, Extraction extraction) {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();

        CriteriaQuery<ScheduleExecution> criteriaQuery = criteriaBuilder.createQuery(ScheduleExecution.class);
        Root<ScheduleExecution> root = criteriaQuery.from(ScheduleExecution.class);

        // CHECKSTYLE-OFF: NestedMethodCall
        criteriaQuery.where(
            criteriaBuilder.equal(root.get(ScheduleExecution_.job).get(ScheduleJob_.id), scheduleJobId)
        );

        criteriaQuery.orderBy(
            criteriaBuilder.desc(root.get(ScheduleExecution_.fired))
        );
        // CHECKSTYLE-ON: NestedMethodCall

        TypedQuery<ScheduleExecution> typedQuery = entityManager.createQuery(criteriaQuery);
        if (Extraction.isRequired(extraction)) {
View Full Code Here

    private EntityManager entityManager;

    @Override
    public List<ScheduleGroup> findAll(Extraction extraction) {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();

        CriteriaQuery<ScheduleGroup> criteriaQuery = criteriaBuilder.createQuery(ScheduleGroup.class);
        Root<ScheduleGroup> root = criteriaQuery.from(ScheduleGroup.class);
        root.fetch(ScheduleGroup_.jobs, JoinType.LEFT);

        // CHECKSTYLE-OFF: NestedMethodCall
        criteriaQuery.orderBy(
            criteriaBuilder.asc(root.get(ScheduleGroup_.name))
        );
        // CHECKSTYLE-ON: NestedMethodCall

        TypedQuery<ScheduleGroup> typedQuery = entityManager.createQuery(criteriaQuery);
        if (Extraction.isRequired(extraction)) {
View Full Code Here

    private EntityManager entityManager;

    @Override
    public List<ClusterGroup> findAll(Extraction extraction) {
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();

        CriteriaQuery<ClusterGroup> criteriaQuery = criteriaBuilder.createQuery(ClusterGroup.class);
        Root<ClusterGroup> root = criteriaQuery.from(ClusterGroup.class);

        // CHECKSTYLE-OFF: NestedMethodCall
        criteriaQuery.orderBy(
            criteriaBuilder.asc(root.get(ClusterGroup_.name))
        );
        // CHECKSTYLE-ON: NestedMethodCall

        TypedQuery<ClusterGroup> typedQuery = entityManager.createQuery(criteriaQuery);
        if (Extraction.isRequired(extraction)) {
View Full Code Here

    private <T> Query createFinderQuery(EntityManager entityManager, String methodName, Class<T> entityType, Object[] args) {
        final List<String> conditions = parseMethodName(methodName);

        final EntityType<T> et = entityManager.getMetamodel().entity(entityType);
        final CriteriaBuilder cb = entityManager.getCriteriaBuilder();

        CriteriaQuery<Object> query = cb.createQuery();
        Root<T> from = query.from(entityType);
        query = query.select(from);

        int i = 0;
        Predicate where = null;
        for (String condition : conditions) {
            SingularAttribute<? super T, ?> attribute = et.getSingularAttribute(condition);
            Path<?> path = from.get(attribute);
            Class<?> javaType = attribute.getType().getJavaType();

            Predicate currentClause;
            if (javaType.equals(String.class)) {
                currentClause = cb.like((Expression<String>) path, (String) args[i++]);
            } else if (Number.class.isAssignableFrom(javaType) || javaType.isPrimitive()) {
                currentClause = cb.equal(path, args[i++]);
            } else {
                LOGGER.warning("field " + condition + " not found, ignoring");
                continue;
            }

            if (where == null) {
                where = currentClause;
            } else {
                where = cb.and(where, currentClause);
            }
        }

        if (where != null) {
            query = query.where(where);
View Full Code Here

    @Override
    public TypedQuery<R> createQuery()
    {
        try
        {
            CriteriaBuilder builder = entityManager.getCriteriaBuilder();
            CriteriaQuery<?> query = createCriteriaQuery(builder);
            From<C, C> root = query.from(entityClass);
            if (!selections.isEmpty())
            {
                query.multiselect(prepareSelections(query, builder, root));
View Full Code Here

TOP

Related Classes of javax.persistence.criteria.CriteriaBuilder

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.