#primary_keys(name = nil)
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 408
def primary_keys(name = nil) # :nodoc: @primary_keys = PrimaryKeyDefinition.new(name) if name @primary_keys end
123456789_123456789_123456789_123456789_123456789_
Relationships & Source Files | |
Extension / Inclusion / Inheritance Descendants | |
Subclasses:
|
|
Super Chains via Extension / Inclusion / Inheritance | |
Instance Chain:
self,
ColumnMethods
|
|
Inherits: | Object |
Defined in: | activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb |
Represents the schema of an SQL table in an abstract way. This class provides methods for manipulating the schema representation.
Inside migration files, the t
object in create_table is actually of this type:
class SomeMigration < ActiveRecord::Migration[8.0]
def up
create_table :foo do |t|
puts t.class # => "ActiveRecord::ConnectionAdapters::TableDefinition"
end
end
def down
#...
end
end
ColumnMethods
- Attributes & MethodsReturns a ColumnDefinition
for the column with name #name.
Alias for #references.
Instantiates a new column for the table.
Returns an array of ColumnDefinition
objects for the columns of the table.
Adds index options to the indexes hash, keyed by column name This is primarily used to track indexes that need to be created after the table.
Adds a reference.
remove the column #name from the table.
Appends :datetime
columns :created_at
and :updated_at
to the table.
ColumnMethods
- Included#column | Appends a column or columns of a specified type. |
#primary_key | Appends a primary key definition to the table definition. |
TableDefinition
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 367
def initialize( conn, name, temporary: false, if_not_exists: false, options: nil, as: nil, comment: nil, ** ) @conn = conn @columns_hash = {} @indexes = [] @foreign_keys = [] @primary_keys = nil @check_constraints = [] @temporary = temporary @if_not_exists = if_not_exists @options = @as = as @name = name @comment = comment end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 365
attr_reader :name, :temporary, :if_not_exists, :, :as, :comment, :indexes, :foreign_keys, :check_constraints
Returns a ColumnDefinition
for the column with name #name.
Alias for #references.
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 552
alias :belongs_to :references
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 323
alias :blob :binary
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 521
def check_constraint(expression, ** ) check_constraints << new_check_constraint_definition(expression, ) end
Instantiates a new column for the table. See connection.add_column for available options.
Additional options are:
:index
- Create an index for the column. Can be either true
or an options hash.
This method returns self
.
# Assuming {td} is an instance of TableDefinition
td.column(:granted, :boolean, index: true)
Instead of calling #column
directly, you can also work with the short-hand definitions for the default types. They use the type as the method name instead of as a parameter and allow for multiple columns to be defined in a single statement.
What can be written like this with the regular calls to column:
create_table :products do |t|
t.column :shop_id, :integer
t.column :creator_id, :integer
t.column :item_number, :string
t.column :name, :string, default: "Untitled"
t.column :value, :string, default: "Untitled"
t.column :created_at, :datetime
t.column :updated_at, :datetime
end
add_index :products, :item_number
can also be written as follows using the short-hand:
create_table :products do |t|
t.integer :shop_id, :creator_id
t.string :item_number, index: true
t.string :name, :value, default: "Untitled"
t. null: false
end
There’s a short-hand method for each of the type values declared at the top. And then there’s #timestamps that’ll add created_at
and updated_at
as datetimes.
#references will add an appropriately-named _id column, plus a corresponding _type column if the :polymorphic
option is supplied. If :polymorphic
is a hash of options, these will be used when creating the _type
column. The :index
option will also create an index, similar to calling add_index. So what can be written like this:
create_table :taggings do |t|
t.integer :tag_id, :tagger_id, :taggable_id
t.string :tagger_type
t.string :taggable_type, default: 'Photo'
end
add_index :taggings, :tag_id, name: 'index_taggings_on_tag_id'
add_index :taggings, [:tagger_id, :tagger_type]
Can also be written as follows using references:
create_table :taggings do |t|
t.references :tag, index: { name: 'index_taggings_on_tag_id' }
t.references :tagger, polymorphic: true
t.references :taggable, polymorphic: { default: 'Photo' }, index: false
end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 488
def column(name, type, index: nil, ** ) name = name.to_s type = type.to_sym if type raise_on_duplicate_column(name) @columns_hash[name] = new_column_definition(name, type, ** ) if index = index.is_a?(Hash) ? index : {} index(name, ** ) end self end
Returns an array of ColumnDefinition
objects for the columns of the table.
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 414
def columns; @columns_hash.values; end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 589
def create_column_definition(name, type, ) unless [: ] .except(:_uses_legacy_reference_index_name, : ).assert_valid_keys( ) end ColumnDefinition.new(name, type, ) end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 517
def foreign_key(to_table, ** ) foreign_keys << new_foreign_key_definition(to_table, ) end
Adds index options to the indexes hash, keyed by column name This is primarily used to track indexes that need to be created after the table
index(:account_id, name: 'index_projects_on_account_id')
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 513
def index(column_name, ** ) indexes << [column_name, ] end
Boolean
(private)
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 601
def integer_like_primary_key?(type, ) [:primary_key] && [:integer, :bigint].include?(type) && ! .key?(:default) end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 605
def integer_like_primary_key_type(type, ) type end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 579
def new_check_constraint_definition(expression, ) # :nodoc: = @conn. (name, expression, ) CheckConstraintDefinition.new(name, expression, ) end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 554
def new_column_definition(name, type, ** ) # :nodoc: if integer_like_primary_key?(type, ) type = integer_like_primary_key_type(type, ) end type = aliased_types(type.to_s, type) if @conn.supports_datetime_with_precision? if type == :datetime && ! .key?(:precision) [:precision] = 6 end end [:primary_key] ||= type == :primary_key [:null] = false if [:primary_key] create_column_definition(name, type, ) end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 571
def new_foreign_key_definition(to_table, ) # :nodoc: prefix = ActiveRecord::Base.table_name_prefix suffix = ActiveRecord::Base.table_name_suffix to_table = "#{prefix}#{to_table}#{suffix}" = @conn. (name, to_table, ) ForeignKeyDefinition.new(name, to_table, ) end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 324
alias :numeric :decimal
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 408
def primary_keys(name = nil) # :nodoc: @primary_keys = PrimaryKeyDefinition.new(name) if name @primary_keys end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 609
def raise_on_duplicate_column(name) if @columns_hash[name] if @columns_hash[name].primary_key? raise ArgumentError, "you can't redefine the primary key column '#{name}' on '#{@name}'. To define a custom primary key, pass { id: false } to create_table." else raise ArgumentError, "you can't define an already defined column '#{name}' on '#{@name}'." end end end
Adds a reference.
t.references(:user)
t.belongs_to(:supplier, foreign_key: true)
t.belongs_to(:supplier, foreign_key: true, type: :integer)
See connection.add_reference for details of the options you can use.
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 547
def references(*args, ** ) args.each do |ref_name| ReferenceDefinition.new(ref_name, ** ).add_to(self) end end
remove the column #name from the table.
remove_column(:account_id)
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 391
def set_primary_key(table_name, id, primary_key, ** ) if id && !as pk = primary_key || Base.get_primary_key(table_name.to_s.singularize) if id.is_a?(Hash) .merge!(id.except(:type)) id = id.fetch(:type, :primary_key) end if pk.is_a?(Array) primary_keys(pk) else primary_key(pk, id, ** ) end end end
Appends :datetime
columns :created_at
and :updated_at
to the table. See connection.add_timestamps
t. null: false
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 529
def (** ) [:null] = false if [:null].nil? if ! .key?(:precision) && @conn.supports_datetime_with_precision? [:precision] = 6 end column(:created_at, :datetime, ** ) column(:updated_at, :datetime, ** ) end
# File 'activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb', line 585
def @conn. end