/** * Equivalent to initDefaultOrderingField(defaultField, PageOrdering.ASC). * * @param defaultField * @see #initDefaultOrderingField(String, PageOrdering) */ public void initDefaultOrderingField(String defaultField) { initDefaultOrderingField(defaultField, PageOrdering.ASC); }
@Override @SuppressWarnings("unchecked") public List<IntegerOptionItem> findAlertDefinitionOptionItemsForGroup(Subject subject, int groupId) { PageControl pageControl = PageControl.getUnlimitedInstance(); pageControl.initDefaultOrderingField("ad.name", PageOrdering.ASC); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, AlertDefinition.QUERY_FIND_OPTION_ITEMS_BY_GROUP, pageControl); query.setParameter("groupId", groupId); List<IntegerOptionItem> results = query.getResultList(); return results; }
@Override @SuppressWarnings("unchecked") public List<IntegerOptionItem> findAlertDefinitionOptionItemsForResource(Subject subject, int resourceId) { PageControl pageControl = PageControl.getUnlimitedInstance(); pageControl.initDefaultOrderingField("ad.name", PageOrdering.ASC); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, AlertDefinition.QUERY_FIND_OPTION_ITEMS_BY_RESOURCE, pageControl); query.setParameter("resourceId", resourceId); List<IntegerOptionItem> results = query.getResultList(); return results; }
@SuppressWarnings("unchecked") public PageList<PackageVersionMetadataComposite> getPackageVersionMetadata(int resourceId, PageControl pc) { pc.initDefaultOrderingField("pv.id"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, PackageVersion.QUERY_FIND_METADATA_BY_RESOURCE_ID, pc); Query countQuery = PersistenceUtility.createCountQuery(entityManager, PackageVersion.QUERY_FIND_METADATA_BY_RESOURCE_ID); query.setParameter("resourceId", resourceId); countQuery.setParameter("resourceId", resourceId); List<PackageVersionMetadataComposite> results = query.getResultList(); long count = (Long) countQuery.getSingleResult(); return new PageList<PackageVersionMetadataComposite>(results, (int) count, pc); }
@SuppressWarnings("unchecked") public PageList<InstalledPackageHistory> getInstalledPackageHistoryForResource(int resourceId, PageControl pc) { pc.initDefaultOrderingField("iph.timestamp", PageOrdering.DESC); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, InstalledPackageHistory.QUERY_FIND_BY_RESOURCE_ID, pc); Query queryCount = PersistenceUtility.createCountQuery(entityManager, InstalledPackageHistory.QUERY_FIND_BY_RESOURCE_ID); query.setParameter("resourceId", resourceId); queryCount.setParameter("resourceId", resourceId); long totalCount = (Long) queryCount.getSingleResult(); List<InstalledPackageHistory> packages = query.getResultList(); return new PageList<InstalledPackageHistory>(packages, (int) totalCount, pc); }
@Override @SuppressWarnings("unchecked") public PageList<AlertDefinition> findAlertDefinitions(Subject subject, int resourceId, PageControl pageControl) { pageControl.initDefaultOrderingField("ctime", PageOrdering.DESC); Query queryCount = PersistenceUtility.createCountQuery(entityManager, AlertDefinition.QUERY_FIND_BY_RESOURCE); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, AlertDefinition.QUERY_FIND_BY_RESOURCE, pageControl); queryCount.setParameter("id", resourceId); query.setParameter("id", resourceId); long totalCount = (Long) queryCount.getSingleResult(); List<AlertDefinition> list = query.getResultList(); return new PageList<AlertDefinition>(list, (int) totalCount, pageControl); }
@SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_REPOSITORIES) public PageList<ContentSource> findAssociatedContentSources(Subject subject, int repoId, PageControl pc) { pc.initDefaultOrderingField("cs.id"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, ContentSource.QUERY_FIND_BY_REPO_ID, pc); Query countQuery = PersistenceUtility.createCountQuery(entityManager, ContentSource.QUERY_FIND_BY_REPO_ID); query.setParameter("id", repoId); countQuery.setParameter("id", repoId); List<ContentSource> results = query.getResultList(); long count = (Long) countQuery.getSingleResult(); return new PageList<ContentSource>(results, (int) count, pc); }
@Override @SuppressWarnings("unchecked") public PageList<ConfigurationUpdateComposite> findPluginConfigurationUpdateCompositesByParentId( int configurationUpdateId, PageControl pageControl) { pageControl.initDefaultOrderingField("cu.modifiedTime"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, PluginConfigurationUpdate.QUERY_FIND_COMPOSITE_BY_PARENT_UPDATE_ID, pageControl); query.setParameter("groupConfigurationUpdateId", configurationUpdateId); long count = getPluginConfigurationUpdateCountByParentId(configurationUpdateId); List<ConfigurationUpdateComposite> results = query.getResultList(); return new PageList<ConfigurationUpdateComposite>(results, (int) count, pageControl); }
public PageList<LdapGroup> findLdapGroups(PageControl pc) { pc.initDefaultOrderingField("g.name"); String queryName = LdapGroup.QUERY_FIND_ALL; Query queryCount = PersistenceUtility.createCountQuery(entityManager, queryName); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, queryName, pc); long count = (Long) queryCount.getSingleResult(); List<LdapGroup> groups = query.getResultList(); return new PageList<LdapGroup>(groups, (int) count, pc); }
/** Methods with page control are typically accessed by the GUI, as such apply permission check. */ @SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_INVENTORY) public PageList<Agent> getAgentsByServer(Subject subject, Integer serverId, PageControl pageControl) { pageControl.initDefaultOrderingField("a.name"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, Agent.QUERY_FIND_BY_SERVER, pageControl); Query countQuery = PersistenceUtility.createCountQuery(entityManager, Agent.QUERY_FIND_BY_SERVER); query.setParameter("serverId", serverId); countQuery.setParameter("serverId", serverId); long count = (Long) countQuery.getSingleResult(); List<Agent> results = query.getResultList(); return new PageList<Agent>(results, (int) count, pageControl); }
@SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_INVENTORY) public PageList<Agent> getAgentMembers(Subject subject, int affinityGroupId, PageControl pageControl) { pageControl.initDefaultOrderingField("a.name"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, Agent.QUERY_FIND_BY_AFFINITY_GROUP, pageControl); Query countQuery = PersistenceUtility.createCountQuery(entityManager, Agent.QUERY_FIND_BY_AFFINITY_GROUP); query.setParameter("affinityGroupId", affinityGroupId); countQuery.setParameter("affinityGroupId", affinityGroupId); long count = (Long) countQuery.getSingleResult(); List<Agent> results = query.getResultList(); return new PageList<Agent>(results, (int) count, pageControl); }
@SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_REPOSITORIES) public PageList<RepoSyncResults> getRepoSyncResults(Subject subject, int repoId, PageControl pc) { pc.initDefaultOrderingField("cssr.startTime", PageOrdering.DESC); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, RepoSyncResults.QUERY_GET_ALL_BY_REPO_ID, pc); Query countQuery = PersistenceUtility.createCountQuery(entityManager, RepoSyncResults.QUERY_GET_ALL_BY_REPO_ID); query.setParameter("repoId", repoId); countQuery.setParameter("repoId", repoId); List<RepoSyncResults> results = query.getResultList(); long count = (Long) countQuery.getSingleResult(); return new PageList<RepoSyncResults>(results, (int) count, pc); }
@SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_REPOSITORIES) public PageList<ContentSource> getAllContentSources(Subject subject, PageControl pc) { pc.initDefaultOrderingField("cs.name"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, ContentSource.QUERY_FIND_ALL_WITH_CONFIG, pc); Query countQuery = PersistenceUtility.createCountQuery(entityManager, ContentSource.QUERY_FIND_ALL); List<ContentSource> results = query.getResultList(); long count = (Long) countQuery.getSingleResult(); return new PageList<ContentSource>(results, (int) count, pc); }
@SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_REPOSITORIES) public PageList<PackageVersionContentSource> getPackageVersionsFromContentSource(Subject subject, int contentSourceId, PageControl pc) { pc.initDefaultOrderingField("pvcs.contentSource.id"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, PackageVersionContentSource.QUERY_FIND_BY_CONTENT_SOURCE_ID, pc); query.setParameter("id", contentSourceId); List<PackageVersionContentSource> results = query.getResultList(); long count = getPackageVersionCountFromContentSource(subject, contentSourceId); return new PageList<PackageVersionContentSource>(results, (int) count, pc); }
@SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_INVENTORY) public PageList<Server> getServerNonMembers(Subject subject, int affinityGroupId, PageControl pageControl) { pageControl.initDefaultOrderingField("s.name"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, Server.QUERY_FIND_WITHOUT_AFFINITY_GROUP, pageControl); Query countQuery = PersistenceUtility.createCountQuery(entityManager, Server.QUERY_FIND_WITHOUT_AFFINITY_GROUP); long count = (Long) countQuery.getSingleResult(); List<Server> results = query.getResultList(); return new PageList<Server>(results, (int) count, pageControl); }
@SuppressWarnings("unchecked") @RequiredPermission(Permission.MANAGE_INVENTORY) public PageList<Agent> getAgentNonMembers(Subject subject, int affinityGroupId, PageControl pageControl) { pageControl.initDefaultOrderingField("a.name"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, Agent.QUERY_FIND_WITHOUT_AFFINITY_GROUP, pageControl); Query countQuery = PersistenceUtility.createCountQuery(entityManager, Agent.QUERY_FIND_WITHOUT_AFFINITY_GROUP); long count = (Long) countQuery.getSingleResult(); List<Agent> results = query.getResultList(); return new PageList<Agent>(results, (int) count, pageControl); }
@SuppressWarnings("unchecked") public PageList<PackageVersion> findPackageVersionsInRepo(Subject subject, int repoId, PageControl pc) { if (!authzManager.canViewRepo(subject, repoId)) { throw new PermissionException("User [" + subject + "] can't access repo with id " + repoId); } pc.initDefaultOrderingField("pv.generalPackage.name, pv.version"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, PackageVersion.QUERY_FIND_BY_REPO_ID_WITH_PACKAGE, pc); query.setParameter("repoId", repoId); List<PackageVersion> results = query.getResultList(); long count = getPackageVersionCountFromRepo(subject, null, repoId); return new PageList<PackageVersion>(results, (int) count, pc); }
@SuppressWarnings( { "unchecked" }) public PageList<GroupDefinition> getGroupDefinitions(Subject subject, PageControl pc) { pc.initDefaultOrderingField("gd.name"); if (authorizationManager.isInventoryManager(subject)) { Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, GroupDefinition.QUERY_FIND_ALL, pc); List<GroupDefinition> results = query.getResultList(); int count = getGroupDefinitionCount(subject); return new PageList<GroupDefinition>(results, count, pc); } else { return new PageList<GroupDefinition>(pc); } }
@SuppressWarnings("unchecked") @RequiredPermissions({ @RequiredPermission(Permission.MANAGE_SETTINGS), @RequiredPermission(Permission.MANAGE_INVENTORY) }) public PageList<AffinityGroupCountComposite> getComposites(Subject subject, PageControl pageControl) { pageControl.initDefaultOrderingField("ag.name"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, AffinityGroup.QUERY_FIND_ALL_COMPOSITES, pageControl); int count = getAffinityGroupCount(); List<AffinityGroupCountComposite> results = query.getResultList(); return new PageList<AffinityGroupCountComposite>(results, count, pageControl); }
@SuppressWarnings("unchecked") @RequiredPermissions({ @RequiredPermission(Permission.MANAGE_SETTINGS), @RequiredPermission(Permission.MANAGE_INVENTORY) }) public PageList<ServerWithAgentCountComposite> getServerComposites(Subject subject, PageControl pc) { pc.initDefaultOrderingField("s.name"); Query query = PersistenceUtility.createQueryWithOrderBy(entityManager, Server.QUERY_FIND_ALL_COMPOSITES, pc); List<ServerWithAgentCountComposite> results = query.getResultList(); int count = getServerCount(); return new PageList<ServerWithAgentCountComposite>(results, count, pc); }