diff options
| author | jwansek <eddie.atten.ea29@gmail.com> | 2022-04-27 19:42:55 +0100 |
|---|---|---|
| committer | jwansek <eddie.atten.ea29@gmail.com> | 2022-04-27 19:42:55 +0100 |
| commit | d0f18184cb8619a1b4c1c540cf6af66eaacac239 (patch) | |
| tree | 0066a262a65ac3d0c0377c96d24b774ac73b58c6 /Smarker/database.py | |
| parent | 2c891af807fd46b72a539ee99040dee18b3cd6e3 (diff) | |
| download | Smarker-d0f18184cb8619a1b4c1c540cf6af66eaacac239.tar.gz Smarker-d0f18184cb8619a1b4c1c540cf6af66eaacac239.zip | |
Added adding submissions to database
Diffstat (limited to 'Smarker/database.py')
| -rw-r--r-- | Smarker/database.py | 6 |
1 files changed, 3 insertions, 3 deletions
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() |