Module: ArJdbc::MySQL::Column

Included in:
ActiveRecord::ConnectionAdapters::MysqlAdapter::Column
Defined in:
lib/arjdbc/mysql/column.rb

Overview

Column behavior based on (abstract) MySQL adapter in Rails.

See Also:

Instance Attribute Summary collapse

Instance Method Summary collapse

Instance Attribute Details

#collation ⇒ Object (readonly)

Returns the value of attribute collation.



33
34
35
 
# File 'lib/arjdbc/mysql/column.rb', line 33

def collation
  @collation
end

#extra ⇒ Object (readonly)

Returns the value of attribute extra.



33
34
35
 
# File 'lib/arjdbc/mysql/column.rb', line 33

def extra
  @extra
end

#strict ⇒ Object (readonly)

Returns the value of attribute strict.



33
34
35
 
# File 'lib/arjdbc/mysql/column.rb', line 33

def strict
  @strict
end

Instance Method Details

#blob_or_text_column? ⇒ Boolean

Returns:

  • (Boolean) 


51
52
53
 
# File 'lib/arjdbc/mysql/column.rb', line 51

def blob_or_text_column?
  sql_type.index('blob') || type == :text
end

#case_sensitive? ⇒ Boolean

Returns:

  • (Boolean) 


55
56
57
 
# File 'lib/arjdbc/mysql/column.rb', line 55

def case_sensitive?
  collation && !collation.match(/_ci$/)
end

#extract_default(default) ⇒ Object 



35
36
37
38
39
40
41
42
43
44
 
# File 'lib/arjdbc/mysql/column.rb', line 35

def extract_default(default)
  if blob_or_text_column?
    return null || strict ? nil : '' if default.blank?
    raise ArgumentError, "#{type} columns cannot have a default value: #{default.inspect}"
  elsif missing_default_forged_as_empty_string?(default)
    nil
  else
    super
  end
end

#extract_limit(sql_type) ⇒ Object 



103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
 
# File 'lib/arjdbc/mysql/column.rb', line 103

def extract_limit(sql_type)
  case sql_type
  when /blob|text/i
    case sql_type
    when /tiny/i
      255
    when /medium/i
      16777215
    when /long/i
      2147483647 # mysql only allows 2^31-1, not 2^32-1, somewhat inconsistently with the tiny/medium/normal cases
    else
      super # we could return 65535 here, but we leave it undecorated by default
    end
  when /^bigint/i;    8
  when /^int/i;       4
  when /^mediumint/i; 3
  when /^smallint/i;  2
  when /^tinyint/i;   1
  when /^enum\((.+)\)/i # 255
    $1.split(',').map{ |enum| enum.strip.length - 2 }.max
  when /^(bool|date|float|int|time)/i
    nil
  else
    super
  end
end

#has_default? ⇒ Boolean

Returns:

  • (Boolean) 


46
47
48
49
 
# File 'lib/arjdbc/mysql/column.rb', line 46

def has_default?
  return false if blob_or_text_column? #mysql forbids defaults on blob and text columns
  super
end

#initialize(name, default, sql_type = nil, null = true, collation = nil, strict = false, extra = '') ⇒ Object 



13
14
15
16
17
18
19
20
21
 
# File 'lib/arjdbc/mysql/column.rb', line 13

def initialize(name, default, sql_type = nil, null = true, collation = nil, strict = false, extra = '')
  if name.is_a?(Hash)
    super # first arg: config
  else
    @strict = strict; @collation = collation; @extra = extra
    super(name, default, sql_type, null)
    # base 4.1: (name, default, sql_type = nil, null = true)
  end
end

#missing_default_forged_as_empty_string?(default) ⇒ Boolean

MySQL misreports NOT NULL column default when none is given. We can't detect this for columns which may have a legitimate '' default (string) but we can for others (integer, datetime, boolean, and the rest).

Test whether the column has default '', is not null, and is not a type allowing default ''.

Returns:

  • (Boolean) 


137
138
139
 
# File 'lib/arjdbc/mysql/column.rb', line 137

def missing_default_forged_as_empty_string?(default)
  type != :string && !null && default == ''
end

#simplified_type(field_type) ⇒ Object 



59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
 
# File 'lib/arjdbc/mysql/column.rb', line 59

def simplified_type(field_type)
  if adapter && adapter.emulate_booleans?
    return :boolean if field_type.downcase.index('tinyint(1)')
  end

  case field_type
  when /enum/i, /set/i then :string
  when /year/i then :integer
  # :tinyint : {:name=>"tinyint", :limit=>3}
  # :"tinyint unsigned" : {:name=>"tinyint unsigned", :limit=>3}
  # :bigint : {:name=>"bigint", :limit=>19}
  # :"bigint unsigned" : {:name=>"bigint unsigned", :limit=>20}
  # :integer : {:name=>"integer", :limit=>10}
  # :"integer unsigned" : {:name=>"integer unsigned", :limit=>10}
  # :int : {:name=>"int", :limit=>10}
  # :"int unsigned" : {:name=>"int unsigned", :limit=>10}
  # :mediumint : {:name=>"mediumint", :limit=>7}
  # :"mediumint unsigned" : {:name=>"mediumint unsigned", :limit=>8}
  # :smallint : {:name=>"smallint", :limit=>5}
  # :"smallint unsigned" : {:name=>"smallint unsigned", :limit=>5}
  when /int/i then :integer
  when /double/i then :float # double precision (alias)
  when 'bool' then :boolean
  when 'char' then :string
  # :mediumtext => {:name=>"mediumtext", :limit=>16777215}
  # :longtext => {:name=>"longtext", :limit=>2147483647}
  # :text => {:name=>"text"}
  # :tinytext => {:name=>"tinytext", :limit=>255}
  when /text/i then :text
  when 'long varchar' then :text
  # :"long varbinary" => {:name=>"long varbinary", :limit=>16777215}
  # :varbinary => {:name=>"varbinary", :limit=>255}
  when /binary/i then :binary
  # :mediumblob => {:name=>"mediumblob", :limit=>16777215}
  # :longblob => {:name=>"longblob", :limit=>2147483647}
  # :blob => {:name=>"blob", :limit=>65535}
  # :tinyblob => {:name=>"tinyblob", :limit=>255}
  when /blob/i then :binary
  when /^bit/i then :binary
  else
    super
  end
end