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

feat: Meeting 테이블에 인덱스 붙이기 #581

Open
eun-byeol opened this issue Sep 25, 2024 · 0 comments
Open

feat: Meeting 테이블에 인덱스 붙이기 #581

eun-byeol opened this issue Sep 25, 2024 · 0 comments
Assignees

Comments

@eun-byeol
Copy link
Contributor

📝 작업 내용

쿼리 성능 개선

@Query("""
      select meeting
      from Meeting meeting
      right join Mate mate on meeting.id = mate.meeting.id
      where mate.member.id = :memberId
      and meeting.overdue = false
      """
)
List<Meeting> findAllByMemberId(Long memberId);

@Modifying(clearAutomatically = true)
@Query("update Meeting m set m.overdue = true where m.overdue = false and m.date < CURRENT_DATE")
void updateAllByNotOverdueMeetings();

Optional<Meeting> findByIdAndOverdueFalse(Long id);

Optional<Meeting> findByInviteCode(String inviteCode);

boolean existsByInviteCode(String inviteCode);
@eun-byeol eun-byeol added this to the 5차 스프린트 milestone Sep 25, 2024
@eun-byeol eun-byeol self-assigned this Sep 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: No status
Development

No branches or pull requests

1 participant