Libor Nenadál - 2008-02-18

I'm stuck at a quite simple testing scenario. I have a procedural wrapper for table insert. And I want to test it inserts row into the specified table.


  insert_cust("John", "Brown");

and than want to issue:
select name, surname from customers;

and make sure it contains row with John Brown.

As the procedure does not return any value I can not use test tag. I thought I could use diff tag and issue the procedure call in prepare phase but it is not allowed. :-/ So should I create one test where I call the procedure and than second test where I issue select statement and compare it to the result set (the actual test)? It is a bit clumsy, don't you think?

Thanks in advance for any clue.