Ruby Critic

Updated 2016-05-27 14:12:35 +0100

db/migrate / 20160527112417_add_index_to_signature_name.rb

24 lines of codes

3 methods

2.8 complexity/method

1 churn

8.25 complexity

0 duplications

code
1 smell

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

  def up
    unless index_exists?(:signatures, :name)
      execute <<-SQL
        CREATE INDEX CONCURRENTLY index_signatures_on_name
        ON signatures USING btree ((lower(name)));
      SQL
    end
  end

  def down
    if index_exists?(:signatures, :name)
      remove_index :signatures, :name
    end
  end

  private

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