Skip to main content
 首页 » 编程设计

python之Model.objects.filter([foreign table]).update()

2024年11月01日11zhengyun_ustc

在这种情况下,如何使用真正的 Django 代码更改 [book must etc...]:

Book.objects.filter(processed=True, [book must have all the volumes belonging to it with property is_file_processed set to True]).update(status="PU") 

模型:

class Book(models.Model): 
    title = models.CharField(max_length=100, blank=True) 
    ... 
 
 
class Volume(models.Model): 
    file = models.FileField(...) 
    ... 
    is_file_processed = models.BooleanField(default=False) 
    book = models.ForeignKey(Book) 

请您参考如下方法:

由于处理完所有卷的所有书籍的集合等于处理了至少一卷的所有书籍的集合减去所有处理了未处理卷的书籍的集合:

Book.objects.filter(processed=True, volume__is_file_processed=True).exclude(volume__is_file_processed=False).update(status="PU") 
# Or     
Book.objects.exclude(volume__is_file_processed=False).filter(processed=True, volume__is_file_processed=True).update(status="PU")