4 ms·
Why would testing stored procedures be "prohibitely difficult"? Just create a new test database, populate it with test data, call the function with test inputs
by devit 5y ago
Why would testing stored procedures be "prohibitely difficult"?
Just create a new test database, populate it with test data, call the function with test inputs and assert that the return value and the SQL dump of the resulting state of the database are what you expect.
- dmitryminkovsky 5y agoThat's a lot harder than unit testing, for me at least. When you have a small team (or a team consisting of 1 person :)) there are just so many other things you'll end up needing to do before properly verifying functions that "work."