48 / 65 · 15 SQL & Database Testing · Stored Procedures and Triggers← prev⊞ allnext →☰ Read as one page
6.7Practical Exercise
- Write tests for a
calculate_order_totalfunction: normal case, empty order, large numbers, precision - Write tests for an
updated_attrigger: verify it changes on update - Write tests for an audit trail trigger: verify inserts, updates, and deletes are logged
- Write tests for a fund transfer procedure: success case, insufficient balance, same account
- Test a trigger that prevents deletion of admin users