Add JSONObject to a JSON Array

Question

I am new to Python. Here is my code

class Test(Base):
     __tablename__ = 'test'
     __public__ = ('my_id', 'name')
     my_id = Column(Integer, primary_key=True)
     name = Column(String)
     def __init__(self, id, name):
         self.my_id = id
         self.name = name
     def __repr__(self):
         return "<User('%d','%s')>" % (self.id, self.name)
     @property   
     def json(self):    
         return to_json(self, self.__class__)

output=[]
users= cess.query(Test).order_by(Test.my_id).distinct().all()
for c in users:
    output.append(c.json)

print json.dumps(output)

But this is not correct json? I want to add all the json objects from the for loop into a proper json array, so the client can loop over it ? How can i do this ?

I think you should simplify your code in order for us to understand it. Also, that will likely find the source of the error. — philshem, Oct 01 '13 at 19:22
If you give us an [SSCCE](http://sscce.org), we can run your example and figure out what it's doing wrong. Otherwise, we have to guess what the "this" is and in what way it's not correct JSON (or maybe just not the JSON you expected?) and how the code you haven't shown us might be generating it and so on, which means the odds of us giving you a useful answer are pretty slim. — abarnert, Oct 01 '13 at 19:48

score 1 · Accepted Answer · edited May 23 '17 at 12:03

1

You can construct a list of dicts from your query results. Define to_dict method on your model (taken from here):

class Test(Base):
   ...

   def to_dict(self):
       return {c.name: getattr(self, c.name) for c in self.__table__.columns}

Then, make a list of dicts and dump it to json:

users = cess.query(Test).order_by(Test.my_id).distinct().all()
output = [c.to_dict() for c in users]

print json.dumps(output)

Also see:

edited May 23 '17 at 12:03

Community

1
1

answered Oct 01 '13 at 19:24

alecxe

462,703
120
1,088
1,195

@BadLuckBrian could you give an example? – alecxe Oct 01 '13 at 19:43
The Test class has only a string and a integer ? What if this has nested classes ? Will the dict function work then as well ? – AndroidDev Oct 01 '13 at 19:57
@BadLuckBrian I'm pretty sure it'll take only table columns into account - it's a pretty straightforward approach. – alecxe Oct 01 '13 at 19:59

Add JSONObject to a JSON Array

1 Answers1