From d0f18184cb8619a1b4c1c540cf6af66eaacac239 Mon Sep 17 00:00:00 2001 From: jwansek Date: Wed, 27 Apr 2022 19:42:55 +0100 Subject: Added adding submissions to database --- Smarker/database.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'Smarker/database.py') diff --git a/Smarker/database.py b/Smarker/database.py index f17c285..38af6a7 100644 --- a/Smarker/database.py +++ b/Smarker/database.py @@ -140,11 +140,11 @@ class SmarkerDatabase: def add_submission(self, student_id, assessment_name, report_yaml, files): with self.__connection.cursor() as cursor: cursor.execute("INSERT INTO submissions (student_no, assessment_name, report_yaml) VALUES (%s, %s, %s);", ( - student_id, assessment_name, report_yaml + student_id, assessment_name, yaml.dump(report_yaml) )) submission_id = cursor.lastrowid - for file_name, file_contents in files: + for file_name, file_contents in files.items(): cursor.execute(""" INSERT INTO submitted_files (submission_id, file_id, file_text) @@ -152,4 +152,4 @@ class SmarkerDatabase: """, ( submission_id, file_name, file_contents )) - + self.__connection.commit() -- cgit v1.2.3