PL-project-crud: 프로젝트 CRUD API 구현 #9
Description
프로젝트 의뢰 CRUD API 구현
상위 릴리스
하위 이슈
- DS-entity-project: Project Entity 생성
- DS-dto-project: Project Create, Update용 DTO 생성
- DS-repository-project: Project Repository 생성
- DS-service-project: Project CRUD Service 생성
- DS-controller-project: Project CRUD RestController 생성
- DS-test-project-crud: Project Domain CRUD TestCode 생성
- DS-refactor-table: figma UI에 맞게 컬럼 및 로직 수정 #49
- DS-refactor-domain-name: 도메인 네임 변경: request -> project #51
- DS-add-column-position: Project에 컬럼으로 Vector값(Postion)에 대해서 추가 #57
- DS-add-get-method: 언리얼을 위한 추가 조회 메서드 구현 #61
- DS-update-entity-column: 엔티티 컬럼 수정과 그에 따른 조회문 수정 및 추가 #69
[DS-entity-project] 테이블과 Java 객체 매핑을 하기 위한 Entity를 구현한다.
Note
ORM은 JPA를 사용할 예정
[DS-dto-project] Project Regist, Update data를 묶어서 보내기 위한 DTO를 구현한다.
Note
Data RegistRequestDTO와 UpdateRequestDTO만 생성할 예정
[DS-repository-project] JPA를 사용해서 Repository 구현
Note
CRUD 로직을 포함해서 pagination 기능까지 구현할 예정
[DS-service-project] Project Domain Service 구현
Note
Transaction 단위로 작업 단위 구분, @transactional을 사용해 적절히 구분할 예정
[DS-controller-project] Project Domain CRUD API 구현
Note
조회 API는 단일 조회, 전체 조회, paging 조회 3개로 나눠 구현할 예정
[DS-test-project-crud] Project Domain에 대해 CRUD Test Code를 작성한다.
Note
JUnit5를 사용해서 테스트할 예정
TestData Insert Query
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (1, '계정1', '요청 내용 1', '2024-10-13 13:09:25.000000', '2023-10-01 12:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-01 10:00:00.000000', '제목 1');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (2, '계정1', '요청 내용 2', '2024-10-13 13:09:25.000000', '2023-10-02 13:30:00.000000', '2024-10-13 13:09:25.000000', '2023-10-02 10:30:00.000000', '제목 2');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (3, '계정1', '요청 내용 3', '2024-10-13 13:09:25.000000', '2023-10-03 12:30:00.000000', '2024-10-13 13:09:25.000000', '2023-10-03 11:00:00.000000', '제목 3');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (4, '계정1', '요청 내용 4', '2024-10-13 13:09:25.000000', '2023-10-04 11:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-04 09:00:00.000000', '제목 4');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (5, '계정1', '요청 내용 5', '2024-10-13 13:09:25.000000', '2023-10-05 16:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-05 14:00:00.000000', '제목 5');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (6, '계정2', '요청 내용 6', '2024-10-13 13:09:25.000000', '2023-10-06 11:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-06 10:00:00.000000', '제목 6');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (7, '계정2', '요청 내용 7', '2024-10-13 13:09:25.000000', '2023-10-07 17:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-07 15:00:00.000000', '제목 7');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (8, '계정2', '요청 내용 8', '2024-10-13 13:09:25.000000', '2023-10-08 14:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-08 12:00:00.000000', '제목 8');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (9, '계정2', '요청 내용 9', '2024-10-13 13:09:25.000000', '2023-10-09 12:30:00.000000', '2024-10-13 13:09:25.000000', '2023-10-09 11:30:00.000000', '제목 9');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (10, '계정2', '요청 내용 10', '2024-10-13 13:09:25.000000', '2023-10-10 14:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-10 13:00:00.000000', '제목 10');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (11, '계정1', '요청 내용 11', '2024-10-13 13:09:25.000000', '2023-10-11 11:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-11 09:00:00.000000', '제목 11');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (12, '계정1', '요청 내용 12', '2024-10-13 13:09:25.000000', '2023-10-12 17:30:00.000000', '2024-10-13 13:09:25.000000', '2023-10-12 15:30:00.000000', '제목 12');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (13, '계정1', '요청 내용 13', '2024-10-13 13:09:25.000000', '2023-10-13 10:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-13 08:00:00.000000', '제목 13');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (14, '계정1', '요청 내용 14', '2024-10-13 13:09:25.000000', '2023-10-14 15:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-14 14:00:00.000000', '제목 14');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (15, '계정1', '요청 내용 15', '2024-10-13 13:09:25.000000', '2023-10-15 18:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-15 16:00:00.000000', '제목 15');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (16, '계정2', '요청 내용 16', '2024-10-13 13:09:25.000000', '2023-10-16 12:30:00.000000', '2024-10-13 13:09:25.000000', '2023-10-16 10:30:00.000000', '제목 16');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (17, '계정2', '요청 내용 17', '2024-10-13 13:09:25.000000', '2023-10-17 13:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-17 11:00:00.000000', '제목 17');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (18, '계정2', '요청 내용 18', '2024-10-13 13:09:25.000000', '2023-10-18 11:30:00.000000', '2024-10-13 13:09:25.000000', '2023-10-18 09:30:00.000000', '제목 18');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (19, '계정2', '요청 내용 19', '2024-10-13 13:09:25.000000', '2023-10-19 14:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-19 12:00:00.000000', '제목 19');
INSERT INTO devlink.request (request_id, account_id, content, created_at, end_datetime, modified_at, start_datetime, title) VALUES (20, '계정2', '요청 내용 20', '2024-10-13 13:09:25.000000', '2023-10-20 15:00:00.000000', '2024-10-13 13:09:25.000000', '2023-10-20 13:00:00.000000', '제목 20');
Metadata
Metadata
Assignees
Type
Projects
Status