From a87831846d1f82c0da851e55c6599f6f5a24791f Mon Sep 17 00:00:00 2001 From: lonkaars Date: Sun, 14 Mar 2021 13:30:59 +0100 Subject: use lower() for register, search and login --- api/auth/signup.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'api/auth/signup.py') 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(): -- cgit v1.2.3