mxhdev / SQLChecker

GNU General Public License v3.0
1 stars 1 forks source link

Name and Student ID in summary report #18

Closed timoei closed 8 years ago

timoei commented 8 years ago

At the moment only the filename is printed in the summary report. The student's name and ID should be added too as the filename could used of multiple students (for example exercisesheet2.txt etc.). Also the filename could be changed to the full path of the submission, so that each submission can be found easily in a folder structure of the submissions.

The new header of the report should be look like: Name;StudentID;Path to submission;Right;Wrong;Ignored;Exceptions...

mxhdev commented 8 years ago
Note

A submission could have multiple authors, so some kind of delimiter has to be defined for the values in the name/studentID field. This delimiter should obviously be different to the

IOUtil.CSV_DELIMITER
Another Solution (1)

Each line is only associated with one student. If a submission is done by multiple students, then the final table will contain multiple rows for a submission which would be copies of eachother (except for the author information)

Another Solution (2)

Identify each submission only by its (relative path P). The header would then look like

Path to submission;Right;Wrong;Ignored;Exceptions...

In order to store author informations about a submission, there would be another table with the following schema

Student_id, Name, Path to submission;

The student id would work like a primary key here and assign a submission to a student. The Path P would be a foreign key referencing the "main" table This would work because every student is associated with _at most one_ submission

timoei commented 8 years ago

This issue was fixed with commit a40ef07ec3e7f8b0a96fb8d426c594b38a8ad53f

The new fields name and student ID were added to the summary report. Multiple authors are represented in one line for seperating the names/ids the IOUtil.VALUE_DELIMTER is used.