Convert SQL into json in Python [duplicate]

Question

I need to pass an object that I can convert using $.parseJSON. The query looks like this:

cursor.execute("SELECT earnings, date FROM table")

What do I need to do from here in order to pass an HttpResponse object that can be converted into json?

mata · Accepted Answer · 2012-05-31 19:00:42Z

15

Well, if you simply do:

json_string = json.dumps(cursor.fetchall())

you'll get an array of arrays...

[["earning1", "date1"], ["earning2", "date2"], ...]

Another way would be to use:

json_string = json.dumps(dict(cursor.fetchall()))

That will give you a json object with earnings as indexes...

{"earning1": "date1", "earning2": "date2", ...}

If that's not what you want, then you need to specify how you want your result to look...

answered May 31, 2012 at 19:00

mata

69.3k10 gold badges168 silver badges162 bronze badges

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

2 Comments

Nayan Over a year ago

Using, the dict() function gave an error

mata Over a year ago

@Nayan Not sure how that relates to the original question, but I guess you're not passing a list of pair-like items to it?

Maus · Accepted Answer · 2012-05-31 19:00:17Z

0

Have you investigated the json library?

The following will serialize your data base output into json. I'm not sure what you data looks like, or what you need the json to look like, but if you just keep in mind that python lists -> arrays, and python dicts -> objects, I think you'll be alright.

import json
json.dumps(data)

answered May 31, 2012 at 19:00

Maus

1,8431 gold badge18 silver badges29 bronze badges

Collectives™ on Stack Overflow

Convert SQL into json in Python [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related