Project Lab 5. 게시판 개발(QueryDsl, 조회수 개발) - 2

<module-domain-core/kr/ac/univ/common/config/QueryDslConfig>

package kr.ac.univ.common.config;

import com.querydsl.jpa.impl.JPAQueryFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

@Configuration
public class QueryDslConfig {
   @PersistenceContext
   private EntityManager entityManager;

   @Bean
   public JPAQueryFactory jpaQueryFactory() {
       return new JPAQueryFactory(entityManager);
   }
}

<module-domain-core/kr/ac/univ/noticeBoard/repository/NoticeBoardRepositoryImpl>

package kr.ac.univ.noticeBoard.repository;

import com.querydsl.jpa.impl.JPAQueryFactory;
import kr.ac.univ.noticeBoard.domain.NoticeBoard;
import kr.ac.univ.noticeBoard.domain.QNoticeBoard;
import org.springframework.data.jpa.repository.support.QuerydslRepositorySupport;
import org.springframework.stereotype.Repository;

import javax.transaction.Transactional;
import java.util.List;

import static kr.ac.univ.event.domain.QNoticeBoard.noticeBoard;

@Repository
@Transactional
public class NoticeBoardRepositoryImpl extends QuerydslRepositorySupport {
   private final JPAQueryFactory queryFactory;

   public NoticeBoardRepositoryImpl(JPAQueryFactory queryFactory ) {
       super(NoticeBoard.class);
       this.queryFactory = queryFactory;
   }

   public List<NoticeBoard> findByTitle(String title) {
       /*
        * SELECT *
        *   FROM notice_board
        *  WHERE title = 'title'
        */
       return queryFactory
               .selectFrom(noticeBoard)
               .where(noticeBoard.title.eq(title))
               .fetch();
   }

   public long updateViewCountById(Long idx) {
       /*
        * UPDATE notice_board
        *    SET view_count = view_count + 1
        *  WHERE id = 'id';
        */
       return queryFactory
               .update(noticeBoard)
               .set(noticeBoard.viewCount, noticeBoard.viewCount.add(1))
               .where(noticeBoard.idx.eq(idx))
               .execute();
   }

}

<module-app-web/src/test/java/kr/ac/univ/QueryDslTest>

package kr.ac.univ;

import kr.ac.univ.common.domain.enums.ActiveStatus;
import kr.ac.univ.noticeBoard.domain.NoticeBoard;
import kr.ac.univ.noticeBoard.repository.NoticeBoardRepository;
import kr.ac.univ.noticeBoard.repository.NoticeBoardRepositoryImpl;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.DisplayName;
import org.junit.jupiter.api.Test;
import org.junit.jupiter.api.extension.ExtendWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit.jupiter.SpringExtension;

import java.util.List;
import java.util.Optional;
import java.util.stream.IntStream;

import static org.junit.jupiter.api.Assertions.assertEquals;

@Slf4j
@SpringBootTest
@EnableAutoConfiguration
@ExtendWith(SpringExtension.class)
public class QueryDslTest {
   @Autowired
   NoticeBoardRepository noticeBoardRepository;

   @Autowired
   NoticeBoardRepositoryImpl noticeBoardRepositoryImpl;

   @BeforeEach
   public void init() {
       IntStream.rangeClosed(1, 200)
               .forEach(index -> noticeBoardRepository.save(NoticeBoard.builder()
                       .title("게시글" + index)
                       .content("컨텐츠")
                       .viewCount(0L)
                       .activeStatus(ActiveStatus.ACTIVE)
                       .build()));
   }

   @Test
   @DisplayName("QueryDsl로 구현한 findByTitle 테스트")
   public void Test() {
       List<NoticeBoard> list = noticeBoardRepositoryImpl.findByTitle("게시글10");

       for (NoticeBoard noticeboard : list) {
           assertEquals(noticeboard.getTitle(), "게시글10");
       }
   }

   @Test
   @DisplayName("QueryDsl로 구현한 updateViewCountByIdx 테스트")
   public void Test2() {
       // update된 column 개수 반환
       Long cnt = noticeBoardRepositoryImpl.updateViewCountById(1L);
       assertEquals(cnt, 1);
   }

   @Test
   @DisplayName("JPA findById를 사용한 viewCount 테스트")
   public void Test3() {
       Optional<NoticeBoard> optionalNoticeBoard = noticeBoardRepository.findById(1L);
       NoticeBoard noticeBoard = null;

       if (optionalNoticeBoard.isPresent()) {
           noticeBoard = optionalNoticeBoard.get();
       }

       // idx 1인 column을 조회한다.
       assertEquals(noticeBoard.getIdx(), 1L);
       assertEquals(noticeBoard.getViewCount(), 1L);
   }
}

<module-domain-core/src/main/java/kr/ac/univ/noticeBoard/service/NoticeBoardService>

@Service
public class NoticeBoardService {
    private final NoticeBoardRepository noticeBoardRepository;
    private final NoticeBoardRepositoryImpl noticeBoardRepositoryImpl;

    public NoticeBoardService(NoticeBoardRepository noticeBoardRepository, NoticeBoardRepositoryImpl noticeBoardRepositoryImpl) {
        this.noticeBoardRepository = noticeBoardRepository;
        this.noticeBoardRepositoryImpl = noticeBoardRepositoryImpl;
    }

    ...

    public NoticeBoardDto findNoticeBoardByIdx(Long idx) {
        noticeBoardRepositoryImpl.updateViewCountById(idx);

        return NoticeBoardMapper.INSTANCE.toDto(noticeBoardRepository.findById(idx).orElse(new NoticeBoard()));
    }

    ...