djagngo 获取所有带有条件的 .objects.filter()

Question

我有一个包含许多列的表 Batch

Column  Type    Comment
id  bigint(20) Auto Increment   
start_date  datetime(6) NULL    
acerage double  
batch_health    int(11) NULL    
stage   varchar(100) NULL   
expected_delivery_date  datetime(6) NULL    
current_pdd double NULL 
historic_pdd    double NULL 
current_gdd double NULL 
historic_gdd    double NULL 
sub_farmer_id   int(10) unsigned NULL   
batch_status    varchar(100)    
commodity_id    int(10) unsigned NULL   
commodity_variety_id    int(10) unsigned NULL   
farm_id bigint(20) NULL 
created_at  datetime(6) 
created_by_id   int(10) unsigned NULL   
updated_at  datetime(6) 
updated_by_id   int(10) unsigned NULL   
actual_produce  double NULL 
actual_yield_per_acre   double NULL 
expected_produce    double NULL 
historical_yield_per_acre   double NULL 
sop_adherence   double NULL 
end_date    datetime(6) NULL    
batch_median_health int(10) unsigned NULL   
batch_name  varchar(200) NULL   
commodity_name  varchar(200) NULL   
pending_tasks   int(10) unsigned NULL   
pest_attack varchar(500) NULL   

当我尝试从该表获取对象时，

Batch.objects.filter(farm_id = farm_id, batch_status='completed')

，就像已经定义了 farm_id 变量 一样 那么我应该该批次的所有数据列 但我没有得到所有的列，我只得到一个批次名称作为输出，

 (2706) Papaya | 2021-03-18
 (2707) Papaya | 2021-03-18

如何获取 dict 中的所有列？ 这样我就可以在batchyield的过滤器中使用它

batch_id Is a foreign key in batchyield which is batch table ID

并获取batchyield的所有数据 经过

Batchyield.objects.filter(batch_id=batch_id)

Answer 1

试试这个：

batch_ids = Batch.objects.filter(
    farm_id = farm_id, batch_status='completed'
).values_list('id', flat=True)

batch_yields = Batchyield.objects.filter(batch_id__in=batch_ids)

values_list('id', flat=True) 返回 Batch 对象的 id 列的查询集