PL-ether-crud: 에테르(재화) 이력 CRUD API 구현

[Hexeong]

에테르(재화) 이력 CRUD API 구현

상위 릴리스

BR-002-A: Data CRUD

하위 이슈

• DS-entity-ether: Ether Entity 생성
• DS-dto-ether: Ether Create, Update용 DTO 생성
• DS-repository-ether: Ether Repository 생성
• DS-service-ether: Ether CRUD Service 생성
• DS-controller-ether: Ether CRUD RestController 생성
• DS-test-ether-crud: Ether Domain CRUD TestCode 생성
• DS-refactor-entity-and-API: Ether 도메인 엔티티 및 API 리팩토링 #98

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

Note

ORM은 JPA를 사용할 예정

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

Note

Data RegistRequestDTO와 UpdateRequestDTO만 생성할 예정

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

Note

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

[DS-service-ether] Ether Domain Service 구현

Note

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

[DS-controller-ether] Ether Domain CRUD API 구현

Note

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

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

Note

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

TestData Insert Query

insert into devlink.ether (ether_id, account_id, amount, created_at, modified_at, reason)
values  (1, '계정1', 1000, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Payment Reason 1'),
        (2, '계정2', 2000, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Payment Reason 2'),
        (3, '계정1', 1500, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Refund Reason'),
        (4, '계정2', 3000, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Bonus Payment'),
        (5, '계정1', 1200, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Allowance'),
        (6, '계정2', 2500, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Compensation'),
        (7, '계정1', 5000, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Payment Reason 3'),
        (8, '계정2', 1700, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Service Payment'),
        (9, '계정1', 800, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Subscription Fee'),
        (10, '계정2', 3500, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Gift Refund'),
        (11, '계정1', 2200, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Salary Bonus'),
        (12, '계정2', 2800, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Annual Allowance'),
        (13, '계정1', 1800, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Expense Compensation'),
        (14, '계정2', 2700, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Travel Allowance'),
        (15, '계정1', 600, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Business Payment'),
        (16, '계정2', 4500, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Educational Bonus'),
        (17, '계정1', 3300, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Holiday Allowance'),
        (18, '계정2', 1200, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Refund Reason 4'),
        (19, '계정1', 1600, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Work Compensation'),
        (20, '계정2', 2100, '2024-10-10 13:34:20.000000', '2024-10-10 13:34:20.000000', 'Insurance Allowance');