django-sql：sql查询集 [英] django-sql : sql to query set

问题描述

我有2个表格如下：

puzz_meeting_candidats :
  - id, canceled, candidat_id, meeting_id
puzz_meeting :
  - id, Client

我有一个查询：

SELECT U1.`candidat_id` AS Col1 FROM `puzz_meeting_candidats` U1 
 INNER JOIN `puzz_meeting` U2 ON ( U1.`meeting_id` = U2.`id` ) 
 WHERE U2.`Client` LIKE '%ipsos%' AND U1.`canceled` = False

如何使用Django中的Q对象将条件转换为查询语句。我非常感谢你的帮助！ ：D

How to convert query above to queryset with condition using Q object in Django. I'm so thank for your helping!!! :D

推荐答案

假设你的模型看起来像这样：

Assuming your models look like something this:

class PuzzMeetingCandidats(models.Model):
    canceled = models.BooleanField(default=False)
    candidat = models.ForeignKey('Candidat')
    meeting = models.ForeignKey('PuzzMeeting')

class PuzzMeeting(models.Model):
    Client = models.CharField(max_length=128, null=True)

您可以编写一个这样的查询，而不使用 Q ：

You can write a query like this without using Q:

qs = PuzzMeetingCandidats.objects.filter(
    canceled=False, 
    meeting__Client__contains='ipsos')

说，你没有发布你的模型，我们需要先看看，帮助你写出来查询。

That said, you have not posted your models, and we’d need to see those first to help you out with writing the query.

这篇关于django-sql：sql查询集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！