zammad/db/migrate/20221010142630_issue_2401_convert_user_login_email_to_unicode.rb

# Copyright (C) 2012-2023 Zammad Foundation, https://zammad-foundation.org/

class Issue2401ConvertUserLoginEmailToUnicode < ActiveRecord::Migration[6.1]
  def up
    # return if it's a new setup
    return if !Setting.exists?(name: 'system_init_done')

    sql_regex = "%@%#{SimpleIDN::ACE_PREFIX}%"

    User.where('email like ? or login like ?', sql_regex, sql_regex).each do |user|
      user.update_columns(login: EmailHelper::Idn.to_unicode(user.login), email: EmailHelper::Idn.to_unicode(user.email)) # rubocop:disable Rails/SkipsModelValidations
    end
  end
end