When I use test fixtures to populate test data into mysql database I am
running into an unexpected behavior. Only columns explicitly defined
in the fixture is populated into the database. However, created_on,
created_by, updated_on, updated_by fields along with all fields
normally populated by observers are NULL. For example, I have a couple
fields that have their values calculated via observers. I want to test
that these calculations are performed correctly by the observer, so I
don't want to hard code their values in the fixture.
Has anyone else run into this issue? If so, how did you perform
testing of these fields? I realize that I could perform these tests
without fixtures by creating and saving the object. Behind the scenes,
Active Record populates all the fields in the expected manner. Then I
could find the saved record and assert_equal the expected calculations.
However this approach seems brittle and I rather use fixtures. It
doesn't seem (from the results) that I am getting that the fixtures
functionality uses Active Record to serialize data to mysql.