UserRepository doesn't work in Spring boot tests

Question

I'm creating an app for practice in java spring boot, but I faced with the problem when I started to test my UserService. I don't know why, but UserRepository just doesn't want to work. It initialized but when I try to call the save() method, it doesn't save anything in database.

So here's my test:

UserServiceTest.java

@SpringBootTest
@ExtendWith(SpringExtension.class)
@TestMethodOrder(MethodOrderer.OrderAnnotation.class)
public class UserServiceTest {

    @InjectMocks
    private UserService userService;

    @Spy
    private UserRepo userRepo;

    @Spy
    private ValidationService validationService;
    @Spy
    private PasswordEncoder passwordEncoder;


    @AfterEach
    public void deleteDb() {
        List<UserEntity> users = userRepo.findAll();
        userRepo.deleteAll(users);
    }

    @BeforeEach
    public void setupMock() {
        Mockito.when(userRepo.save(Mockito.any(UserEntity.class))).thenReturn(new UserEntity());
    }

    @Test
    @Order(1)
    public void testUserAdding() {

        List<UserAddModel> addModels = getUserAddModels();
        addModels.forEach(m -> {
            userService.addUser(m);
            List<UserEntity> users = userRepo.findAll();
            System.out.println(users);
            UserEntity user = userRepo.findByPhoneNumber(m.getPhoneNumber()).orElseThrow(UserNotFoundException::new);
            isUserGetModelValid(m, UserGetModel.toModel(user));
        });
        addModels = getInvalidUserAddModels();
        addModels.forEach(m -> Assertions.assertThrows(InvalidDataException.class,
                () -> isUserGetModelValid(m, userService.addUser(m))));
    }


    private List<UserAddModel> getUserAddModels() {
        return new ArrayList<>(List.of(
                new UserAddModel(
                        "Alex",
                        "Filtch",
                        null,
                        "+19772395747",
                        null,
                        "AbobaAbobaAboba"
                ),
                new UserAddModel(
                        "Scarlet",
                        "Brown",
                        "FiftithEnumed",
                        "+19164167722",
                        null,
                        "Fi123sdamJfw+"
                ),
                new UserAddModel(
                        "Andy",
                        "Balk",
                        "Afton",
                        "+112486759123",
                        "IBiB@Basas",
                        "IBiB@Basas"
                )
        ));

    }

    private void isUserGetModelValid(UserAddModel userAddModel, UserGetModel userGetModel) {
        Assertions.assertAll(
                () -> Assertions.assertNotNull(userGetModel.getId()),
                () -> Assertions.assertEquals(userAddModel.getFirstName(), userGetModel.getFirstName()),
                () -> Assertions.assertEquals(userAddModel.getLastName(), userGetModel.getLastName()),
                () -> Assertions.assertEquals(userAddModel.getPatronymic(), userGetModel.getPatronymic()),
                () -> Assertions.assertEquals(userAddModel.getEmail(), userGetModel.getEmail()),
                () -> Assertions.assertEquals(userAddModel.getPhoneNumber(), userGetModel.getPhoneNumber())
        );
    }
}

And here I decided to check if userRepo is working right in UserService.java:

UserEntity us = userRepo.save(user);

But us variable has null fields after saving:

So what can be the problem? If you know, please tell me, I'd really appreciate it!

Answer 1

First of all you don't need @ExtendWith(SpringExtension.class) over you test class as @SpringBootTest already contains it. Second, to have actual data saved into the database you should use real beans, not mocks, as well as have some real storage. Just add this into your application-test.yml:

spring:
  datasource:
    url: jdbc:h2:mem:~/test;DB_CLOSE_ON_EXIT=FALSE
    username: sa
    password:
    driver-class-name: org.h2.Driver

This will give you in-memory database for tests. Then use @Autowired instead of @Spy/@Mock:

@SpringBootTest
@TestMethodOrder(MethodOrderer.OrderAnnotation.class)
public class UserServiceTest {

    @Autowired
    private UserService userService;

    @Autowired
    private UserRepo userRepo;

    @MockBean
    private ValidationService validationService;
    @MockBean
    private PasswordEncoder passwordEncoder;


    @AfterEach
    public void deleteDb() {
        userRepo.deleteAll();
    }

This would allow you to have real userService and real userRepo and mock validationService and passwordEncoder