List of alterProjection() Examples

Examples of alterProjection()

org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()
If you want to return something other than the list of entities represented by the passed Criteria object, you can alter the projection here to return a customized subset or superset of data. The projection will only affect the ResultSet for the data query, not the count query.
If you are projecting a composite object that does not directly extend the entity your Criteria object represents, then you will need to manually initialize the persistent bags and fetch fields using the {@link CriteriaQueryRunner#initFetchFields(Object)} method for each object in the results (for which you needto instantiate the {@link CriteriaQueryRunner} with automatic fetching switched OFF). Note that this willNOT work on the composite object itself. You need to pass an instance of the entity class to the {@link CriteriaQueryRunner#initFetchFields(Object)} method.

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

            + "   MIN(calltimedatavalue.minimum), " //
            + "   MAX(calltimedatavalue.maximum), " //
            + "   SUM(calltimedatavalue.total), " //
            + "   SUM(calltimedatavalue.count), " //
            + "   SUM(calltimedatavalue.total) / SUM(calltimedatavalue.count) ) ";
        generator.alterProjection(replacementSelectList);
        generator.setGroupByClause("calltimedatavalue.key.callDestination");


        if (authorizationManager.isInventoryManager(subject) == false) {
            generator.setAuthorizationResourceFragment(CriteriaQueryGenerator.AuthorizationTokenType.RESOURCE,
                "key.schedule.resource", subject.getId());

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

            compositeProjection = compositeProjection.replace("%subjectId%", String.valueOf(subject.getId()));
        }
        compositeProjection = compositeProjection.replace("%alias%", criteria.getAlias());


        CriteriaQueryGenerator generator = new CriteriaQueryGenerator(subject, criteria);
        generator.alterProjection(compositeProjection);


        if (isInventoryManager == false) {
            if (criteria.isInventoryManagerRequired()) {
                throw new PermissionException("Subject [" + subject.getName()
                    + "] requires InventoryManager permission for requested query criteria.");

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

            + "   bundle.id,"
            + "   bundle.name,"
            + "   bundle.description,"
            + "   ( SELECT bv1.version FROM bundle.bundleVersions bv1 WHERE bv1.versionOrder = (SELECT MAX(bv2.versionOrder) FROM BundleVersion bv2 WHERE bv2.bundle.id = bundle.id) ) AS latestVersion,"
            + "   ( SELECT COUNT(bv3) FROM bundle.bundleVersions bv3 WHERE bv3.bundle.id = bundle.id) AS deploymentCount ) ";
        generator.alterProjection(replacementSelectList);


        if (!authorizationManager.hasGlobalPermission(subject, Permission.VIEW_BUNDLES)) {
            generator.setAuthorizationBundleFragment(CriteriaQueryGenerator.AuthorizationTokenType.BUNDLE,
                subject.getId(), null);
        }

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

        AlertDefinitionCriteria criteria = new AlertDefinitionCriteria();
        criteria.addFilterResourceGroupIds(resourceGroupId);
        criteria.setPageControl(PageControl.getUnlimitedInstance());


        CriteriaQueryGenerator generator = new CriteriaQueryGenerator(criteria);
        generator.alterProjection("alertdefinition.id");
        Query query = generator.getQuery(entityManager);
        List<Integer> groupAlertDefinitionIds = query.getResultList();


        Integer[] results = groupAlertDefinitionIds.toArray(new Integer[groupAlertDefinitionIds.size()]);
        return results;

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

        criteria.addFilterAgentId(agentId);


        try {
            CriteriaQueryGenerator generator = new CriteriaQueryGenerator(criteria);


            generator.alterProjection("resource.id");
            String resourceSubQuery = generator.getParameterReplacedQuery(false);


            String markResourceQueryString = "" //
                + "UPDATE Resource res " //
                + "   SET res.mtime = :now " //

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

        }
        criteria.addFilterDefinitionIds(ArrayUtils.wrapInArray(measurementDefinitionIds));


        CriteriaQueryGenerator generator = new CriteriaQueryGenerator(subject, criteria);
        ;
        generator.alterProjection("measurementschedule.id");
        String measurementScheduleSubQuery = generator.getParameterReplacedQuery(false);


        return measurementScheduleSubQuery;
    }

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

            // generator. But seeing that this would be to support non-default criteria queries (i.e
            // the altered projection using DISTINCT), of which this is the only one in the code base,
            // and we are in control of the order by clause, and therefore are predictably working with
            // the JPQL above, I've chosen to just make a change to the custom altered projection, using
            // the JPQL to guide me.
            generator.alterProjection(" distinct orderingField0");
            generator.alterCountProjection(" count(distinct orderingField0)");
            CriteriaQueryRunner<MeasurementDefinition> queryRunner = new CriteriaQueryRunner(criteria, generator,
                entityManager);
            definitions = queryRunner.execute();

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

            // Reset paging -- remove ordering, add group by.
            criteria.setPageControl(PageControl.getUnlimitedInstance());
            generator.setGroupByClause(" measurementschedule.definition.id ");


            // Get the interval results.
            generator.alterProjection("" //
                + " measurementschedule.definition.id, " //
                + " min(measurementschedule.interval), " //
                + " max(measurementschedule.interval) ");
            Query query = generator.getQuery(entityManager);
            List<Object[]> definitionIntervalResults = query.getResultList();

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

            Query query = generator.getQuery(entityManager);
            List<Object[]> definitionIntervalResults = query.getResultList();


            // Get the enabled results.
            criteria.addFilterEnabled(true);
            generator.alterProjection(" measurementschedule.definition.id, count(measurementschedule.id) ");
            query = generator.getQuery(entityManager);
            List<Object[]> definitionEnabledResults = query.getResultList();


            // Generate intermediate maps for intervals and enabled values.
            for (Object[] nextInterval : definitionIntervalResults) {

View Full Code Here

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterProjection()

        compositeProjection = compositeProjection.replace("%alias%", alias);
        String permAlias = alias + ((authzType == CriteriaAuthzType.AUTO_CLUSTER) ? ".clusterResourceGroup" : "");
        compositeProjection = compositeProjection.replace("%permAlias%", permAlias);


        CriteriaQueryGenerator generator = getCriteriaQueryGenerator(subject, criteria, authzType);
        generator.alterProjection(compositeProjection);


        CriteriaQueryRunner<ResourceGroupComposite> queryRunner = new CriteriaQueryRunner<ResourceGroupComposite>(
            criteria, generator, entityManager, false); // don't auto-init bags, we're returning composites not entities
        PageList<ResourceGroupComposite> results = queryRunner.execute();

View Full Code Here

0 1

TOP

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.