Useful scripts

rails_to_myqsl_insert.rb

ARModel.where(id: []).each do |b|
  puts "INSERT INTO models"
  puts "(#{b.attributes.keys.join(',')})"
  values = b.attributes.values.map do |v|
    if v.nil?
      'NULL'
    else
      if v.is_a?(String)
        '"' + v.to_s + '"'
      elsif v.is_a?(Time)
        '"' + v.strftime("%Y-%m-%d %H:%M:%S") + '"'
      elsif v.is_a?(Date)
        '"' + v.strftime("%Y-%m-%d") + '"'
      else
        v
      end
    end
  end
  puts "VALUES(#{values.join(',')});"
end;nil