Parsing JSON to MYSQL Python 3

Question

i want to parse JSON to mysql database with python 3. Lets say i have JSON from www.test.com/api/students contains list of students, 

{
    contents: [
        {
            id:"a",
            name:"rey"
        },
        {
            id:"b",
            name:"rio"
        },
        {
            id:"c",
            name:"ramy"
        },
    ]
}

and i have database called "student" and table MSStudent contains "student_id" and "student_name".

How to parse this JSON and pass it to my database, and how i query it into model on python?

thanks.

ggupta · Accepted Answer · 2017-07-21 20:02:46Z

3

you can use the following methods:

Method 1: basic python

import json
json_data = json.loads("json string")
typ = type(json_data)
if typ == "dict":
    for key,value in json_data.items():
        print key+"=>"+val
        // insert in mysql (mysql query)
elif typ == "list":
    for k in json_data:
       print k

once you have parsed this, you may insert this in mysql. Method 2: use pandas

PS: this is just pseudo code, you need to modify it, create one function and parse every key and value, this has worked for me even for GB's of json data.

answered Jul 21, 2017 at 20:02

ggupta

7171 gold badge11 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Parsing JSON to MYSQL Python 3

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related