存储过程和单元测试
有谁知道一个框架(或方法)仅使用 SQL 来对存储过程进行单元测试,并能够生成关于已通过和已失败的合理报告(类似于 CPPUnit)?
Does anybody know of a framework (or methodology) to unit test stored procedures just using SQL and be able to produce a reasonable report as to what has passed and what has failed (something similar to CPPUnit)?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
MyTAP 可能就是您正在寻找的,您可以在 Github 中找到它,
它将自己描述为:“使用函数和过程编写的 MySQL 5.x 单元测试框架。”它包括一系列 TAP 发射断言函数,以及与其他 TAP 发射测试框架集成的能力。'
MyTAP 现在托管在
[https://github.com/hepabolu/ mytap][1]
MyTAP will probably be what you are looking for, you can find it in Github
it describes itself as: 'a unit testing framework for MySQL 5.x written using fuctions and procedures. It includes a collection of TAP-emitting assertion functions, as well as the ability to integrate with other TAP-emitting test frameworks.'
MyTAP is now hosted at
[https://github.com/hepabolu/mytap][1]
也许你想尝试 STK/Unit,它是用纯 SQL 编写的,支持 Test Case 和 Test Suite 的思想。此外,支持预期。
http://stk.wikidot.com/stk-unit
Maybe you want to try STK/Unit, which is written in pure SQL and supports the ideas of Test Case and Test Suite. Also, supports expectations.
http://stk.wikidot.com/stk-unit