8911801772

Committed 01 May 2024 04:09PM CUT coverage: 57.379% (-1.8%) from 59.163%

Build # 8911801772

Build Type

push

github

Committed by

pwelter34

Commit Message

tweak build

Run Details

342 of 700 branches covered (48.86%)

Branch coverage included in aggregate %.

1011 of 1658 relevant lines covered (60.98%)

18.48 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

85.71

/src/MediatR.CommandQuery.EntityFrameworkCore/Handlers/EntityPagedQueryHandler.cs

using System.Linq.Dynamic.Core;

using AutoMapper;
using AutoMapper.QueryableExtensions;

using MediatR.CommandQuery.Extensions;
using MediatR.CommandQuery.Queries;

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;

namespace MediatR.CommandQuery.EntityFrameworkCore.Handlers;

public class EntityPagedQueryHandler<TContext, TEntity, TReadModel>
    : DataContextHandlerBase<TContext, EntityPagedQuery<TReadModel>, EntityPagedResult<TReadModel>>
    where TContext : DbContext
    where TEntity : class
{

    public EntityPagedQueryHandler(ILoggerFactory loggerFactory, TContext dataContext, IMapper mapper)
        : base(loggerFactory, dataContext, mapper)
    {
    }


    protected override async Task<EntityPagedResult<TReadModel>> Process(EntityPagedQuery<TReadModel> request, CancellationToken cancellationToken)
    {
        if (request is null)
            throw new ArgumentNullException(nameof(request));

        var query = DataContext
            .Set<TEntity>()
            .AsNoTracking();

        // build query from filter
        query = BuildQuery(request, query);

        // get total for query
        int total = await QueryTotal(request, query, cancellationToken)
            .ConfigureAwait(false);

        // short circuit if total is zero
        if (total == 0)
            return new EntityPagedResult<TReadModel> { Data = new List<TReadModel>() };

        // page the query and convert to read model
        var result = await QueryPaged(request, query, cancellationToken)
            .ConfigureAwait(false);

        return new EntityPagedResult<TReadModel>
        {
            Total = total,
            Data = result
        };
    }


    protected virtual IQueryable<TEntity> BuildQuery(EntityPagedQuery<TReadModel> request, IQueryable<TEntity> query)
    {
        var entityQuery = request.Query;

        // build query from filter
        if (entityQuery?.Filter != null)
            query = query.Filter(entityQuery.Filter);

        // add raw query
        if (!string.IsNullOrEmpty(entityQuery?.Query))
            query = query.Where(entityQuery.Query);


        return query;
    }

    protected virtual async Task<int> QueryTotal(EntityPagedQuery<TReadModel> request, IQueryable<TEntity> query, CancellationToken cancellationToken)
    {
        return await query
            .CountAsync(cancellationToken)
            .ConfigureAwait(false);
    }

    protected virtual async Task<IReadOnlyCollection<TReadModel>> QueryPaged(EntityPagedQuery<TReadModel> request, IQueryable<TEntity> query, CancellationToken cancellationToken)
    {
        var entityQuery = request.Query;

        var queryable = query
            .Sort(entityQuery.Sort);

        if (entityQuery.Page > 0 && entityQuery.PageSize > 0)
            queryable = queryable.Page(entityQuery.Page, entityQuery.PageSize);

        return await queryable
            .ProjectTo<TReadModel>(Mapper.ConfigurationProvider)
            .ToListAsync(cancellationToken)
            .ConfigureAwait(false);
    }
}

1	using System.Linq.Dynamic.Core;
2
3	using AutoMapper;
4	using AutoMapper.QueryableExtensions;
5
6	using MediatR.CommandQuery.Extensions;
7	using MediatR.CommandQuery.Queries;
8
9	using Microsoft.EntityFrameworkCore;
10	using Microsoft.Extensions.Logging;
11
12	namespace MediatR.CommandQuery.EntityFrameworkCore.Handlers;
13
14	public class EntityPagedQueryHandler<TContext, TEntity, TReadModel>
15	: DataContextHandlerBase<TContext, EntityPagedQuery<TReadModel>, EntityPagedResult<TReadModel>>
16	where TContext : DbContext
17	where TEntity : class
18	{
19
20	public EntityPagedQueryHandler(ILoggerFactory loggerFactory, TContext dataContext, IMapper mapper)
21	: base(loggerFactory, dataContext, mapper)	4✔
22	{
23	}	4✔
24
25
26	protected override async Task<EntityPagedResult<TReadModel>> Process(EntityPagedQuery<TReadModel> request, CancellationToken cancellationToken)
27	{
28	if (request is null)	4!
29	throw new ArgumentNullException(nameof(request));	×
30
31	var query = DataContext	4✔
32	.Set<TEntity>()	4✔
33	.AsNoTracking();	4✔
34
35	// build query from filter
36	query = BuildQuery(request, query);	4✔
37
38	// get total for query
39	int total = await QueryTotal(request, query, cancellationToken)	4✔
40	.ConfigureAwait(false);	4✔
41
42	// short circuit if total is zero
43	if (total == 0)	4!
44	return new EntityPagedResult<TReadModel> { Data = new List<TReadModel>() };	×
45
46	// page the query and convert to read model
47	var result = await QueryPaged(request, query, cancellationToken)	4✔
48	.ConfigureAwait(false);	4✔
49
50	return new EntityPagedResult<TReadModel>	4✔
51	{	4✔
52	Total = total,	4✔
53	Data = result	4✔
54	};	4✔
55	}	4✔
56
57
58	protected virtual IQueryable<TEntity> BuildQuery(EntityPagedQuery<TReadModel> request, IQueryable<TEntity> query)
59	{
60	var entityQuery = request.Query;	4✔
61
62	// build query from filter
63	if (entityQuery?.Filter != null)	4!
64	query = query.Filter(entityQuery.Filter);	4✔
65
66	// add raw query
67	if (!string.IsNullOrEmpty(entityQuery?.Query))	4!
68	query = query.Where(entityQuery.Query);	×
69
70
71	return query;	4✔
72	}
73
74	protected virtual async Task<int> QueryTotal(EntityPagedQuery<TReadModel> request, IQueryable<TEntity> query, CancellationToken cancellationToken)
75	{
76	return await query	4✔
77	.CountAsync(cancellationToken)	4✔
78	.ConfigureAwait(false);	4✔
79	}	4✔
80
81	protected virtual async Task<IReadOnlyCollection<TReadModel>> QueryPaged(EntityPagedQuery<TReadModel> request, IQueryable<TEntity> query, CancellationToken cancellationToken)
82	{
83	var entityQuery = request.Query;	4✔
84
85	var queryable = query	4✔
86	.Sort(entityQuery.Sort);	4✔
87
88	if (entityQuery.Page > 0 && entityQuery.PageSize > 0)	4✔
89	queryable = queryable.Page(entityQuery.Page, entityQuery.PageSize);	4✔
90
91	return await queryable	4✔
92	.ProjectTo<TReadModel>(Mapper.ConfigurationProvider)	4✔
93	.ToListAsync(cancellationToken)	4✔
94	.ConfigureAwait(false);	4✔
95	}	4✔
96	}

loresoft / MediatR.CommandQuery / 8911801772

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous