Ensure email addresses are lowercase throughout

At least all email addresses being input by end users should be
confverted to lowercase to avoid duplicates.

Update existing users, registrations and election candidates to be
lowercase, and add constraints to them

For things like conference contract addresses that are only set by
superusers, we skip the constraints part and let the user take some more
responsibility.

1 files changed, 9 insertions, 0 deletions

diff --git a/postgresqleu/util/fields.py b/postgresqleu/util/fields.py
new file mode 100644
index 00000000..b1ed1190
--- /dev/null
+++ b/postgresqleu/util/fields.py
@@ -0,0 +1,9 @@
+from django.db import models
+
+
+class LowercaseEmailField(models.EmailField):
+    def get_prep_value(self, value):
+        value = super(models.EmailField, self).get_prep_value(value)
+        if value is not None:
+            value = value.lower()
+        return value