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

This is not valid JSON. String values should have quotes around them: {"title": "My title"} — myaut
– myaut, Commented Feb 3, 2015 at 18:01
It depends on the DB wrapper/connector You are using. Don't dump the dict, take advantage of the key-value structure and use it to update multiple columns in a single query. — Krzysztof Rosiński
– Krzysztof Rosiński, Commented Feb 3, 2015 at 18:01

Vor · Accepted Answer · 2015-02-03 18:08:45Z

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)

answered Feb 3, 2015 at 18:08

Vor

35.6k47 gold badges142 silver badges196 bronze badges

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

Collectives™ on Stack Overflow

Python - How to parse JSON string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related