diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-03-04 23:39:26 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-03-04 23:39:26 +0900 |
| commit | efd34b970d0d1f88fa7d7e9d69e569f039867ca2 (patch) | |
| tree | ba1e5a51e2fac9ecbe7b9b3e0e197bdb327f2a4e /backend/db | |
| parent | bd9c2e8b587c733059d44f642c53536eb7fe1ec9 (diff) | |
| download | phperkaigi-2025-albatross-efd34b970d0d1f88fa7d7e9d69e569f039867ca2.tar.gz phperkaigi-2025-albatross-efd34b970d0d1f88fa7d7e9d69e569f039867ca2.tar.zst phperkaigi-2025-albatross-efd34b970d0d1f88fa7d7e9d69e569f039867ca2.zip | |
rm registration token
Diffstat (limited to 'backend/db')
| -rw-r--r-- | backend/db/models.go | 5 | ||||
| -rw-r--r-- | backend/db/query.sql.go | 14 |
2 files changed, 0 insertions, 19 deletions
diff --git a/backend/db/models.go b/backend/db/models.go index f6e7ed1..b21fd9b 100644 --- a/backend/db/models.go +++ b/backend/db/models.go @@ -30,11 +30,6 @@ type Problem struct { Description string } -type RegistrationToken struct { - RegistrationTokenID int32 - Token string -} - type Submission struct { SubmissionID int32 GameID int32 diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 35b7edd..fdd40dd 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -258,20 +258,6 @@ func (q *Queries) GetUserIDByUsername(ctx context.Context, username string) (int return user_id, err } -const isRegistrationTokenValid = `-- name: IsRegistrationTokenValid :one -SELECT EXISTS ( - SELECT 1 FROM registration_tokens - WHERE token = $1 -) -` - -func (q *Queries) IsRegistrationTokenValid(ctx context.Context, token string) (bool, error) { - row := q.db.QueryRow(ctx, isRegistrationTokenValid, token) - var exists bool - err := row.Scan(&exists) - return exists, err -} - const listGamePlayers = `-- name: ListGamePlayers :many SELECT game_id, game_players.user_id, users.user_id, username, display_name, icon_path, is_admin, created_at FROM game_players JOIN users ON game_players.user_id = users.user_id |
