module ActiveRecord module ConnectionAdapters class PostgreSQLColumn < Column module Cast def string_to_time(string) return string unless String === string case string when 'infinity'; 1.0 / 0.0 when '-infinity'; -1.0 / 0.0 else super end end def hstore_to_string(object) if Hash === object object.map { |k,v| "#{escape_hstore(k)}=>#{escape_hstore(v)}" }.join ',' else object end end def string_to_hstore(string) if string.nil? nil elsif String === string Hash[string.scan(HstorePair).map { |k,v| v = v.upcase == 'NULL' ? nil : v.gsub(/^"(.*)"$/,'\1').gsub(/\\(.)/, '\1') k = k.gsub(/^"(.*)"$/,'\1').gsub(/\\(.)/, '\1') [k,v] }] else string end end def string_to_cidr(string) if string.nil? nil elsif String === string IPAddr.new(string) else string end end def cidr_to_string(object) if IPAddr === object "#{object.to_s}/#{object.instance_variable_get(:@mask_addr).to_s(2).count('1')}" else object end end private HstorePair = begin quoted_string = /"[^"\\]*(?:\\.[^"\\]*)*"/ unquoted_string = /(?:\\.|[^\s,])[^\s=,\\]*(?:\\.[^\s=,\\]*|=[^,>])*/ /(#{quoted_string}|#{unquoted_string})\s*=>\s*(#{quoted_string}|#{unquoted_string})/ end def escape_hstore(value) if value.nil? 'NULL' else if value == "" '""' else '"%s"' % value.to_s.gsub(/(["\\])/, '\\\\\1') end end end end end end end