From 71b82eca41b89437dbed7a80b3bf620cd6c0a074 Mon Sep 17 00:00:00 2001 From: Emile Date: Sat, 19 Oct 2019 21:19:10 +0200 Subject: edit challenge function --- src/db.go | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'src/db.go') diff --git a/src/db.go b/src/db.go index 6961aad..3238bf2 100644 --- a/src/db.go +++ b/src/db.go @@ -95,3 +95,14 @@ func dbNewChallenge(challenge Challenge) (string, error) { } return uuid, nil } + +// editChallengeUUID edited the challenge with the given uuid using the values in the updatedChallenge +func editChallengeUUID(uuid string, updatedChallenge Challenge) error { + query := fmt.Sprintf("UPDATE challenges SET name = '%s', description = '%s', flag = '%s', container = '%s', category = '%s', points = %d, static = %t WHERE uuid::text = '%s'", updatedChallenge.Name, updatedChallenge.Description, updatedChallenge.Flag, updatedChallenge.Container, updatedChallenge.Category, updatedChallenge.Points, updatedChallenge.Static, updatedChallenge.UUID) + + fmt.Printf("Query: %s", query) + + _, _ = db.Exec(query) + + return nil +} -- cgit 1.4.1