Load fixtures to Testdb with PHPUnit and extbase

Question

I search for a way to load test-data to a MySQL in my phpunit testcase. I use typo3 4.5 and want to test my pages-override and some functions in my testcase. I don't want to create all models ever and ever by hand, and would like to load a test-db and some sql-file for each test. Is this possible?

Answer 1

I resolved this problem by loading a complete testdatabase in my setup method. It works for me. For some inserts i will try to use

 function setUp() { $this->db->exec("BEGIN"); }
 function tearDown() { $this->db->exec("ROLLBACK"); }

like here