From a9bd9843d41a2c3b8d0893b30c0c7d0754ba5dbf Mon Sep 17 00:00:00 2001 From: Joram Wilander Date: Wed, 13 Apr 2016 14:31:27 -0400 Subject: Lower case email before database queries (#2689) --- store/sql_user_store.go | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'store/sql_user_store.go') diff --git a/store/sql_user_store.go b/store/sql_user_store.go index 767892056..2b52dfbd7 100644 --- a/store/sql_user_store.go +++ b/store/sql_user_store.go @@ -320,6 +320,8 @@ func (us SqlUserStore) UpdateAuthData(userId, service, authData, email string) S go func() { result := StoreResult{} + email = strings.ToLower(email) + updateAt := model.GetMillis() query := ` @@ -508,6 +510,8 @@ func (us SqlUserStore) GetByEmail(teamId string, email string) StoreChannel { go func() { result := StoreResult{} + email = strings.ToLower(email) + user := model.User{} if err := us.GetReplica().SelectOne(&user, "SELECT * FROM Users WHERE TeamId = :TeamId AND Email = :Email", map[string]interface{}{"TeamId": teamId, "Email": email}); err != nil { @@ -666,7 +670,7 @@ func (us SqlUserStore) PermanentDelete(userId string) StoreChannel { result := StoreResult{} if _, err := us.GetMaster().Exec("DELETE FROM Users WHERE Id = :UserId", map[string]interface{}{"UserId": userId}); err != nil { - result.Err = model.NewLocAppError("SqlUserStore.GetByEmail", "store.sql_user.permanent_delete.app_error", nil, "userId="+userId+", "+err.Error()) + result.Err = model.NewLocAppError("SqlUserStore.PermanentDelete", "store.sql_user.permanent_delete.app_error", nil, "userId="+userId+", "+err.Error()) } storeChannel <- result -- cgit v1.2.3-1-g7c22