查询相关lis中的最后一项

2024-05-28 18:05:04 发布

您现在位置:Python中文网/ 问答频道 /正文

我有型号.py看起来像

class Node(models.Model):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)

    created = models.DateTimeField(auto_now_add=True)
    updated = models.DateTimeField(auto_now=True)

    org_env = models.ForeignKey(OrgEnv)

    name = models.CharField(max_length=100)
    tags = models.ManyToManyField(Tag)

    def __unicode__(self):
        return self.name


class Run(models.Model):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)

    created = models.DateTimeField(auto_now_add=True)
    updated = models.DateTimeField(auto_now=True)

    node = models.ForeignKey(Node)

    job_id = models.CharField(max_length=100)
    module = models.CharField(max_length=100)
    arguments = models.CharField(max_length=200)
    return_code = models.IntegerField()
    run_time = models.DecimalField(max_digits=10, decimal_places=4)

每个节点可以有许多运行,我想查询出所有节点和他们的最后一次运行的基础上创建的日期。你知道吗


Tags: keyidnodetrueautomodelmodelslength

热门问题