import requests
class Classrequset:
    def Claete(self):
        r = requests.get('http://www.baidu.com')
        print(r.text)
a=Classrequset()
a.Claete()     

payload = {'key1': 'value1', 'key2': 'value2', 'key3': None}
r = requests.get('http://www.baidu.com ', params=payload)

    def XWTTMethod(self):
        params = {"type": "guonei", "key": "4b72107de3a197b3bafd9adacf685790"}
        r = requests.get("http://v.juhe.cn/toutiao/index", params=params)
        print(r.text)
a=Classrequset()
a.XWTTMethod()

 payload = {'key1': 'value1', 'key2': 'value2'}
 r = requests.post("http://httpbin.org/post", data=payload)

 def XWTTMethodpost(self):
        uripost="http://v.juhe.cn/toutiao/index"
        datapost={"type":"youxi","page":"1","size":"10","key":"ff64bdb75dd1fbc636724101514cfbe7"}
        r =requests.post(url=uripost,data=datapost)
        print(r.text)
        # print(r.status_code) #這是查看狀態(tài)碼的
a=Classrequset()
a.XWTTMethodpost()

r.status_code        響應(yīng)狀態(tài)碼
r.heards             響應(yīng)頭
r.cookies            響應(yīng)cookies
r.text               響應(yīng)文本
r. encoding          當(dāng)前編碼
r. content		    以字節(jié)形式（二進(jìn)制）返回

url = 'http://httpbin.org/post'
files = {'file': open('report.xls', 'rb')}
r = requests.post(url, files=files)

import csv
class ReadCsv():
    def readCsv(self):
        item = []
        rr = csv.reader(open("../request/1212223.csv"))
        for csv_i in rr:
            item.append(csv_i)
        return item

a=ReadCsv()
print(a.readCsv())

from request.dataDemo import ReadCsv
import requests
r=ReadCsv()
ee=r.readCsv()
ltms=[]
class RequestClass:
    def requesthome(self):
        for a in ee:
            if a[2]=="get":
              ss=requests.get(url=a[0],params=a[1])
              ltms.append(ss.status_code)
            else:
              ss=requests.post(url=a[0],data=a[1])
              ltms.append(ss.status_code)
        return ltms
q=RequestClass()
print(q.requesthome())

import pytest, allure, os
from request.request03_csv import RequestClass

r = RequestClass()
aa = r.requesthome()


class TestRequest:
    def testcvsHose(self):
        for s in aa:
            assert s == 200


if __name__ == '__main__':
    pytest.main(['--alluredir','report/result','requests_test.py'])
    split = 'allure ' + 'generate ' + './report/result ' + '-o ' + './report/html ' + '--clean'
    os.system(split)

from openpyxl import load_workbook
class UseExcel():
    def get_TestExcel(self):
        # 打開表
        workbook = load_workbook('./777.xlsx')
        # 定位表單
        sheet = workbook['Sheet1']
        print(sheet.max_row)     #3 行
        print(sheet.max_column)  #3 列
        test_data = []#把所有行的數(shù)據(jù)放到列表中
        for i in range(2,sheet.max_row+1):
            sub_data = {}#把每行的數(shù)據(jù)放到字典中
            for j in range(1,sheet.max_column+1):
                sub_data[sheet.cell(1,j).value] = sheet.cell(i,j).value
            test_data.append(sub_data)#拼接每行單元格的數(shù)據(jù)
        return test_data
t = UseExcel()
f = t.get_TestExcel()
print(f)

import requests
from request.requestxls import UseExcel
a=UseExcel()
f = a.get_TestExcel()
item = []
class Use_Requestexcel():
    def qualification_mord(self):
        for excel_i in f:
             if excel_i["method"] == "get":
                rr = requests.get(url=excel_i["url"],params=excel_i["paras"])
                item.append(rr.status_code)
             else:
                rr = requests.post(url=excel_i["url"],data=excel_i["paras"])
                item.append(rr.status_code)
        return item

r=Use_Requestexcel()

import pytest, allure, os
from request.requestextes import Use_Requestexcel
r = Use_Requestexcel()
aa = r.qualification_mord()

print(aa)
class Testrequest:
    def testcvsHose(self):
        for s in aa:
            assert s == 200

if __name__ == '__main__':
    pytest.main(['--alluredir','report/result','test_req.py'])
    split = 'allure ' + 'generate ' + './report/result ' + '-o ' + './report/html ' + '--clean'
    os.system(split)