Howto: Run a rake task in sandbox mode

If you have a Rails rake task that somehow changes your DB data, but you want to be sure that the DB will be rolled back to its previous state after the rake task has completed, you can simply include this snippet right after your task definition:

	ActiveRecord::Base.connection.increment_open_transactions
	ActiveRecord::Base.connection.begin_db_transaction
	at_exit do
	ActiveRecord::Base.connection.rollback_db_transaction
	ActiveRecord::Base.connection.decrement_open_transactions
	end

view raw rollback.rb hosted with ❤ by GitHub

If you wonder where is this code coming from, it's directly from the rails console code.