擅长:python、mysql、java
<p>可以使用<a href="https://docs.djangoproject.com/en/dev/ref/models/querysets/#django.db.models.Q" rel="nofollow noreferrer"><strong>^{<cd1>}</strong> objects [Django-doc]</a>对析取进行编码。<em>a的逻辑等价性→ b</em>是<em>,-a∨ b</em>:</p>
<pre><code>from django.db.models import Q
review = Review.objects.get(id=review_id)
offers = OfferGeneric.objects.filter(
Q(<b>digital_exp_score=None</b>) |
Q(<b>digital_exp_score__gte=review.digital</b>),
is_personalized=True,
)</code></pre>
<p>或者我们可以简单地筛选出<code>digital_exp_score</code>不小于review的对象。digital <code>. Django will then automatically include </code>NULL`本身:</p>
<pre><code>from django.db.models import Q
review = Review.objects.get(id=review_id)
offers = OfferGeneric.objects.filter(
~Q(<b>digital_exp_score__lt=review.digital</b>),
is_personalized=True,
)</code></pre>
<p>这里的tilde(<code>~</code>)是条件的否定</p>