We’ve said it before, and we’ll say it again – we are huge fans of the Yii Framework. This PHP framework is easy to understand, and even better, easy to create test cases. One of the most time consuming portions of writing the test suite, however, was getting your test data into Yii’s ‘fixture’ files. These fixture files correspond to data that would be in your database tables, but the files stay constant so you always have a known start state. That way, you can test your application easily at any time, ensuring that your recent build hasn’t broken any legacy functions.
Due to the fixture files, we had resorted to running a custom script that took data out of our production database and exported it to a fixture file. However, with a recent new installation of phpMyAdmin, we came across the PHP Array plugin. Using this plugin, you can easily export your table data into PHP array format – the same format that is needed for your Yii fixture files.
We hope this saves someone some time and hassle down the road!