동적쿼리 오류

Question

package com.study.studyproject.member.repository; import com.querydsl.core.types.OrderSpecifier; import com.querydsl.core.types.dsl.BooleanExpression; import com.querydsl.jpa.JPAExpressions; import com.querydsl.jpa.impl.JPAQuery; import com.querydsl.jpa.impl.JPAQueryFactory; import com.study.studyproject.entity.QPostLike; import com.study.studyproject.list.dto.ListResponseDto; import com.study.studyproject.entity.Board; import com.study.studyproject.entity.Category; import com.study.studyproject.entity.Recruit; import com.study.studyproject.list.dto.QListResponseDto; import com.study.studyproject.member.dto.MemberListRequestDto; import jakarta.persistence.EntityManager; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.support.PageableExecutionUtils; import org.springframework.stereotype.Repository; import java.util.List; import static com.study.studyproject.entity.QBoard.board; import static com.study.studyproject.entity.QPostLike.postLike; import static com.study.studyproject.entity.QReply.reply; import static org.springframework.util.StringUtils.isEmpty; @Repository public class MyPagePostLikeQueryRepository{ private final JPAQueryFactory queryFactory; public MyPagePostLikeQueryRepository(EntityManager em) { this.queryFactory = new JPAQueryFactory(em); } public Page MyPageListPage(MemberListRequestDto condition, Pageable pageable, Long memeberId) { List content = getContent(memeberId,condition, pageable); JPAQuery countQuery = getTotal(memeberId,condition); return PageableExecutionUtils.getPage(content,pageable, countQuery::fetchCount); } public List getContent(Long memeberId, MemberListRequestDto condition, Pageable pageable) { return queryFactory .select( new QListResponseDto( board.nickname, board.id.intValue(), board.recruit.stringValue(), board.category.stringValue(), board.content, board.title, board.createdDate, board.viewCount.intValue(), JPAExpressions .select(reply.count()) .from(reply) .where(reply.isDeleted.eq(false) .and(reply.board.id.eq(board.id))) )) .from(board) .innerJoin(board.postLikes).fetchJoin() .where( getType(condition.getRecruit()), //모집여부 getPostLikeMember(memeberId), //사용자 아이디 유무 getCategory(condition.getCategory()), board.isDeleted.eq(false) ) .orderBy( getOrder(condition.getOrder()) // 순서 ) .groupBy(board) .offset(pageable.getOffset()) .limit(pageable.getPageSize()) .fetch(); } //cs private BooleanExpression getCategory(Category category) { if(isEmpty(category)){ return null; } return category.equals(Category.전체) ? null : board.category.eq(category); } public JPAQuery getTotal(Long memeberId, MemberListRequestDto condition) { return queryFactory .select( board ) .from(board) .where( getType(condition.getRecruit()), //모집여부 getPostLikeMember(memeberId), //사용자 이메일 getCategory(condition.getCategory()), board.isDeleted.eq(false) ); } private BooleanExpression getType(Recruit type) { return isEmpty(type) ? null : board.recruit.eq(type); } private BooleanExpression getPostLikeMember(Long userId) { System.out.println("userId = " + userId); return isEmpty(userId) ? null : postLike.member.id.eq(userId); } private OrderSpecifier getOrder(int num) { if (num == 0) { System.out.println("0"); return board.createdDate.desc(); } else { System.out.println("1"); return board.viewCount.desc(); } } } e = org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.query.SemanticException: Could not interpret path expression 'postLike.member.id' 이 오류가 뜹니다. select * from post_like pl where member_id =2; 이렇게 해서 해당 post_like를 가져오고 싶은데 어떻게 해야한요?

동적쿼리 오류

0개의 답변

기술 목록