Skip to content

Instantly share code, notes, and snippets.

@fredkingham
Last active March 13, 2017 13:24
Show Gist options
  • Save fredkingham/57dbee1b3456f8d8311d826316c7ff4f to your computer and use it in GitHub Desktop.
Save fredkingham/57dbee1b3456f8d8311d826316c7ff4f to your computer and use it in GitHub Desktop.
from opal.models import Tagging, Episode
from django.db.models import Count
dupes = Tagging.objects.values('value', 'episode', 'user').annotate(Count('id')).order_by().filter(id__count__gt=1)
# handle non mine
for dupe in dupes:
episode = Episode.objects.get(id=dupe["episode"])
print "episode {}".format(episode)
tags = episode.tagging_set.filter(value=dupe["value"], user=dupe["user"])
tags = tags.exclude(id=tags.last().id)
tags.delete()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment