擅长:python、mysql、java
<p>如果更改模型的成本不高,则可以将相关名称添加到FK字段:</p>
<pre><code>class Record(models.Model):
# autogen id as primary key
name = models.ForeignKey(Product, on_delete=models.DO_NOTHING)
value = models.FloatField()
date = models.DateTimeField()
class Integration(models.Model):
# autogen id as primary key
action = models.FloatField()
on_record = models.ForeignKey(Record, on_delete=models.DO_NOTHING, related_name='integration')
</code></pre>
<p>然后可以执行以下查询:</p>
<pre><code>Record.objects.all().annotate(integration_avg_action=Avg('integration__action')).values('name', 'value', 'date', 'integration_avg_action')
</code></pre>