how to convert Sqlalchemy query result to JSON data [duplicate]

Question

When I do:

merchant = Merchant.query.all()
data = json.dumps(merchant)
data = json.load(data)

This is my queried result:

company: Rajendra | agent: None | user: zxnGiCqSPl | fullname: CtwrXsGVQZOSEwZtbYTrTkPTDjY | dob : 1989-12-12 | idproof: | mobile: 8874565109 | email : [email protected] | bankName: KOTAK | ifsc: KOTAK5064960 | acNumber: 5696245574 | MDR_Debit: 0.73 | MDR_Credit: 0.96 | MDR_CreditGold : 1.01 | address1: Vindhya C5-222 | address2: OBH | city: Hyderabad | district: Hyderabad | state: statethree | pincode: 677514

that result is not working in my case can you please elaborate it more #rmn — rajendra lora
– rajendra lora, Commented Dec 21, 2015 at 10:21

Will · Accepted Answer · 2015-12-21 10:39:43Z

2

Just put the data into a dictionary and dump the dictionary, or am I missing something:

data = {
    'company': merchant.company,
    'agent': merchant.agent,
    'user': merchant.user,
    'fullname': merchant.fullname
    'dob': merchant.dob
    ...
}
jsonified_data = json.dumps(data)

And use json.loads when loading a JSON string.

json.loads(jsonified_data)

edited Dec 21, 2015 at 10:39

answered Dec 21, 2015 at 10:33

Will

4534 silver badges8 bronze badges

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

1 Comment

rajendra lora Over a year ago

I used your concept and created a serialiser function in models and it return dictionary. So it works now. thanks

Collectives™ on Stack Overflow

how to convert Sqlalchemy query result to JSON data [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related