fix_shitty_characters.rb

Rails.application.eager_load! if Rails.env.development?
ActiveRecord::Base.descendants.each do |d|
  puts d.table_name
  d.columns_hash.each do |f, t|
    if t.type == :string || t.type == :text
      puts "\t#{f} #{t.type}"
      queries = []
      queries << "#{f} = replace(#{f}, '“', '“')"
      queries << "#{f} = replace(#{f}, '’', '’')"
      queries << "#{f} = replace(#{f}, '‘', '‘')"
      queries << "#{f} = replace(#{f}, '—', '–')"
      queries << "#{f} = replace(#{f}, '–', '—')"
      queries << "#{f} = replace(#{f}, '•', '-')"
      queries << "#{f} = replace(#{f}, '…', '…')"
      queries << "#{f} = replace(#{f}, '”', '”')"
      queries << "#{f} = replace(#{f}, '―', '—')"
      queries << "#{f} = replace(#{f}, '£', '£')"
      queries << "#{f} = replace(#{f}, 'é', 'é')"
      queries << "#{f} = replace(#{f}, 'ö', 'ö')"
      
      queries.each do |q|
        d.update_all(q)
      end
    end
  end
end;nil