require 'cases/helper'
module ActiveRecord
class Migration
class IndexTest < ActiveRecord::TestCase
attr_reader :connection, :table_name
def setup
super
@connection = ActiveRecord::Base.connection
@table_name = :testings
connection.create_table table_name do |t|
t.column :foo, :string, :limit => 100
t.column :bar, :string, :limit => 100
t.string :first_name
t.string :last_name, :limit => 100
t.string :key, :limit => 100
t.boolean :administrator
end
end
def teardown
super
connection.drop_table :testings rescue nil
ActiveRecord::Base.primary_key_prefix_type = nil
end
def test_rename_index
skip "not supported on openbase" if current_adapter?(:OpenBaseAdapter)
# keep the names short to make Oracle and similar behave
connection.add_index(table_name, [:foo], :name => 'old_idx')
connection.rename_index(table_name, 'old_idx', 'new_idx')
# if the adapter doesn't support the indexes call, pick defaults that let the test pass
refute connection.index_name_exists?(table_name, 'old_idx', false)
assert connection.index_name_exists?(table_name, 'new_idx', true)
end
def test_double_add_index
skip "not supported on openbase" if current_adapter?(:OpenBaseAdapter)
connection.add_index(table_name, [:foo], :name => 'some_idx')
assert_raises(ArgumentError) {
connection.add_index(table_name, [:foo], :name => 'some_idx')
}
end
def test_remove_nonexistent_index
skip "not supported on openbase" if current_adapter?(:OpenBaseAdapter)
# we do this by name, so OpenBase is a wash as noted above
assert_raise(ArgumentError) { connection.remove_index(table_name, "no_such_index") }
end
def test_add_index_name_length_limit
good_index_name = 'x' * connection.index_name_length
too_long_index_name = good_index_name + 'x'
assert_raises(ArgumentError) {
connection.add_index(table_name, "foo", :name => too_long_index_name)
}
refute connection.index_name_exists?(table_name, too_long_index_name, false)
connection.add_index(table_name, "foo", :name => good_index_name)
assert connection.index_name_exists?(table_name, good_index_name, false)
connection.remove_index(table_name, :name => good_index_name)
end
def test_index_symbol_names
connection.add_index table_name, :foo, :name => :symbol_index_name
assert connection.index_exists?(table_name, :foo, :name => :symbol_index_name)
connection.remove_index table_name, :name => :symbol_index_name
refute connection.index_exists?(table_name, :foo, :name => :symbol_index_name)
end
def test_index_exists
connection.add_index :testings, :foo
assert connection.index_exists?(:testings, :foo)
assert !connection.index_exists?(:testings, :bar)
end
def test_index_exists_on_multiple_columns
connection.add_index :testings, [:foo, :bar]
assert connection.index_exists?(:testings, [:foo, :bar])
end
def test_unique_index_exists
connection.add_index :testings, :foo, :unique => true
assert connection.index_exists?(:testings, :foo, :unique => true)
end
def test_named_index_exists
connection.add_index :testings, :foo, :name => "custom_index_name"
assert connection.index_exists?(:testings, :foo, :name => "custom_index_name")
end
def test_add_index_attribute_length_limit
connection.add_index :testings, [:foo, :bar], :length => {:foo => 10, :bar => nil}
assert connection.index_exists?(:testings, [:foo, :bar])
end
def test_add_index
connection.add_index("testings", "last_name")
connection.remove_index("testings", "last_name")
# Orcl nds shrt indx nms. Sybs 2.
# OpenBase does not have named indexes. You must specify a single column name
unless current_adapter?(:SybaseAdapter, :OpenBaseAdapter)
connection.add_index("testings", ["last_name", "first_name"])
connection.remove_index("testings", :column => ["last_name", "first_name"])
# Oracle adapter cannot have specified index name larger than 30 characters
# Oracle adapter is shortening index name when just column list is given
unless current_adapter?(:OracleAdapter)
connection.add_index("testings", ["last_name", "first_name"])
connection.remove_index("testings", :name => :index_testings_on_last_name_and_first_name)
connection.add_index("testings", ["last_name", "first_name"])
connection.remove_index("testings", "last_name_and_first_name")
end
connection.add_index("testings", ["last_name", "first_name"])
connection.remove_index("testings", ["last_name", "first_name"])
connection.add_index("testings", ["last_name"], :length => 10)
connection.remove_index("testings", "last_name")
connection.add_index("testings", ["last_name"], :length => {:last_name => 10})
connection.remove_index("testings", ["last_name"])
connection.add_index("testings", ["last_name", "first_name"], :length => 10)
connection.remove_index("testings", ["last_name", "first_name"])
connection.add_index("testings", ["last_name", "first_name"], :length => {:last_name => 10, :first_name => 20})
connection.remove_index("testings", ["last_name", "first_name"])
end
# quoting
# Note: changed index name from "key" to "key_idx" since "key" is a Firebird reserved word
# OpenBase does not have named indexes. You must specify a single column name
unless current_adapter?(:OpenBaseAdapter)
connection.add_index("testings", ["key"], :name => "key_idx", :unique => true)
connection.remove_index("testings", :name => "key_idx", :unique => true)
end
# Sybase adapter does not support indexes on :boolean columns
# OpenBase does not have named indexes. You must specify a single column
unless current_adapter?(:SybaseAdapter, :OpenBaseAdapter)
connection.add_index("testings", %w(last_name first_name administrator), :name => "named_admin")
connection.remove_index("testings", :name => "named_admin")
end
# Selected adapters support index sort order
if current_adapter?(:SQLite3Adapter, :MysqlAdapter, :Mysql2Adapter, :PostgreSQLAdapter)
connection.add_index("testings", ["last_name"], :order => {:last_name => :desc})
connection.remove_index("testings", ["last_name"])
connection.add_index("testings", ["last_name", "first_name"], :order => {:last_name => :desc})
connection.remove_index("testings", ["last_name", "first_name"])
connection.add_index("testings", ["last_name", "first_name"], :order => {:last_name => :desc, :first_name => :asc})
connection.remove_index("testings", ["last_name", "first_name"])
connection.add_index("testings", ["last_name", "first_name"], :order => :desc)
connection.remove_index("testings", ["last_name", "first_name"])
end
end
def test_add_partial_index
skip 'only on pg' unless current_adapter?(:PostgreSQLAdapter)
connection.add_index("testings", "last_name", :where => "first_name = 'john doe'")
assert connection.index_exists?("testings", "last_name")
connection.remove_index("testings", "last_name")
assert !connection.index_exists?("testings", "last_name")
end
end
end
end
