Etc
package com.subject1.images.config;
import com.fasterxml.jackson.annotation.JsonCreator;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.fasterxml.jackson.annotation.JsonProperty;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageImpl;
import org.springframework.data.domain.PageRequest;
import java.util.List;
// PageImpl<T>이 기본 생성자가 없어 만들기 위해 생성.
// 해당 클래스가 없다면 Redis에서 PageImpl<T>를 직렬화하지 못해 오류가 발생한다.
@JsonIgnoreProperties(ignoreUnknown = true, value = {"pageable"})
public class CustomPageImpl<T> extends PageImpl<T> {
@JsonCreator(mode = JsonCreator.Mode.PROPERTIES)
public CustomPageImpl(@JsonProperty("content") List<T> content,
@JsonProperty("number") int number,
@JsonProperty("size") int size,
@JsonProperty("totalElements") long totalElements
) {
super(content, PageRequest.of(number, size), totalElements);
}
public CustomPageImpl(Page<T> page) {
super(page.getContent(), page.getPageable(), page.getTotalElements());
}
}
Controller
// 이미지 목록 조회 API
@GetMapping("/projects/{projectId}/images")
public ResponseEntity<?> getListImg(
@PathVariable Long projectId,
@ModelAttribute SearchParam searchParam,
@PageableDefault(size = 10) Pageable pageable) {
// Offset 방식
CustomPageImpl<Image> offsetPage
= imageService.getListImgListOffset(projectId, searchParam, pageable);
return ResponseEntity.ok(offsetPage);
}
Service
// 이미지 목록 조회(Offset)
@Cacheable(value = "imageListOffset", key = "{#searchParam, #pageable}")
public CustomPageImpl<Image> getListImgListOffset(Long projectId, SearchParam searchParam, Pageable pageable) {
System.out.println("...: DB에서 데이터 조회 중...");
Page<Image> resultPage
= imageRepository.searchListOffset(projectId, searchParam, pageable);
return new CustomPageImpl<>(resultPage);
}
Repository
@Override
public Page<Image> searchListOffset(
Long projectId, SearchParam searchParam, Pageable pageable
) {
String thumbnailStatusName = Optional.ofNullable(searchParam.getThumbnailStatus())
.map(Image.ThumbnailStatus::name)
.orElse(null);
BooleanBuilder builder = basicWhere(
projectId,
searchParam.getTag(),
thumbnailStatusName
);
List<Image> content = queryFactory
.selectFrom(image)
.where(builder)
.orderBy(image.imageId.asc())
.offset(pageable.getOffset())
.limit(pageable.getPageSize())
.fetch();
JPAQuery<Long> countQuery = queryFactory
.select(image.count())
.from(image)
.where(builder);
return PageableExecutionUtils.getPage(content, pageable, countQuery::fetchOne);
}
private BooleanBuilder basicWhere(Long projectId, String tag, String status) {
BooleanBuilder builder = new BooleanBuilder();
builder.and(image.softDelete.isNull()
.or(image.softDelete.eq(Boolean.FALSE)));
if (projectId != null) {
builder.and(image.projectId.eq(projectId));
}
if (StringUtils.isNotBlank(tag)) {
builder.and(image.tag.eq(tag));
}
if (StringUtils.isNotBlank(status)) {
builder.and(image.thumbnailStatus.eq(Image.ThumbnailStatus.valueOf(status)));
}
return builder;
}