#22571: DateTimeField(auto_now_add=True) Breaks -------------------------+------------------------------------------------- Reporter: | Owner: nobody nu.everest@… | Status: new Type: | Version: 1.4 Uncategorized | Keywords: integrityerror auto_now_add Component: | get_or_create duplicatekey Uncategorized | Has patch: 0 Severity: Normal | UI/UX: 0 Triage Stage: | Unreviewed | Easy pickings: 0 | -------------------------+------------------------------------------------- Example: # Given this simple model class Foo(models.Model): name = models.CharField(max_length=100) date_added = models.DateTimeField(auto_now_add=True)
# This will always be true, even if an instance # with this name and today's date already exists bar, created = Foo.objects.get_or_create( name = 'Alex', date_added = some_datetime_obj ) print created # >> True # The problem is, auto_now_add does some stuff that # makes it uneditable, and messes up my expectations # when using it with get_or_create # Here's the solution class Foo(models.Model): name = models.CharField(max_length=100) date_added = models.DateTimeField(default=datetime.today()) bar, created = Foo.objects.get_or_create( name = 'Alex', date_added = some_datetime_obj ) print created # >> False Error: django.db.utils.IntegrityError: duplicate key value violates unique constraint These two links document the issue: http://alexkehayias.tumblr.com/post/33889961953/django-gotcha-duplicate- models-when-using http://stackoverflow.com/questions/9297422/get-or-create-failure-with- django-and-postgres-duplicate-key-value-violates-uni -- Ticket URL: <https://code.djangoproject.com/ticket/22571> Django <https://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-updates+unsubscr...@googlegroups.com. To post to this group, send email to django-updates@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/063.15e266088f142f4bfb7927fe4908c9c9%40djangoproject.com. For more options, visit https://groups.google.com/d/optout.