인프런 커뮤니티 질문&답변

단일 테스트는 문제 없지만 전체 테스트 진행 시

테이블의 id의 시퀀스가 계속 증가 하는 문제로
jpa save 시 id 1에 저장하려는 문제가 발생하여

user-service-test-data.sql

-- insert into `users` (`id`, `email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
-- values (1, 'kok202@naver.com', 'kok202', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'ACTIVE', 0);
-- insert into `users` (`id`, `email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
-- values (2, 'kok303@naver.com', 'kok303', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab', 'PENDING', 0);


insert into `users` (`email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
values ('kok202@naver.com', 'kok202', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'ACTIVE', 0);
insert into `users` (`email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
values ('kok303@naver.com', 'kok303', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab', 'PENDING', 0);

post-service-test-data.sql


-- insert into `users` (`id`, `email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
-- values (1, 'kok202@naver.com', 'kok202', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'ACTIVE', 0);
-- insert into `users` (`id`, `email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
-- values (2, 'kok303@naver.com', 'kok303', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab', 'PENDING', 0);
-- insert into `posts` (`id`, `content`, `created_at`, `modified_at`, `user_id`)
-- values (1, 'helloworld', 1678530673958, 0, 1);


insert into `users` (`email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
values ('kok202@naver.com', 'kok202', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 'ACTIVE', 0);
insert into `users` (`email`, `nickname`, `address`, `certification_code`, `status`, `last_login_at`)
values ('kok303@naver.com', 'kok303', 'Seoul', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab', 'PENDING', 0);
insert into `posts` (`content`, `created_at`, `modified_at`, `user_id`)
values ('helloworld', 1678530673958, 0, 1);

delte-all-data.sql

delete from `posts` where 1;
delete from `users` where 1;

ALTER TABLE `users` ALTER COLUMN id RESTART WITH 1;
ALTER TABLE `posts` ALTER COLUMN id RESTART WITH 1;

이와 같이 변경하였는데 혹시 다른 방법이 있을까요?