How To Get Sample Data Into Test Db?

[XavierJohn]

How to get sample data into test db?

Per the documentation, fixtures should only be used for data that changes. http://www.yiiframework.com/doc/guide/1.1/en/test.fixture

Tip: Having too many fixture files could increase the test time dramatically. For this reason, you should only provide fixture files for those tables whose content may change during the test. Tables that serve as look-ups do not change and thus do not need fixture files.

migration scripts would work if it can be conditioned to run only against the test db.

I need to get a few rows of data into my db, and it will not change during testing.

For now I am going to use http://www.yiiframework.com/doc/api/1.1/CDbMigration#getDbConnection-detail

method to figure out if I am using the test connection to insert test row.