January 17, 2025 at 12:00 am
Comments posted to this topic are about the item The Types of Changes
January 17, 2025 at 7:15 pm
At my last gig, I was asked to develop a testing framework in T-SQL for stored procedures used in a billing system.
This was a shop in which all the billing logic was encapsulated in stored procedures. Most of the stored procedures to be tested had the same parameter definitions and were expected produce data in certain target tables.
What we ended up doing was defining specific parameter inputs for whatever stored procedures we wanted to test and populating target tables with expected results.
We then had an outer stored procedure to coordinate the test run, executing whatever stored procedures we wanted to test using the defined parameter values, and then comparing the output with the expected outputs. If they matched, it would be a pass, otherwise a fail.
There was a bit more to it that I'm not mentioning but you should get the gist of it.
It was a SQL developer's dream to work on and it did the trick!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply