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

贡献者指南