Chris@0: require File.join(File.dirname(__FILE__), 'abstract_unit')
Chris@0: 
Chris@0: if ActiveRecord::Base.connection.supports_migrations? 
Chris@0:   class Thing < ActiveRecord::Base
Chris@0:     attr_accessor :version
Chris@0:     acts_as_versioned
Chris@0:   end
Chris@0: 
Chris@0:   class MigrationTest < Test::Unit::TestCase
Chris@0:     self.use_transactional_fixtures = false
Chris@0:     def teardown
Chris@0:       if ActiveRecord::Base.connection.respond_to?(:initialize_schema_information)
Chris@0:         ActiveRecord::Base.connection.initialize_schema_information
Chris@0:         ActiveRecord::Base.connection.update "UPDATE schema_info SET version = 0"
Chris@0:       else
Chris@0:         ActiveRecord::Base.connection.initialize_schema_migrations_table
Chris@0:         ActiveRecord::Base.connection.assume_migrated_upto_version(0)
Chris@0:       end
Chris@0:       
Chris@0:       Thing.connection.drop_table "things" rescue nil
Chris@0:       Thing.connection.drop_table "thing_versions" rescue nil
Chris@0:       Thing.reset_column_information
Chris@0:     end
Chris@0:         
Chris@0:     def test_versioned_migration
Chris@0:       assert_raises(ActiveRecord::StatementInvalid) { Thing.create :title => 'blah blah' }
Chris@0:       # take 'er up
Chris@0:       ActiveRecord::Migrator.up(File.dirname(__FILE__) + '/fixtures/migrations/')
Chris@0:       t = Thing.create :title => 'blah blah', :price => 123.45, :type => 'Thing'
Chris@0:       assert_equal 1, t.versions.size
Chris@0:       
Chris@0:       # check that the price column has remembered its value correctly
Chris@0:       assert_equal t.price,  t.versions.first.price
Chris@0:       assert_equal t.title,  t.versions.first.title
Chris@0:       assert_equal t[:type], t.versions.first[:type]
Chris@0:       
Chris@0:       # make sure that the precision of the price column has been preserved
Chris@0:       assert_equal 7, Thing::Version.columns.find{|c| c.name == "price"}.precision
Chris@0:       assert_equal 2, Thing::Version.columns.find{|c| c.name == "price"}.scale
Chris@0: 
Chris@0:       # now lets take 'er back down
Chris@0:       ActiveRecord::Migrator.down(File.dirname(__FILE__) + '/fixtures/migrations/')
Chris@0:       assert_raises(ActiveRecord::StatementInvalid) { Thing.create :title => 'blah blah' }
Chris@0:     end
Chris@0:   end
Chris@0: end