diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-28 00:57:07 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-28 00:57:07 +0900 |
| commit | ab2a49654a7964bf9e6222b17676ca87588b88d8 (patch) | |
| tree | 4674b807c4e32efd9919e6ab90019e5b68a84d19 /backend/query.sql | |
| parent | b70fa3abf9c96871cc3e39090e9a00da4ad87b8b (diff) | |
| parent | 519008c4bae3db046004e4bc2aaa23a2e66311c7 (diff) | |
| download | phperkaigi-2025-albatross-ab2a49654a7964bf9e6222b17676ca87588b88d8.tar.gz phperkaigi-2025-albatross-ab2a49654a7964bf9e6222b17676ca87588b88d8.tar.zst phperkaigi-2025-albatross-ab2a49654a7964bf9e6222b17676ca87588b88d8.zip | |
Merge branch 'auth'
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/backend/query.sql b/backend/query.sql index bdcd657..165c2c9 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -1,4 +1,10 @@ --- name: GetUserAuthFromUsername :one +-- name: GetUserById :one +SELECT * FROM users +WHERE users.user_id = $1 +LIMIT 1; + +-- name: GetUserAuthByUsername :one SELECT * FROM users JOIN user_auths ON users.user_id = user_auths.user_id -WHERE users.username = $1; +WHERE users.username = $1 +LIMIT 1; |