Unit testing
Unit testing is a process in software development that makes it possible to find errors in various components or modules in an application. In databases, those components are stored procedures, functions, triggers, and so on. A view definition, or even the SQL code of queries that applications use, can also be the subject of unit testing.
The idea behind unit testing is that for every module of a software system, such as a class or a function, there is a set of tests that invokes that module with a certain input data and checks whether the outcome of the invocation matches the expected result.
If the function being tested does not have any side-effects, meaning that it does not change any data or state of a component outside ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access