path: root/activerecord/test/cases/migration/table_and_index_test.rb

require "cases/helper"

module ActiveRecord
  class Migration
    class TableAndIndexTest < ActiveRecord::TestCase
      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
    end
  end
end