Enforce valid email address for User email

[harminius]

resolves #2537

Add additional format validity check for the user's email.

• when the validation registration form
• on the database level

Registration form check

Before running the migration, we need to sanitize our database.

To see which emails break the new rule, try select email from public."user" where email !~ '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,}$';

[MarcelGeo]

I am not confident with this change and multi language support.

[varmar05]

@harminius I suggest also to check db against invalid characters and non-utf8 mess, if you can pass me the queries

[github-actions[bot]]

Pull Request Test Coverage Report for Build 13589212467

Details

• 22 of 22 (100.0%) changed or added relevant lines in 5 files are covered.
• No unchanged relevant lines lost coverage.
• Overall coverage increased (+0.03%) to 92.436%

---

Totals
Change from base Build 13584997311:	0.03%
Covered Lines:	6795
Relevant Lines:	7351

---

💛 - Coveralls