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

안녕하세요 영한님

잘보고있습니다. 감사합니다

 

질문이 하나 있습니다.

 

    public List<MemberTeamDto> searchByBuilder(MemberSearchCondition condition){

 

        BooleanBuilder builder = new BooleanBuilder();

        if(StringUtils.hasText(condition.getUsername())){

            builder.and(member.username.eq(condition.getUsername()));

        }

        if(StringUtils.hasText(condition.getTeamName())){

            builder.and(team.name.eq(condition.getTeamName()));

        }

        if(condition.getAgeGoe() != null){

           builder.and(member.age.goe(condition.getAgeGoe()));

        }

        if(condition.getAgeLoe() != null){

            builder.and(member.age.loe(condition.getAgeLoe()));

        }

 

       return queryFactory

               .select(new QMemberTeamDto(

                       member.id.as("memberId"),

                       member.username,

                       member.age,

                       team.id.as("teamId"),

                       team.name.as("teamName")

               ))

               .from(member)

               .leftJoin(member.team, team)

               .where(builder)

               .fetch();

    }

//페치조인 미 적용

 

테스트를 해보면

 @Test

    public void searchTest(){

        Team teamA = new Team("teamA");

        Team teamB = new Team("teamB");

        em.persist(teamA);

        em.persist(teamB);

 

        Member member1 = new Member("member1", 10, teamA);

        Member member2 = new Member("member2", 20, teamA);

 

        Member member3 = new Member("member3", 30, teamB);

        Member member4 = new Member("member4" ,40, teamB);

 

        em.persist(member1);

        em.persist(member2);

        em.persist(member3);

        em.persist(member4);

 

        MemberSearchCondition condition = new MemberSearchCondition();

        condition.setAgeGoe(35);

        condition.setAgeLoe(40);

        condition.setTeamName("teamB");

 

        List<MemberTeamDto> result = memberJpaRepository.searchByBuilder(condition);

 

        assertThat(result).extracting("username").containsExactly("member4");

    }

 

N+1 같은 현상이 일어나지 않습니다.

페치 조인을 사용하지 않았는데

이유가 있을까요 ?