Skip to main content
 首页 » 编程设计

python之我得到了查询集,如何得到相关对象

2024年11月01日12luoye11

我从queryset中获取了相关对象,但是它还有一个更进一步的相关查询,如何获取这些对象?

class PropertyTaxItem(models.Model): 
    property = models.ForeignKey(Property) 
 
class Property(models.Model): 
    citizens = models.ManyToManyField(Citizen, null=True, through = 'Ownership',help_text="a property could belong to multiple citizens") 
 
class Citizen(models.Model): 
   first_name = models.CharField(max_length = 50, help_text = 'First name') 
   last_name = models.CharField(max_length = 50, help_text = 'Last name') 

我得到公民部分:

items = PropertyTaxItem.objects.filter(i_status='active').select_related('property_id').prefetch_related('property_id.citizens') 
for i in items: 
    pp.pprint(i.citizens.__dict__) 

输出是:

{'_db': None, 
'_fk_val': 10092, 
'_inherited': False, 
'core_filters': {'property__pk': 10092}, 
'creation_counter': 69, 
'instance': <Property: 306 GASHIHA, KAGINA, Kicukiro,Kicukiro>, 
'model': <class 'citizen.models.Citizen'>, 
'prefetch_cache_name': 'citizens', 
'query_field_name': 'property', 
'reverse': False, 
'source_field_name': 'asset_property', 
'symmetrical': False, 
'target_field_name': 'owner_citizen', 
'through': <class 'property.models.Ownership'>} 

但我想得到像公民这样的元素:

{'id': 18980, 
 'first_name': 'Jack', 
 'last_name' : 'blablabla', 
 .... 
 } 

怎么做?

请您参考如下方法:

你有几个问题。您正在查询 PropertyTaxItem Property 的外键,然后它有多个 Citizen。这将是一个正确的查询来选择相关的“propertys 并预取 property.citizens”

items = PropertyTaxItem.objects.filter(i_status='active').select_related('property').prefetch_related('property__citizens') 

您可以像这样访问公民:

for i in items: 
    citizens = i.property.citizens.all() # now you have a queryset of citizens.  
    # To get a list of dictionaries, you can call `.values()` on the queryset. 
    pp.pprint(citizens.values()) 

您可能遇到的另一个问题是citizens 使用自定义直通模型。使用自定义虽然模型时,ManyToManyField 查询集有一些限制。