view db/migrate/20130911193200_remove_eols_from_attachments_filename.rb @ 1624:76f8f0814e1e live

Use --check to avoid errors when updating in repos with more than one head

class RemoveEolsFromAttachmentsFilename < ActiveRecord::Migration
  def up
    Attachment.where("filename like ? or filename like ?", "%\r%", "%\n%").each do |attachment|
      filename = attachment.filename.to_s.tr("\r\n", "_")
      Attachment.where(:id => attachment.id).update_all(:filename => filename)
    end
  end

  def down
    # nop
  end
end