wafflestudio / wafflestudio/snuclear-server
groupReactionTimeByCourseNumber: 분반별 제한 조건이 반영되지 않음
Nobody has claimed this yet.
- Dominant language
- Kotlin
- Stars
- 3
- Forks
- 2
- PR merge metrics
- No merged PRs in 30d
Description
문제
groupReactionTimeByCourseNumber 쿼리는 같은 course_number를 가진 모든 분반(section)을 하나로 묶어 통계를 집계합니다.
이 때문에 분반별로 다른 수강 제한 조건(예: "수리과학부 분반만 가능", "주전공 불허")이 통계에 반영되지 않습니다. 실제로는 특정 학생이 신청할 수 없는 분반의 데이터도 합산되어 평균 반응 시간이 왜곡될 수 있습니다.
현재 동작
GROUP BY c.course_number로 모든 분반을 단일 그룹으로 처리
분반별 credit_limit, department_restriction 등의 조건 무시
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Locate the groupReactionTimeByCourseNumber query and inspect its GROUP BY c.course_number logic together with the section fields credit_limit and department_restriction. Trace how student eligibility is represented before deciding how restricted sections should affect aggregation. Done means statistics exclude data from sections the relevant student cannot apply for, with behavior verified against representative restricted and unrestricted sections.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- kotlin
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100