English 中文(简体)
Django query to list
原标题:Django query to list

我有一个数据库,拥有几个含有某些信息的领域的记录。

获取表内所有数据,对一些过滤器I d进行匹配:

records = Record.objects.filter(fieldA= a )

记录,I suppose,是QuerySet的标语,载有“记录清单”。 这是否正确?

现在我要说一个领域的价值观清单。

如果我这样做的话:

records = Record.objects.filter(fieldA= a ).only( fieldB )

我仍然抱着疑虑,但现在有一些推迟的领域。 我想的只是一份我想要占领一个卡地的价值观清单。 B. 出席情况 我还希望能够 gr清战地的独特价值,我相信,我只能 over弄每个记录,撤出战地,如果名单上没有的话,就添加到名单上,但情况较好。

感谢!

EDIT:我想我所期待的是什么。

Record.objects.values_list( fieldB )
最佳回答
问题回答

下面请 James。 在这里,它更加突出。 这肯定是我所期待的。

我希望一份价值清单。 使用<代码>QuerySet方法。 为了获得一份价值清单,我需要选择<代码>flat=True

Record.objects.values_list( fieldB , flat=True) 




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

An enterprise scheduler for python (like quartz)

I am looking for an enterprise tasks scheduler for python, like quartz is for Java. Requirements: Persistent: if the process restarts or the machine restarts, then all the jobs must stay there and ...

How to remove unique, then duplicate dictionaries in a list?

Given the following list that contains some duplicate and some unique dictionaries, what is the best method to remove unique dictionaries first, then reduce the duplicate dictionaries to single ...

What is suggested seed value to use with random.seed()?

Simple enough question: I m using python random module to generate random integers. I want to know what is the suggested value to use with the random.seed() function? Currently I am letting this ...

How can I make the PyDev editor selectively ignore errors?

I m using PyDev under Eclipse to write some Jython code. I ve got numerous instances where I need to do something like this: import com.work.project.component.client.Interface.ISubInterface as ...

How do I profile `paster serve` s startup time?

Python s paster serve app.ini is taking longer than I would like to be ready for the first request. I know how to profile requests with middleware, but how do I profile the initialization time? I ...

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 ...

Converting Dictionary to List? [duplicate]

I m trying to convert a Python dictionary into a Python list, in order to perform some calculations. #My dictionary dict = {} dict[ Capital ]="London" dict[ Food ]="Fish&Chips" dict[ 2012 ]="...

热门标签