use lower() for register, search and login

1 files changed, 1 insertions, 1 deletions

diff --git a/api/auth/signup.py b/api/auth/signup.py
index 648f1b5..210ba94 100644
--- a/api/auth/signup.py
+++ b/api/auth/signup.py
@@ -38,7 +38,7 @@ def index():
        not validate_password(password):
            return {"error": "form_data_invalid"}, 403
 
-    if cursor.execute("select username from users where username = ?", [username]).fetchone():
+    if cursor.execute("select username from users where lower(username) = lower(?)", [username]).fetchone():
         return {"error": "username_taken"}, 403
 
     if cursor.execute("select email from users where email = ?", [email]).fetchone():