Python - How to parse JSON string

Question

I am trying to find a way to parse a JSON string and save them into mysql. This is my json!

{"title": My title, "desc": mydesc, "url": http//example.com}

From now i don't have problem to save all json into one column usining json.dumps() so actually I'm trying to parse each joson data string to send him to mysql table. Title | Desc | Url.

This is my python code for desc example (pyspider-resultdb.py)

def _parse(self, data):
    for key, value in list(six.iteritems(data)):
        if isinstance(value, (bytearray, six.binary_type)):
            data[key] = utils.text(value)
    if 'result' in data:
        decoded = json.loads(data['result'])
        data['result'] = json.dumps(decoded['desc'])
    return data

def _stringify(self, data):
    if 'result' in data:
         decoded = json.loads(data['result'])
         data['result'] = json.dumps(decoded['desc'])
    return data

Answer 1

It's unclear from your question what you trying to achieve, but If your question is how to convert JSON to python dict and then load to the table, then that's how you can do it:

my_dict = json.loads('{"title": "foo", "dest": "bar"}')
curs.execute('INSERT INTO test (title, dest) values(%(title)s, %(dest)s)', my_dict)