method

type_to_sql

v4.2.1 - Show latest stable - 0 notes - Class: AbstractMysqlAdapter

1.0.0
1.1.1
1.1.6
1.2.0
1.2.6
2.0.0
2.0.3
2.1.0
2.2.1
2.3.2
2.3.8
3.0.0
3.0.5
3.0.9
3.1.0
3.2.1 (0)
3.2.3 (0)
3.2.8 (0)
3.2.13 (0)
4.0.2 (0)
4.1.8 (0)
4.2.1 (0)
4.2.7 (0)
What's this?

type_to_sql(type, limit = nil, precision = nil, scale = nil) public

Maps logical Rails types to MySQL-specific data types.

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 561
      def type_to_sql(type, limit = nil, precision = nil, scale = nil)
        case type.to_s
        when 'binary'
          case limit
          when 0..0xfff;           "varbinary(#{limit})"
          when nil;                "blob"
          when 0x1000..0xffffffff; "blob(#{limit})"
          else raise(ActiveRecordError, "No binary type has character length #{limit}")
          end
        when '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
        when 'text'
          case limit
          when 0..0xff;               'tinytext'
          when nil, 0x100..0xffff;    'text'
          when 0x10000..0xffffff;     'mediumtext'
          when 0x1000000..0xffffffff; 'longtext'
          else raise(ActiveRecordError, "No text type has character length #{limit}")
          end
        when 'datetime'
          return super unless precision

          case precision
            when 0..6; "datetime(#{precision})"
            else raise(ActiveRecordError, "No datetime type has precision of #{precision}. The allowed range of precision is from 0 to 6.")
          end
        else
          super
        end
      end

type_to_sql

Related methods

Flowdock - Team Inbox With Chat