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 



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

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, index_name) ⇒ Object 



14
15
16
 
# File 'lib/ridgepole/ext/abstract_mysql_adapter/use_alter_index.rb', line 14

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