擅长:python、mysql、java
<p>在<code>ExtractHour</code>内使用<code>OuterRef</code>:</p>
<pre class="lang-py prettyprint-override"><code>
from django.db.models.functions import ExtractHour
...
query = StatByHour.objects.filter(
hour_of_day=ExtractHour(ExpressionWrapper(
# NOTE: `OuterRef()+something` works only on Django >= 2.1.0
OuterRef("article__created_on") + timedelta(0, avg_fp_time_in_seconds),
output_field=models.DateTimeField()
),
)
)
qset = ArticleStat.objects.filter(
votes__gte=(
F("article__website__stats__total_score")
/
F("article__website__stats__num_articles")
*
Subquery(
query.values('index')[:1],
output_field=FloatField()
)
*
day_of_week_index
),
)
</code></pre>