如何使用Python将API响应存储在MySQL数据库中？

我真的是Python,MySQL和API开拓的新手.因此,我行使邮递员(颠末数小时的在线研究)通过布置日历建设了一个简朴的哀求.我可以或许在当田主机上建设一个MySQL数据库.我可以行使Python插入数据,可是我不想手动存储API相应.请查察我的代码,假若有任何机构可以辅佐我,我将不胜谢谢.

行使Python哀求呼唤

    import requests

    url = "https://shedul.com/api/v1/appointments"
    querystring = {"minDate":"02/01/2019","maxDate":"02/08/2019"}

    payload = ""
    headers = {
        'Authorization': "Basic ************************"}

    response = requests.request("GET",url,data=payload,headers=headers,params=querystring)
    print(response.json())

我会收到相同这样的相应(我会收到许多哀求和更多字段,但我必要的是少数几个字段),

[
    {
        "id": 2649,"firstName": "Walikada","lastName": "Sumana","phone": "7894561452","email": "wsumanar@gmail.com","date": "February 8,2019","time": "2:00pm","endTime": "3:00pm","dateCreated": "February 5,"datetimeCreated": "2019-02-05T15:57:13-0600","datetime": "2019-02-08T14:00:00-0700",},{
        "id": 264693950,"firstName": "Wade","lastName": "Gulikapupusa","phone": "789691985","email": "W.Gulika77@yhaoo.com","endTime": "2:20pm","dateCreated": "February 4,"datetimeCreated": "2019-02-04T15:05:07-0600","datetime": "2019-02-08T14:00:00-0600",}
]

我发明用于毗连MySQl数据库的代码,

import mysql.connector

connection = mysql.connector.connect(
              host="localhost",user="root",passwd="admin",database="techbrandtest"
            )
mycursor = connection.cursor()

sqlcode = """INSERT INTO techbrandtest.acuity 
                (
                    id,firstName,lastName,phone,email,date,time,endTime,dateCreated,datetimeCreated,datetime                     

                ) 
                VALUES (%s,%s,%s)"""

insertvalues = ('546606','Suneth','Tharinda','8016381256','wimalasena@gmail.com','2019-02-02','','2019-02-02 23:59:59','2019-02-05 23:59:59')

mycursor.execute(sqlcode,insertvalues)
connection.commit()
print(mycursor.rowcount,"was inserted.")

我想使其成为一个代码,并将每个相应存储在MySQL数据库上.我不确定这是太多要问的题目,可是任何辅佐将不胜谢谢.

很是感激您的参加

譬喻.,

    for i in response:
        mycursor.execute(sqlcode,(i['id'],i['firstName']))           

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!