{
  "dataItem": [
    {
      "id": "testget-1",
      "name": "草料二維碼get接口1",
      "headers":{
        "Accept-Encoding":"gzip, deflate, br"
      },
      "url":"/qrcode/getDefaultComponentMsg",
      "method":"get",
      "expectdata": {
        "code": "1"
      }
    },


    {
      "id": "testget-2",
      "name": "草料二維碼get接口2",
      "headers":{},
      "url":"/qrcode/getDefaultComponentMsg",
      "method":"get",
      "expectdata": {
        "code": "1"
      }
    }
  ]
}

{
    "id":"testpost-1",
    "name":"草料二維碼post接口1",
    "url":"/Apis/QrCode/saveStatic",
    "headers":{
        "Content-Type":"application/x-www-form-urlencoded",
        "Accept-Encoding":"gzip, deflate, br"
    },
    "parameters":{
        "info":11111,
        "content":11111,
        "level":"H",
        "size":500,
        "fgcolor":"#000000",
        "bggcolor":"#FFFFFF",
        "transparent":"false",
        "type":"text",
        "codeimg":1
    },
    "expectdata":{
        "status":"1",
        "qrtype":"static"
    }
}

# 配置HTTP接口的域名，方便一套腳本用于多套環(huán)境運(yùn)行時(shí)，只需要改這里的全局配置就OK
CAOLIAO_HTTP_POST_HOST = "https://cli.im"
CAOLIAO_HTTP_GET_HOST = "https://nc.cli.im"

import json
import os

class ReadJsonFileUtils:
    def __init__(self, file_name):
        self.file_name = file_name
        self.data = self.get_data()

    def get_data(self):
        fp = open(self.file_name,encoding='utf-8')
        data = json.load(fp)
        fp.close()
        return data

    def get_value(self, id):
        return self.data[id]

    @staticmethod
    def get_data_path(folder, fileName):
        BASE_PATH = os.path.dirname(os.path.dirname(os.path.realpath(__file__)))
        data_file_path = os.path.join(BASE_PATH, folder, fileName)
        return data_file_path

if __name__ == '__main__':
    opers = ReadJsonFileUtils("..\\resources\\test_http_post_data.json")
    #讀取文件中的dataItem,是一個(gè)list列表，list列表中包含多個(gè)字典
    dataitem=opers.get_value('dataItem')
    print(dataitem)

import requests
import json

class HttpUtils:
    @staticmethod
    def http_post(headers, url, parameters):
        print("接口請(qǐng)求url：" + url)
        print("接口請(qǐng)求headers：" + json.dumps(headers))
        print("接口請(qǐng)求parameters：" + json.dumps(parameters))
        res = requests.post(url, data=parameters, headers=headers)
        print("接口返回結(jié)果："+res.text)
        if res.status_code != 200:
            raise Exception(u"請(qǐng)求異常")
        result = json.loads(res.text)
        return result

    @staticmethod
    def http_get(headers, url):
        req_headers = json.dumps(headers)
        print("接口請(qǐng)求url：" + url)
        print("接口請(qǐng)求headers：" + req_headers)
        res = requests.get(url, headers=headers)
        print("接口返回結(jié)果：" + res.text)
        if res.status_code != 200:
            raise Exception(u"請(qǐng)求異常")
        result = json.loads(res.text)
        return result

import xlrd
from xlrd import xldate_as_tuple
import datetime

