< Summary - Syki

Information

Class:	Syki.Back.Features.Academic.GetTeachers.GetTeachersService
Assembly:	Back
File(s):	/home/runner/work/syki/syki/Back/Features/Academic/GetTeachers/GetTeachersService.cs
Tag:	4_16869239191

Line coverage

100%

Branch coverage

N/A

Method coverage

Feature is only available for sponsors

Metrics

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

#	Line	Line coverage
	`1`	`namespace Syki.Back.Features.Academic.GetTeachers;`
	`2`
2	`3`	`public class GetTeachersService(SykiDbContext ctx) : IAcademicService`
	`4`	`{`
	`5`	`public async Task<List<TeacherOut>> Get(Guid institutionId)`
	`6`	`{`
2	`7`	`FormattableString sql = $@"`
2	`8`	`SELECT`
2	`9`	`t.id,`
2	`10`	`t.name,`
2	`11`	`u.email,`
2	`12`	`COUNT(td.syki_teacher_id) AS disciplines`
2	`13`	`FROM`
2	`14`	`syki.teachers t`
2	`15`	`INNER JOIN`
2	`16`	`syki.users u ON u.id = t.id`
2	`17`	`LEFT JOIN`
2	`18`	`syki.teachers__disciplines td ON td.syki_teacher_id = t.id`
2	`19`	`WHERE`
2	`20`	`u.institution_id = {institutionId}`
2	`21`	`GROUP BY`
2	`22`	`t.id,`
2	`23`	`t.name,`
2	`24`	`u.email`
2	`25`	`ORDER BY`
2	`26`	`t.name`
2	`27`	`";`
	`28`
2	`29`	`return await ctx.Database.SqlQuery<TeacherOut>(sql).ToListAsync();`
2	`30`	`}`
	`31`	`}`