Skip to main content
 首页 » 编程设计

python之Django : get the last item of manytomanyfield

2025年05月04日8mfrbuaa

使用这些模型:

class Message(models.Model): 
    text = models.CharField(max_length=200) 
    date_send = models.DateTimeField(auto_now_add=True,editable=False) 
    emeteur = models.ForeignKey(User,null=True,related_name="+") 
 
    class Meta : 
        abstract = True 
 
 
class MessagePerso(Message) : 
    read_at = models.DateTimeField(("read at"), null=True, blank=True) 
 
class Conversation(models.Model): 
    title = models.CharField(max_length=90) 
    creator = models.ForeignKey(User,null=True,related_name="CreatorConversation") 
    recipient = models.ForeignKey(User,null=True,related_name="RecipientConversation") 
    created_at = models.DateTimeField(auto_now_add=True,editable=False) 
    messages = models.ManyToManyField(MessagePerso) 

因此,对于每个对话,我想要最后创建的 MessagePerso 的文本(对话中的 ManyToManyField)和其他信息。

所以现在,我有这个:

def .. : 
    u = request.user 
    conversations = Conversation.objects.filter(Q(creatorr=u)|Q(destinataire=u)).annotate(nbMsg=Count('messages'),date=Max('messages__date_send')).order_by('date','id') 

我没有为每个对话创建的最后一条消息的文本,这是怎么回事?

请您参考如下方法:

您可以通过 date_send 字段升序排列您的数据,如下所示:

class Message(models.Model): 
    text = models.CharField(max_length=200) 
    date_send = models.DateTimeField(auto_now_add=True,editable=False) 
    emeteur = models.ForeignKey(User,null=True,related_name="+") 
 
    class Meta : 
        abstract = True 
        ordering = ['date_send'] # default ordrer while fetching data 

对于每个对话的消息,您使用 .last() 获取最后一条消息:

def .. : 
    u = request.user 
    conversation_id_list = Conversation.objects.filter(Q(creatorr=u)|Q(destinataire=u)).values_list('id', flat=True) 
    message_list = list(() 
    for id in conversation_id_list: 
        last_message = MessagePerso.objects.filter(conversation_id=id).last() 
        message_list.append(last_message) 
        print(last_message.text) 

如果对话的数量有点大,你想尽量减少数据库查询,你可以使用 prefetch_related

def .. : 
    u = request.user 
    conversation_list = Conversation.objects.filter(Q(creatorr=u)|Q(destinataire=u)).preftech_related('messages') 
    messages_dict =dict() 
    for conversation in conversation_list: 
        messages_dict.update({ 
            converstaion.id: conversation.messages.all() 
        }) 
    last_message_list = list() 
    for conversation_id, message_list in messages_dict.items(): 
        if message_list: 
          last_message = messages_dict.get(conversation_id)[len(message_list) -1:] 
          last_message_list.append(last_message) 
          print(last_message.text)