VRMS icon indicating copy to clipboard operation
VRMS copied to clipboard

Update db call to to receive email strings back from the db in lower case form

Open trillium opened this issue 1 year ago • 3 comments

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

trillium avatar Aug 26 '23 18:08 trillium

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!

trillium avatar Aug 27 '23 16:08 trillium

@Spiteless There is a { lowercase: true } value that can be added at the db layer to avoid all these manipulations on the FE.

bkmorgan3 avatar Nov 07 '23 17:11 bkmorgan3

This issue is being addressed by #1551. Once that ticket is finished, we can address this issue.

JackHaeg avatar Feb 28 '24 19:02 JackHaeg