Python DoExcel.get_data示例

示例#1

import unittest
from tools.do_excel import DoExcel
from tools.project_path import *
from ddt import *
from tools.http_request import HttpRequest
from tools.get_cookie import GetCookie
from tools.my_log import MyLog

test_data=DoExcel.get_data(test_case_path)
@ddt
class TestHttpRequest(unittest.TestCase):
    def setUp(self):
        pass
    @data(*test_data)
    def test_api(self,item):
        res=HttpRequest.http_request(item['method'],item['url'],eval(item['data']),getattr(GetCookie,'Cookie'))
        if res.cookies: #利用反射存储cookie值
            setattr(GetCookie,'Cookie',res.cookies)
        try:
            self.assertEqual(str(item['expected']),res.json()['resultcode'])
            TestResult='PASS'
        except AssertionError as e:
            TestResult='Failed'
            MyLog.error("执行用例出错:{0}".format(e))
            raise e
        finally:
            DoExcel.write_back(test_case_path,item['sheet_name'],item['case_id']+1,res.text,TestResult)
            MyLog.info("获取到的结果是：{0}".format(res.text))
    def tearDown(self):
        pass
if __name__ == '__main__':

示例#2

# -*- conding: utf-8 -*-
# @Time      :2019/7/30 15:09
# Author     :chengjin
# @Email     :[email protected]
# @File      :test_http_request.py
import unittest
from tools.project_path import *
from tools.http_request import HttpRequest
from tools.get_cookie import GetCookie
from ddt import ddt, data  #列表嵌套列表 或者列表嵌套字典
from tools.do_excel import DoExcel

test_data = DoExcel.get_data(test_case_path, "login")


@ddt
class TestHttpRequest(unittest.TestCase):
    def setUp(self):
        pass

    @data(*test_data)
    def test_api(self, item):
        res = HttpRequest.http_request(item['url'], eval(item['data']),
                                       item['http_method'],
                                       getattr(GetCookie, "Cookie"))
        try:
            self.assertEqual(item['excepted'], res.json()["status"])
            TestResult = 'PASS'  #成功的
        except AssertionError as e:
            TestResult = 'Failed'  #失败的
            print("执行用例出错：{}".format(e))

示例#3

#作者:HP
#日期:2020-03-20 20:48
#文件:test_http_request
import unittest
from tools.http_request import HttpRequest
from tools.get_data import GetCookie
from ddt import ddt, data  #
from tools.do_excel import DoExcel
from tools.project_path import *

test_data = DoExcel.get_data(test_case_path, 'login')  #执行登录用例


@ddt
class TestHttpRequest(unittest.TestCase):
    def setUp(self, ):
        pass

    @data(*test_data)
    def test_api(self, item):
        res = HttpRequest.http_request(item['url'], eval(item['data']),
                                       item['http_method'],
                                       getattr(GetCookie, 'Cookie'))

        try:
            self.assertEqual(item['expected'], res.json()['stat'])
            TestResult = 'PASS'
        except Exception as e:
            TestResult = 'Failed'
            print("执行用例出错：{0}".format(e))
            raise e

示例#4

# -*- conding: utf-8 -*-
# @Time      :2019/7/30 15:09
# Author     :chengjin
# @Email     :[email protected]
# @File      :test_http_request.py
import unittest
from tools.project_path import *
from tools.http_request import HttpRequest
from tools.get_cookie import GetCookie
from ddt import ddt, data  #列表嵌套列表 或者列表嵌套字典
from tools.do_excel import DoExcel

test_data = DoExcel.get_data(test_case_path, "recharge")


@ddt
class TestHttpRequest(unittest.TestCase):
    def setUp(self):
        pass

    @data(*test_data)
    def test_api(self, item):
        res = HttpRequest.http_request(item['url'], eval(item['data']),
                                       item['http_method'],
                                       getattr(GetCookie, "Cookie"))
        try:
            self.assertEqual(item['excepted'], res.json()["status"])
            TestResult = 'PASS'  #成功的
        except AssertionError as e:
            TestResult = 'Failed'  #失败的
            print("执行用例出错：{}".format(e))