class ExcelData(object):
    '''
    xlrd中單元格的數(shù)據(jù)類(lèi)型
    數(shù)字一律按浮點(diǎn)型輸出，日期輸出成一串小數(shù)，布爾型輸出0或1，所以我們必須在程序中做判斷處理轉(zhuǎn)換
    成我們想要的數(shù)據(jù)類(lèi)型
    0 empty,1 string, 2 number, 3 date, 4 boolean, 5 error
    '''
    def __init__(self, data_path, sheetname="Sheet1"):
        #定義一個(gè)屬性接收文件路徑
        self.data_path = data_path
        # 定義一個(gè)屬性接收工作表名稱(chēng)
        self.sheetname = sheetname
        # 使用xlrd模塊打開(kāi)excel表讀取數(shù)據(jù)
        self.data = xlrd.open_workbook(self.data_path)
        # 根據(jù)工作表的名稱(chēng)獲取工作表中的內(nèi)容
        self.table = self.data.sheet_by_name(self.sheetname)
        # 根據(jù)工作表的索引獲取工作表的內(nèi)容
        # self.table = self.data.sheet_by_name(0)
        # 獲取第一行所有內(nèi)容,如果括號(hào)中1就是第二行，這點(diǎn)跟列表索引類(lèi)似
        self.keys = self.table.row_values(0)
        # 獲取工作表的有效行數(shù)
        self.rowNum = self.table.nrows
        # 獲取工作表的有效列數(shù)
        self.colNum = self.table.ncols

    # 定義一個(gè)讀取excel表的方法
    def readExcel(self):
        # 定義一個(gè)空列表
        datas = []
        for i in range(1, self.rowNum):
            # 定義一個(gè)空字典
            sheet_data = {}
            for j in range(self.colNum):
                # 獲取單元格數(shù)據(jù)類(lèi)型
                c_type = self.table.cell(i,j).ctype
                # 獲取單元格數(shù)據(jù)
                c_cell = self.table.cell_value(i, j)
                if c_type == 2 and c_cell % 1 == 0:  # 如果是整形
                    c_cell = int(c_cell)
                elif c_type == 3:
                    # 轉(zhuǎn)成datetime對(duì)象
                    date = datetime.datetime(*xldate_as_tuple(c_cell, 0))
                    c_cell = date.strftime('%Y/%d/%m %H:%M:%S')
                elif c_type == 4:
                    c_cell = True if c_cell == 1 else False
                sheet_data[self.keys[j]] = c_cell
                # 循環(huán)每一個(gè)有效的單元格，將字段與值對(duì)應(yīng)存儲(chǔ)到字典中
                # 字典的key就是excel表中每列第一行的字段
                # sheet_data[self.keys[j]] = self.table.row_values(i)[j]
            # 再將字典追加到列表中
            datas.append(sheet_data)
        # 返回從excel中獲取到的數(shù)據(jù)：以列表存字典的形式返回
        return datas

if __name__ == "__main__":
    data_path = "..\\resources\\test_http_data.xls"
    sheetname = "Sheet1"
    get_data = ExcelData(data_path, sheetname)
    datas = get_data.readExcel()
    print(datas)

import logging
import allure

import pytest
from utils.http_utils import HttpUtils
from utils.read_jsonfile_utils import ReadJsonFileUtils
from config.global_config import CAOLIAO_HTTP_GET_HOST

@pytest.mark.httptest
@allure.feature("草料二維碼get請(qǐng)求測(cè)試")
class TestHttpInterface:
    # 獲取文件相對(duì)路徑
    data_file_path = ReadJsonFileUtils.get_data_path("resources", "test_http_get_data.json")
    # 讀取測(cè)試數(shù)據(jù)文件
    param_data = ReadJsonFileUtils(data_file_path)
    data_item = param_data.get_value('dataItem')  # 是一個(gè)list列表，list列表中包含多個(gè)字典

    """
    @pytest.mark.parametrize是數(shù)據(jù)驅(qū)動(dòng);
    data_item列表中有幾個(gè)字典，就運(yùn)行幾次case
    ids是用于自定義用例的名稱(chēng)
    """
    
    @pytest.mark.parametrize("args", data_item, ids=['測(cè)試草料二維碼get接口1', '測(cè)試草料二維碼get接口2'])
    def test_caoliao_get_demo(self, args, login_test):
        # 打印用例ID和名稱(chēng)到報(bào)告中顯示
        print("用例ID:{}".format(args['id']))
        print("用例名稱(chēng):{}".format(args['name']))
        print("測(cè)試conftest傳值：{}".format(login_test))
        logging.info("測(cè)試開(kāi)始啦~~~~~~~")
        res = HttpUtils.http_get(args['headers'], CAOLIAO_HTTP_GET_HOST+args['url'])
        # assert斷言，判斷接口是否返回期望的結(jié)果數(shù)據(jù)
        assert str(res.get('code')) == str(args['expectdata']['code']), "接口返回status值不等于預(yù)期"

import pytest
import logging
import allure
from utils.http_utils import HttpUtils
from utils.read_jsonfile_utils import ReadJsonFileUtils
from config.global_config import CAOLIAO_HTTP_POST_HOST

