class ActiveRecord::Migration::RenameTableTest
Public Instance Methods
setup()
click to toggle source
Calls superclass method
ActiveRecord::Migration::TestHelper#setup
# 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
Calls superclass method
ActiveRecord::Migration::TestHelper#teardown
# 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