diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-22 04:36:45 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-22 04:36:53 +0900 |
| commit | a4685927a1f7fe8374a567ee74cc62aad639f4c3 (patch) | |
| tree | 1eaf5845965c4d5d2db4faf9582c17444a762ffd /backend/query.sql | |
| parent | 2512da7ca57dc4c52900417a50daf4f6f2f74054 (diff) | |
| download | phperkaigi-2025-albatross-a4685927a1f7fe8374a567ee74cc62aad639f4c3.tar.gz phperkaigi-2025-albatross-a4685927a1f7fe8374a567ee74cc62aad639f4c3.tar.zst phperkaigi-2025-albatross-a4685927a1f7fe8374a567ee74cc62aad639f4c3.zip | |
user login
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index e69de29..bdcd657 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -0,0 +1,4 @@ +-- name: GetUserAuthFromUsername :one +SELECT * FROM users +JOIN user_auths ON users.user_id = user_auths.user_id +WHERE users.username = $1; |