name: "✅ Feature"
about: Feature 요구 사항을 입력해주세요.
title: "✅ Feature"
labels: ✅ Feature
assignees: ''
History
🚀 Major Changes & Explanations
로그인 한 사람의 경우 그 사람의 취향을 조회한다
선호도 추천 테이블에서 조회한 취향으로 필터링
필터링 후 커서기반 페이지네이션을 적용
조회 쿼리
Hibernate:
select
p1_0.id,
p1_0.preference_type
from
preference p1_0
join
member_preference mp1_0
on p1_0.id=mp1_0.preference_id
where
mp1_0.member_id=?
Hibernate:
select
distinct b1_0.id
from
product p1_0
join
product_board b1_0
on p1_0.product_board_id=b1_0.id
join
board_preference_statistic bps1_0
on bps1_0.board_id=b1_0.id
where
b1_0.is_deleted=?
and bps1_0.preference_type=?
order by
bps1_0.preference_score desc
limit
?
Hibernate:
select
b1_0.id,
s1_0.id,
s1_0.name,
b1_0.profile,
b1_0.title,
b1_0.price,
p1_0.category,
p1_0.gluten_free_tag,
p1_0.high_protein_tag,
p1_0.sugar_free_tag,
p1_0.vegan_tag,
p1_0.ketogenic_tag,
bs1_0.board_review_grade,
bs1_0.board_review_count,
p1_0.order_end_date,
p1_0.is_soldout,
b1_0.discount_rate
from
product p1_0
join
product_board b1_0
on p1_0.product_board_id=b1_0.id
join
store s1_0
on b1_0.store_id=s1_0.id
join
board_statistic bs1_0
on bs1_0.board_id=b1_0.id
join
board_preference_statistic bps1_0
on b1_0.id=bps1_0.board_id
where
b1_0.id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
and bps1_0.preference_type=?
order by
bps1_0.preference_score desc
📷 Test Image
💡 ETC
조회 시 member 취향 타입이 등록되고 그것이 쿼리에 반영되어야 하기 때문에 기존에 cursorId와 필터 조건만 받아오던 QueryProvider, CursorGenerator와 호환이 되지 않아 상속이 아닌 별도의 클래스를 만들어 작성
name: "✅ Feature" about: Feature 요구 사항을 입력해주세요. title: "✅ Feature" labels: ✅ Feature assignees: ''
History
🚀 Major Changes & Explanations
조회 쿼리
📷 Test Image
💡 ETC