diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-12 01:23:54 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-12 01:23:54 +0900 |
| commit | 5964fa404909550a2dd42a75633fef223fdb05fb (patch) | |
| tree | d282d098690d0a85930d89ff68f47507c0eb5d7c /backend/db/query.sql.go | |
| parent | 8c7d882dfa67bcef37a4f39be6f1ca57f160b816 (diff) | |
| download | iosdc-japan-2024-albatross-5964fa404909550a2dd42a75633fef223fdb05fb.tar.gz iosdc-japan-2024-albatross-5964fa404909550a2dd42a75633fef223fdb05fb.tar.zst iosdc-japan-2024-albatross-5964fa404909550a2dd42a75633fef223fdb05fb.zip | |
feat: do not show preliminary score
Diffstat (limited to 'backend/db/query.sql.go')
| -rw-r--r-- | backend/db/query.sql.go | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 583389e..34b0ae9 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -174,6 +174,19 @@ func (q *Queries) GetGameByID(ctx context.Context, gameID int32) (GetGameByIDRow return i, err } +const getSubmissionCodeSizeByID = `-- name: GetSubmissionCodeSizeByID :one +SELECT code_size FROM submissions +WHERE submission_id = $1 +LIMIT 1 +` + +func (q *Queries) GetSubmissionCodeSizeByID(ctx context.Context, submissionID int32) (int32, error) { + row := q.db.QueryRow(ctx, getSubmissionCodeSizeByID, submissionID) + var code_size int32 + err := row.Scan(&code_size) + return code_size, err +} + const getUserAuthByUsername = `-- name: GetUserAuthByUsername :one SELECT users.user_id, username, display_name, icon_path, is_admin, created_at, user_auth_id, user_auths.user_id, auth_type, password_hash FROM users JOIN user_auths ON users.user_id = user_auths.user_id |