멤버와 팀 정보를 한번에 조회하는 요구사항

검색 조건이 있다.

검색 조건 파라미터를 위한 dto를 따로 만든다.

@Data
public class MemberSearchCondition {
	// 회원명, 팀명, 나이
	private String username;
	private String teamName;
	private Integer ageGoe;
	private Integer ageLoe;
}

repository

public List<MemberTeamDto> searchByBuilder(MemberSearchCondition condition) {
	BooleanBuilder builder = new BooleanBuilder();
	if (hasText(condition.getUsername())) {
		builder.and(member.username.eq(condition.getUsername()));
	}
	if (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

@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");
}

주의

만약 조건이 없는 경우 모든 데이터를 가져온다. 이런 동적 쿼리를 짤 때에는 기본 검색 조건이 있던가 페이징이 들어가 줘야한다. 장사 잘되면 데이터가 너무 많기 때문에 서버가 힘들어한다.