final CannedQueryResults<AuthorityInfo> results = cq.execute();
final CannedQueryResults<AuthorityInfo> results = cq.execute();
@Override public PagingResults<CopyInfo> getCopies(NodeRef originalNodeRef, PagingRequest pagingRequest) { CannedQueryFactory<CopyInfo> queryFactory = cannedQueryRegistry.getNamedObject(QUERY_FACTORY_GET_COPIES); CannedQueryParameters params = new CannedQueryParameters( new AbstractCopyCannedQueryFactory.CopyCannedQueryDetail(originalNodeRef), null, pagingRequest); CannedQuery<CopyInfo> query = queryFactory.getCannedQuery(params); return query.execute(); }
final CannedQueryResults<ArchivedNodeEntity> results = ((CannedQuery<ArchivedNodeEntity>) cq).execute();
@Override public PagingResults<CopyInfo> getCopies(NodeRef originalNodeRef, PagingRequest pagingRequest) { CannedQueryFactory<CopyInfo> queryFactory = cannedQueryRegistry.getNamedObject(QUERY_FACTORY_GET_COPIES); CannedQueryParameters params = new CannedQueryParameters( new AbstractCopyCannedQueryFactory.CopyCannedQueryDetail(originalNodeRef), null, pagingRequest); CannedQuery<CopyInfo> query = queryFactory.getCannedQuery(params); return query.execute(); }
@Override public PagingResults<CopyInfo> getCopies( NodeRef originalNodeRef, NodeRef copyParentNodeRef, PagingRequest pagingRequest) { CannedQueryFactory<CopyInfo> queryFactory = cannedQueryRegistry.getNamedObject(QUERY_FACTORY_GET_COPIES); CannedQueryParameters params = new CannedQueryParameters( new AbstractCopyCannedQueryFactory.CopyCannedQueryDetail(originalNodeRef, copyParentNodeRef), null, pagingRequest); CannedQuery<CopyInfo> query = queryFactory.getCannedQuery(params); return query.execute(); }
final CannedQueryResults<ArchivedNodeEntity> results = ((CannedQuery<ArchivedNodeEntity>) cq).execute();
@Override public PagingResults<CopyInfo> getCopies( NodeRef originalNodeRef, NodeRef copyParentNodeRef, PagingRequest pagingRequest) { CannedQueryFactory<CopyInfo> queryFactory = cannedQueryRegistry.getNamedObject(QUERY_FACTORY_GET_COPIES); CannedQueryParameters params = new CannedQueryParameters( new AbstractCopyCannedQueryFactory.CopyCannedQueryDetail(originalNodeRef, copyParentNodeRef), null, pagingRequest); CannedQuery<CopyInfo> query = queryFactory.getCannedQuery(params); return query.execute(); }
public PagingResults<SiteMembership> listMembersPaged(String shortName, boolean collapseGroups, List<Pair<SiteService.SortFields, Boolean>> sortProps, PagingRequest pagingRequest) { CannedQueryPageDetails pageDetails = new CannedQueryPageDetails(pagingRequest.getSkipCount(), pagingRequest.getMaxItems()); // sort details CannedQuerySortDetails sortDetails = null; if(sortProps != null) { List<Pair<? extends Object, SortOrder>> sortPairs = new ArrayList<Pair<? extends Object, SortOrder>>(sortProps.size()); for (Pair<SiteService.SortFields, Boolean> sortProp : sortProps) { sortPairs.add(new Pair<SiteService.SortFields, SortOrder>(sortProp.getFirst(), (sortProp.getSecond() ? SortOrder.ASCENDING : SortOrder.DESCENDING))); } sortDetails = new CannedQuerySortDetails(sortPairs); } SiteMembersCannedQueryParams parameterBean = new SiteMembersCannedQueryParams(shortName, collapseGroups); CannedQueryParameters params = new CannedQueryParameters(parameterBean, pageDetails, sortDetails, pagingRequest.getRequestTotalCountMax(), pagingRequest.getQueryExecutionId()); CannedQuery<SiteMembership> query = new SiteMembersCannedQuery(this, personService, nodeService, params); CannedQueryResults<SiteMembership> results = query.execute(); return getPagingResults(pagingRequest, results); }
public PagingResults<SiteMembership> listMembersPaged(String shortName, boolean collapseGroups, List<Pair<SiteService.SortFields, Boolean>> sortProps, PagingRequest pagingRequest) { CannedQueryPageDetails pageDetails = new CannedQueryPageDetails(pagingRequest.getSkipCount(), pagingRequest.getMaxItems()); // sort details CannedQuerySortDetails sortDetails = null; if(sortProps != null) { List<Pair<? extends Object, SortOrder>> sortPairs = new ArrayList<Pair<? extends Object, SortOrder>>(sortProps.size()); for (Pair<SiteService.SortFields, Boolean> sortProp : sortProps) { sortPairs.add(new Pair<SiteService.SortFields, SortOrder>(sortProp.getFirst(), (sortProp.getSecond() ? SortOrder.ASCENDING : SortOrder.DESCENDING))); } sortDetails = new CannedQuerySortDetails(sortPairs); } SiteMembersCannedQueryParams parameterBean = new SiteMembersCannedQueryParams(shortName, collapseGroups); CannedQueryParameters params = new CannedQueryParameters(parameterBean, pageDetails, sortDetails, pagingRequest.getRequestTotalCountMax(), pagingRequest.getQueryExecutionId()); CannedQuery<SiteMembership> query = new SiteMembersCannedQuery(this, personService, nodeService, params); CannedQueryResults<SiteMembership> results = query.execute(); return getPagingResults(pagingRequest, results); }
@Override public List<Long> getNodeLinksIds(NodeRef nodeRef) { /* Validate input */ PropertyCheck.mandatory(this, "nodeRef", nodeRef); /* Get all links of the given nodeRef */ PagingRequest pagingRequest = new PagingRequest(0, 100000); List<Long> nodeLinks = new ArrayList<Long>(); Pair<Long, QName> nameQName = qnameDAO.getQName(ContentModel.PROP_LINK_DESTINATION); if (nameQName != null) { // Execute the canned query if there are links in the database GetDoclinkNodesCannedQueryParams parameterBean = new GetDoclinkNodesCannedQueryParams(nodeRef.toString(), nameQName.getFirst(), pagingRequest.getMaxItems()); CannedQueryParameters params = new CannedQueryParameters(parameterBean, null, null, pagingRequest.getRequestTotalCountMax(), pagingRequest.getQueryExecutionId()); CannedQuery<Long> query = new GetDoclinkNodesCannedQuery(cannedQueryDAO, params); CannedQueryResults<Long> results = query.execute(); for (Long nodeId : results.getPage()) { nodeLinks.add(nodeId); } } return nodeLinks; }
@Override public List<Long> getNodeLinksIds(NodeRef nodeRef) { /* Validate input */ PropertyCheck.mandatory(this, "nodeRef", nodeRef); /* Get all links of the given nodeRef */ PagingRequest pagingRequest = new PagingRequest(0, 100000); List<Long> nodeLinks = new ArrayList<Long>(); Pair<Long, QName> nameQName = qnameDAO.getQName(ContentModel.PROP_LINK_DESTINATION); if (nameQName != null) { // Execute the canned query if there are links in the database GetDoclinkNodesCannedQueryParams parameterBean = new GetDoclinkNodesCannedQueryParams(nodeRef.toString(), nameQName.getFirst(), pagingRequest.getMaxItems()); CannedQueryParameters params = new CannedQueryParameters(parameterBean, null, null, pagingRequest.getRequestTotalCountMax(), pagingRequest.getQueryExecutionId()); CannedQuery<Long> query = new GetDoclinkNodesCannedQuery(cannedQueryDAO, params); CannedQueryResults<Long> results = query.execute(); for (Long nodeId : results.getPage()) { nodeLinks.add(nodeId); } } return nodeLinks; }
@SuppressWarnings("unchecked") public void testQueryPermissionCheckedResults() throws Exception { CannedQueryFactory<String> qfOne = namedQueryFactoryRegistry.getNamedObject(QUERY_TEST_ONE); CannedQueryParameters params = new CannedQueryParameters(null, null, null, 0, null); CannedQuery<String> qOne = qfOne.getCannedQuery(params); CannedQueryResults<String> qrOne = qOne.execute(); // Check pages assertEquals("Incorrect number of results", 9, qrOne.getPagedResultCount()); assertEquals("Incorrect result order", "ONE_0", qrOne.getPages().get(0).get(0)); assertEquals("Incorrect result order", "ONE_1", qrOne.getPages().get(0).get(1)); assertEquals("Incorrect result order", "ONE_2", qrOne.getPages().get(0).get(2)); assertEquals("Incorrect result order", "ONE_3", qrOne.getPages().get(0).get(3)); assertEquals("Incorrect result order", "ONE_4", qrOne.getPages().get(0).get(4)); // << missing 5! assertEquals("Incorrect result order", "ONE_6", qrOne.getPages().get(0).get(5)); assertEquals("Incorrect result order", "ONE_7", qrOne.getPages().get(0).get(6)); assertEquals("Incorrect result order", "ONE_8", qrOne.getPages().get(0).get(7)); assertEquals("Incorrect result order", "ONE_9", qrOne.getPages().get(0).get(8)); assertFalse("Should NOT have any more pages/items", qrOne.hasMoreItems()); }
@SuppressWarnings("unchecked") public void testQuerySortedResults() throws Exception { CannedQueryFactory<String> qfOne = namedQueryFactoryRegistry.getNamedObject(QUERY_TEST_ONE); CannedQuerySortDetails qSortDetails = new CannedQuerySortDetails( new Pair<Object, SortOrder>("blah", SortOrder.DESCENDING)); CannedQueryParameters params = new CannedQueryParameters(null, null, qSortDetails); CannedQuery<String> qOne = qfOne.getCannedQuery(params); CannedQueryResults<String> qrOne = qOne.execute(); // Check pages assertEquals("Incorrect number of results", 9, qrOne.getPagedResultCount()); assertEquals("Expected inverse sorting", "ONE_9", qrOne.getPages().get(0).get(0)); assertEquals("Expected inverse sorting", "ONE_0", qrOne.getPages().get(0).get(8)); assertFalse("Should NOT have any more pages/items", qrOne.hasMoreItems()); }
@SuppressWarnings("unchecked") public void testQueryMaxResults() throws Exception { // An instance of the CannedQueryFactory could be injected or constructed as well CannedQueryFactory<String> qfOne = namedQueryFactoryRegistry.getNamedObject(QUERY_TEST_ONE); CannedQuery<String> qOne = qfOne.getCannedQuery(null, 0, 9, null); CannedQueryResults<String> qrOne = qOne.execute(); // Get the paged result count int pagedResultCount = qrOne.getPagedResultCount(); assertEquals("Incorrect number of results", 9, pagedResultCount); assertEquals("Incorrect number of pages", 1, qrOne.getPageCount()); List<List<String>> pages = qrOne.getPages(); assertEquals("Incorrect number of pages", 1, pages.size()); assertEquals("No sorting was specified in the parameters", "ONE_0", qrOne.getPages().get(0).get(0)); assertEquals("No sorting was specified in the parameters", "ONE_9", qrOne.getPages().get(0).get(8)); assertFalse("Should have more pages/items", qrOne.hasMoreItems()); }
@SuppressWarnings("unchecked") public PagingResults<FileInfo> listContainers(String shortName, PagingRequest pagingRequest) { SiteContainersCannedQueryFactory sitesContainersCannedQueryFactory = (SiteContainersCannedQueryFactory)cannedQueryRegistry.getNamedObject("siteContainersCannedQueryFactory"); CannedQueryPageDetails pageDetails = new CannedQueryPageDetails(pagingRequest.getSkipCount(), pagingRequest.getMaxItems()); CannedQuerySortDetails sortDetails = new CannedQuerySortDetails(new Pair<Object, SortOrder>(SiteContainersCannedQueryParams.SortFields.ContainerName, SortOrder.ASCENDING)); SiteContainersCannedQueryParams parameterBean = new SiteContainersCannedQueryParams(getSiteNodeRef(shortName)); CannedQueryParameters params = new CannedQueryParameters(parameterBean, pageDetails, sortDetails, pagingRequest.getRequestTotalCountMax(), pagingRequest.getQueryExecutionId()); CannedQuery<FileInfo> query = sitesContainersCannedQueryFactory.getCannedQuery(params); CannedQueryResults<FileInfo> results = query.execute(); return getPagingResults(pagingRequest, results); }
@SuppressWarnings("unchecked") public PagingResults<FileInfo> listContainers(String shortName, PagingRequest pagingRequest) { SiteContainersCannedQueryFactory sitesContainersCannedQueryFactory = (SiteContainersCannedQueryFactory)cannedQueryRegistry.getNamedObject("siteContainersCannedQueryFactory"); CannedQueryPageDetails pageDetails = new CannedQueryPageDetails(pagingRequest.getSkipCount(), pagingRequest.getMaxItems()); CannedQuerySortDetails sortDetails = new CannedQuerySortDetails(new Pair<Object, SortOrder>(SiteContainersCannedQueryParams.SortFields.ContainerName, SortOrder.ASCENDING)); SiteContainersCannedQueryParams parameterBean = new SiteContainersCannedQueryParams(getSiteNodeRef(shortName)); CannedQueryParameters params = new CannedQueryParameters(parameterBean, pageDetails, sortDetails, pagingRequest.getRequestTotalCountMax(), pagingRequest.getQueryExecutionId()); CannedQuery<FileInfo> query = sitesContainersCannedQueryFactory.getCannedQuery(params); CannedQueryResults<FileInfo> results = query.execute(); return getPagingResults(pagingRequest, results); }
CannedQueryParameters params = new CannedQueryParameters(null, qPageDetails, null); CannedQuery<String> qOne = qfOne.getCannedQuery(params); CannedQueryResults<String> qrOne = qOne.execute(); params = new CannedQueryParameters(null, qPageDetails, null); qOne = qfOne.getCannedQuery(params); qrOne = qOne.execute(); params = new CannedQueryParameters(null, qPageDetails, null); qOne = qfOne.getCannedQuery(params); qrOne = qOne.execute();
@SuppressWarnings("unchecked") public void testQueryPermissionCheckedPagedTotalCount() throws Exception { CannedQueryFactory<String> qfOne = namedQueryFactoryRegistry.getNamedObject(QUERY_TEST_ONE); CannedQueryPageDetails qPageDetails = new CannedQueryPageDetails(5, 1, 1, 1); CannedQuerySortDetails qSortDetails = new CannedQuerySortDetails( new Pair<Object, SortOrder>("blah", SortOrder.DESCENDING)); CannedQueryParameters params = new CannedQueryParameters(null, qPageDetails, qSortDetails, 1000, null); CannedQuery<String> qOne = qfOne.getCannedQuery(params); CannedQueryResults<String> qrOne = qOne.execute(); // Check pages assertEquals("Incorrect number of total results", new Pair<Integer, Integer>(9,9), qrOne.getTotalResultCount()); // Pre-paging assertEquals("Incorrect number of paged results", 1, qrOne.getPagedResultCount()); // Skipped 5 assertEquals("Incorrect result order", "ONE_3", qrOne.getPages().get(0).get(0)); // Order reversed assertTrue("Should have more pages/items", qrOne.hasMoreItems()); }