Re: queryset field order

On 8/6/2010 1:34 PM, owidjaya wrote:
> is there a way that i can get the a list of dictionaries as a result
> with the dictionary having the same field order as the table?
>
What do you regard as the "field order" of the dictionary? If you are
talking about the order Python iterates over the field, this is not
predictable or controllable: it is an artefact of the dict
implementation, whose primary focus is on speed of operation.

But you can get the list of field names from the model using
model._meta.get_all_field_names(), create a set of (name, value) tuples
with zip() and then iterate over that?

http://stackoverflow.com/questions/2170228/django-iterate-over-model-instance-field-names-and-values-in-template

might give you some ideas.

regards
Steve

> On Aug 6, 10:18 am, Daniel Roseman <dan...@roseman.org.uk> wrote:
>> On Aug 6, 6:08 pm, owidjaya <owidj...@gmail.com> wrote:
>>
>>> I checked it and the field order still not the same.
>>> Just to clarify. I want the to do this A.objects.all().values()
>>> and still get the each list in the result to have the same "field
>>> order" as the database table defined.
>>
>> `values()` returns a set of dictionaries. Dictionaries are unordered
>> by definition.
>>
>> `values_list()` returns a set of tuples, which should be in the same
>> order as the model definition, however you don't get the fieldnames.
>> --
>> DR.
>

--
I'm no expert.
"ex" == "has-been"; "spurt" == "drip under pressure"
"expert" == "has-been drip under pressure".

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.