Module: Code0::ZeroTrack::Database::MigrationHelpers::RemoveColumnEnhancements

Included in:
Code0::ZeroTrack::Database::Migration::V1_0
Defined in:
lib/code0/zero_track/database/migration_helpers/remove_column_enhancements.rb

Instance Method Summary collapse

Instance Method Details

#remove_column(table_name, column_name, type = nil, **kwargs) ⇒ Object



8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
# File 'lib/code0/zero_track/database/migration_helpers/remove_column_enhancements.rb', line 8

def remove_column(table_name, column_name, type = nil, **kwargs)
  if type == :text
    limit = kwargs.delete(:limit)
    unique = kwargs.delete(:unique)

    if limit
      quoted_column_name = quote_column_name(column_name)
      name = text_limit_name(table_name, column_name)
      definition = "char_length(#{quoted_column_name}) <= #{limit}"

      remove_check_constraint(table_name, definition, name: name)
    end

    if unique.is_a?(Hash)
      quoted_column_name ||= quote_column_name(column_name)
      index_column = column_name
      unique[:where] = "#{column_name} IS NOT NULL" if unique.delete(:allow_nil_duplicate)
      index_column = "LOWER(#{quoted_column_name})" if unique.delete(:case_insensitive)

      remove_index table_name, index_column, unique: true, **unique
    elsif unique
      remove_index table_name, column_name, unique: unique
    end
  end

  super
end