Ruby Critic

Updated 2019-04-05 22:01:33 +0100

db/migrate / 20190405201240_add_normalized_email_index_to_archived_signatures.rb

27 lines of codes

3 methods

2.8 complexity/method

1 churn

8.25 complexity

0 duplications

code
1 smell

class AddNormalizedEmailIndexToArchivedSignatures < ActiveRecord::Migration                                        IrresponsibleModule              
      AddNormalizedEmailIndexToArchivedSignatures has no descriptive comment          
  
  disable_ddl_transaction!

  def up
    unless index_exists?(:archived_signatures, :normalized_email)
      execute <<-SQL
        CREATE INDEX CONCURRENTLY index_archived_signatures_on_normalized_email
        ON archived_signatures USING btree ((
          REGEXP_REPLACE(LEFT(email, POSITION('@' IN email) - 1), '\.|\+.+', '', 'g') ||
          SUBSTRING(email FROM POSITION('@' IN email))
        ));
      SQL
    end
  end

  def down
    if index_exists?(:archived_signatures, :normalized_email)
      remove_index :archived_signatures, :normalized_email
    end
  end

  private

  def index_exists?(table, names)
    select_value("SELECT to_regclass('index_#{table}_on_#{Array(names).join('_and_')}')")
  end
end