From fafd9e842e9002ed67c7aaed8c8af99187e5b35d Mon Sep 17 00:00:00 2001 From: Guillaume Pellerin Date: Mon, 15 Feb 2021 11:09:40 +0100 Subject: [PATCH] add django command to delete messages older than 1 year --- .../teleforma-delete-jqchat-messages.py | 20 +++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 teleforma/management/commands/teleforma-delete-jqchat-messages.py diff --git a/teleforma/management/commands/teleforma-delete-jqchat-messages.py b/teleforma/management/commands/teleforma-delete-jqchat-messages.py new file mode 100644 index 00000000..c281d537 --- /dev/null +++ b/teleforma/management/commands/teleforma-delete-jqchat-messages.py @@ -0,0 +1,20 @@ + +from optparse import make_option +from django.conf import settings +from django.core.management.base import BaseCommand, CommandError +from django.contrib.auth.models import User +from jqchat.models import Message +import datetime + + +class Command(BaseCommand): + help = "Delete jqchat messages older than 1 year" + + def handle(self, *args, **options): + date_now = datetime.datetime.now() + date_old = date_now.replace(year=date_now.year-1) + print(date_old) + messages = Message.objects.filter(created__lte=date) + print(messages.count()) + for message in messages: + message.delete() -- 2.39.5