我找不到活动记录文档页面,其中列出了所有数据类型。
有人可以帮我吗?
:primary_key
:string
:text
:integer
:bigint
:float
:decimal
:numeric
:datetime
:time
:date
:binary
:boolean
:decimal
类型。只要您的数据库支持它(例如 MySQL 中的 :polygon
),您可以使用此列表中未列出的类型,但这样做将不具备数据库通用性,因此也应该避免使用。ActiveRecord::Base.connection.native_database_types.keys
请注意,这是基于2015年2月13日的Rails源代码(Rails 4.2)。
如果有人想看看这些数据类型如何映射到他们正在使用的数据库中,可以轻松地在github上获取rails源代码。
例如:
Rails数据类型到mysql数据类型的映射。
NATIVE_DATABASE_TYPES = {
:primary_key => "int(11) auto_increment PRIMARY KEY",
:string => { :name => "varchar", :limit => 255 },
:text => { :name => "text" },
:integer => { :name => "int", :limit => 4 },
:float => { :name => "float" },
:decimal => { :name => "decimal" },
:datetime => { :name => "datetime" },
:time => { :name => "time" },
:date => { :name => "date" },
:binary => { :name => "blob" },
:boolean => { :name => "tinyint", :limit => 1 }
}
如果有人想要PostgreSQL,这是链接:
NATIVE_DATABASE_TYPES = {
primary_key: "serial primary key",
bigserial: "bigserial",
string: { name: "character varying" },
text: { name: "text" },
integer: { name: "integer" },
float: { name: "float" },
decimal: { name: "decimal" },
datetime: { name: "timestamp" },
time: { name: "time" },
date: { name: "date" },
daterange: { name: "daterange" },
numrange: { name: "numrange" },
tsrange: { name: "tsrange" },
tstzrange: { name: "tstzrange" },
int4range: { name: "int4range" },
int8range: { name: "int8range" },
binary: { name: "bytea" },
boolean: { name: "boolean" },
bigint: { name: "bigint" },
xml: { name: "xml" },
tsvector: { name: "tsvector" },
hstore: { name: "hstore" },
inet: { name: "inet" },
cidr: { name: "cidr" },
macaddr: { name: "macaddr" },
uuid: { name: "uuid" },
json: { name: "json" },
jsonb: { name: "jsonb" },
ltree: { name: "ltree" },
citext: { name: "citext" },
point: { name: "point" },
bit: { name: "bit" },
bit_varying: { name: "bit varying" },
money: { name: "money" },
}
:timestamp
似乎不再在列表中,并被视为:datetime
(在db/schema.rb
中显示为:datetime
)。或者可能只是:datetime
的别名(参见 https://github.com/rails/rails/blob/v4.2.1.rc4/activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb#L364-366)。 - x-yuri:timestamp
已从 Rails 4.2+ 中移除。 - Mark Thomas