PL-team-crud: 프로젝트 팀 CRUD API 구현

[Hexeong]

프로젝트 팀 CRUD API 구현

상위 릴리스

BR-002-A: Data CRUD

하위 이슈

• DS-entity-team: Team Entity 생성
• DS-dto-team: Team Create, Update용 DTO 생성
• DS-repository-team: Team Repository 생성
• DS-service-team: Team CRUD Service 생성
• DS-controller-team: Team CRUD RestController 생성
• DS-test-team-crud: Team Domain CRUD TestCode 생성
• DS-refactor-team-entity: Team Entity & API refactor #84

[DS-entity-team] 테이블과 Java 객체 매핑을 하기 위한 Entity를 구현한다.

Note

ORM은 JPA를 사용할 예정

[DS-dto-team] Team Regist, Update data를 묶어서 보내기 위한 DTO를 구현한다.

Note

Data RegistRequestDTO와 UpdateRequestDTO만 생성할 예정

[DS-repository-team] JPA를 사용해서 Repository 구현

Note

CRUD 로직을 포함해서 pagination 기능까지 구현할 예정

[DS-service-team] Team Domain Service 구현

Note

Transaction 단위로 작업 단위 구분, @transactional을 사용해 적절히 구분할 예정

[DS-controller-team] Team Domain CRUD API 구현

Note

조회 API는 단일 조회, 전체 조회, paging 조회 3개로 나눠 구현할 예정

[DS-test-team-crud] Team Domain에 대해 CRUD Test Code를 작성한다.

Note

JUnit5를 사용해서 테스트할 예정

TestData Insert Query

-- TEAM 테이블에 데이터 삽입
INSERT INTO TEAM (PM_ID, TEAM_NAME, INTRODUCTION) VALUES 
('계정1', 'Team 1', 'Team 1 Introduction'),
('계정2', 'Team 2', 'Team 2 Introduction'),
('계정3', 'Team 3', 'Team 3 Introduction'),
('계정4', 'Team 4', 'Team 4 Introduction'),
('계정5', 'Team 5', 'Team 5 Introduction'),
('계정6', 'Team 6', 'Team 6 Introduction'),
('계정7', 'Team 7', 'Team 7 Introduction'),
('계정8', 'Team 8', 'Team 8 Introduction'),
('계정9', 'Team 9', 'Team 9 Introduction'),
('계정10', 'Team 10', 'Team 10 Introduction'),
('계정11', 'Team 11', 'Team 11 Introduction'),
('계정12', 'Team 12', 'Team 12 Introduction'),
('계정13', 'Team 13', 'Team 13 Introduction'),
('계정14', 'Team 14', 'Team 14 Introduction'),
('계정15', 'Team 15', 'Team 15 Introduction'),
('계정16', 'Team 16', 'Team 16 Introduction'),
('계정17', 'Team 17', 'Team 17 Introduction'),
('계정18', 'Team 18', 'Team 18 Introduction'),
('계정19', 'Team 19', 'Team 19 Introduction'),
('계정20', 'Team 20', 'Team 20 Introduction'),
('계정21', 'Team 21', 'Team 21 Introduction');

-- TEAM_MEMBER 테이블에 데이터 삽입 (각 pmId를 제외한 나머지 계정 중 두 개씩 추가)
INSERT INTO TEAM_MEMBER (TEAM_ID, MEMBER_LIST) VALUES 
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정1'), '계정2'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정1'), '계정3'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정2'), '계정3'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정2'), '계정4'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정3'), '계정4'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정3'), '계정5'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정4'), '계정5'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정4'), '계정6'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정5'), '계정6'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정5'), '계정7'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정6'), '계정7'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정6'), '계정8'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정7'), '계정8'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정7'), '계정9'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정8'), '계정9'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정8'), '계정10'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정9'), '계정10'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정9'), '계정11'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정10'), '계정11'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정10'), '계정12'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정11'), '계정12'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정11'), '계정13'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정12'), '계정13'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정12'), '계정14'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정13'), '계정14'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정13'), '계정15'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정14'), '계정15'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정14'), '계정16'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정15'), '계정16'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정15'), '계정17'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정16'), '계정17'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정16'), '계정18'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정17'), '계정18'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정17'), '계정19'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정18'), '계정19'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정18'), '계정20'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정19'), '계정20'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정19'), '계정21'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정20'), '계정21'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정20'), '계정1'),
((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정21'), '계정1'), ((SELECT TEAM_ID FROM TEAM WHERE PM_ID = '계정21'), '계정2');