Test ActiveRecord with Reset Transactions Without Rails

I found myself wanting to use Rails’ test transaction functionality in a Rails-less environment, and couldn’t find a tutorial about it. So I dug into the Rails source to figure out how it worked–just enough to pull it out into a gist. So, if you add this to your test_helper.rb or equivalent, you too can have your ActiveRecord tests wrapped in transactions that rollback after each case. It also lets you use fixtures, but who does that?

# Snippet to wrap tests with ActiveRecord db transactions outside Rails.
#
# references:
# https://github.com/rails/rails/blob/master/railties/lib/rails/test_help.rb#L27
# https://github.com/rails/rails/blob/master/activerecord/lib/active_record/fixtures.rb#L704
#
# TestFixtures checks whether configurations is blank
# to determine whether to use transactions/fixtures or not.
# which is why we need to set it to something.
ActiveRecord::Base.configurations= {test: {
database: 'something_test',
adapter: 'mysql',
# ...
}}
ActiveRecord::Base.establish_connection ActiveRecord::Base.configurations[:test]
class ActiveSupport::TestCase

This entry was posted on Monday, January 9th, 2012 at 8:23 pm and is filed under ruby. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.