示例#5

文件： http_request_testcase.py 项目： demilxj/API_AUTO

# @Author : demi
# @Email : [email protected]
# @File : http_request_testcase.py


import unittest
from tools.http_request import HttpRequest
from tools.get_data import GetData
from ddt import ddt, data  # 列表嵌套列表 或者是列表嵌套字典
from tools.do_excel import DoExcel
from tools import project_path
from tools.my_log import MyLog
from tools.do_mysql import DoMysql


test_data = DoExcel.get_data(project_path.test_case_path)
my_logger = MyLog()


@ddt
class HttpRequestTestcase(unittest.TestCase):
    def setUp(self):
        pass

    @data(*test_data)
    def test_api(self, item):
        my_logger.info('开始执行用例{0}:{1}'.format(item['case_id'], item['title']))
        loan_member_id = getattr(GetData, 'loan_member_id')

        # 请求之前完成load_id的替换
        if item['data'].find('${loan_id}') != -1:

示例#6

文件： test_01_register.py 项目： ziying123/Auto_Api

# -*- coding: UTF-8 -*-
"""Script content introduction
__author__ = 'ziying'
__date__ = '2020/11/1 14:23'
__function__ = ''
"""

import pytest
import os
from common.until.register import register
from tools.do_excel import DoExcel
from tools.logger import logger
from config.conf import DATA_DIR

do_excel = DoExcel(DATA_DIR, "register")
TestData = do_excel.get_data()
do_excel.close_file()


@pytest.mark.usefixtures("fix_class_level")
class TestRegister:
    @pytest.mark.usefixtures("fix_function_level")
    @pytest.mark.register
    @pytest.mark.parametrize("case", TestData)  # 读取excel文件中的测试用例
    def test_register(self, case):

        logger.info("测试数据：{}".format(eval(case["Data"])))
        logger.info("开始执行第 {} 条用例：{}！".format(case["CaseID"], case["Title"]))
        # print("开始执行第 {} 条用例：{}，测试数据：{}！".format(case["CaseID"], case["Title"], eval(case["Data"])))
        res = register(
            eval(case["Data"])["username"],

示例#7

#作者:HP
#日期:2020-03-20 20:48
#文件:test_http_request
import unittest
from tools.http_request import HttpRequest
from tools.get_data import GetCookie
from ddt import ddt, data  #
from tools.do_excel import DoExcel
from tools.project_path import *

test_data = DoExcel.get_data(test_case_path, 'create')  #执行登录用例


@ddt
class TestHttpRequest(unittest.TestCase):
    def setUp(self, ):
        pass

    @data(*test_data)
    def test_api(self, item):
        res = HttpRequest.http_request(item['url'], eval(item['data']),
                                       item['http_method'],
                                       getattr(GetCookie, 'Cookie'))

        try:
            self.assertEqual(item['expected'], res.json()['stat'])
            TestResult = 'PASS'
        except Exception as e:
            TestResult = 'Failed'
            print("执行用例出错：{0}".format(e))
            raise e

示例#8

文件： http_request_ddt.py 项目： windy0122/Api_Auto

from ddt import ddt, data  # 数据类型必须是列表嵌套列表，或者列表嵌套字典
import unittest
from tools.http_request import HttpRequest
import json
import tools.project_path as tool_path
from tools.do_excel import DoExcel
from test_result.log.api_logging import MyLog

my_logger = MyLog()
test_data = DoExcel.get_data(tool_path.test_data_path)


@ddt
class TestHttpRequest(unittest.TestCase):
    def setUp(self):
        pass

    def tearDown(self):
        pass

    @data(*test_data)
    def test_api(self, item):
        res = HttpRequest.http_request(item['url'],
                                       json.dumps(eval(item['data'])),
                                       item['http_method'],
                                       eval(item['header']))
        try:
            self.assertEqual('0', res.json()['success'])
            TestResult = 'PASS'
        except AssertionError as e:
            TestResult = 'FAILED'