Works with SQL dabatase.

The most important function of this module is cleaning database before each test. That's why this module was added into global configuration file: codeception.yml. To have your database properly cleaned you should configure it to access the database.

In order to have your database populated with data you need a raw SQL dump. Just put it in {% highlight yaml %} tests/_data {% endhighlight %} dir (by default) and specify path to it in config. Next time after database is cleared all your data will be restored from dump. Don't forget to include CREATE TABLE statements into it.

Performance may dramatically change when using SQLite file database storage. Consider converting your database into SQLite3 format with one of provided tools. While using SQLite database not recreated from SQL dump, but a database file is copied itself. So database repopulation is just about copying file.

Supported and tested databases are:

• MySQL
• SQLite (only file)
• PostgreSQL

Supported but not tested.

• MSSQL
• Orcale

Connection is done by database Drivers, which are stored in Codeception\Util\Driver namespace. Check out drivers if you get problems loading dumps and cleaning databases.

• dsn required - PDO DSN
• user required - user to access database
• password required - password
• dump - path to database dump.
• populate: true - should the dump be loaded before test suite is started.
• cleanup: true - should the dump be reloaded after each test

Also provides actions to perform checks in database.

• dbh - contains PDO connection.
• driver - contains Connection Driver. See list all available drivers

Effect is opposite to ->seeInDatabase

Checks if there is no record with such column values in database. Provide table name and column values.

Example:

{% highlight php %}