class ActiveRecord::Migration::RenameTableTest

Public Instance Methods

setup() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 12
def setup
  super
  add_column "test_models", :url, :string
  remove_column "test_models", :created_at
  remove_column "test_models", :updated_at
end
teardown() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 19
def teardown
  rename_table :octopi, :test_models if connection.table_exists? :octopi
  super
end
test_rename_table() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 45
def test_rename_table
  rename_table :test_models, :octopi

  connection.execute "INSERT INTO octopi (#{connection.quote_column_name('id')}, #{connection.quote_column_name('url')}) VALUES (1, 'http://www.foreverflying.com/octopus-black7.jpg')"

  assert_equal "http://www.foreverflying.com/octopus-black7.jpg", connection.select_value("SELECT url FROM octopi WHERE id=1")
end
test_rename_table_does_not_rename_custom_named_index() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 66
def test_rename_table_does_not_rename_custom_named_index
  add_index :test_models, :url, name: "special_url_idx"

  rename_table :test_models, :octopi

  assert_equal ["special_url_idx"], connection.indexes(:octopi).map(&:name)
end
test_rename_table_for_postgresql_should_also_rename_default_sequence() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 76
def test_rename_table_for_postgresql_should_also_rename_default_sequence
  rename_table :test_models, :octopi

  pk, seq = connection.pk_and_sequence_for("octopi")

  assert_equal ConnectionAdapters::PostgreSQL::Name.new("public", "octopi_#{pk}_seq"), seq
end
test_rename_table_for_sqlite_should_work_with_reserved_words() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 25
def test_rename_table_for_sqlite_should_work_with_reserved_words
  renamed = false

  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://rubyonquails.com', 0, 0)"
  assert_equal "http://rubyonquails.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
test_rename_table_with_an_index() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 53
def test_rename_table_with_an_index
  add_index :test_models, :url

  rename_table :test_models, :octopi

  connection.execute "INSERT INTO octopi (#{connection.quote_column_name('id')}, #{connection.quote_column_name('url')}) VALUES (1, 'http://www.foreverflying.com/octopus-black7.jpg')"

  assert_equal "http://www.foreverflying.com/octopus-black7.jpg", connection.select_value("SELECT url FROM octopi WHERE id=1")
  index = connection.indexes(:octopi).first
  assert_includes index.columns, "url"
  assert_equal "index_octopi_on_url", index.name
end
test_renaming_table_doesnt_attempt_to_rename_non_existent_sequences() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 106
def test_renaming_table_doesnt_attempt_to_rename_non_existent_sequences
  connection.create_table :cats, id: :uuid, default: "uuid_generate_v4()"
  assert_nothing_raised { rename_table :cats, :felines }
  assert connection.table_exists? :felines
  refute connection.table_exists? :cats
ensure
  connection.drop_table :cats, if_exists: true
  connection.drop_table :felines, if_exists: true
end
test_renaming_table_renames_primary_key() click to toggle source
# File activerecord/test/cases/migration/rename_table_test.rb, line 84
        def test_renaming_table_renames_primary_key
          connection.create_table :cats, id: :uuid, default: "uuid_generate_v4()"
          rename_table :cats, :felines

          assert connection.table_exists? :felines
          refute connection.table_exists? :cats

          primary_key_name = connection.select_values(<<-SQL.strip_heredoc, "SCHEMA")[0]
            SELECT c.relname
              FROM pg_class c
              JOIN pg_index i
                ON c.oid = i.indexrelid
             WHERE i.indisprimary
               AND i.indrelid = 'felines'::regclass
          SQL

          assert_equal "felines_pkey", primary_key_name
        ensure
          connection.drop_table :cats, if_exists: true
          connection.drop_table :felines, if_exists: true
        end