On what exactly?
And what defines the ‘first’? First registered matching the constraint? (for example: first user registered at an address)
Ps. My guess now is that we will end up writing the proper query or migration 
Or: you have multiple entries that should be detected as the same (needs logic) and have to be ‘merged’ into one.
Yep, your 2nd thought..
Old methods allows them to have different accounts with same email and we treated them based on a verified column, if they’re verified ?
Now seems like new logic users are all verified and old logic made bunches of duplicates in the past and the past users can’t register now because register method now got piped through email check
So I cleaned old data and put unique constraint on email
I’m lost.
But for archeological reasons:
were you looking for the “first” two identical values of the map?
Otherwise there are no duplicated email addresses in the database possible due to the constraint…so no merging needed.
Yeah I need to make a unique constraint for it, it’s not there since the beginning
But after I run a mix task to clean all the old data
We are getting there
So, I guess the email addresses are some sort of ‘group by’ field, which creates groups with multiple accounts. Then:
A. All records should merge their fields
B. Just pick one (first based on insert date?), remove the rest
C. Other…
Pick one.
Once we have only one record per email address, the unique constraint can be set.
Yep
A. All records should merge themselves
And luckily they are lists
So I can iterate through each bunch of records
Then I can Enum.reduce to get accumulated records of same kind in one bunch of duplicate based on statuses, delete the rest and except the 1st one in that acc records
Or I can just Enum.each if they’re the same status
Or if all of them not verified then I delete all except first one
Just for the record badum tishh: How many record are there in total?
ps. Gotta sleep. Will see if someone takes it from here
Then we better get to the solution quickly otherwise there might be more posts in this thread then records..and doing it manually would have been faster 