django constraint in multi-tenant application

Question

I have a multi-tenant application where we use multi-currency.

The simplified models looks like:

class Currency(models.Model):
    multi_tenant_company = models.ForeignKey(MultiTenantCompany, on_delete=models.CASCADE)
    is_default_currency = models.BooleanField(default=False)

Now I want to add a unique db constraint on this model where every multi_tenant_company can only have 1 default currency.

My current approach, which fails is:

    class Meta:
        constraints = [
            models.UniqueConstraint(
                fields=['is_default_currency', 'multi_tenant_company'],
                condition=Q(is_default_currency=True),
                name='unique_is_default_currency')
        ]

What am I missing?

S.D. · Accepted Answer · 2024-04-07 16:12:35Z

0

It seems that the answer seems to be

class Meta:
    constraints = [
        models.UniqueConstraint(
            fields=['multi_tenant_company'],
            condition=Q(is_default_currency=True),
            name='unique_is_default_currency')
    ]

In this version, the condition is only applied to the field multi_tenant_company uniqueness.

answered Apr 7, 2024 at 16:12

S.D.

2,9812 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

django constraint in multi-tenant application

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related