edit challenge function

1 files changed, 11 insertions, 0 deletions

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
+}