From e9b709c12a9f64ab99b361a93c173548382147fd Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Tue, 13 Feb 2024 20:45:09 +0100 Subject: Check username in lowercase --- model/users.sql.sqlite.go | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'model/users.sql.sqlite.go') diff --git a/model/users.sql.sqlite.go b/model/users.sql.sqlite.go index 75fdf33..4662ca4 100644 --- a/model/users.sql.sqlite.go +++ b/model/users.sql.sqlite.go @@ -37,16 +37,16 @@ func (q *Queries) GetUserById(ctx context.Context, id int64) (User, error) { const getUserByName = `-- name: GetUserByName :one SELECT id, name, pwd, description FROM users - WHERE name = ? + WHERE LOWER(name) = LOWER(?) ` // GetUserByName // // SELECT id, name, pwd, description // FROM users -// WHERE name = ? -func (q *Queries) GetUserByName(ctx context.Context, name string) (User, error) { - row := q.db.QueryRowContext(ctx, getUserByName, name) +// WHERE LOWER(name) = LOWER(?) +func (q *Queries) GetUserByName(ctx context.Context, lower string) (User, error) { + row := q.db.QueryRowContext(ctx, getUserByName, lower) var i User err := row.Scan( &i.ID, -- cgit v1.2.3-54-g00ecf