< Summary - Syki

Information

Class:	Syki.Back.Features.Academic.GetCampusStudents.GetCampusStudentsService
Assembly:	Back
File(s):	/home/runner/work/syki/syki/Back/Features/Academic/GetCampusStudents/GetCampusStudentsService.cs
Tag:	21_17346963026

Line coverage

Branch coverage

N/A

Method coverage

Feature is only available for sponsors

Metrics

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

#	Line	Line coverage
	`1`	`namespace Syki.Back.Features.Academic.GetCampusStudents;`
	`2`
0	`3`	`public class GetCampusStudentsService(SykiDbContext ctx) : IAcademicService`
	`4`	`{`
	`5`	`public async Task<List<GetCampusStudentsOut>> Get(Guid campusId)`
	`6`	`{`
0	`7`	`FormattableString sql = $@"`
0	`8`	`SELECT`
0	`9`	`s.id,`
0	`10`	`s.name,`
0	`11`	`s.course_offering_id`
0	`12`	`FROM`
0	`13`	`syki.students s`
0	`14`	`INNER JOIN`
0	`15`	`syki.course_offerings co ON co.id = s.course_offering_id`
0	`16`	`WHERE`
0	`17`	`s.institution_id = {ctx.InstitutionId}`
0	`18`	`AND`
0	`19`	`co.campus_id = {campusId}`
0	`20`	`GROUP BY`
0	`21`	`s.id, s.name`
0	`22`	`ORDER BY`
0	`23`	`s.name`
0	`24`	`";`
	`25`
0	`26`	`return await ctx.Database.SqlQuery<GetCampusStudentsOut>(sql).ToListAsync();`
0	`27`	`}`
	`28`	`}`