Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[REFACTOR] 영화목록 api 쿼리 수정 #110

Open
Jake1152 opened this issue Aug 21, 2024 · 0 comments
Open

[REFACTOR] 영화목록 api 쿼리 수정 #110

Jake1152 opened this issue Aug 21, 2024 · 0 comments
Assignees
Labels

Comments

@Jake1152
Copy link
Member

어떤 작업인가요?

영화별로 up, down 갯수를 가져올 때 COUNT, GROUP BY를 이용해서 가져오기

변경 전의 상황

'인사이드 아웃 2' 영화라면 up, down 갯수만큼 검색 결과에 나오고 있으며 Nest코드에서 up, down 갯수를 세고 있는 상황
image

변경 후의 예상하는 구조

SQL 쿼리에서 COUNT, GROUP BY 이용하여 갯수를 미리 세서 오게 함

@Jake1152 Jake1152 self-assigned this Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant