Spring引导和Spring数据休息集成测试无法持久数据(Spring boot & Spring data rest integration test fails to persist data)

 我正在使用Spring Boot和Spring Data Rest来公开我的数据存储库。 
 
 我编写的集成测试将用户添加到数据库，然后调用其余方法列出用户。 但添加的用户不在列表中。 
 
 一个ApplicationRunner被用来填充数据库和我使用Spring配置文件不同的数据库。 
 
 例如，对于我的测试： 
 
spring:
  profiles: unittest
  datasource:
    url: 'jdbc:h2:mem:MYDB;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE'
    driver-class-name: org.h2.Driver
    username: myname
    password: mypassword
  jpa:
    show-sql: true
    hibernate:
      ddl-auto: create-drop
  jpa:
    hibernate:
      dialect: org.hibernate.dialect.H2Dialect
 
 单元测试： 
 
@RunWith(SpringRunner.class)
@SpringBootTest(webEnvironment = WebEnvironment.RANDOM_PORT)
@ActiveProfiles("unittest")
@AutoConfigureTestEntityManager
@Transactional
public class MyUserRepoIntegrationTest {
  private static Logger log = Logger.getLogger(MyUserRepoIntegrationTest.class);
  // 3 default users + "test"
  private static final int NUM_USERS = 4;

  @Autowired
  private TestRestTemplate restTemplate;
  @Autowired
  private TestEntityManager entityManager;

  @Before
  public void setupTests() {
    entityManager.persistAndFlush(new MyUser("test", "test"));
  }

  @Test
  public void listUsers() {
    ResponseEntity<String> response = restTemplate.withBasicAuth("user", "user").getForEntity("/apiv1/data/users", String.class);
    assertThat(response.getStatusCode()).isEqualTo(HttpStatus.OK);
    assertThat(response.getBody()).contains("\"totalElements\" : "+NUM_USERS);
  }
}
 
 最后的断言总是失败。 数据库中只有3个用户，由ApplicationRunner添加（通过userRepository）。 我已经尝试使用userRepository而不是TestEntityManager，并在测试方法本身内添加用户，但没有任何更改。 
 
 我已经验证过，它使用H2而不是我的生产数据库。 
 
 编辑： 
 
 经过仔细检查，数据实际上到达数据库。 当我注入UserRepository并调用.count（）时，它给了我NUM_USERS（4）。 
 
 问题可能在于Spring Data REST，因为REST响应不包括新用户。 我也尝试修改一个现有的用户并显式调用flush（），但响应仍然是一样的。 我已经从我的POM中删除了'spring-boot-starter-cache'，并在'unittest'配置文件中为我的application.yml添加了spring.cache.type = none，但没有运气。 

I'm using Spring Boot and Spring Data Rest to expose my Data repository.
 
The integration test I wrote, adds a user to the database and then calls the rest method to lists users. But the added user is NOT being listed.
 
An ApplicationRunner is used to populate the DB with data and I'm using Spring profiles for differnt databases.
 
For example, for my tests:
 
spring:
  profiles: unittest
  datasource:
    url: 'jdbc:h2:mem:MYDB;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE'
    driver-class-name: org.h2.Driver
    username: myname
    password: mypassword
  jpa:
    show-sql: true
    hibernate:
      ddl-auto: create-drop
  jpa:
    hibernate:
      dialect: org.hibernate.dialect.H2Dialect
 
The unit test:
 
@RunWith(SpringRunner.class)
@SpringBootTest(webEnvironment = WebEnvironment.RANDOM_PORT)
@ActiveProfiles("unittest")
@AutoConfigureTestEntityManager
@Transactional
public class MyUserRepoIntegrationTest {
  private static Logger log = Logger.getLogger(MyUserRepoIntegrationTest.class);
  // 3 default users + "test"
  private static final int NUM_USERS = 4;

  @Autowired
  private TestRestTemplate restTemplate;
  @Autowired
  private TestEntityManager entityManager;

  @Before
  public void setupTests() {
    entityManager.persistAndFlush(new MyUser("test", "test"));
  }

  @Test
  public void listUsers() {
    ResponseEntity<String> response = restTemplate.withBasicAuth("user", "user").getForEntity("/apiv1/data/users", String.class);
    assertThat(response.getStatusCode()).isEqualTo(HttpStatus.OK);
    assertThat(response.getBody()).contains("\"totalElements\" : "+NUM_USERS);
  }
}
 
The last assertion always fails. There are only 3 users in the DB, the ones added by the ApplicationRunner (via the userRepository). I've tried using the userRepository instead of the TestEntityManager and adding the user inside the test method itself, but nothing changes.
 
I've verified, that it's using H2 and not my production DB.
 
EDIT:
 
Upon closer inspection, the Data actually gets to the Database. When I inject my UserRepository and call .count(), it gives me NUM_USERS (4).
 
The Problem probably lies with Spring Data REST, since the REST response doesn't include the new user. I've also tried modifying an existing user and explicitly calling flush(), yet the response is still the same. I've removed 'spring-boot-starter-cache' from my POM and added spring.cache.type=none to my application.yml for the 'unittest' profile, but no luck.

原文：https://stackoverflow.com/questions/41099879