Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
ActiveRecord type of integer (tinyint, smallint, mediumint, int, bigint)
# activerecord-3.0.0/lib/active_record/connection_adapters/mysql_adapter.rb
# Maps logical Rails types to MySQL-specific data types.
def type_to_sql(type, limit = nil, precision = nil, scale = nil)
return super unless type.to_s == 'integer'
case limit
when 1; 'tinyint'
when 2; 'smallint'
when 3; 'mediumint'
when nil, 4, 11; 'int(11)' # compatibility with MySQL default
when 5..8; 'bigint'
else raise(ActiveRecordError, "No integer type has byte size #{limit}")
end
end
# ActiveRecord Migrate
create_table 'example' do |t|
t.integer :int # int (4 bytes, max 2,147,483,647)
t.integer :int1, :limit => 1 # tinyint (1 byte, -128 to 127)
t.integer :int2, :limit => 2 # smallint (2 bytes, max 32,767)
t.integer :int3, :limit => 3 # mediumint (3 bytes, max 8,388,607)
t.integer :int4, :limit => 4 # int (4 bytes)
t.integer :int5, :limit => 5 # bigint (8 bytes, max 9,223,372,036,854,775,807)
t.integer :int8, :limit => 8 # bigint (8 bytes)
t.integer :int11, :limit => 11 # int (4 bytes)
end
@moeabdol

This comment has been minimized.

Copy link

moeabdol commented Apr 18, 2015

Thanks. This made my day.

@chrishough

This comment has been minimized.

Copy link

chrishough commented Mar 15, 2016

This was awesome, thank you!

@stephen-puiszis

This comment has been minimized.

Copy link

stephen-puiszis commented Dec 21, 2016

Super handy, thank you!

@mathieujobin

This comment has been minimized.

Copy link

mathieujobin commented Dec 22, 2016

in case you land here looking for a 16 bytes integer.
you have to use binary(16)
I am testing the idea of adding a real uuid column to AR Mysql adapter

https://github.com/mathieujobin/rails-mysql-uuid-column

@uhrohraggy

This comment has been minimized.

Copy link

uhrohraggy commented Aug 23, 2019

Still in love with this all these years later, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.