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屋！