Research on Automated Testing of Stored Procedure
MA Zhu-gen · Computer Knowledge and Technology · 2009
Stored procedure test is an extremely tedious work.Some database products provide some tools to be able to make the statistics of the execution time of a stored procedure,the number of records and other information,but these tools can not carry on batch and repeated testing.Moreover,the test result is not intuitive.This paper describes the implementation scheme of stored procedure automation test under the junit framework.The code-reuse technique based automatic testing framework of Junit realizes the regression testing of procedure.The test cases are described and organized using XML to realize the separation between code and data in order to improve efficiency of test,and the test result using XML provides developers with an intuitive notation.