3 ms·
I always enjoy reading about new ways of doing things, so thanks! How would you test your logic in isolation with unit tests using an architecture like this?
by michaelmcmillan 11y ago
I always enjoy reading about new ways of doing things, so thanks! How would you test your logic in isolation with unit tests using an architecture like this?
- vp89 11y agoThe same way you test any other piece of code. A stored procedure is just an encapsulation of logic, with inputs and possibly state changes and/or outputs. Expected/actual asserts can be coded in SQL. The code tends to be verbose, but some RDBMS have evolved to include more powerful language features. It's probably possible in almost all RDBMS, but certainly easier in some than others.