带有 spring JDBC 模板的 DAO：单元测试的最佳方法

发布于 2024-12-10 19:43:13 字数 543 浏览 0 评论 0原文

使用 Spring JDBC 模板构建的单元/集成测试 DAO 层类的最佳方法是什么？

我想到了三种方法：

1）Mock 库（EasyMock、JMock、Mockito 等） - Spring 框架测试代码使用这种方法 - 他们使用 EasyMock。

2) 嵌入式数据库（H2、HSQL、Derby）

3) 真实数据库 - 与生产中使用的产品相同，在我的例子中为 Sybase ASE - 显然有不同的模式。

Cons:
1)This may slow down unit test execution.
2)Schema is shared between different developers / CI server. So, need to make sure there is no concurrency issue.

有些人认为第一种和第二种方法并不是真正的测试。第二种方法的另一个问题是，我使用的数据库 Sybase ASE 似乎与其中任何一个都不兼容。

想了解最佳实践。

谢谢。

原文

What is the best way to unit/integration test DAO layer classes built using Spring JDBC templates?

Three approaches come to mind:

1) Mock library (EasyMock, JMock, Mockito, etc) - Spring framework test code makes use of this approach - They use EasyMock.

2) Embedded Database (H2, HSQL, Derby)

3) Real Database - Same product as used in production, Sybase ASE in my case - different schema obviously.

Cons:
1)This may slow down unit test execution.
2)Schema is shared between different developers / CI server. So, need to make sure there is no concurrency issue.

Some people argue that First and Second approaches are not real testing. Additional problem with Second approach is that, the database I use, Sybase ASE doesn't seem compatible with any of them.

Would like to know best practices.

Thanks.

分享到QQ

分享到微博