diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-31 01:49:34 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-31 01:49:34 +0900 |
| commit | 7a06def8085b432994dc054037183795e7ec25a0 (patch) | |
| tree | 95456a82897787bac87c350dbc65cad6f35e4ebd /backend/query.sql | |
| parent | 19a75493f5897685cb36c66c7bb3d31ea6a6bd2d (diff) | |
| parent | 5bcffc6a83021b2bcb06b8c6f622a1d623fc753e (diff) | |
| download | phperkaigi-2025-albatross-7a06def8085b432994dc054037183795e7ec25a0.tar.gz phperkaigi-2025-albatross-7a06def8085b432994dc054037183795e7ec25a0.tar.zst phperkaigi-2025-albatross-7a06def8085b432994dc054037183795e7ec25a0.zip | |
Merge branch 'admin'
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index b2ad2c4..ca2095c 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -3,6 +3,9 @@ SELECT * FROM users WHERE users.user_id = $1 LIMIT 1; +-- name: ListUsers :many +SELECT * FROM users; + -- name: GetUserAuthByUsername :one SELECT * FROM users JOIN user_auths ON users.user_id = user_auths.user_id |