Rails check for duplicate models

Question

I did a mistake in my rails app, and I didn't enforce the uniqueness of logins. Now I'd like to clean this mess by finding and removing duplicates (manually) in my code.

Is there a nice command I could enter in the Rails console that would let me find those duplicates ? Eg. find two users with the same login, and maybe make an array of array of duplicates ?

score 0 · Accepted Answer · edited Jul 21 '15 at 00:08

0

Assuming your model is User and you are looking for duplicate attribute login, you should be able to do something like this:

User.find_by_sql("SELECT u1.id, u1.login FROM users u1 LEFT JOIN users u2 WHERE u1.login=u2.login AND u1.id!=u2.id ORDER BY u1.login, u1.id")

Of course, you can change the select to include whatever attributes you will need in order to decide what to do about the duplicates.

EDIT for Mongoid, look at this link

edited Jul 21 '15 at 00:08

Cyril Duchon-Doris

12,964
9
77
164

answered Jun 19 '15 at 12:26

steve klein

2,566
1
14
27

I don't think you can use sql queries with mongoid :) – cthulhu Jun 19 '15 at 13:13
2

Sorry @Cyril feeling bad that I answerbombed your question :( I am not so familiar with `Mongoid` but found [this answer](http://blog.mongolab.com/2014/03/finding-duplicate-keys-with-the-mongodb-aggregation-framework/) which looks promising for your use case. Hope it helps... – steve klein Jun 19 '15 at 13:35
Sorry, for some reason I didn't get notified of answers. I'll have a look. – Cyril Duchon-Doris Jun 23 '15 at 21:20
Yes thank you, your link was helpful, I will edit your answer to add it. – Cyril Duchon-Doris Jul 20 '15 at 22:43

Rails check for duplicate models

1 Answers1