English 中文(简体)
Django query using OR conditions
原标题:Django query using OR condition

在Django,你们如何想获得两种不同的价值观,就像以下那样?

profile_setting = (pSetting.objects.get(module="my_mod", setting_value=1) or
                   pSetting.objects.get(module="my_mod", setting_value=0))
最佳回答

http://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q-objects”rel=“noreferer”

profile_setting = pSetting.objects.get(Q(module="my_mod"),
                  Q(setting_value=1)|Q(setting_value=0))

此外,为了改进你的编码风格,请大家看一下编码准则。 PSetting

问题回答

你们是否确信你只是一个物体?

如果你试图 gr一堆物体,那么你们都需要做的是链条过滤器:

profile_setting = pSetting.objects.filter(module="my_mod", setting_value__in=0)
                         .filter(module="my_mod", setting_value__in=1)

然而,由于除了确定价值之外的一切都一样,你只能看一看一个清单或图:

profile_setting = pSetting.objects.filter(module="my_mod", setting_value__in=[0,1])

(如果你确信你只拿一个物体作为对你的询问的答复,上述建议是罚款)

 profile_setting = pSetting.objects.get(module="my_mod",setting_value__in=[0,1])




相关问题
How to get two random records with Django

How do I get two distinct random records using Django? I ve seen questions about how to get one but I need to get two random records and they must differ.

Moving (very old) Zope/Plone Site to Django

I am ask to move data from a (now offline) site driven by Plone to a new Django site. These are the version informations I have: Zope Version (unreleased version, python 2.1.3 ) Python Version 2.1....

Can Django models use MySQL functions?

Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...

Flexible pagination in Django

I d like to implement pagination such that I can allow the user to choose the number of records per page such as 10, 25, 50 etc. How should I go about this? Is there an app I can add onto my project ...

is it convenient to urlencode all next parameters? - django

While writing code, it is pretty common to request a page with an appended "next" query string argument. For instance, in the following template code next points back to the page the user is on: &...

Pragmatically adding give-aways/freebies to an online store

Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...

热门标签