fix: email + domain ignore case

fixes #15

Change-Id: I8928aa862393ef7977e91393ae8d91667e790fe8

diff --git a/src/org/cacert/gigi/database/DatabaseConnection.java b/src/org/cacert/gigi/database/DatabaseConnection.java
index f1c1c01102e126677e373c42edc864270c512de6..09093669210c3229e9baf8e9ac42968500588660 100644 (file)
--- a/src/org/cacert/gigi/database/DatabaseConnection.java
+++ b/src/org/cacert/gigi/database/DatabaseConnection.java
@@ -99,7 +99,7 @@ public class DatabaseConnection {
 
     }
 
-    public static final int CURRENT_SCHEMA_VERSION = 10;
+    public static final int CURRENT_SCHEMA_VERSION = 11;
 
     public static final int CONNECTION_TIMEOUT = 24 * 60 * 60;
 

diff --git a/src/org/cacert/gigi/database/upgrade/from_10.sql b/src/org/cacert/gigi/database/upgrade/from_10.sql
new file mode 100644 (file)
index 0000000..8bbb6bb
--- /dev/null
+++ b/src/org/cacert/gigi/database/upgrade/from_10.sql
@@ -0,0 +1,2 @@
+UPDATE "emails" SET "email" = lower("email");
+UPDATE "domains" SET "domain" = lower("domain");

diff --git a/src/org/cacert/gigi/dbObjects/Domain.java b/src/org/cacert/gigi/dbObjects/Domain.java
index 5876530355a8f9d5be1c37aa20f588e40ff37ca2..fa6a6d0e10240b75b37d205c0a33e7645d02980f 100644 (file)
--- a/src/org/cacert/gigi/dbObjects/Domain.java
+++ b/src/org/cacert/gigi/dbObjects/Domain.java
@@ -51,6 +51,7 @@ public class Domain implements IdCachable, Verifyable {
     }
 
     public Domain(User actor, CertificateOwner owner, String suffix) throws GigiApiException {
+        suffix = suffix.toLowerCase();
         synchronized (Domain.class) {
             checkCertifyableDomain(suffix, actor.isInGroup(Group.CODESIGNING));
             this.owner = owner;

diff --git a/src/org/cacert/gigi/dbObjects/EmailAddress.java b/src/org/cacert/gigi/dbObjects/EmailAddress.java
index d92338ca9899f0dc8e126159e005e26863cd0b88..04108ea2ec3831284f479ecd186f843d6a7790ee 100644 (file)
--- a/src/org/cacert/gigi/dbObjects/EmailAddress.java
+++ b/src/org/cacert/gigi/dbObjects/EmailAddress.java
@@ -42,6 +42,7 @@ public class EmailAddress implements IdCachable, Verifyable {
     }
 
     public EmailAddress(User owner, String address, Locale mailLocale) throws GigiApiException {
+        address = address.toLowerCase();
         if ( !EmailProvider.MAIL.matcher(address).matches()) {
             throw new IllegalArgumentException("Invalid email.");
         }