Module: Ridgepole::Ext::AbstractMysqlAdapter::UseAlterIndex

Included in:
ActiveRecord::ConnectionAdapters::AbstractMysqlAdapter
Defined in:
lib/ridgepole/ext/abstract_mysql_adapter/use_alter_index.rb

Instance Method Summary collapse

Instance Method Details

#add_index(table_name, column_name, options = {}) ⇒ Object 



9
10
11
12
13
14
 
# File 'lib/ridgepole/ext/abstract_mysql_adapter/use_alter_index.rb', line 9

def add_index(table_name, column_name, options = {})
  index_name, index_type, index_columns, index_options, _index_algorithm, index_using = add_index_options(table_name, column_name, options)

  # cannot specify index_algorithm
  execute "ALTER TABLE #{quote_table_name(table_name)} ADD #{index_type} INDEX #{quote_column_name(index_name)} #{index_using} (#{index_columns})#{index_options}"
end

#remove_index(table_name, options) ⇒ Object 



16
17
18
19
 
# File 'lib/ridgepole/ext/abstract_mysql_adapter/use_alter_index.rb', line 16

def remove_index(table_name, options)
  index_name = index_name_for_remove(table_name, options)
  execute "ALTER TABLE #{quote_table_name(table_name)} DROP INDEX #{quote_column_name(index_name)}"
end