CODEWITHSUNDEEP
djangodjango-models
orokusaki
orokusaki

Reputation: 57158

Django unique_together on sub-class model for parent attribute?

In this:

class Administrator(models.Model):
    user = models.OneToOneField(User, primary_key=True)
    account = models.ForeignKey(Account)

    class Meta:
        unique_together = (('account', 'self.user.username'),)

The self.user.username part is obviously incorrrect. However, in this:

class Administrator(User):
    account = models.ForeignKey(Account)

    class Meta:
        unique_together = (('account', 'username'),)

would that work since I'm inheriting from User? (I can't test it yet because there are too many elements out of place elsewhere). Can I use the first version with 'user.username' instead though? Or, should I use the second version?

Upvotes: 13

Views: 4246

Answers (3)

Brian Edwards
Brian Edwards

Reputation: 3

What you are missing is abstract = True in the base class. This creates a table with all the fields for the subclass.

Upvotes: 0

Mike Fogel
Mike Fogel

Reputation: 3197

I don't believe you can do what you're trying to do using django core. As pointed out in this answer to a related question unique_together is enforced at the DB layer. If you inspect the DB tables created by django model inheritance, you'll see this isn't possible for the DB to accomplish.

Take a look at that related question for some alternative solutions.

Upvotes: 7

Tom
Tom

Reputation: 22841

It would be 

unique_together = (('account', 'user__username'),)

if I understand what you're trying to do. Note the double underscore. That's how you look at a foreign key's object's properties.

Upvotes: 13

Related Questions