Looking to delete old entries from a table because they've expired? Want to do it in an elegant way?
I usually like to split this kind of functionality into two different parts: the method that does the deleting and a static method that can be invoked from cron, a celery scheduled task or a django command.
As an example, let's say we want to delete all the log entries on a system that are over 181 days (6 months) old.
Assuming a model like:
__tablename__ = 'log_entries'
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.String(80))
timestamp = db.Column(db.DateTime, default=datetime.datetime.utcnow)
First we add a method on the model that deletes expired log entries.
expiration_days = 181
limit = datetime.datetime.now() - datetime.timedelta(days=expiration_days)
cls.query.filter(cls.timestamp <= limit).delete()
You'll notice the use of
@classmethod, that's needed so we can invoke from the class and not from an object, as I'm doing in the next function (the one that can be called from a celery scheduled task, for instance):
And with this you keep it elegant: all the relevant model relevant information in the model class, so if someone changes the timestamp field to another name, they will only have to change it in the delete_expired method, but you can easily call from somewhere else like a task or command.