Railsドキュメント

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_definitions.rb, line 406
def change(column_name, type, options = {})
  @base.change_column(@table_name, column_name, type, options)
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 158
def create_table(table_name, options = {})
  td = table_definition
  td.primary_key(options[:primary_key] || Base.get_primary_key(table_name.to_s.singularize)) unless options[:id] == false

  yield td if block_given?

  if options[:force] && table_exists?(table_name)
    drop_table(table_name, options)
  end

  create_sql = "CREATE#{' TEMPORARY' if options[:temporary]} TABLE "
  create_sql << "#{quote_table_name(table_name)} ("
  create_sql << td.to_sql
  create_sql << ") #{options[:options]}"
  execute create_sql
  td.indexes.each_pair { |c,o| add_index table_name, c, o }
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 311
def rename_table(table_name, new_name)
  raise NotImplementedError, "rename_table is not implemented"
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 320
def drop_table(table_name, options = {})
  execute "DROP TABLE #{quote_table_name(table_name)}"
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 298
def change_table(table_name, options = {})
  if supports_bulk_alter? && options[:bulk]
    recorder = ActiveRecord::Migration::CommandRecorder.new(self)
    yield Table.new(table_name, recorder)
    bulk_change_table(table_name, recorder.commands)
  else
    yield Table.new(table_name, self)
  end
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 210
def create_join_table(table_1, table_2, options = {})
  join_table_name = find_join_table_name(table_1, table_2, options)

  column_options = options.delete(:column_options) || {}
  column_options.reverse_merge!(null: false)

  t1_column, t2_column = [table_1, table_2].map{ |t| t.to_s.singularize.foreign_key }

  create_table(join_table_name, options.merge!(id: false)) do |td|
    td.integer t1_column, column_options
    td.integer t2_column, column_options
    yield td if block_given?
  end
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 23
def table_exists?(table_name)
  tables.include?(table_name.to_s)
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 231
def drop_join_table(table_1, table_2, options = {})
  join_table_name = find_join_table_name(table_1, table_2, options)
  drop_table(join_table_name)
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 326
def add_column(table_name, column_name, type, options = {})
  add_column_sql = "ALTER TABLE #{quote_table_name(table_name)} ADD #{quote_column_name(column_name)} #{type_to_sql(type, options[:limit], options[:precision], options[:scale])}"
  add_column_options!(add_column_sql, options)
  execute(add_column_sql)
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 374
def rename_column(table_name, column_name, new_column_name)
  raise NotImplementedError, "rename_column is not implemented"
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 358
def change_column(table_name, column_name, type, options = {})
  raise NotImplementedError, "change_column is not implemented"
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 349
def remove_column(table_name, column_name, type = nil, options = {})
  execute "ALTER TABLE #{quote_table_name(table_name)} DROP #{quote_column_name(column_name)}"
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 335
def remove_columns(table_name, *column_names)
  raise ArgumentError.new("You must specify at least one column name. Example: remove_columns(:people, :first_name)") if column_names.empty?
  column_names.each do |column_name|
    remove_column(table_name, column_name)
  end
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 367
def change_column_default(table_name, column_name, default)
  raise NotImplementedError, "change_column_default is not implemented"
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 70
def column_exists?(table_name, column_name, type = nil, options = {})
  columns(table_name).any?{ |c| c.name == column_name.to_s &&
                                (!type                     || c.type == type) &&
                                (!options.key?(:limit)     || c.limit == options[:limit]) &&
                                (!options.key?(:precision) || c.precision == options[:precision]) &&
                                (!options.key?(:scale)     || c.scale == options[:scale]) &&
                                (!options.key?(:default)   || c.default == options[:default]) &&
                                (!options.key?(:null)      || c.null == options[:null]) }
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 424
def add_index(table_name, column_name, options = {})
  index_name, index_type, index_columns, index_options = add_index_options(table_name, column_name, options)
  execute "CREATE #{index_type} INDEX #{quote_column_name(index_name)} ON #{quote_table_name(table_name)} (#{index_columns})#{index_options}"
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 451
def rename_index(table_name, old_name, new_name)
  # this is a naive implementation; some DBs may support this more efficiently (Postgres, for instance)
  old_index_def = indexes(table_name).detect { |i| i.name == old_name }
  return unless old_index_def
  remove_index(table_name, :name => old_name)
  add_index(table_name, old_index_def.columns, :name => new_name, :unique => old_index_def.unique)
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 439
def remove_index(table_name, options = {})
  remove_index!(table_name, index_name_for_remove(table_name, options))
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 43
def index_exists?(table_name, column_name, options = {})
  column_names = Array(column_name)
  index_name = options.key?(:name) ? options[:name].to_s : index_name(table_name, :column => column_names)
  if options[:unique]
    indexes(table_name).any?{ |i| i.unique && i.name == index_name }
  else
    indexes(table_name).any?{ |i| i.name == index_name }
  end
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_definitions.rb, line 397
def timestamps
  @base.add_timestamps(@table_name)
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 610
def add_timestamps(table_name)
  add_column table_name, :created_at, :datetime
  add_column table_name, :updated_at, :datetime
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_definitions.rb, line 460
def references(*args)
  options = args.extract_options!
  args.each do |ref_name|
    @base.add_reference(@table_name, ref_name, options)
  end
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 495
def add_reference(table_name, ref_name, options = {})
  polymorphic = options.delete(:polymorphic)
  index_options = options.delete(:index)
  add_column(table_name, "#{ref_name}_id", :integer, options)
  add_column(table_name, "#{ref_name}_type", :string, polymorphic.is_a?(Hash) ? polymorphic : options) if polymorphic
  add_index(table_name, polymorphic ? %w[id type].map{ |t| "#{ref_name}_#{t}" } : "#{ref_name}_id", index_options.is_a?(Hash) ? index_options : nil) if index_options
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/abstract/schema_statements.rb, line 513
def remove_reference(table_name, ref_name, options = {})
  remove_column(table_name, "#{ref_name}_id")
  remove_column(table_name, "#{ref_name}_type") if options[:polymorphic]
end

# File /usr/local/lib/ruby/gems/2.0.0/gems/activerecord-4.0.0.beta1/lib/active_record/connection_adapters/mysql2_adapter.rb, line 206
def execute(sql, name = nil)
  # make sure we carry over any changes to ActiveRecord::Base.default_timezone that have been
  # made since we established the connection
  @connection.query_options[:database_timezone] = ActiveRecord::Base.default_timezone

  super
end