VRMS
VRMS copied to clipboard
Update db call to to receive email strings back from the db in lower case form
Dependency
Complete after #1551
Overview
This is part of #1456
We need to receive email addresses as lowercase from the db so that duplicates of different casing ([email protected], [email protected]) aren't able to be created.
Action Items
Either:
- Update the db so that all emails are already lowercase (this is the preferred solution, but we will need to handle duplicate addresses which increases complexity)
Or:
- Update the db email address call to receive back email addresses in lower case format
Resources
We're in luck here, the production DB only has two duplicate emails eg jeff@example, Jeff@example
and ~40 emails that have upper case letters in them. Enough that a manual edit isn't a huge burden.
That means we don't need to update the DB call to return an email in lower case format. Win!
@Spiteless There is a { lowercase: true } value that can be added at the db layer to avoid all these manipulations on the FE.
This issue is being addressed by #1551. Once that ticket is finished, we can address this issue.