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

[BE] 상품 리스트 조회 (동적 쿼리) #27

Closed
3 tasks done
jun108059 opened this issue Jan 17, 2023 · 0 comments · Fixed by #46
Closed
3 tasks done

[BE] 상품 리스트 조회 (동적 쿼리) #27

jun108059 opened this issue Jan 17, 2023 · 0 comments · Fixed by #46
Assignees
@jun108059
Labels
✨ Feature 새로운 기능 관련
Milestone
Sprint-2

Comments

@jun108059
Copy link
Owner

jun108059 commented Jan 17, 2023 •
edited
Loading

✍🏻 Description

Description Method Endpoint Page
상품 전체 조회 (지역) GET /api/v1/product/list 홈
상품 전체 조회 (지역+카테고리) GET /api/v1/product/list?{category_id} 홈 → 우측상단메뉴 → 카테고리선택
상품 전체 조회 (특정회원+거래상태) GET /api/v1/product/list/{member_id}&{status} 홈 → 상품상세 홈 → 상품상세 → 모두보기
홈 → 마이페이지 → 판매내역
상품 전체 조회 (특정회원+좋아요+거래상태) GET /api/v1/product/list/{member_id}&{likes}&{status}/ 홈 → 마이페이지 → 관심목록

✅ To-Do

  • Query-DSL 의존성 추가
  • 상품 전체 조회 API 수정
  • 동적 쿼리 작성
@jun108059 jun108059 added the ✨ Feature 새로운 기능 관련 label Jan 17, 2023
@jun108059 jun108059 added this to the Sprint-2 milestone Jan 17, 2023
@jun108059 jun108059 self-assigned this Jan 17, 2023
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
➕ QueryDSL 관련 의존성 [#27]
b271c2b 
- 상품 조회 동적 Query 생성을 위해

Related to: #27
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
🔧 QueryDSL Config 추가 [#27]
82b0be1 
- 상품 조회 동적 Query 생성을 위한 config

Related to: #27
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
👔 product 리스트 조회 필터 데이터 추가 [#27]
d7b91a1 
- 상품 조회 동적 Query 생성을 위한 config

Related to: #27
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
👔 QueryDSL Support class [#27]
fd89823 
- findByFilter 메서드

Related to: #27
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
✅ Product QueryDSL Test 코드 [#27]
9a79da5 
- QueryDSL 설정 검증

Related to: #27
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
♻️ Product Status 패키지 변경 [#27]
72c2193 
- QueryDSL 설정 검증

Related to: #27
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
➕ Kotest 테스트 관련 의존성 추가
82d22b4 
- kotest.extensions : spring boot test 사용
- ninja-squad : junit의 @MockBean @SpyBean 같은 기능 제공
- mockk : unit test - mocking 사용

Related to: #27
jun108059 added a commit that referenced this issue Feb 5, 2023
@jun108059
🔧 QueryDSL - JPQL 로깅을 위한 설정 추가
6e00610 
- sql debug (trace 확인)

Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
♻️ ktlint 코드 정렬 적용
5dbad33 
Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
👔 상품 리스트 필터 기반 Querydsl 호출 추가 (#27)
2a4864a 
- ProductRepositorySupport 의존성 주입

Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
👔 상품 리스트 조회 title 검색 분리 (#27)
84b801e 
- containTitle 분리

Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
✅ 카테고리별 조회, 상품 상태별 조회 호출 테스트 추가 (#27)
c0c6589 
- category_id, status 파라미터

Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
👔 특정 회원이 등록한 상품 리스트 요청 dto 추가 (#27)
91ff4da 
- category_id, status 파라미터

Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
👔 특정 회원이 등록한 상품 리스트 비즈니스 로직 추가 (#27)
a47843d 
- 특정회원+거래상태 조회 (지역 미포함)
- 지역+카테고리 조회

Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
👔 관심상품 리스트 조회 로직 (#27)
75543b5 
- product, likes filed inner join

Related to: #27
jun108059 added a commit that referenced this issue Feb 7, 2023
@jun108059
✅ 관심 상품 목록 조회 호출 테스트 (#27)
79f6a21 
- 파라미터 member_id, likes, status

Related to: #27
@jun108059 jun108059 changed the title [BE] 상품 전체 조회 (동적 쿼리) [BE] 상품 리스트 조회 (동적 쿼리) Feb 7, 2023
@jun108059 jun108059 mentioned this issue Feb 7, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jun108059 jun108059

Labels
✨ Feature 새로운 기능 관련
Projects
당근마켓 클론코딩 프로젝트 🥕
Status: Done
Milestone
Sprint-2
Development

Successfully merging a pull request may close this issue.

[BE] 상품 리스트 조회 API 개발 [ISSUE-27] jun108059/daangn-market
1 participant
@jun108059