Class ActiveRecord::Migration::TableAndIndexTest < ActiveRecord::TestCase

# File activerecord/test/cases/migration/table_and_index_test.rb, line 6
def test_add_schema_info_respects_prefix_and_suffix
  conn = ActiveRecord::Base.connection

  conn.drop_table(ActiveRecord::Migrator.schema_migrations_table_name) if conn.table_exists?(ActiveRecord::Migrator.schema_migrations_table_name)
  # Use shorter prefix and suffix as in Oracle database identifier cannot be larger than 30 characters
  ActiveRecord::Base.table_name_prefix = 'p_'
  ActiveRecord::Base.table_name_suffix = '_s'
  conn.drop_table(ActiveRecord::Migrator.schema_migrations_table_name) if conn.table_exists?(ActiveRecord::Migrator.schema_migrations_table_name)

  conn.initialize_schema_migrations_table

  assert_equal "p_unique_schema_migrations_s", conn.indexes(ActiveRecord::Migrator.schema_migrations_table_name)[0][:name]
ensure
  ActiveRecord::Base.table_name_prefix = ""
  ActiveRecord::Base.table_name_suffix = ""
end