< Summary - Syki

Information

Class:	Syki.Back.Features.Adm.GetDomainEvents.GetDomainEventsService
Assembly:	Back
File(s):	/home/runner/work/syki/syki/Back/Features/Adm/GetDomainEvents/GetDomainEventsService.cs
Tag:	4_16869239191

Line coverage

Branch coverage

Method coverage

Feature is only available for sponsors

Metrics

Method	Branch coverage	Crap Score	Cyclomatic complexity	Line coverage
.ctor(...)	100%	2	1	0%
Get()	0%	42	6	0%

#	Line	Line coverage
	`1`	`using Dapper;`
	`2`	`using Npgsql;`
	`3`
	`4`	`namespace Syki.Back.Features.Adm.GetDomainEvents;`
	`5`
0	`6`	`public class GetDomainEventsService(NpgsqlDataSource dataSource) : IAdmService`
	`7`	`{`
	`8`	`public async Task<List<DomainEventTableOut>> Get(DomainEventTableFilterIn filters)`
	`9`	`{`
0	`10`	`await using var connection = await dataSource.OpenConnectionAsync();`
	`11`
	`12`	`const string sql = @"`
	`13`	`SELECT`
	`14`	`e.id,`
	`15`	`e.type,`
	`16`	`e.status,`
	`17`	`e.occurred_at,`
	`18`	`e.processed_at,`
	`19`	`ARRAY_AGG(t.status ORDER BY t.created_at) AS commands`
	`20`	`FROM`
	`21`	`syki.domain_events e`
	`22`	`LEFT JOIN`
	`23`	`syki.commands t ON t.event_id = e.id`
	`24`	`WHERE`
	`25`	`(@Type IS NULL OR e.type = @Type)`
	`26`	`AND`
	`27`	`(@Status IS NULL OR e.status = @Status)`
	`28`	`AND`
	`29`	`(@InstitutionId IS NULL OR e.institution_id = @InstitutionId)`
	`30`	`GROUP BY`
	`31`	`e.id`
	`32`	`ORDER BY`
	`33`	`e.occurred_at DESC`
	`34`	`";`
	`35`
0	`36`	`var parameters = new`
0	`37`	`{`
0	`38`	`filters.Type,`
0	`39`	`filters.InstitutionId,`
0	`40`	`Status = filters.Status?.ToString(),`
0	`41`	`};`
	`42`
0	`43`	`var events = (await connection.QueryAsync<DomainEventTableOut>(sql, parameters)).ToList();`
	`44`
0	`45`	`if (filters.Commands != null)`
	`46`	`{`
0	`47`	`events = events.Where(x => x.Commands.Contains(filters.Commands.Value)).ToList();`
	`48`	`}`
	`49`
0	`50`	`events.ForEach(x => x.Description = x.Type.ToDomainEventDescription());`
	`51`
0	`52`	`return events;`
0	`53`	`}`
	`54`	`}`