diff options
| author | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-02-13 20:45:09 +0100 |
|---|---|---|
| committer | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-02-13 20:45:09 +0100 |
| commit | e9b709c12a9f64ab99b361a93c173548382147fd (patch) | |
| tree | c46ec4392adcf2d128ff763ea005b9fe28e8fe79 | |
| parent | 5cef17441a94167aedc729628f0e7122ec3edccb (diff) | |
| download | gosten-e9b709c12a9f64ab99b361a93c173548382147fd.tar.gz gosten-e9b709c12a9f64ab99b361a93c173548382147fd.tar.bz2 gosten-e9b709c12a9f64ab99b361a93c173548382147fd.zip | |
Check username in lowercase
| -rw-r--r-- | model/users.sql.mysql.go | 8 | ||||
| -rw-r--r-- | model/users.sql.sqlite.go | 8 | ||||
| -rw-r--r-- | sql/users.sql | 2 |
3 files changed, 9 insertions, 9 deletions
diff --git a/model/users.sql.mysql.go b/model/users.sql.mysql.go index b16d388..acc462d 100644 --- a/model/users.sql.mysql.go +++ b/model/users.sql.mysql.go @@ -37,16 +37,16 @@ func (q *Queries) GetUserById(ctx context.Context, id int32) (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, 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, diff --git a/sql/users.sql b/sql/users.sql index 3e0e992..9f1b5ef 100644 --- a/sql/users.sql +++ b/sql/users.sql @@ -5,7 +5,7 @@ SELECT * -- name: GetUserByName :one SELECT * FROM users - WHERE name = ?; + WHERE LOWER(name) = LOWER(?); -- name: GetUserById :one SELECT * |