数据分析笔记二：python数据库请求接口端（简单写法）

本次程序对接数据分析笔记一，请运行了数据分析一中的代码再运行此代码，没有postman的小伙伴可以试试自己请求接口哦。

import requests
import time

 
 #你的接口请求地址
g_request_url = "************/"
 
 #串行请求 
def getUser(request_get,my_id):
     get_fun = requests.get(request_get+"/getUser",params={"my_id":my_id})
     return get_fun
if __name__ == '__main__':
    my_id = "1024"
    #发送请求
    result=getUser(g_request_url,my_id)
    print(result.json())
    #确保运行成功
    code = result.status_code


def delete(request_del,my_id):
    delete_pain =requests.delete(request_del+"/delete",params={"my_id":my_id})
    return delete_pain
if __name__ == '__main__':
    my_id = "1024"
    #发送请求
    # result=delete(g_request_url,my_id)
    # code = result.status_code
def update(request_update,my_id,name,player_name,height):
    update_annoyance=requests.patch(
        request_update+"/update",params={"my_id":my_id,"name":name,"player_name":player_name,"height":height})
    return update_annoyance
if __name__ == '__main__':
    my_id = "1025"
    player_name="444"
    name="111"
    height="1.33"
    #发送请求
    #result=update(g_request_url,my_id,name,player_name,height)
    # code = result.status_code
    # print(code)
def add(request_add,my_id,name,player_name,height):
    add_luck=requests.post(
        request_add+"/add",params={"my_id": my_id,"name":name,"player_name":player_name,"height":height})
    return add_luck
if __name__ == '__main__':
    start=time.time()
    arr = []
    data1 = {
        "my_id" : "1026",
        "player_name" : "444",
        "name" : "mark",
        "height" : "1.88",
    }
    data2 = {
        "my_id" : "1026",
        "player_name" : "444",
        "name" : "mark",
        "height" : "1.88",
    }

    arr.append(data1)
    arr.append(data2)
    for data in arr:
        result = add(g_request_url, data["my_id"], data["name"], data["player_name"], data["height"])
        code = result.status_code
        print(code)

    end=time.time()
    print(time.strftime("%Y-%M-%D %H:%M:%S"),end-start)