diff options
| -rw-r--r-- | db/post_migrate/20170828124518_downcase_gpg_key_user_email_on_gpg_signatures.rb | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/db/post_migrate/20170828124518_downcase_gpg_key_user_email_on_gpg_signatures.rb b/db/post_migrate/20170828124518_downcase_gpg_key_user_email_on_gpg_signatures.rb new file mode 100644 index 00000000000..a11a9b0669f --- /dev/null +++ b/db/post_migrate/20170828124518_downcase_gpg_key_user_email_on_gpg_signatures.rb @@ -0,0 +1,23 @@ +class DowncaseGpgKeyUserEmailOnGpgSignatures < ActiveRecord::Migration + DOWNTIME = false + + include Gitlab::Database::MigrationHelpers + disable_ddl_transaction! + + class GpgSignature < ActiveRecord::Base + self.table_name = 'gpg_signatures' + + include EachBatch + end + + def up + GpgSignature.each_batch do |relation| + relation.update_all('gpg_key_user_email = LOWER(gpg_key_user_email)') + end + end + + def down + # we can't revert the downcasing, but actually we don't need to really, as + # downcasing the emails is not a harmful change. + end +end |