Yes, using things like models.F('price') made it !
Thank you very much, Leonardo, for this.
Le mercredi 13 novembre 2019 13:35:37 UTC+1, LRezende a écrit :
>
> Hi,
> Didn't tested... Did you try the F expression?
>
> from django.db import models
> class Customer(models.Model):
> age = models.IntegerField()
>
> class Meta:
> constraints = [
>
> models.CheckConstraint(check=models.Q(discounted_price__lte=models.F('price')),
> name='age_gte_18'),
> ]
>
>
> Em ter., 12 de nov. de 2019 às 14:14, Olivier <oza...@gmail.com
> <javascript:>> escreveu:
>
>> hello,
>>
>> Looking at [1], I can see examples where one can check at database level,
>> that a model field min_foo satisfies a constraint such as "min_foo > 5".
>> How do you write a constraint involving two different fields like
>> "min_foo < max_foo" or "discounted_price < price" ?
>>
>> PostgreSQL doc shows how to write such constraint but how to express
>> those with Django 2.2 ?
>>
>> [1] https://docs.djangoproject.com/en/2.2/ref/models/constraints/
>>
>> Best regards
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django...@googlegroups.com <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/43d1b1aa-9261-4ebc-b54f-761959c01c31%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/django-users/43d1b1aa-9261-4ebc-b54f-761959c01c31%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
>
> --
> --
>
> Leonardo Rezende
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/ce19686c-8a3b-4d29-bc81-33137560737a%40googlegroups.com.
