Unit tests / code coverage for ASE stored procedures

[Former Member]

Hi All,

With Test Driven Development everywhere, I am trying to see how this can be used for the stored procedure development in ASE database as well. I could find a tool called dbunit (http://dbunit.sourceforge.net/) for writing unit test cases. I am able to write some test cases to connect to the ASE database.

The unit tests would be meaningful if we could get some useful coverage statistics (i.e.,) how much of the code is covered by the unit tests.

For the MS SQL Server, there seems to be a tool called - SQLCC (jbarker7/sqlcc · GitHub)

Is there any tool available for code coverage for ASE stored procedures ?

Thanks and regards,

-Subbu

[Former Member]

Not that I'm aware of.  I believe everyone is waiting on someone to undertake that task. 

jason

[Former Member]

One option, to write a code coverage tool would be via the use of set tracefile option. The trace file contains the line number of the executed stored procedures.

Reference link:

Application Tracing in ASE.pdf

http://wiki.scn.sap.com/wiki/download/attachments/394101270/Application%20Tracing%20in%20ASE.pdf?ver...