Class ActiveRecord::Migration::ReferencesIndexTest < ActiveRecord::TestCase

# File activerecord/test/cases/migration/references_index_test.rb, line 8
def setup
  super
  @connection = ActiveRecord::Base.connection
  @table_name = :testings
end

# File activerecord/test/cases/migration/references_index_test.rb, line 18
def test_creates_index
  connection.create_table table_name do |t|
    t.references :foo, :index => true
  end

  assert connection.index_exists?(table_name, :foo_id, :name => :index_testings_on_foo_id)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 62
def test_creates_index_for_existing_table
  connection.create_table table_name
  connection.change_table table_name do |t|
    t.references :foo, :index => true
  end

  assert connection.index_exists?(table_name, :foo_id, :name => :index_testings_on_foo_id)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 42
def test_creates_index_with_options
  connection.create_table table_name do |t|
    t.references :foo, :index => {:name => :index_testings_on_yo_momma}
    t.references :bar, :index => {:unique => true}
  end

  assert connection.index_exists?(table_name, :foo_id, :name => :index_testings_on_yo_momma)
  assert connection.index_exists?(table_name, :bar_id, :name => :index_testings_on_bar_id, :unique => true)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 53
def test_creates_polymorphic_index
  connection.create_table table_name do |t|
    t.references :foo, :polymorphic => true, :index => true
  end

  assert connection.index_exists?(table_name, [:foo_type, :foo_id], name: :index_testings_on_foo_type_and_foo_id)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 90
def test_creates_polymorphic_index_for_existing_table
  connection.create_table table_name
  connection.change_table table_name do |t|
    t.references :foo, :polymorphic => true, :index => true
  end

  assert connection.index_exists?(table_name, [:foo_type, :foo_id], name: :index_testings_on_foo_type_and_foo_id)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 26
def test_does_not_create_index
  connection.create_table table_name do |t|
    t.references :foo
  end

  assert_not connection.index_exists?(table_name, :foo_id, :name => :index_testings_on_foo_id)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 34
def test_does_not_create_index_explicit
  connection.create_table table_name do |t|
    t.references :foo, :index => false
  end

  assert_not connection.index_exists?(table_name, :foo_id, :name => :index_testings_on_foo_id)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 71
def test_does_not_create_index_for_existing_table
  connection.create_table table_name
  connection.change_table table_name do |t|
    t.references :foo
  end

  assert_not connection.index_exists?(table_name, :foo_id, :name => :index_testings_on_foo_id)
end

# File activerecord/test/cases/migration/references_index_test.rb, line 80
def test_does_not_create_index_for_existing_table_explicit
  connection.create_table table_name
  connection.change_table table_name do |t|
    t.references :foo, :index => false
  end

  assert_not connection.index_exists?(table_name, :foo_id, :name => :index_testings_on_foo_id)
end