Django: Create fixtures without specifying a primary key?

David_Wolever_71522 0
Viewed 19052

One of the things that bugs me about Django fixtures is that you've got to specify every model's primary key. Is there any way to create fixtures without having to specify a primary key for each row?

fixtures django
6 Answers
user_2720310

I had to deal with existing DB schema without possibility to change it, so I need a table with complex primary key or without it at all - but not with the serial one. What I did:

I've specified a primary_key=True to the field, which should not be unique at all and wrote overloaded method:

class ContraIndicationsMedicines(models.Model):

    contra_indication = models.ForeignKey(ContraIndication, primary_key=True)
    medicine = models.ForeignKey(Medicine)

    def validate_unique(self, exclude=None): 
        pass

In fact, it worked for my needs, but there are more validations call inside django.contib.admin.* and not all the inlines e.t.c are guaranteed to work. That was the only solution I could implement... ((

user_13184170

natural primary key

With a natural primary key (where the model field option is set to "primary_key=True") you can easily leave out the specification of the primary key in your fixture. Django will automatically check for the natural primary key then and there is no risk of adding duplicate entries.

auto primary key (not manually defined pk)

When there is an automatic primary key the only option I see here is to dump the data and edit the entries with a script or set new entries' primary key to null as stated by @spookylukey.

user_111842550
Related