RefugeRestrooms/refugerestrooms

namespace :db do
  desc "Fix wrongly-encoded accented characters (use db:fix_accents[dry_run] to preview changes)"
  task :fix_accents, [:dry_run] => [:environment] do |t, args|
    args.with_defaults(dry_run: false)

    transformations = {
      "Ž" => "é",
      "™" => "ô",
      "è" => "è",
      "é" => "é",
      "�Restroom�" => "'Restroom'",
      "� " => "é ",
      "ÌÊ" => "à",
      "Ì«" => "ô",
      "Ì©" => "é",
      "̬s" => "’s",
      "̬" => "è",
      "̨" => "î",
      "Ìø" => "ï",
      "ÌÛ" => "À",
      "\u008F" => "è",
      "á" => "á",
      "&" => "&",
      "ç" => "ç"
    }

    if args.dry_run
      puts "Dry running fix_accents"
    else
      puts "Running fix_accents"
    end

    puts ""

    fields = [:name, :street, :city, :directions, :comment]

    fields.each do |field|
      where_clause = transformations.keys.map{|original| "#{field} like '%#{original}%'"}.join(" OR ")

      puts field, "="*field.length,""

      Restroom.where(where_clause).each do |restroom|
        transformations.each do |original, transformed|
          restroom.send("#{field}=", restroom.send(field).gsub(original, transformed))
        end

        puts restroom.id, "", restroom.send("#{field}_was"), "", restroom.send(field), "\n\n"

        restroom.save unless args.dry_run
      end
    end
  end
end