Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

django database delete specific number of entries

How to delete specific number of entries from the database? I did something like this

EntriesToDelete=Statusmessages.objects.filter(time__lt=date)[:30000]
EntriesToDelete.delete()

But I get an error which says: AssertionError. Cannot use 'limit' or 'offset' with delete.

How can I specify the number of entries to be deleted.

like image 292
arjun Avatar asked Nov 06 '12 09:11

arjun


1 Answers

You could do it like this:

Statusmessages.objects.filter(pk__in=Statusmessages.objects.filter(time__lt=date).values_list('pk')[:30000]).delete()
like image 192
jpic Avatar answered Nov 14 '22 09:11

jpic