private IQueryable <PageVersion> CreateQuery(SearchPageRenderSummariesQuery query, IExecutionContext executionContext)
{
var dbQuery = _dbContext
.PagePublishStatusQueries
.AsNoTracking()
.Include(v => v.PageVersion)
.ThenInclude(v => v.OpenGraphImageAsset)
.FilterByStatus(query.PublishStatus, executionContext.ExecutionDate)
.FilterActive()
;
// Filter by locale
if (query.LocaleId > 0)
{
dbQuery = dbQuery.FilterByLocaleId(query.LocaleId.Value);
}
// Filter by directory
if (query.PageDirectoryId > 0)
{
dbQuery = dbQuery.FilterByDirectoryId(query.PageDirectoryId.Value);
}
return(dbQuery
.SortBy(query.SortBy, query.SortDirection)
.Select(p => p.PageVersion));
}
public async Task <PagedQueryResult <PageRenderSummary> > ExecuteAsync(SearchPageRenderSummariesQuery query, IExecutionContext executionContext)
{
var dbPagedResult = await CreateQuery(query, executionContext)
.ToPagedResultAsync(query);
var allPageIds = dbPagedResult.Items.Select(p => p.PageId);
var allPageRoutes = await _queryExecutor.ExecuteAsync(new GetPageRoutesByIdRangeQuery(allPageIds));
var results = new List <PageRenderSummary>(dbPagedResult.Items.Count);
foreach (var dbResult in dbPagedResult.Items)
{
var mappedResult = _pageRenderSummaryMapper.Map <PageRenderSummary>(dbResult, allPageRoutes);
results.Add(mappedResult);
}
return(dbPagedResult.ChangeType(results));
}
public IContentRepositoryQueryContext <PagedQueryResult <PageRenderSummary> > AsRenderSummaries(SearchPageRenderSummariesQuery query)
{
return(ContentRepositoryQueryContextFactory.Create(query, ExtendableContentRepository));
}
/// <summary>
/// Search page data returning the PageRenderSummary projection, which is
/// a lighter weight projection designed for rendering to a site when the
/// templates, region and block data is not required. The result is
/// version-sensitive and defaults to returning published versions only, but
/// this behavior can be controlled by the PublishStatus query property.
/// </summary>
/// <param name="query">Query parameters</param>
/// <param name="executionContext">Optional execution context to use when executing the query. Useful if you need to temporarily elevate your permission level.</param>
public Task <PagedQueryResult <PageRenderSummary> > SearchPageRenderSummariesAsync(SearchPageRenderSummariesQuery query, IExecutionContext executionContext = null)
{
return(_queryExecutor.ExecuteAsync(query, executionContext));
}
public IEnumerable <IPermissionApplication> GetPermissions(SearchPageRenderSummariesQuery query)
{
yield return(new PageReadPermission());
}
public Task <PagedQueryResult <PageRenderSummary> > AsRenderSummariesAsync(SearchPageRenderSummariesQuery query)
{
return(ExtendableContentRepository.ExecuteQueryAsync(query));
}