How to create an automation structure for a database

Question

Recently, I came across an interview question: "If there is a database containing many stored procedures and functions, then how would you develop and develop the basics for testing automation?"

How would you answer this question?

Answer 1

Well, I would start by asking which tests are: unit tests? system / integration tests? regression tests? Is this a one-time exercise to (say) test the success of a database upgrade process? Or is it the basis for moving a database layer into a TDD project?

" ", , . , dbUnit. , , . .

: API, API - (.. DML)? .

Answer 2

" " .
, , , "" "".
:

• , (idealResults.txt)
• say (currentResults.txt)
• idealResults.txt currentResults.txt. , ( perl script ).
  , .

Answer 3

iterate over processes and functions and generate code to call them with specific parameters?