인프런 커뮤니티 질문&답변

주문 조회 V4: JPA에서 DTO 직접 조회 강의에서

OrderQueryRepository를 스프링데이터JPA를 이용해 변경하려하는데 잘 되지않아서 질문하게 되었습니다.

(변수명이 바뀐 것은 제가 강의를 보면서 좀 수정해가며 작성하였습니다.)

package jaein.crudpractice.repository.order.query;

import jaein.crudpractice.domain.Order;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface OrderQueryRepository extends JpaRepository<Order, Long> {


//    @Query("select o from Order o" +
//            " join fetch o.student s" +
//            " join fetch o.loan l")
//    List<OrderQueryDto> findOrderQueryDtos();

//    @Query("select o.id as orderId, s.name as name, o.loanDate, o.returnDate, o.status, " +
//            "oi.id as itemId, i.name as itemName " +
//            "from Order o " +
//            "join o.student s " +
//            "join o.loan l " +
//            "join OrderItem oi on oi.order.id = o.id " +
//            "join oi.item i")
//    List<OrderQueryDto> findOrderQueryDtos(Pageable pageable);

    @Query("select o.id, s.name, o.loanDate, o.returnDate, o.status " +
            "from Order o " +
            "join fetch o.student s " +
            "join fetch o.loan l " +
            "join fetch OrderItem oi on oi.order.id = o.id")
    List<OrderQueryDto> findOrderQueryDtos(Pageable pageable);


//    @Query("select oi.order.id, i.name, oi.orderPrice, oi.count " +
//            "from OrderItem oi join oi.item i where oi.order.id = :orderId")
//    List<OrderItemQueryDto> findOrderItems(Long orderId);

    @Query("select oi from OrderItem oi" +
            " join oi.item i where oi.order.id = :orderId")
    List<OrderItemQueryDto> findOrderItems(@Param("orderId") Long orderId);


}

package jaein.crudpractice.repository.order.query;

import jaein.crudpractice.domain.OrderStatus;
import lombok.Data;

import java.util.Date;
import java.util.List;

@Data
public class OrderQueryDto {

    private Long orderId;
    private String name;
    private Date loanDate;
    private Date returnDate;
    private OrderStatus status;
    private List<OrderItemQueryDto> orderItems;

    public OrderQueryDto(Long orderId, String name, Date loanDate,
                         Date returnDate, OrderStatus status, List<OrderItemQueryDto> orderItems) {
        this.orderId = orderId;
        this.name = name;
        this.loanDate = loanDate;
        this.returnDate = returnDate;
        this.status = status;
        this.orderItems = orderItems;
    }
}

package jaein.crudpractice.repository.order.query;

import lombok.Data;

@Data
public class OrderItemQueryDto {

    private Long orderId;
    private String itemName;
    private int count;

    public OrderItemQueryDto(Long orderId, String itemName, int count) {
        this.orderId = orderId;
        this.itemName = itemName;
        this.count = count;
    }
}