Unit tests not flush db changes on disk. How to disable?

Yii 2.0 General Discussions
1

Hello. I got simple ActiveRecord model and unit tests for that, with one adding test.
In the test i just fill model fields and call $model->save(). After that, test check tables row count. Success - there was 0 rows and now 1 row verified (checks by field values success too).

But if i look in the table after test is done (by mysql client or pma), i see a 0 rows there. If i put sleep(60) in the tests code, and go to PMA - i see 0 rows there. But yii2+codecept see this row.

I think tests works in the one big transaction and not flushing on disk. How can i disable it?

2

This question was answered on StackOverflow.

But you would need to change the config.php file in Codeception as they outline in their docs:

transaction - (default: true) wrap all database connection inside a transaction and roll it back after the > test. Should be disabled for acceptance testing.