Search code examples
mysqlregexunit-testingstored-proceduresdatabase-testing

Stored procedures and unit testing

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)?

Solution

  • 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]