PHPUnit offers the possibility to perform tests based in database fixtures. The common way is like described in the PHPUnit documentation.
But what if you just want to have a small and different dataset on every test?
PHPUnit: use different dataset on every test in a testcase weiterlesen
It is always a pain to create datasets for testing. I know the code should make it possible to test without using the database, but this is not always the case. Phpmyadmin offers a good possibility to create datasets by exporting the needed data from a database. The problem here is that the exported format does not match the format needed for phpunit. After digging a while in the net I found out, that there are converters to do this, but they are for older versions of phpmyadmin. Since version 3.3.0 they changed their xml format.
So I decided to create my own converter:
Convert phpmyadmin to phpunit xml format weiterlesen