How to automatically delete records from database after a specific time in Django

Question

I have a model named 'Complaint' with numerous entries and I want to delete the entry if it is in database for more than 3 days. How can I do that is there any query for specifying the time. I'm also storing the time at which the entry was stored. This is my models.py file.

complaint_for = models.CharField(max_length=25, choices=COMPLAINT_CHOICES, default='Misbehave')
name = models.CharField(max_length=50)
created = models.DateTimeField(auto_now_add=True)

I also think that the best way to do this is on the DB site. More info about the dB you are using? — teoML, Dec 20 '19 at 10:11

score 2 · Accepted Answer · answered Dec 20 '19 at 10:27

To be honest, I have never worked worked with Django, but as far as I know, a good solution to delete records after a certain time interval, is to run automatically a database script. In your case, I can imagine that you have somewhere in your db-table a column which is named creation_time or something like that and then with your script you can just check if the difference between the current time and the creation_time is more or equal to the specified time interval. If so, the script deletes the record. In order to run such a script automatically, you can start a cron job . You can read more on the topic how to delete records with sql here and here on the topic cron jobs.

@Nouman Malik, you could upvote my answer or choose it as the best one in order to show others that my proposal was helpful. — teoML, Dec 22 '19 at 11:02

How to automatically delete records from database after a specific time in Django

1 Answers1