PL/SQL 的单元测试 [英] Unit testing for PL/SQL

问题描述

任何人都有任何用于单元测试 PL/SQL 的经验或工具.我见过的最好看的工具似乎是 Quests Code Tester，但我不确定它与持续集成工具或命令行测试的集成效果如何?

Anyone have any experience or tools for unit testing PL/SQL. The best looking tool I've seen for this seems to be Quests Code Tester, but i'm not sure how well that would integration with continuous integration tools or command line testing?

推荐答案

我使用 utPLSQL 作为框架，使用 OUnit 作为客户端.utPLSQL 并不是真的要单独使用，需要一个好的图形客户端.OUnit 是 Qute 的前身.Qute 也是一个很好的工具，但比我的要求更复杂 - 它允许您使用 GUI 构建测试并执行诸如测试代码生成之类的好东西.

I use utPLSQL as the framework and OUnit as the client. utPLSQL isn't really meant to be used by itself, a good graphical client is required. OUnit is the predecessor to Qute. Qute is also a good tool but more complex than my requirements - it allows you to construct tests using a GUI and does good stuff like test code generation.

我的理解是 utPLSQL 将所有结果存储在数据库表中，包括所有历史结果，这将成为收集持续集成统计数据的良好数据源.您还可以定义测试组，以便对 utPLSQL 的单个调用可以调用多个测试包.

My understanding is that utPLSQL stores all results in database tables, including all historical results which would make a good data source for gathering statistics for continuous integration. You can also define test groups so a single call to utPLSQL can call multiple test packages.

这篇关于PL/SQL 的单元测试的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！