Generating json in python for app engine

Question

I am somewhat new to python and I am wondering what the best way is to generate json in a loop. I could just mash a bunch of strings together in the loop, but I'm sure there is a better way. Here's some more specifics. I am using app engine in python to create a service that returns json as a response.

So as an example, let's say someone requests a list of user records from the service. After the service queries for the records, it needs to return json for each record it found. Maybe something like this:

{records: 
{record: { name:bob, email:[e-mail], age:25 } },
{record: { name:steve, email:[e-mail], age:30 } }, 
{record: { name:jimmy, email:[e-mail], age:31 } }, 
}

Excuse my poorly formatted json. Thanks for your help.

Answer 1

Few steps here.

First import simplejson

from django.utils import simplejson

Then create a function that will return json with the appropriate data header.

def write_json(self, data):
  self.response.headers['Content-Type'] = 'application/json'
  self.response.out.write(simplejson.dumps(data))

Then from within your post or get handler, create a python dictionary with the desired data and pass that into the function you created.

 ret = {"records":{
   "record": {"name": "bob", ...}
   ...
 }
 write_json(self, ret)

Answer 2

Creating your own JSON is silly. Use json or simplejson for this instead.

>>> json.dumps(dict(foo=42))
'{"foo": 42}'

Answer 3

My question is how do I add to the dictionary dynamically? So foreach record in my list of records, add a record to the dictionary.

You may be looking to create a list of dictionaries.

records = []
record1 = {"name":"Bob", "email":"[e-mail]"}
records.append(record1)    
record2 = {"name":"Bob2", "email":"[e-mail]"}
records.append(record2)

Then in app engine, use the code above to export records as json.