/** * Construct all the parameters for executing a named query, using values from the * {@link PagingRequest}. * * @param parameterBean the values that the query will be based on or <tt>null</tt> * if not relevant to the query * @param sortDetails the type of sorting to be applied or <tt>null</tt> for none * @param pagingRequest the type of paging to be applied or <tt>null</tt> for none */ public CannedQueryParameters( Object parameterBean, CannedQuerySortDetails sortDetails, PagingRequest pagingRequest) { this ( parameterBean, pagingRequest == null ? null : new CannedQueryPageDetails(pagingRequest), sortDetails, pagingRequest == null ? 0 : pagingRequest.getRequestTotalCountMax(), pagingRequest == null ? null : pagingRequest.getQueryExecutionId()); }
/** * Construct all the parameters for executing a named query, using values from the * {@link PagingRequest}. * * @param parameterBean the values that the query will be based on or <tt>null</tt> * if not relevant to the query * @param sortDetails the type of sorting to be applied or <tt>null</tt> for none * @param pageRequest the type of paging to be applied or <tt>null</tt> for none */ public CannedQueryParameters( Object parameterBean, CannedQuerySortDetails sortDetails, PagingRequest pagingRequest) { this ( parameterBean, pagingRequest == null ? null : new CannedQueryPageDetails(pagingRequest), sortDetails, pagingRequest == null ? 0 : pagingRequest.getRequestTotalCountMax(), pagingRequest == null ? null : pagingRequest.getQueryExecutionId()); }
public ScriptPagingDetails(PagingRequest paging) { super(paging.getSkipCount(), paging.getMaxItems(), paging.getQueryExecutionId()); setRequestTotalCountMax(paging.getRequestTotalCountMax()); }
public ScriptPagingDetails(PagingRequest paging) { super(paging.getSkipCount(), paging.getMaxItems(), paging.getQueryExecutionId()); setRequestTotalCountMax(paging.getRequestTotalCountMax()); }
private CannedQueryResults<NodeRef> listImpl(NodeRef contextNodeRef, String pattern, Set<QName> assocTypeQNames, Set<QName> searchTypeQNames, Set<QName> ignoreAspectQNames, List<Pair<QName, Boolean>> sortProps, List<FilterProp> filterProps, PagingRequest pagingRequest) { Long start = (logger.isDebugEnabled() ? System.currentTimeMillis() : null); // get canned query GetChildrenCannedQueryFactory getChildrenCannedQueryFactory = (GetChildrenCannedQueryFactory)cannedQueryRegistry.getNamedObject(CANNED_QUERY_FILEFOLDER_LIST); GetChildrenCannedQuery cq = (GetChildrenCannedQuery)getChildrenCannedQueryFactory.getCannedQuery(contextNodeRef, pattern, assocTypeQNames, searchTypeQNames, ignoreAspectQNames, filterProps, sortProps, pagingRequest); // execute canned query CannedQueryResults<NodeRef> results = cq.execute(); if (start != null) { int cnt = results.getPagedResultCount(); int skipCount = pagingRequest.getSkipCount(); int maxItems = pagingRequest.getMaxItems(); boolean hasMoreItems = results.hasMoreItems(); Pair<Integer, Integer> totalCount = (pagingRequest.getRequestTotalCountMax() > 0 ? results.getTotalResultCount() : null); int pageNum = (skipCount / maxItems) + 1; logger.debug("List: "+cnt+" items in "+(System.currentTimeMillis()-start)+" msecs [pageNum="+pageNum+",skip="+skipCount+",max="+maxItems+",hasMorePages="+hasMoreItems+",totalCount="+totalCount+",parentNodeRef="+contextNodeRef+"]"); } return results; }
private CannedQueryResults<NodeRef> listImpl(NodeRef contextNodeRef, String pattern, Set<QName> assocTypeQNames, Set<QName> searchTypeQNames, Set<QName> ignoreAspectQNames, List<Pair<QName, Boolean>> sortProps, List<FilterProp> filterProps, PagingRequest pagingRequest) { Long start = (logger.isDebugEnabled() ? System.currentTimeMillis() : null); // get canned query GetChildrenCannedQueryFactory getChildrenCannedQueryFactory = (GetChildrenCannedQueryFactory)cannedQueryRegistry.getNamedObject(CANNED_QUERY_FILEFOLDER_LIST); GetChildrenCannedQuery cq = (GetChildrenCannedQuery)getChildrenCannedQueryFactory.getCannedQuery(contextNodeRef, pattern, assocTypeQNames, searchTypeQNames, ignoreAspectQNames, filterProps, sortProps, pagingRequest); // execute canned query CannedQueryResults<NodeRef> results = cq.execute(); if (start != null) { int cnt = results.getPagedResultCount(); int skipCount = pagingRequest.getSkipCount(); int maxItems = pagingRequest.getMaxItems(); boolean hasMoreItems = results.hasMoreItems(); Pair<Integer, Integer> totalCount = (pagingRequest.getRequestTotalCountMax() > 0 ? results.getTotalResultCount() : null); int pageNum = (skipCount / maxItems) + 1; logger.debug("List: "+cnt+" items in "+(System.currentTimeMillis()-start)+" msecs [pageNum="+pageNum+",skip="+skipCount+",max="+maxItems+",hasMorePages="+hasMoreItems+",totalCount="+totalCount+",parentNodeRef="+contextNodeRef+"]"); } return results; }
public PagingRequest getPagingRequest() { PagingRequest pr = new PagingRequest(this.pagingRequest.getSkipCount(), this.pagingRequest.getMaxItems(), this.pagingRequest.getQueryExecutionId()); pr.setRequestTotalCountMax(this.pagingRequest.getRequestTotalCountMax()); return pr; }
public PagingRequest getPagingRequest() { PagingRequest pr = new PagingRequest(this.pagingRequest.getSkipCount(), this.pagingRequest.getMaxItems(), this.pagingRequest.getQueryExecutionId()); pr.setRequestTotalCountMax(this.pagingRequest.getRequestTotalCountMax()); return pr; }
public ArchivedNodesCannedQueryBuilder(Builder builder) { ParameterCheck.mandatory("storeRef", (this.archiveRootNodeRef = builder.archiveRootNodeRef)); ParameterCheck.mandatory("pagingRequest", builder.pagingRequest); // Defensive copy PagingRequest pr = new PagingRequest(builder.pagingRequest.getSkipCount(), builder.pagingRequest.getMaxItems(), builder.pagingRequest.getQueryExecutionId()); pr.setRequestTotalCountMax(builder.pagingRequest.getRequestTotalCountMax()); this.pagingRequest = pr; this.filter = builder.filter; this.sortOrderAscending = builder.sortOrderAscending; }
public ArchivedNodesCannedQueryBuilder(Builder builder) { ParameterCheck.mandatory("storeRef", (this.archiveRootNodeRef = builder.archiveRootNodeRef)); ParameterCheck.mandatory("pagingRequest", builder.pagingRequest); // Defensive copy PagingRequest pr = new PagingRequest(builder.pagingRequest.getSkipCount(), builder.pagingRequest.getMaxItems(), builder.pagingRequest.getQueryExecutionId()); pr.setRequestTotalCountMax(builder.pagingRequest.getRequestTotalCountMax()); this.pagingRequest = pr; this.filter = builder.filter; this.sortOrderAscending = builder.sortOrderAscending; }
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); }
@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); }
public CannedQuery<NodeWithChildrenEntity> getCannedQuery(NodeRef parentNodeRef, Date topicCreatedFrom, Date postCreatedFrom, boolean excludePrimaryPosts, CannedQuerySortDetails sortDetails, PagingRequest pagingReq) { ParameterCheck.mandatory("parentNodeRef", parentNodeRef); ParameterCheck.mandatory("pagingReq", pagingReq); int requestTotalCountMax = pagingReq.getRequestTotalCountMax(); //FIXME Need tenant service like for GetChildren? GetDiscussionTopcisWithPostsCannedQueryParams paramBean = new GetDiscussionTopcisWithPostsCannedQueryParams( getNodeId(parentNodeRef), getQNameId(ContentModel.PROP_NAME), getQNameId(ForumModel.TYPE_TOPIC), getQNameId(ForumModel.TYPE_POST), topicCreatedFrom, postCreatedFrom, excludePrimaryPosts); CannedQueryPageDetails cqpd = createCQPageDetails(pagingReq); // create query params holder CannedQueryParameters params = new CannedQueryParameters( paramBean, cqpd, sortDetails, requestTotalCountMax, pagingReq.getQueryExecutionId()); // return canned query instance return getCannedQuery(params); } }
public CannedQuery<BlogEntity> getGetDraftsCannedQuery(NodeRef blogContainerNode, String username, PagingRequest pagingReq) { ParameterCheck.mandatory("blogContainerNode", blogContainerNode); ParameterCheck.mandatory("pagingReq", pagingReq); int requestTotalCountMax = pagingReq.getRequestTotalCountMax(); //FIXME Need tenant service like for GetChildren? boolean isPublished = false; GetBlogPostsCannedQueryParams paramBean = new GetBlogPostsCannedQueryParams(getNodeId(blogContainerNode), getQNameId(ContentModel.PROP_NAME), getQNameId(ContentModel.PROP_PUBLISHED), getQNameId(ContentModel.TYPE_CONTENT), username, isPublished, null, null, null, null); CannedQueryPageDetails cqpd = createCQPageDetails(pagingReq); CannedQuerySortDetails cqsd = createCQSortDetails(ContentModel.PROP_CREATED, SortOrder.DESCENDING); // create query params holder CannedQueryParameters params = new CannedQueryParameters(paramBean, cqpd, cqsd, requestTotalCountMax, pagingReq.getQueryExecutionId()); // return canned query instance return getCannedQuery(params); }
public CannedQuery<BlogEntity> getGetPublishedCannedQuery(NodeRef blogContainerNode, Date fromDate, Date toDate, String byUser, PagingRequest pagingReq) { ParameterCheck.mandatory("blogContainerNode", blogContainerNode); ParameterCheck.mandatory("pagingReq", pagingReq); int requestTotalCountMax = pagingReq.getRequestTotalCountMax(); boolean isPublished = true; GetBlogPostsCannedQueryParams paramBean = new GetBlogPostsCannedQueryParams(getNodeId(blogContainerNode), getQNameId(ContentModel.PROP_NAME), getQNameId(ContentModel.PROP_PUBLISHED), getQNameId(ContentModel.TYPE_CONTENT), byUser, isPublished, fromDate, toDate, null, null); CannedQueryPageDetails cqpd = createCQPageDetails(pagingReq); CannedQuerySortDetails cqsd = createCQSortDetails(ContentModel.PROP_PUBLISHED, SortOrder.DESCENDING); // create query params holder CannedQueryParameters params = new CannedQueryParameters(paramBean, cqpd, cqsd, requestTotalCountMax, pagingReq.getQueryExecutionId()); // return canned query instance return getCannedQuery(params); } }
public CannedQuery<BlogEntity> getGetDraftsCannedQuery(NodeRef blogContainerNode, String username, PagingRequest pagingReq) { ParameterCheck.mandatory("blogContainerNode", blogContainerNode); ParameterCheck.mandatory("pagingReq", pagingReq); int requestTotalCountMax = pagingReq.getRequestTotalCountMax(); //FIXME Need tenant service like for GetChildren? boolean isPublished = false; GetBlogPostsCannedQueryParams paramBean = new GetBlogPostsCannedQueryParams(getNodeId(blogContainerNode), getQNameId(ContentModel.PROP_NAME), getQNameId(ContentModel.PROP_PUBLISHED), getQNameId(ContentModel.TYPE_CONTENT), username, isPublished, null, null, null, null); CannedQueryPageDetails cqpd = createCQPageDetails(pagingReq); CannedQuerySortDetails cqsd = createCQSortDetails(ContentModel.PROP_CREATED, SortOrder.DESCENDING); // create query params holder CannedQueryParameters params = new CannedQueryParameters(paramBean, cqpd, cqsd, requestTotalCountMax, pagingReq.getQueryExecutionId()); // return canned query instance return getCannedQuery(params); }
public CannedQuery<BlogEntity> getGetPublishedCannedQuery(NodeRef blogContainerNode, Date fromDate, Date toDate, String byUser, PagingRequest pagingReq) { ParameterCheck.mandatory("blogContainerNode", blogContainerNode); ParameterCheck.mandatory("pagingReq", pagingReq); int requestTotalCountMax = pagingReq.getRequestTotalCountMax(); boolean isPublished = true; GetBlogPostsCannedQueryParams paramBean = new GetBlogPostsCannedQueryParams(getNodeId(blogContainerNode), getQNameId(ContentModel.PROP_NAME), getQNameId(ContentModel.PROP_PUBLISHED), getQNameId(ContentModel.TYPE_CONTENT), byUser, isPublished, fromDate, toDate, null, null); CannedQueryPageDetails cqpd = createCQPageDetails(pagingReq); CannedQuerySortDetails cqsd = createCQSortDetails(ContentModel.PROP_PUBLISHED, SortOrder.DESCENDING); // create query params holder CannedQueryParameters params = new CannedQueryParameters(paramBean, cqpd, cqsd, requestTotalCountMax, pagingReq.getQueryExecutionId()); // return canned query instance return getCannedQuery(params); } }
public CannedQuery<NodeWithTargetsEntity> getCannedQuery(NodeRef parentNodeRef, QName contentType, QName assocType, CannedQuerySortDetails sortDetails, PagingRequest pagingReq) { ParameterCheck.mandatory("parentNodeRef", parentNodeRef); ParameterCheck.mandatory("contentType", contentType); ParameterCheck.mandatory("pagingReq", pagingReq); int requestTotalCountMax = pagingReq.getRequestTotalCountMax(); //FIXME Need tenant service like for GetChildren? GetChildrenWithTargetAssocsAuditableCannedQueryParams paramBean = new GetChildrenWithTargetAssocsAuditableCannedQueryParams( getNodeId(parentNodeRef), getQNameId(ContentModel.PROP_NAME), getQNameId(contentType), getQNameId(assocType) ); CannedQueryPageDetails cqpd = createCQPageDetails(pagingReq); // create query params holder CannedQueryParameters params = new CannedQueryParameters( paramBean, cqpd, sortDetails, requestTotalCountMax, pagingReq.getQueryExecutionId()); // return canned query instance return getCannedQuery(params); } }