Periodically hard delete Notification records that are older than 90 days.

[rithviknishad]

Is your feature request related to a problem? Please describe.
The notification table is huge. We don't want notification records older than 90 days.

Describe the solution you'd like
Periodically hard delete records from Notifications table that are older than 90 days.

[yaswanthsaivendra]

Hey @rithviknishad , i would like to take up this one.

As far i understand, we would need to create a periodic_task using celery that would run maybe every midnight to delete all the notifications that are older than 90 days.

but can we specify a few things for me,

• Like what would be a great place to create this scheduler function(maybe inside a new file - care/facility/tasks/notification/delete_older_notifications.py)??
• period/Time to run the task(maybe every midnight)??
• 90 days later on based upon created_date field??

[rithviknishad]

1. Yes, that place looks right!
2. Yes, every midnight should be fine.
3. Yes, based upon created_date field which is when the notification record has been created.

[rithviknishad]

cc: @yaswanthsaivendra