Submitty/Submitty

Don't delete access information for deleted course materials

Open

#10,006 建立於 2023年11月20日

在 GitHub 查看
 (1 留言) (0 反應) (0 負責人)PHP (1,066 fork)auto 404
course materialsenhancement / feature requestgood first issue

倉庫指標

Star
 (776 star)
PR 合併指標
 (PR 指標待抓取)

描述

What problem are you trying to solve with Submitty If an instructor uploads a course material, it is available on the site for some period fo time, and users access this course material, those accesses will be stored in the course_materials_access table. If the course material is later deleted, that id is removed from the course_materials table and also all accesses to that course_materials_id are removed from the course_materials_access table.

Describe the way you'd like to solve this problem Let's not delete the information from the access table. It is still relevant for student activity that they downloaded the file (and the instructor may want to know who accessed the now deleted file).

ADDITIONALLY, we should consider leaving the information about the deleted course material in the course_materials table. We can remove the file from the file system, but perhaps leave the row in the course_materials table... if necessary adding a column "deleted". This might be more involved, so perhaps this is a second PR.

NOTE: This is related to issue #10005

貢獻者指南