fix ldap identities

1 files changed, 16 insertions, 0 deletions

diff --git a/db/migrate/20150411000035_fix_identities.rb b/db/migrate/20150411000035_fix_identities.rb
new file mode 100644
index 00000000000..12526b10e6e
--- /dev/null
+++ b/db/migrate/20150411000035_fix_identities.rb
@@ -0,0 +1,16 @@
+class FixIdentities < ActiveRecord::Migration
+  def up
+    new_provider = Gitlab.config.ldap.servers.first.last['provider_name']
+	  # Delete duplicate identities
+    Identity.connection.select_one("DELETE FROM identities WHERE provider = 'ldap' AND user_id IN (SELECT user_id FROM identities WHERE provider = '#{new_provider}')")
+	  # Update legacy identities
+    Identity.where(provider: 'ldap').update_all(provider: new_provider)
+
+    if defined?(LdapGroupLink)
+      LdapGroupLink.where('provider IS NULL').update_all(provider: new_provider)
+    end
+  end
+
+  def down
+  end
+end