Rollback of database transactions should support multiple databases.

I have an application with two databases.

I setup models as so

class VqdataBase < ActiveRecord::Base
  establish_connection "otherdb_#{RAILS_ENV}"
  self.abstract_class = true
end 

class Video < VqdataBase
end

I do the following for migrations

class InitialSetup < ActiveRecord::Migration
  def self.connection  
    VqdataBase.connection
  end 
end

This works fine except in testing. The second database doesn't have any changes made to it rolled back.

The following patch ensures that all DBs have a rolled back connection

=== modified file 'vendor/rails/activerecord/lib/active_record/fixtures.rb'
--- vendor/rails/activerecord/lib/active_record/fixtures.rb     2009-12-07 23:56:25 +0000
+++ vendor/rails/activerecord/lib/active_record/fixtures.rb     2009-12-08 12:32:39 +0000
@@ -928,9 +928,11 @@
           load_fixtures
           @@already_loaded_fixtures[self.class] = @loaded_fixtures
         end
-        ActiveRecord::Base.connection.increment_open_transactions
-        ActiveRecord::Base.connection.transaction_joinable = false
-        ActiveRecord::Base.connection.begin_db_transaction
+        ActiveRecord::Base.connection_handler.connection_pools.values.map {|pool| pool.connection}.each do |c|
+          c.increment_open_transactions
+          c.transaction_joinable = false
+          c.begin_db_transaction
+        end
       # Load fixtures for every test.
       else
         Fixtures.reset_cache
@@ -950,9 +952,11 @@
       end
 
       # Rollback changes if a transaction is active.
-      if run_in_transaction? && ActiveRecord::Base.connection.open_transactions != 0
-        ActiveRecord::Base.connection.rollback_db_transaction
-        ActiveRecord::Base.connection.decrement_open_transactions
+      ActiveRecord::Base.connection_handler.connection_pools.values.map {|pool| pool.connection}.each do |c|
+        if run_in_transaction? && c.open_transactions != 0
+          c.rollback_db_transaction
+          c.decrement_open_transactions
+        end
       end
       ActiveRecord::Base.clear_active_connections!
     end