Skip to content

Instantly share code, notes, and snippets.

View LordBastor's full-sized avatar

Boris Gaganelov LordBastor

  • Sofia, Bulgaria
View GitHub Profile
@victorono
victorono / remove_duplicates.py
Last active February 22, 2024 13:11
Django - remove duplicate objects where there is more than one field to compare
from django.db.models import Count, Max
unique_fields = ['field_1', 'field_2']
duplicates = (
MyModel.objects.values(*unique_fields)
.order_by()
.annotate(max_id=Max('id'), count_id=Count('id'))
.filter(count_id__gt=1)
)