Contents

# frozen_string_literal: true

class CreateSearchConfigurations < ActiveRecord::Migration[5.2]
  def up
    dictionaries.each do |dict|
      stem = dict == "simple" ? "simple" : "#{dict}_stem"

      ActiveRecord::Base.connection.execute <<-SQL.squish
        DROP TEXT SEARCH CONFIGURATION IF EXISTS #{dict}_unaccent;
        CREATE TEXT SEARCH CONFIGURATION #{dict}_unaccent
          (COPY = pg_catalog.#{dict});
        ALTER TEXT SEARCH CONFIGURATION #{dict}_unaccent
          ALTER MAPPING FOR hword, hword_part, word
          WITH unaccent, #{stem};
      SQL
    end
  end

  def down
    dictionaries.each do |dict|
      ActiveRecord::Base.connection.execute <<-SQL.squish
        DROP TEXT SEARCH CONFIGURATION IF EXISTS #{dict}_unaccent;
      SQL
    end
  end

  private

  def dictionaries
    %w[arabic danish dutch english finnish french german
       hungarian indonesian irish italian lithuanian nepali
       norwegian portuguese romanian russian spanish swedish
       tamil turkish simple]
  end
end

Version data entries

28 entries across 28 versions & 1 rubygems

Version	Path
pages_core-3.10.1	db/migrate/20210209151400_create_search_configurations.rb
pages_core-3.9.2	db/migrate/20210209151400_create_search_configurations.rb
pages_core-3.9.1	db/migrate/20210209151400_create_search_configurations.rb
pages_core-3.9.0	db/migrate/20210209151400_create_search_configurations.rb
pages_core-3.8.3	db/migrate/20210209151400_create_search_configurations.rb
pages_core-3.8.2	db/migrate/20210209151400_create_search_configurations.rb
pages_core-3.8.1	db/migrate/20210209151400_create_search_configurations.rb
pages_core-3.8.0	db/migrate/20210209151400_create_search_configurations.rb