Ruby Critic

Updated 2017-09-09 10:51:33 +0100
db/migrate / 20170909092251_migrate_archived_signature_indexes_to_partial_indexes.rb

53 lines of codes
3 methods
8.7 complexity/method
1 churn
25.98 complexity
40 duplications
class MigrateArchivedSignatureIndexesToPartialIndexes < ActiveRecord::Migration                                        IrresponsibleModule              
      MigrateArchivedSignatureIndexesToPartialIndexes has no descriptive comment          
  
  disable_ddl_transaction!

  def up
    unless index_exists?(:archived_signatures, name: "index_archived_signatures_on_petition_id_where_creator_is_true")
      add_index :archived_signatures, :petition_id,
        where: "creator = 't'",  unique: true, algorithm: :concurrently,
        name: "index_archived_signatures_on_petition_id_where_creator_is_true"
    end

    unless index_exists?(:archived_signatures, name: "index_archived_signatures_on_petition_id_where_sponsor_is_true")                                        DuplicateCode              
      Similar code found in 2 nodes              Locations:                  0                  1                  
  
      add_index :archived_signatures, :petition_id,
        where: "sponsor = 't'", algorithm: :concurrently,
        name: "index_archived_signatures_on_petition_id_where_sponsor_is_true"
    end

    if index_exists?(:archived_signatures, [:creator, :petition_id])
      remove_index :archived_signatures, [:creator, :petition_id]
    end

    if index_exists?(:archived_signatures, [:sponsor, :petition_id])
      remove_index :archived_signatures, [:sponsor, :petition_id]
    end
  end

  def down
    if index_exists?(:archived_signatures, name: "index_archived_signatures_on_petition_id_where_creator_is_true")
      remove_index :archived_signatures, name: "index_archived_signatures_on_petition_id_where_creator_is_true"
    end

    if index_exists?(:archived_signatures, name: "index_archived_signatures_on_petition_id_where_sponsor_is_true")
      remove_index :archived_signatures, name: "index_archived_signatures_on_petition_id_where_sponsor_is_true"
    end

    unless index_exists?(:archived_signatures, [:creator, :petition_id])
      add_index :archived_signatures, [:creator, :petition_id]
    end

    unless index_exists?(:archived_signatures, [:sponsor, :petition_id])
      add_index :archived_signatures, [:sponsor, :petition_id]
    end
  end

  private

  def index_exists?(table, names_or_options)                                        DuplicateCode              
      Identical code found in 2 nodes              Locations:                  0                  1                  
  
    if names_or_options.is_a?(Hash)
      select_value("SELECT to_regclass('#{names_or_options[:name]}')")
    else
      select_value("SELECT to_regclass('index_#{table}_on_#{Array(names_or_options).join('_and_')}')")
    end
  end
end