From f926ef682de637b717d3b0cc0eaee43c59e83c95 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Sat, 17 Aug 2024 18:59:55 +0900 Subject: feat(backend): allow login/signup with email address --- backend/db/query.sql.go | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'backend/db/query.sql.go') diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 34b0ae9..02e660a 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -245,6 +245,19 @@ func (q *Queries) GetUserByID(ctx context.Context, userID int32) (User, error) { return i, err } +const getUserIDByUsername = `-- name: GetUserIDByUsername :one +SELECT user_id FROM users +WHERE users.username = $1 +LIMIT 1 +` + +func (q *Queries) GetUserIDByUsername(ctx context.Context, username string) (int32, error) { + row := q.db.QueryRow(ctx, getUserIDByUsername, username) + var user_id int32 + err := row.Scan(&user_id) + return user_id, err +} + const isRegistrationTokenValid = `-- name: IsRegistrationTokenValid :one SELECT EXISTS ( SELECT 1 FROM registration_tokens -- cgit v1.2.3-70-g09d2