On PHPMaster.com today there's a new tutorial posted about improving on the PHPUnit database testing extension to allow you do other non-query (select) operations - the "C" and "UD" in the typical "CRUD".
In a previous article I discussed how you can create more robust code that queries your relational database through automated testing. But, as you know, querying is just one part of the picture. There are still other database operations, namely create, update, and delete. Just like retrieval, they too should be tested. I’ll be exploring the other features of PHPUnit’s Database Extensions in this article while building on your knowledge of database testing in PHP.
He helps you get the test environment, complete with the base SQL structure, and the data to test against (and XML structure). They include the sample code to create the test itself and the results when the tests are executed.