Convert a hash into a valid key=value SQL string

sqlize.rb

# gives a valid key=value SQL string for using in "INSERT INTO `table` SET" sentences
# >> "INSERT INTO `table_name` SET #{sqlize(Model.find(id).attributes)};"
# returns
# => "INSERT INTO `table_name` SET `attr1`=value1,`attr2`=value2..."
# Handles different datatypes

def sqlize hash
  hash.map do |k,v|
    v = case v
    when Time
      %{"#{v.to_s(:db)}"}
    when TrueClass
      1
    when FalseClass
      0
    when NilClass
      "NULL"
    when String
      %{"#{v.gsub(/['"\\\x0]/,'\\\\\0')}"}
    else
      v
    end

    "`#{k}`=#{v}"
  end.join(',')
end

ActiveRecord::Base implementa esto en sanitize_sql_hash_for_assignment:

ActiveRecord::Base.send(:sanitize_sql_hash_for_assignment,{:wadus=> 'wadus', :foo => nil})

=> "foo = NULL, wadus = 'wadus'"