< Summary - Syki

Information

Class:	Syki.Back.Features.Cross.GetUserAccount.GetUserAccountService
Assembly:	Back
File(s):	/home/runner/work/syki/syki/Back/Features/Cross/GetUserAccount/GetUserAccountService.cs
Tag:	36_19195353031

Line coverage

85%

Branch coverage

75%

Method coverage

Feature is only available for sponsors

Metrics

Method	Branch coverage	Crap Score	Cyclomatic complexity	Line coverage
.ctor(...)	100%	1	1	100%
Get()	75%	4	4	83.33%

#	Line	Line coverage
	`1`	`using Dapper;`
	`2`	`using Npgsql;`
	`3`
	`4`	`namespace Syki.Back.Features.Cross.GetUserAccount;`
	`5`
2	`6`	`public class GetUserAccountService(NpgsqlDataSource dataSource) : ICrossService`
	`7`	`{`
	`8`	`public async Task<GetUserAccountOut> Get(Guid userId)`
	`9`	`{`
2	`10`	`await using var connection = await dataSource.OpenConnectionAsync();`
	`11`
	`12`	`const string sql = @"`
	`13`	`SELECT`
	`14`	`u.id,`
	`15`	`u.name,`
	`16`	`u.email,`
	`17`	`u.profile_photo,`
	`18`	`r.name AS role,`
	`19`	`i.name AS institution`
	`20`	`FROM`
	`21`	`syki.users u`
	`22`	`INNER JOIN`
	`23`	`syki.user_roles ur ON ur.user_id = u.id`
	`24`	`INNER JOIN`
	`25`	`syki.roles r ON r.id = ur.role_id`
	`26`	`INNER JOIN`
	`27`	`syki.institutions i ON i.id = u.institution_id`
	`28`	`WHERE`
	`29`	`u.id = @UserId`
	`30`	`LIMIT 1`
	`31`	`";`
	`32`
2	`33`	`var data = await connection.QueryFirstAsync<GetUserAccountOut>(sql, new { userId });`
	`34`
2	`35`	`if (data.Role == UserRole.Student)`
	`36`	`{`
	`37`	`const string studentSql = @"`
	`38`	`SELECT name FROM syki.courses WHERE id =`
	`39`	`(`
	`40`	`SELECT course_id`
	`41`	`FROM syki.course_offerings co`
	`42`	`INNER JOIN syki.students s ON s.course_offering_id = co.id`
	`43`	`WHERE s.id = @UserId`
	`44`	`)`
	`45`	`";`
0	`46`	`data.Course = await connection.QueryFirstAsync<string?>(studentSql, new { userId });`
	`47`	`}`
	`48`
2	`49`	`return data;`
2	`50`	`}`
	`51`	`}`