Opened 8 years ago

Last modified 7 years ago

#28253 closed Bug

Integrity error in get_or_create — at Initial Version

Reported by: Anuranjit maindola Owned by: Anuranjit maindola
Component: Database layer (models, ORM) Version: 1.11
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

I came across an issue. Consider a code example below

class Config(models.Model):
    key = models.CharField(max_length=100)
    value = models.CharField(max_length=100)
    def save(self, *args, **kwargs):
         super(Config, self).save(*args, **kwargs)
         super(Config, self).save(*args, **kwargs)

Now if for the Above model I do

params = {"key":"1", "value": "2")
obj, created = Config.objects.get_or_create(**params)

I get an Integrity Error for Primary Key i.e. the database id field.

The issue as i understood comes because Django tries to insert again with duplicate Primary key. In get_or_create the create method is called with force_insert=True and a particular check in _save_table fails (line number 897) . (If this check passes django is supposed to do an update).

    # If possible, try an UPDATE. If that doesn't update anything, do an INSERT.
    if pk_set and not force_insert:

Change History (0)

Note: See TracTickets for help on using tickets.
Back to Top