Convert queryset to list in Django

Question

I have a queryset with objects having fields date and value.

I need to populate the template with an array [[date_1, value_1],[date_2,value_2],...,[date_n,value_n]].

How is this possible when each object has multiple fields?

I have tried

MyModel.objects.values_list('date', 'value')

but date is printed in datetime format (e.g. datetime.date(2013, 9, 21)) and value is printed as decimal (e.g. Decimal('72495.0')). I need it in a flot.js chart.

http://stackoverflow.com/questions/4424435/how-to-convert-a-django-queryset-to-a-list — chandu, Jun 02 '15 at 13:58

score 2 · Answer 1 · edited May 23 '17 at 12:18

2

MyModel.objects.values_list('date', 'value', flat=True)

how-to-convert-a-django-queryset-to-a-list

edited May 23 '17 at 12:18

Community

1
1

answered Jun 02 '15 at 13:56

chandu

1,053
9
18

score 1 · Answer 2 · answered Jun 02 '15 at 13:56

1

You can use list comprehension:

[(str(my_record.date), str(my_record.value)) for my_record in MyModel.objects.all()]

In fact, this way you can transform the data however you wish.

answered Jun 02 '15 at 13:56

Wtower

18,848
11
103
80

score 0 · Answer 3 · edited May 23 '17 at 10:27

import calendar
import json

raw_data = MyModel.objects.values_list('date', 'value')

result = []
for date, value in raw_data:
    result.append([calendar.timegm(date.timetuple()) * 1000,
                   float(value)])

To use result in template, serialize it to JSON first and pass data to template

data = json.dumps(result)

In template

var data = {{ data|safe }};

Also:

How to convert datetime to timestamp

How to serialize Decimal to JSON

Convert queryset to list in Django

3 Answers3