diff options
| -rw-r--r-- | gn_auth/auth/authorisation/users/models.py | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/gn_auth/auth/authorisation/users/models.py b/gn_auth/auth/authorisation/users/models.py index 956f239..1b7d8e0 100644 --- a/gn_auth/auth/authorisation/users/models.py +++ b/gn_auth/auth/authorisation/users/models.py @@ -54,18 +54,18 @@ def __list_user_clauses_and_params__(**kwargs) -> tuple[str, dict[str, Union[int clauses = "email LIKE :email" params["email"] = f'%{kwargs["email"].strip()}%' elif bool(kwargs.get("name", "").strip()): - clauses = clauses + ["name LIKE :name"] + clauses = "name LIKE :name" params["name"] = f'%{kwargs["name"].strip()}%' else: clauses = "" if bool(kwargs.get("verified", "").strip()): - clauses = clauses + " AND verified=:verified" - params["verified"] = 1 if kwargs["verified"].strip() == "yes" else 0 + clauses = clauses + (" AND " if len(clauses) > 0 else "") + "verified=:verified" + params["verified"] = "1" if kwargs["verified"].strip() == "yes" else "0" if bool(kwargs.get("age", "").strip()): _clause, _param = __process_age_clause__(kwargs["age"].strip()) - clauses = clauses + f" AND {_clause}" + clauses = clauses + (" AND " if len(clauses) > 0 else "") + _clause params["created"] = _param return clauses, params |