下面列出了org.springframework.test.context.jdbc.Sql#org.springframework.test.context.jdbc.SqlConfig 实例代码,或者点击链接到github查看源代码,也可以在右侧发表评论。
@Test
@SqlGroup({
@Sql(
value = "classpath:db/extra-data.sql",
config = @SqlConfig(encoding = "utf-8", separator = ";", commentPrefix = "--")
),
@Sql(
scripts = "classpath:db/delete-test-data.sql",
config = @SqlConfig(transactionMode = SqlConfig.TransactionMode.ISOLATED),
executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD
)
})
public void testCount() {
int count = userService.countUsers();
assertEquals(8, count);
}
@Test
@Sql(scripts = "/org/springframework/test/context/jdbc/schema.sql", //
config = @SqlConfig(separator = ";"))
@Sql("/org/springframework/test/context/jdbc/data-add-users-with-custom-script-syntax.sql")
public void methodLevelScripts() {
assertNumUsers(3);
}
@Test
@Sql(scripts = "/org/springframework/test/context/jdbc/schema.sql", //
config = @SqlConfig(separator = ";"))
@Sql("/org/springframework/test/context/jdbc/data-add-users-with-custom-script-syntax.sql")
public void methodLevelScripts() {
assertNumUsers(3);
}
@Test
@SqlGroup({
@Sql(value = "classpath:db/extra-data.sql", config = @SqlConfig(encoding = "utf-8", separator = ";", commentPrefix = "--")),
@Sql(
scripts = "classpath:db/delete-test-data.sql",
config = @SqlConfig(transactionMode = SqlConfig.TransactionMode.ISOLATED),
executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD
)
})
public void testCount() {
int count = userService.countUsers();
assertEquals(8, count);
}
@Test
@Sql(scripts = {"/import_senior_employees.sql"}, config = @SqlConfig(encoding = "utf-8", transactionMode = TransactionMode.ISOLATED))
public void testLoadDataForTestCase() {
assertEquals(5, employeeRepository.findAll()
.size());
}