# pytest.ini文件中要添加markers = httptest，不然會(huì)有warning，說(shuō)這個(gè)Mark有問(wèn)題
@pytest.mark.httptest
@allure.feature("草料二維碼post請(qǐng)求測(cè)試")
class TestHttpInterface:
    # 獲取文件相對(duì)路徑
    data_file_path = ReadJsonFileUtils.get_data_path("resources", "test_http_post_data.json")
    # 讀取測(cè)試數(shù)據(jù)文件
    param_data = ReadJsonFileUtils(data_file_path)
    data_item = param_data.get_value('dataItem') #是一個(gè)list列表，list列表中包含多個(gè)字典

    """
    @pytest.mark.parametrize是數(shù)據(jù)驅(qū)動(dòng);
    data_item列表中有幾個(gè)字典，就運(yùn)行幾次case
    ids是用于自定義用例的名稱(chēng)
    
    """
    @pytest.mark.parametrize("args", data_item, ids=['測(cè)試草料二維碼post接口1','測(cè)試草料二維碼post接口2'])
    def test_caoliao_post_demo(self, args):
        # 打印用例ID和名稱(chēng)到報(bào)告中顯示
        print("用例ID:{}".format(args['id']))
        print("用例名稱(chēng):{}".format(args['name']))
        logging.info("測(cè)試開(kāi)始啦~~~~~~~")
        res = HttpUtils.http_post(args['headers'], CAOLIAO_HTTP_POST_HOST+args['url'], args['parameters'])
        # assert斷言，判斷接口是否返回期望的結(jié)果數(shù)據(jù)
        assert str(res.get('status')) == str(args['expectdata']['status']), "接口返回status值不等于預(yù)期"
        assert str(res.get('data').get('qrtype')) == str(args['expectdata']['qrtype']), "接口返回qrtype值不等于預(yù)期"

import logging
import traceback

import pytest
import requests

"""
如果用例執(zhí)行前需要先登錄獲取token值，就要用到conftest.py文件了
作用：conftest.py 配置里可以實(shí)現(xiàn)數(shù)據(jù)共享，不需要import導(dǎo)入 conftest.py，pytest用例會(huì)自動(dòng)查找
scope參數(shù)為session，那么所有的測(cè)試文件執(zhí)行前執(zhí)行一次
scope參數(shù)為module，那么每一個(gè)測(cè)試文件執(zhí)行前都會(huì)執(zhí)行一次conftest文件中的fixture
scope參數(shù)為class，那么每一個(gè)測(cè)試文件中的測(cè)試類(lèi)執(zhí)行前都會(huì)執(zhí)行一次conftest文件中的fixture
scope參數(shù)為function，那么所有文件的測(cè)試用例執(zhí)行前都會(huì)執(zhí)行一次conftest文件中的fixture
"""

# 獲取到登錄請(qǐng)求返回的ticket值，@pytest.fixture裝飾后，testcase文件中直接使用函數(shù)名"login_ticket"即可得到ticket值
@pytest.fixture(scope="session")
def login_ticket():
    header = {
        'Content-Type': 'application/x-www-form-urlencoded; charset=UTF-8'
    }
    params = {
        "loginId": "username",
        "pwd": "password",
    }
    url = 'http://testxxxxx.xx.com/doLogin'
    logging.info('開(kāi)始調(diào)用登錄接口:{}'.format(url))
    res = requests.post(url, data=params, headers=header, verify=False)  # verify：忽略https的認(rèn)證
    try:
        ticket = res.headers['Set-Cookie']
    except Exception as ex:
        logging.error('登錄失??！接口返回：{}'.format(res.text))
        traceback.print_tb(ex)
    logging.info('登錄成功，ticket值為：{}'.format(ticket))
    return ticket


#測(cè)試一下conftest.py文件和fixture的作用
@pytest.fixture(scope="session")
def login_test():
    print("運(yùn)行用例前先登錄！")


    # 使用yield關(guān)鍵字實(shí)現(xiàn)后置操作，如果上面的前置操作要返回值，在yield后面加上要返回的值
    # 也就是yield既可以實(shí)現(xiàn)后置，又可以起到return返回值的作用
    yield "runBeforeTestCase"
    print("運(yùn)行用例后退出登錄！")

[pytest]
markers =
  httptest: run http interface test
  dubbotest: run dubbo interface test

log_cli = true
log_cli_level = INFO
log_cli_format = %(asctime)s - %(pathname)s[line:%(lineno)d] - %(levelname)s: %(message)s
log_cli_date_format=%Y-%m-%d %H:%M:%S
log_format = %(asctime)s - %(pathname)s[line:%(lineno)d] - %(levelname)4s: %(message)s
log_date_format=%Y-%m-%d %H:%M:%S

allure open report/