Rake task to create Trigram indizes for a Redmine database (PostgreSQL only)

pg_trgm.rake

class CreatePostgresqlTrgmIndex
  def self.call(model, column, concurrently: true)
    table = model.table_name
    column = column.sub(/.*\./, "")
    puts sql = "CREATE INDEX #{"CONCURRENTLY" if concurrently} index_#{table}_on_#{column}_trgm ON #{table} USING gin (#{column} gin_trgm_ops)"
    model.connection.execute sql
  rescue ActiveRecord::StatementInvalid
    raise $! unless $!.message =~ /PG::Duplicate/
  end
end

namespace :redmine do
  namespace :pg_trgm do
    task setup: :environment do

      begin
        Project.connection.execute "create extension pg_trgm"
      rescue ActiveRecord::StatementInvalid
        # ignore the error if the extension is already set up
        raise $! unless $!.message =~ /PG::Duplicate/
      end


      [
        Changeset,
        Document,
        Issue,
        Project,
        Message,
        News,
      ].each do |model|
        model.searchable_options[:columns].each do |column|
          CreatePostgresqlTrgmIndex.(model, column)
        end
      end

      CreatePostgresqlTrgmIndex.(Attachment, "filename")
      CreatePostgresqlTrgmIndex.(Attachment, "description")
      CreatePostgresqlTrgmIndex.(WikiPage, "title")
      CreatePostgresqlTrgmIndex.(WikiContent, "text")

    end
  end
end