How Do I Json Encode This View?

New to python and Pyramid. I have a view that does pagination. How do I json encode it? I get an error 'object at 0x2d16d90> is not JSON serializable' when I try this: @view

Solution 1:

JSON is a strict textual format. You cannot just throw SQLAlchemy at the encoder and expect this to Just Work, you need to decide what the encoding for your objects will look like.

One way is for your SQLAlchemy objects to implement an extra method that returns a simple python dictionary; one that can be serialized. That means it can only use strings for keys, and can only contain lists, tuples, numbers and / or strings.

An example method could be:

defjson_dump(self):
    returndict(name=self.name, phone=[p.number for p in self.phonenumbers])

This returns a dictionary with name and phone keys, where the phone key contains a list of phone numbers from a (purely made up for example purposes) phonenumbers relationship.

You can then use that information to create a new list of dictionaries that json.dumps can handle:

if"partial"in request.params:
    customer_json_data = [c.json_dump() for c in customers]
    # Render the partial list pagereturn render_to_response("templates/my_json.jinja2",
                              {"customers": json.dumps(customer_json_data)},
                              request=request)

The upcoming Pyramid 1.4 adds specific support for serializing custom objects in the json renderer via the __json__ method hook, as well as support for adapters to do the conversion for you.

Solution 2:

Are you sure you want to render a template to send your JSON response? I've done something more like this in the past:

return HttpResponse(
        json.dumps(customers),
        status=200,
        mimetype="application/json")

FYI: that's Django code above... I'm not sure what the Pylons equivalent is, but I'm looking it up...