Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[sim-mer ->weekly] 검색어로 상품 및 작가 검색 #27

Closed
5 tasks done
sim-mer opened this issue Sep 25, 2024 · 0 comments
Closed
5 tasks done

[sim-mer ->weekly] 검색어로 상품 및 작가 검색 #27

sim-mer opened this issue Sep 25, 2024 · 0 comments
Assignees
@sim-mer
Labels
✨ Feature 기능 개발

Comments

@sim-mer
Copy link
Contributor

sim-mer commented Sep 25, 2024 •
edited
Loading

Issue

✨ 기능 리스트

  • 상품 더미 데이터 삽입
  • 작가 더미 데이터 삽입
  • n-gram parser 기반 full text index 설정
  • 상품 검색 API 구현
  • 작가 검색 API 구현

✏ 사용 이유

  • SQL에서 와일드카드를 검색단어 앞에 붙일 경우 Full Table Scan을 하므로 데이터의 양이 많을 경우 적합하지 않음
  • Elastic Search같은 전문 검색 엔진을 도입하기엔 배경 지식이 부족하고 오버 스펙인거 같아 MySQL의 Full Text Index 사용
  • built-in parser는 토큰이 검색어와 전방 일치해야만 검색이 되기 때문에 n-gram parser 사용
@sim-mer sim-mer added the ✨ Feature 기능 개발 label Sep 25, 2024
@sim-mer sim-mer self-assigned this Sep 25, 2024
sim-mer added a commit that referenced this issue Oct 2, 2024
@sim-mer
#27 add: JpaAuditing을 이용한 BaseTimeEntity 작성
e36a9c6
sim-mer added a commit that referenced this issue Oct 2, 2024
@sim-mer
#27 fix, add: ArtistInfo Id Generator 수정, name column 추가
05c5906
sim-mer added a commit that referenced this issue Oct 2, 2024
@sim-mer
#27 add: Product BaseTimeEntity 상속, ArtistInfo JoinColumn 명시
3a3751b
sim-mer added a commit that referenced this issue Oct 2, 2024
@sim-mer
#27 feat(persistence): 상품 검색 기능 작성(imageUrl 추가 예정)
2c9e499
sim-mer added a commit that referenced this issue Oct 2, 2024
@sim-mer
#27 feat(service): 상품 검색 기능 작성(imageUrl 추가 예정)
e5c750e
sim-mer added a commit that referenced this issue Oct 2, 2024
@sim-mer
#27 feat(presentation): 상품 검색 기능 작성(imageUrl 추가 예정)
fd66d6d
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 add: JpaAuditing을 이용한 BaseTimeEntity 작성
73f68e5
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 add: Product BaseTimeEntity 상속, ArtistInfo JoinColumn 명시
b753e67
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(persistence): 상품 검색 기능 작성(imageUrl 추가 예정)
2c29a01
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(product.service): 상품 검색 기능 작성
1d2d527
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(product.controller): 상품 검색 기능 작성
e4e393a
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 chore(build.gradle): testcontainers 의존성 추가
e2456f8
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 refactor(ProductPage.java): ProductPage 패키지 변경
46e885e
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 fix(SortUtil.java): 상품 정렬 변환 유틸 메서드 스네이크 케이스로 변경
be44e0f
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(product): 상품 페이징 DTO 작성
8f56e6a
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 docs(product): 상품 api 문서 추가 및 url mapping 변경
36bd84f
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 fix(product): ArtistInfo entity 변경에 따른 쿼리 수정
30769a7
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 test(product): 상품 검색 기능 테스트코드 작성
803d9df
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(product): Product thumbnailUrl 삽입 로직 작성
daaf61e
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(product): 상품 검색 시 Product thumbnailUrl 포함되도록 변경
58dad0c
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 fix: git conflict 수정
977511c
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 test(product): 상품 검색 thumbnailUrl 추가에 따른 테스트코드 변경
2be3457
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(user.repository): 작가 검색 기능 작성
b9ac98a
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(user.service): 작가 검색 기능 작성
135135b
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(user.controller): 작가 검색 기능 작성
3e94711
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 feat(user.dto): 작가 검색 페이징 DTO 작성
aff8acf
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 docs(user): 작가 검색 API 문서에 추가
285c4ce
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 test(user): 작가 검색 기능 테스트 코드 작성
425881a
sim-mer added a commit that referenced this issue Oct 29, 2024
@sim-mer
#27 test: 테스트 코드 오류 수정
8478def
sim-mer added a commit that referenced this issue Oct 30, 2024
@sim-mer
Merge pull request #64 from kakao-tech-campus-2nd-step3/feat/#27-prod…
c812e98 
…uct-search

[sim-mer -> weekly] 검색 기능 구현
@sim-mer sim-mer closed this as completed Oct 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sim-mer sim-mer

Labels
✨ Feature 기능 개발
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@sim-mer