Auto-cleanup courses for ended semesters

[AdamFipke]

Problem

The chatbot documents and their chunks take up close to a majority of the space in our system. At this rate we will eventually run out of space on our server without demanding more and more from IT. Not good.

Solution Maybe

Have some kind of cleanup service that will:

• Run periodically. Maybe every month or 4.

• Emails all professors who have courses that are assigned to semesters that have ended that notify them of the following:

  • "Your courses course1 (link), course2 (link), course3 (link) are assigned to a semester that has ended and will be archived on (some date that's like 2 weeks from this email). On this date, the following will occur automatically unless the course is re-assigned to a semester that has not yet ended:
    • All uploaded chatbot documents will be deleted (to save server space. Questions are still saved). This includes data downloaded from Canvas
    • The Canvas integration will be severed
    • The course will be marked as archived

  This is meant to be an automatic-cleanup process. If this course has ended and not being used anymore, you can safely disregard this email."

Note for the sake of robustness, only consider semesters who end date is past the year 2023 (since if it's before then, it's probably an invalid or test semester).