ZinnaChoi / Study-Management

온라인 스터디 관리 시스템: 부재 일정 캘린더, 토론 게시판 및 알림 기능 제공
8 stars 0 forks source link

[Fix Request] 스터디 Test 수정 요청 #80

Closed ZinnaChoi closed 7 months ago

ZinnaChoi commented 7 months ago

안녕하세요 @MeMyself-And-I 다름이 아니라 main 브랜치에서 controller 테스트를 돌리면 다음과 같이 3개의 Test에서 에러가 발생합니다

원인 파악 후 수정 부탁드립니다 감사합니다!!

image

org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2
 at org.springframework.dao.support.DataAccessUtils.nullableSingleResult([DataAccessUtils.java:193](vscode-file://vscode-app/c:/Users/yeahee/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/code/electron-sandbox/workbench/workbench.html))
 at org.springframework.jdbc.core.JdbcTemplate.queryForObject([JdbcTemplate.java:520](vscode-file://vscode-app/c:/Users/yeahee/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/code/electron-sandbox/workbench/workbench.html))
 at org.springframework.jdbc.core.JdbcTemplate.queryForObject([JdbcTemplate.java:526](vscode-file://vscode-app/c:/Users/yeahee/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/code/electron-sandbox/workbench/workbench.html))
 at mogakco.StudyManagement.controller.StudyControllerTest.getStudyName([StudyControllerTest.java:252](vscode-file://vscode-app/c:/Users/yeahee/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/code/electron-sandbox/workbench/workbench.html))
 at mogakco.StudyManagement.controller.StudyControllerTest.createStudyInfoUpdate_Success([StudyControllerTest.java:174](vscode-file://vscode-app/c:/Users/yeahee/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/code/electron-sandbox/workbench/workbench.html))
 at java.base/java.util.ArrayList.forEach([ArrayList.java:1511](vscode-file://vscode-app/c:/Users/yeahee/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/code/electron-sandbox/workbench/workbench.html))
 at java.base/java.util.ArrayList.forEach([ArrayList.java:1511](vscode-file://vscode-app/c:/Users/yeahee/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/code/electron-sandbox/workbench/workbench.html))
MeMyself-And-I commented 7 months ago

해당 이슈는 jdbcTemplate을 통해 스터디 정보를 가져 올 때 두 개 이상의 study_info row가 있을 경우 발생했습니다. 테스트 코드이기 때문에 쿼리에 LIMIT 1을 사용하여 한 개만 가져올 수 있도록 변경하였습니다.

https://github.com/ZinnaChoi/Study-Management/pull/78/commits/5f707cb60357c2699868636b03d18c6c49091239

ZinnaChoi commented 7 months ago

이슈 해결 확인되어 close 하도록 하겠습니다~