diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-01 21:40:17 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-01 21:40:17 +0900 |
| commit | 7ccf1da2f7448d93f8209982813e4097af13fd70 (patch) | |
| tree | 1767a3404b19ab277312caccf442e9f88f2fcba1 /backend/query.sql | |
| parent | f6443042fbec1bd394439904f3c69e23709f7e6a (diff) | |
| parent | 9baf2a7110ecef0eb97301b179bf5a3ca9e9b774 (diff) | |
| download | phperkaigi-2025-albatross-7ccf1da2f7448d93f8209982813e4097af13fd70.tar.gz phperkaigi-2025-albatross-7ccf1da2f7448d93f8209982813e4097af13fd70.tar.zst phperkaigi-2025-albatross-7ccf1da2f7448d93f8209982813e4097af13fd70.zip | |
Merge branch 'refactor/naming-convention'
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/query.sql b/backend/query.sql index ed8c7bc..886f96c 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -1,4 +1,4 @@ --- name: GetUserById :one +-- name: GetUserByID :one SELECT * FROM users WHERE users.user_id = $1 LIMIT 1; @@ -32,7 +32,7 @@ UPDATE games SET started_at = $2 WHERE game_id = $1; --- name: GetGameById :one +-- name: GetGameByID :one SELECT * FROM games LEFT JOIN problems ON games.problem_id = problems.problem_id WHERE games.game_id = $1 |