Unit Testing - Examining Database Records

I am creating some unit test for class methods which create/update
records in one or more tables.
What is the best way to check that this is done and assert the
results?

I would expect something like an unordered array of hashes compare
(with what I think should be in the db with what is in the db), but
before I build this myself is there something about this already
done? I’ve googled everywhere but all I find are validation test
examples.

Thanks!

I am (admittedly slowly) posting a multi-part tutorial on testing.
I’m hoping not just to make testing easy and less intimidating to
beginners, but also to examine what to test and how to write
meaningful tests.

I will be writing about unit testing ActiveRecord models next. (Maybe
by early next week?) It may answer your questions.

The series starts here:
http://www.nullislove.com/2007/11/10/testing-in-rails-introduction/

HTH,
Kevin S.