I’ve been using Codeception for some acceptance testing recently. The project has a large database and using the standard Codeception database module that rebuilds the entire DB from an SQL dump was too slow.
All I needed to do was run a few queries to put some tables into a known state. I made a helper module that will run all .sql files in a directory.
I’ve put the DbHelper on Github and hopefully it will be useful for others.