Python Django json serialise

Question

I have a mysql objects.filter that I was trying to serialise to json. My fields are domain, generated_on, id, priority_mx, record, record_points_to, ttl

However, after I serialise the data like

from getdata.models import record_search
query_data = record_search.objects.filter(**filter_kwargs).only("domain", "record", "record_points_to", "priority_mx", "ttl", "generated_on")
data = serializers.serialize(lang, query_data)

my data has one additional field

model: "getdata.record_search"

I tried to remove it, by trying to select the fields as

 data = serializers.serialize(lang, query_data, fields=('domain','record_points_to'))

but model: "getdata.record_search" still remains in my serialised json data. What is the best way to exclude this?

As of now, since the serializers.serialize() returns a string, I am doing it as

return re.sub('\"model\"\:\s+?\"getdata\.record_search\"\,', "", data)

But I am sure this is an ugly way to do this. What is the pythonic best way to achieve this?

catavaran · Accepted Answer · 2015-01-25 02:26:16Z

1

Serialization is used for serializing/unserializing of models. Django is unable to unserialize model without this "model" field.

Why you use serialization at all? Why not use standard json library?

import json
from getdata.models import record_search

query_data = record_search.objects.filter(**filter_kwargs) \
                          .values("id", "domain", "record", "record_points_to",
                                  "priority_mx", "ttl", "generated_on")
data = json.dumps(list(query_data))

answered Jan 25, 2015 at 2:26

catavaran

45.7k8 gold badges104 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

guy_next_door Over a year ago

Thanks Catavaran. I was using serialize because, I pass json or xml or yaml through a query string, which I pass it on to serialize, rather than writing separate functions to achieve this. Looks like I'm gonna use your solution.

Collectives™ on Stack Overflow

Python Django json serialise

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related