BigW Consortium Gitlab

mysql_ignore_postgresql_options.rb 1.68 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
# This patches ActiveRecord so indexes created using the MySQL adapter ignore
# any PostgreSQL specific options (e.g. `using: :gin`).
#
# These patches do the following for MySQL:
#
# 1. Indexes created using the :opclasses option are ignored (as they serve no
#    purpose on MySQL).
# 2. When creating an index with `using: :gin` the `using` option is discarded
#    as :gin is not a valid value for MySQL.
# 3. The `:opclasses` option is stripped from add_index_options in case it's
#    used anywhere other than in the add_index methods.

if defined?(ActiveRecord::ConnectionAdapters::Mysql2Adapter)
  module ActiveRecord
    module ConnectionAdapters
      class Mysql2Adapter < AbstractMysqlAdapter
        alias_method :__gitlab_add_index, :add_index
        alias_method :__gitlab_add_index_sql, :add_index_sql
        alias_method :__gitlab_add_index_options, :add_index_options

        def add_index(table_name, column_name, options = {})
          unless options[:opclasses]
            __gitlab_add_index(table_name, column_name, options)
          end
        end

        def add_index_sql(table_name, column_name, options = {})
          unless options[:opclasses]
            __gitlab_add_index_sql(table_name, column_name, options)
          end
        end

        def add_index_options(table_name, column_name, options = {})
Douwe Maan committed
34
          if options[:using] && options[:using] == :gin
35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
            options = options.dup
            options.delete(:using)
          end

          if options[:opclasses]
            options = options.dup
            options.delete(:opclasses)
          end

          __gitlab_add_index_options(table_name, column_name, options)
        end
      end
    end
  end
end