PL-reply-crud: 답변 CRUD API 구현

[Hexeong]

답변 CRUD API 구현

상위 릴리스

BR-002-A: Data CRUD

하위 이슈

• DS-entity-reply: Reply Entity 생성
• DS-dto-reply: Reply Create, Update용 DTO 생성
• DS-repository-reply: Reply Repository 생성
• DS-service-reply: Reply CRUD Service 생성
• DS-controller-reply: Reply CRUD RestController 생성
• DS-test-reply-crud: Reply Domain CRUD TestCode 생성

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

Note

ORM은 JPA를 사용할 예정

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

Note

Data RegistRequestDTO와 UpdateRequestDTO만 생성할 예정

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

Note

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

[DS-service-reply] Reply Domain Service 구현

Note

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

[DS-controller-reply] Reply Domain CRUD API 구현

Note

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

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

Note

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

TestData Insert Query

insert into devlink.reply (reply_id, account_id, content, created_at, modified_at, question_id)
values  (1, '계정1', '답변 내용 1-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 1),
        (2, '계정1', '답변 내용 1-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 1),
        (3, '계정1', '답변 내용 1-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 1),
        (4, '계정1', '답변 내용 2-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 2),
        (5, '계정1', '답변 내용 2-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 2),
        (6, '계정1', '답변 내용 2-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 2),
        (7, '계정1', '답변 내용 3-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 3),
        (8, '계정1', '답변 내용 3-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 3),
        (9, '계정1', '답변 내용 3-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 3),
        (10, '계정1', '답변 내용 4-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 4),
        (11, '계정1', '답변 내용 4-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 4),
        (12, '계정1', '답변 내용 4-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 4),
        (13, '계정1', '답변 내용 5-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 5),
        (14, '계정1', '답변 내용 5-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 5),
        (15, '계정1', '답변 내용 5-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 5),
        (16, '계정1', '답변 내용 6-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 6),
        (17, '계정1', '답변 내용 6-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 6),
        (18, '계정1', '답변 내용 6-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 6),
        (19, '계정1', '답변 내용 7-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 7),
        (20, '계정1', '답변 내용 7-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 7),
        (21, '계정1', '답변 내용 7-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 7),
        (22, '계정1', '답변 내용 8-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 8),
        (23, '계정1', '답변 내용 8-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 8),
        (24, '계정1', '답변 내용 8-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 8),
        (25, '계정1', '답변 내용 9-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 9),
        (26, '계정1', '답변 내용 9-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 9),
        (27, '계정1', '답변 내용 9-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 9),
        (28, '계정1', '답변 내용 10-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 10),
        (29, '계정1', '답변 내용 10-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 10),
        (30, '계정1', '답변 내용 10-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 10),
        (31, '계정1', '답변 내용 11-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 11),
        (32, '계정1', '답변 내용 11-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 11),
        (33, '계정1', '답변 내용 11-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 11),
        (34, '계정1', '답변 내용 12-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 12),
        (35, '계정1', '답변 내용 12-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 12),
        (36, '계정1', '답변 내용 12-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 12),
        (37, '계정1', '답변 내용 13-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 13),
        (38, '계정1', '답변 내용 13-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 13),
        (39, '계정1', '답변 내용 13-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 13),
        (40, '계정1', '답변 내용 14-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 14),
        (41, '계정1', '답변 내용 14-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 14),
        (42, '계정1', '답변 내용 14-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 14),
        (43, '계정1', '답변 내용 15-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 15),
        (44, '계정1', '답변 내용 15-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 15),
        (45, '계정1', '답변 내용 15-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 15),
        (46, '계정2', '답변 내용 16-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 16),
        (47, '계정2', '답변 내용 16-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 16),
        (48, '계정2', '답변 내용 16-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 16),
        (49, '계정2', '답변 내용 17-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 17),
        (50, '계정2', '답변 내용 17-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 17),
        (51, '계정2', '답변 내용 17-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 17),
        (52, '계정2', '답변 내용 18-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 18),
        (53, '계정2', '답변 내용 18-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 18),
        (54, '계정2', '답변 내용 18-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 18),
        (55, '계정2', '답변 내용 19-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 19),
        (56, '계정2', '답변 내용 19-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 19),
        (57, '계정2', '답변 내용 19-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 19),
        (58, '계정2', '답변 내용 20-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 20),
        (59, '계정2', '답변 내용 20-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 20),
        (60, '계정2', '답변 내용 20-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 20),
        (61, '계정2', '답변 내용 21-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 21),
        (62, '계정2', '답변 내용 21-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 21),
        (63, '계정2', '답변 내용 21-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 21),
        (64, '계정2', '답변 내용 22-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 22),
        (65, '계정2', '답변 내용 22-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 22),
        (66, '계정2', '답변 내용 22-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 22),
        (67, '계정2', '답변 내용 23-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 23),
        (68, '계정2', '답변 내용 23-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 23),
        (69, '계정2', '답변 내용 23-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 23),
        (70, '계정2', '답변 내용 24-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 24),
        (71, '계정2', '답변 내용 24-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 24),
        (72, '계정2', '답변 내용 24-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 24),
        (73, '계정2', '답변 내용 25-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 25),
        (74, '계정2', '답변 내용 25-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 25),
        (75, '계정2', '답변 내용 25-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 25),
        (76, '계정2', '답변 내용 26-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 26),
        (77, '계정2', '답변 내용 26-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 26),
        (78, '계정2', '답변 내용 26-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 26),
        (79, '계정2', '답변 내용 27-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 27),
        (80, '계정2', '답변 내용 27-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 27),
        (81, '계정2', '답변 내용 27-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 27),
        (82, '계정2', '답변 내용 28-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 28),
        (83, '계정2', '답변 내용 28-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 28),
        (84, '계정2', '답변 내용 28-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 28),
        (85, '계정2', '답변 내용 29-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 29),
        (86, '계정2', '답변 내용 29-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 29),
        (87, '계정2', '답변 내용 29-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 29),
        (88, '계정2', '답변 내용 30-1', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 30),
        (89, '계정2', '답변 내용 30-2', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 30),
        (90, '계정2', '답변 내용 30-3', '2024-10-09 22:15:24.000000', '2024-10-09 22:15:24.000000', 30);