diff options
Diffstat (limited to 'backend/db')
| -rw-r--r-- | backend/db/querier.go | 1 | ||||
| -rw-r--r-- | backend/db/query.sql.go | 9 |
2 files changed, 10 insertions, 0 deletions
diff --git a/backend/db/querier.go b/backend/db/querier.go index 3b9545a..2b957ba 100644 --- a/backend/db/querier.go +++ b/backend/db/querier.go @@ -25,6 +25,7 @@ type Querier interface { DeleteExpiredSessions(ctx context.Context) error DeleteSession(ctx context.Context, sessionID string) error DeleteTestcase(ctx context.Context, testcaseID int32) error + DeleteTestcaseResultsBySubmissionID(ctx context.Context, submissionID int32) error DeleteTournamentEntries(ctx context.Context, tournamentID int32) error DeleteTournamentMatches(ctx context.Context, tournamentID int32) error GetGameByID(ctx context.Context, gameID int32) (GetGameByIDRow, error) diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 50aa02e..8a13726 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -293,6 +293,15 @@ func (q *Queries) DeleteTestcase(ctx context.Context, testcaseID int32) error { return err } +const deleteTestcaseResultsBySubmissionID = `-- name: DeleteTestcaseResultsBySubmissionID :exec +DELETE FROM testcase_results WHERE submission_id = $1 +` + +func (q *Queries) DeleteTestcaseResultsBySubmissionID(ctx context.Context, submissionID int32) error { + _, err := q.db.Exec(ctx, deleteTestcaseResultsBySubmissionID, submissionID) + return err +} + const deleteTournamentEntries = `-- name: DeleteTournamentEntries :exec DELETE FROM tournament_entries WHERE tournament_id = $1 |