require "cases/migration/helper" module ActiveRecord class Migration class RenameTableTest < ActiveRecord::TestCase include ActiveRecord::Migration::TestHelper self.use_transactional_fixtures = false def setup super add_column 'test_models', :url, :string remove_column 'test_models', :created_at remove_column 'test_models', :updated_at end def teardown rename_table :octopi, :test_models if connection.table_exists? :octopi super end def test_rename_table_for_sqlite_should_work_with_reserved_words renamed = false skip "not supported" unless current_adapter?(:SQLite3Adapter) add_column :test_models, :url, :string connection.rename_table :references, :old_references connection.rename_table :test_models, :references renamed = true # Using explicit id in insert for compatibility across all databases connection.execute "INSERT INTO 'references' (url, created_at, updated_at) VALUES ('http://rubyonrails.com', 0, 0)" assert_equal 'http://rubyonrails.com', connection.select_value("SELECT url FROM 'references' WHERE id=1") ensure return unless renamed connection.rename_table :references, :test_models connection.rename_table :old_references, :references end def test_rename_table rename_table :test_models, :octopi # Using explicit id in insert for compatibility across all databases connection.enable_identity_insert("octopi", true) if current_adapter?(:SybaseAdapter) connection.execute "INSERT INTO octopi (#{connection.quote_column_name('id')}, #{connection.quote_column_name('url')}) VALUES (1, 'http://www.foreverflying.com/octopus-black7.jpg')" connection.enable_identity_insert("octopi", false) if current_adapter?(:SybaseAdapter) assert_equal 'http://www.foreverflying.com/octopus-black7.jpg', connection.select_value("SELECT url FROM octopi WHERE id=1") end def test_rename_table_with_an_index add_index :test_models, :url rename_table :test_models, :octopi # Using explicit id in insert for compatibility across all databases connection.enable_identity_insert("octopi", true) if current_adapter?(:SybaseAdapter) connection.execute "INSERT INTO octopi (#{connection.quote_column_name('id')}, #{connection.quote_column_name('url')}) VALUES (1, 'http://www.foreverflying.com/octopus-black7.jpg')" connection.enable_identity_insert("octopi", false) if current_adapter?(:SybaseAdapter) assert_equal 'http://www.foreverflying.com/octopus-black7.jpg', connection.select_value("SELECT url FROM octopi WHERE id=1") assert connection.indexes(:octopi).first.columns.include?("url") end def test_rename_table_for_postgresql_should_also_rename_default_sequence skip 'not supported' unless current_adapter?(:PostgreSQLAdapter) rename_table :test_models, :octopi pk, seq = connection.pk_and_sequence_for('octopi') assert_equal "octopi_#{pk}_seq", seq end end end end