Clean Architecture Demo
Toggle main menu visibility
Loading...
Searching...
No Matches
TaskReadRepository.cs
Go to the documentation of this file.
1
// TaskManagement.Infrastructure/Persistence/Repositories/TaskReadRepository.cs
2
using
System.Data.Common;
3
using
Dapper;
4
using
TaskManagement.Application.Common
;
5
using
TaskManagement.Application.Ports
;
6
using
TaskManagement.Application.Queries
;
7
using
TaskManagement.Application.Queries.SearchTasks
;
8
9
namespace
TaskManagement.Infrastructure.Persistence.Repositories
;
10
11
#pragma warning disable CS1570
// XML comment has badly formed XML
57
#pragma warning restore CS1570
// XML comment has badly formed XML
58
public
sealed
class
TaskReadRepository
:
ITaskReadRepository
59
{
60
private
readonly Func<DbConnection> _createConnection;
61
66
public
TaskReadRepository
(Func<DbConnection> createConnection)
67
{
68
_createConnection = createConnection;
69
}
70
71
public
async Task<TaskDto?>
GetByIdAsync
(
72
Guid
id
,
73
CancellationToken cancellationToken =
default
)
74
{
75
const
string
sql =
@"
76
SELECT
77
t.Id,
78
t.Title,
79
t.Description,
80
t.Status,
81
t.Priority,
82
t.DueDate,
83
t.CreatedAt,
84
t.CreatedBy as CreatedBy,
85
t.AssignedTo as AssignedTo
86
FROM Tasks t
87
WHERE t.Id = @Id"
;
88
89
using
var connection = _createConnection();
90
var command =
new
CommandDefinition(
91
sql,
92
new
{
93
Id =
id
94
},
95
cancellationToken: cancellationToken);
96
97
return
await connection.QueryFirstOrDefaultAsync<
TaskDto
>(command).ConfigureAwait(
false
);
98
}
99
100
public
async Task<PagedResult<TaskDto>>
SearchAsync
(
101
TaskSearchRequest
request,
102
CancellationToken cancellationToken =
default
)
103
{
104
ArgumentNullException.ThrowIfNull(request);
105
106
const
string
selectSql =
@"
107
SELECT
108
t.Id, t.Title, t.Description, t.Status, t.Priority,
109
t.DueDate, t.CreatedAt, t.CreatedBy as CreatedBy,
110
t.AssignedTo as AssignedTo
111
FROM Tasks t"
;
112
const
string
countSql =
"SELECT COUNT(*) FROM Tasks t"
;
113
var whereClause = BuildWhereClause(request);
114
var orderClause = $
"ORDER BY {request.SortBy} {request.SortDirection}"
;
115
var pagedSql = $
"{selectSql} {whereClause} {orderClause} LIMIT @PageSize OFFSET @Offset"
;
116
var parameters =
new
DynamicParameters(request);
117
parameters.Add(
"Offset"
, (request.Page - 1) * request.PageSize);
118
119
using
var connection = _createConnection();
120
var command =
new
CommandDefinition(
121
$
"{pagedSql}; {countSql} {whereClause}"
,
122
parameters,
123
cancellationToken: cancellationToken);
124
125
var multi = await connection.QueryMultipleAsync(command).ConfigureAwait(
false
);
126
var items = (await multi.ReadAsync<
TaskDto
>().ConfigureAwait(
false
)).ToList();
127
var totalCount = await multi.ReadSingleAsync<
int
>().ConfigureAwait(
false
);
128
return
new
PagedResult<TaskDto>(items, totalCount, request.Page, request.PageSize);
129
}
130
131
private
static
string
BuildWhereClause(
TaskSearchRequest
request)
132
{
133
var filters =
new
List<string>();
134
135
if
(!
string
.IsNullOrWhiteSpace(request.Title))
136
{
137
filters.Add(
"t.Title LIKE '%' || @Title || '%'"
);
138
}
139
140
if
(!
string
.IsNullOrWhiteSpace(request.Status))
141
{
142
filters.Add(
"t.Status = @Status"
);
143
}
144
145
if
(!
string
.IsNullOrWhiteSpace(request.Priority))
146
{
147
filters.Add(
"t.Priority = @Priority"
);
148
}
149
150
if
(request.AssignedTo.HasValue)
151
{
152
filters.Add(
"t.AssignedTo = @AssignedTo"
);
153
}
154
155
return
filters.Count == 0 ? string.Empty : $
"WHERE {string.Join("
AND
", filters)}"
;
156
}
157
}
TaskManagement.Application.Queries.TaskDto
TaskDto es el DTO de salida del caso de uso de consultar una tarea.
Definition
TaskDto.cs:11
TaskManagement.Infrastructure.Persistence.Repositories.TaskReadRepository.TaskReadRepository
TaskReadRepository(Func< DbConnection > createConnection)
Definition
TaskReadRepository.cs:66
TaskManagement.Infrastructure.Persistence.Repositories.TaskReadRepository.SearchAsync
async Task< PagedResult< TaskDto > > SearchAsync(TaskSearchRequest request, CancellationToken cancellationToken=default)
Definition
TaskReadRepository.cs:100
TaskManagement.Infrastructure.Persistence.Repositories.TaskReadRepository.GetByIdAsync
async Task< TaskDto?> GetByIdAsync(Guid id, CancellationToken cancellationToken=default)
Definition
TaskReadRepository.cs:71
TaskManagement.Application.Ports.ITaskReadRepository
ITaskReadRepository es la abstracción para consultas de sólo lectura de tareas.
Definition
ITaskReadRepository.cs:43
TaskManagement.Application.Common
Definition
PagedResult.cs:1
TaskManagement.Application.Ports
Definition
IDomainEventDispatcher.cs:3
TaskManagement.Application.Queries.SearchTasks
Definition
TaskSearchRequest.cs:1
TaskManagement.Application.Queries.SearchTasks.TaskSearchRequest
record TaskSearchRequest(string? Title=null, string? Status=null, string? Priority=null, Guid? AssignedTo=null, int Page=1, int PageSize=20, string SortBy="CreatedAt", string SortDirection="DESC")
TaskSearchRequest es el DTO de entrada para operaciones avanzadas de búsqueda de tareas.
TaskManagement.Application.Queries
Definition
GetTaskByIdInput.cs:1
TaskManagement.Infrastructure.Persistence.Repositories
Definition
TaskReadRepository.cs:9
src
TaskManagement.Infrastructure
Persistence
Repositories
TaskReadRepository.cs
Generated by
1.18.0