English 中文(简体)
如何从Django-query 获取独一值
原标题:How to fetch the unique value from Django-query

我有一个方法:

 def get_netmask(user=None):
     user = User.objects.get(username=user)
     id_user = user.id
     obj = Host.objects.get(user=id_user)
     obj = obj.ipv4_sub_net.distinct( ipv4_sub_net ).order_by( ipv4_sub_net )

     # In this line i am getting an error: ` unicode  object has no
     # attribute  distinct ` but the query is not complete . For full
     # question please follow the lines and given example

     return obj

主机模型的对象为 ipv4_sub_net ip6_sub_net 。 我对以上方法的动机是从 ip4_sub_net + >>>> 模型字段获取数值,该字段将从与请求用户(登录用户)相对应的 host 模型 模型中获取。要做到这一点, i 将 code> > reuest.user. username 到调用它时的 giget_netmask 参数。 此外, i 还要返回 ipv4_sub_net ipv6_sub_en_net seperately 中类似的条目。

For example: In table there are four coloum present:

id      user_id        ipv4_sub_net       ipv6_sub_net
1       2              1.0.0.1             /23
2       2              8.9.7.3             /23
3       1              23.2.3.4            /43
4       2              1.0.0.1             /23

所以,让我们假设请求用户是 user_id >2 2 >。 因此,根据方法定义,它将返回字典。 字典的第一个索引含有独一无二的 IPv4_sub_net + ipv6_sub_net , 即 1. 0.01> ,第二个索引将返回返回类似的 sub_net 的计数,第三个索引将返回类似的 sub>sub_net ,即ipv6 < 的计数 ,即 2 < 。

最佳回答

尝试改变

obj = obj.ipv4_sub_net.distinct( ipv4_sub_net ).order_by( ipv4_sub_net )

obj = obj.distinct( ipv4_sub_net ).order_by( ipv4_sub_net )

< 强力 > 编辑 < /强 >

第一关口,我错过了另一个错误。 您也应该更改

obj = Host.objects.get(user=id_user)

obj = Host.objects.filter(user=id_user)

get will always return a single object and throw an error if multiple objects are returned. If you re expecting a single object, then I m not really sure what you re trying 至 do.

问题回答

暂无回答




相关问题
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 ...

热门标签