java - 集成测试在 gradle 测试中失败，但在 IDE 中通过

Question

我在所有集成测试中不断遇到异常，而单元测试运行良好。所有异常如下所示:

UsersControllerTest > getOneUser() FAILED
    java.lang.IllegalStateException at DefaultCacheAwareContextLoaderDelegate.java:132
        Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException at ScriptUtils.java:626
            Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException at DbException.java:459

我正在使用 Jupiter 进行测试。我认为上述异常(exception)指向 data.sql 脚本，我必须填充一些数据。对我来说，语法似乎没问题，而且运行良好，这意味着如果使用 postman 测试，则会生成记录:

INSERT INTO AUTHORITY (ID_AUTHORITY,AUTHORITY) VALUES (1,'USER');
INSERT INTO AUTHORITY (ID_AUTHORITY,AUTHORITY) VALUES (2,'MODERATOR');
INSERT INTO AUTHORITY (ID_AUTHORITY,AUTHORITY) VALUES (3,'ADMIN');
INSERT INTO USER (USER_ID,FIRST_NAME,LAST_NAME,ID,PASSWORD,EMAIL,EMAIL_VERIFIED,ACCOUNT_NON_EXPIRED,ACCOUNT_NON_LOCKED,ENABLED,CREDENTIALS_NON_EXPIRED)
VALUES (1,'Alisher','Urunov','b006c568-a79b-4c28-a06c-df7d89579e00','$2y$12$vLPHTGSDyNWBdH.zxuJgfeiExUwh3zT3Cgj8ZZzW.38rDNK/yBJtm','urunov.alisher@some.com',TRUE,TRUE,TRUE,TRUE,TRUE);
INSERT INTO USER (USER_ID,FIRST_NAME,LAST_NAME,ID,PASSWORD,EMAIL,EMAIL_VERIFIED,ACCOUNT_NON_EXPIRED,ACCOUNT_NON_LOCKED,ENABLED,CREDENTIALS_NON_EXPIRED)
VALUES (2,'Ralf','Tester','b006c568-a79b-123s-a06c-df7d89579e00','$2a$10$3D8eyR7FouUb3RjKoVd9r.pBa7wZbOCe4BeIgxJmJmT9kbYGU43qC','ralf@gmail.com',FALSE,TRUE,TRUE,TRUE,TRUE);
INSERT INTO USER (USER_ID,FIRST_NAME,LAST_NAME,ID,PASSWORD,EMAIL,EMAIL_VERIFIED,ACCOUNT_NON_EXPIRED,ACCOUNT_NON_LOCKED,ENABLED,CREDENTIALS_NON_EXPIRED)
VALUES (3,'Ronald','The Great','b006c568-a79b-123s-1248-df7d89579e00','$2a$10$l9jefOjW/P0/dYH.MkHO8OJkNc7SN/G4ZOK1Lk9ND0x08Yta9hJrq','roland.theGreat@gmail.com',TRUE,TRUE,TRUE,TRUE,TRUE);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (1,1);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (1,2);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (1,3);
INSERT INTO USER_AUTHORITY (ID_USER,ID_AUTHORITY) VALUES (3,1);

还想到了 Spring boot 可能存在的配置问题，因此我在 gradle.build 中添加了 jdbc starter 依赖项，但似乎仍然失败。

这是测试的一部分:

@ExtendWith(SpringExtension.class)
@SpringBootTest(classes = UserServiceApplication.class,webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
@ContextConfiguration(classes = UserServiceApplication.class)
@DirtiesContext(classMode = DirtiesContext.ClassMode.BEFORE_EACH_TEST_METHOD)
class UsersControllerTest {

  private String adminToken;
  private String userToken;

  @Autowired TestRestTemplate restTemplate;
  @Autowired TokenUtils tokenUtils;

  @BeforeEach
  void setUp() {
   userToken = tokenUtils.generateTokenForUser(user());
   adminToken = tokenUtils.generateTokenForUser(admin());
  }

  @Test
  void getOneUser() {
    HttpHeaders headers = new HttpHeaders();
    headers.add("Authorization", "Bearer "+adminToken);
    headers.add("Access-Control-Expose-Headers", "Authorization");
    ResponseEntity<UserModel> result =
        restTemplate.exchange(
            "/users/userInfo", HttpMethod.GET, new HttpEntity<>(headers), UserModel.class);
    assertEquals("awesome@gmail.com", result.getBody().getEmail());
  }

Answer 1

看来我的项目中有两个依赖项

1)Sring-boot-starter-test2)我用mockito 3*添加了一堆jupiter依赖项

他们之间一直存在冲突。我已经删除了第二个，现在一切似乎都正常。