aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/query.sql.go
diff options
context:
space:
mode:
Diffstat (limited to 'backend/db/query.sql.go')
-rw-r--r--backend/db/query.sql.go32
1 files changed, 32 insertions, 0 deletions
diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go
index 404f5d9..b5fef29 100644
--- a/backend/db/query.sql.go
+++ b/backend/db/query.sql.go
@@ -242,6 +242,38 @@ func (q *Queries) ListUsers(ctx context.Context) ([]User, error) {
return items, nil
}
+const updateGame = `-- name: UpdateGame :exec
+UPDATE games
+SET
+ state = $2,
+ display_name = $3,
+ duration_seconds = $4,
+ started_at = $5,
+ problem_id = $6
+WHERE game_id = $1
+`
+
+type UpdateGameParams struct {
+ GameID int32
+ State string
+ DisplayName string
+ DurationSeconds int32
+ StartedAt pgtype.Timestamp
+ ProblemID *int32
+}
+
+func (q *Queries) UpdateGame(ctx context.Context, arg UpdateGameParams) error {
+ _, err := q.db.Exec(ctx, updateGame,
+ arg.GameID,
+ arg.State,
+ arg.DisplayName,
+ arg.DurationSeconds,
+ arg.StartedAt,
+ arg.ProblemID,
+ )
+ return err
+}
+
const updateGameStartedAt = `-- name: UpdateGameStartedAt :exec
UPDATE games
SET started_at = $2