Module: ForAlterStatements

Included in:
ActiveRecord::ConnectionAdapters::Rails72DepartureAdapter, ActiveRecord::ConnectionAdapters::Rails80DepartureAdapter
Defined in:
lib/active_record/connection_adapters/for_alter.rb

Instance Method Summary collapse

Instance Method Details

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



71
72
73
74
75
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 71

def add_column_for_alter(table_name, column_name, type, options = {})
  td = create_table_definition(table_name)
  cd = td.new_column_definition(column_name, type, **options)
  schema_creation.accept(ActiveRecord::ConnectionAdapters::AddColumnDefinition.new(cd))
end

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



48
49
50
51
52
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 48

def add_index_for_alter(table_name, column_name, options = {})
  index_definition, = add_index_options(table_name, column_name, **options)

  "ADD #{schema_creation.accept(index_definition)}"
end

#add_timestamps_for_alter(table_name, options = {}) ⇒ Object 



60
61
62
63
64
65
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 60

def add_timestamps_for_alter(table_name, options = {})
  [
    add_column_for_alter(table_name, :created_at, :datetime, options),
    add_column_for_alter(table_name, :updated_at, :datetime, options)
  ]
end

#bulk_change_table(table_name, operations) ⇒ Object

:nodoc:



4
5
6
7
8
9
10
11
12
13
14
15
16
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 4

def bulk_change_table(table_name, operations) #:nodoc:
  sqls = operations.flat_map do |command, args|
    table = args.shift
    arguments = args

    method = :"#{command}_for_alter"

    raise "Unknown method called : #{method}(#{arguments.inspect})" unless respond_to?(method, true)
    public_send(method, table, *arguments)
  end.join(', ')

  execute("ALTER TABLE #{quote_table_name(table_name)} #{sqls}")
end

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



18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 18

def change_column_for_alter(table_name, column_name, type, options = {})
  column = column_for(table_name, column_name)
  type ||= column.sql_type

  options = {
    default: column.default,
    null: column.null,
    comment: column.comment
  }.merge(options)

  td = create_table_definition(table_name)
  cd = td.new_column_definition(column.name, type, **options)
  schema_creation.accept(ActiveRecord::ConnectionAdapters::ChangeColumnDefinition.new(cd, column.name))
end

#remove_column_for_alter(_table_name, column_name, _type = nil, _options = {}) ⇒ Object 



77
78
79
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 77

def remove_column_for_alter(_table_name, column_name, _type = nil, _options = {})
  "DROP COLUMN #{quote_column_name(column_name)}"
end

#remove_columns_for_alter(table_name, *column_names, **options) ⇒ Object 



81
82
83
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 81

def remove_columns_for_alter(table_name, *column_names, **options)
  column_names.map { |column_name| remove_column_for_alter(table_name, column_name) }
end

#remove_index_for_alter(table_name, column_name = nil, **options) ⇒ Object 



54
55
56
57
58
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 54

def remove_index_for_alter(table_name, column_name = nil, **options)
  index_name = index_name_for_remove(table_name, column_name, options)

  "DROP INDEX #{quote_column_name(index_name)}"
end

#remove_timestamps_for_alter(table_name, _options = {}) ⇒ Object 



67
68
69
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 67

def remove_timestamps_for_alter(table_name, _options = {})
  [remove_column_for_alter(table_name, :updated_at), remove_column_for_alter(table_name, :created_at)]
end

#rename_column_for_alter(table_name, column_name, new_column_name) ⇒ Object 



33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/active_record/connection_adapters/for_alter.rb', line 33

def rename_column_for_alter(table_name, column_name, new_column_name)
  column  = column_for(table_name, column_name)
  options = {
    default: column.default,
    null: column.null,
    auto_increment: column.auto_increment?
  }

  columns_sql = "SHOW COLUMNS FROM #{quote_table_name(table_name)} LIKE #{quote(column_name)}"
  current_type = exec_query(columns_sql, 'SCHEMA').first['Type']
  td = create_table_definition(table_name)
  cd = td.new_column_definition(new_column_name, current_type, **options)
  schema_creation.accept(ActiveRecord::ConnectionAdapters::ChangeColumnDefinition.new(cd, column.name))
end