Python do_excel 예제들

예제 #1

파일: recharge_testcase.py 프로젝트: cxx839113797/future

 def test_recharge(self,case):
     resp=self.session.Session(case.method,case.url,case.data)
     datafill=do_excel(excel_name,recharge_sheet)
     datafill.write(resp.text,case.caseid + 1, 7)
     try:
         self.assertEqual((json.loads(case.expected)["status"]),resp.json()["status"])
         self.assertEqual((json.loads(case.expected)["code"]), resp.json()["code"])
         self.assertEqual((json.loads(case.expected)["msg"]), resp.json()["msg"])
     except AssertionError as e:
         datafill.write("FAIL",case.caseid+1,8)
         raise e
     else:
         datafill.write("PASS",case.caseid + 1, 8)
     finally:
         datafill.close()

예제 #2

파일: addloan_testcase.py 프로젝트: cxx839113797/future

# -*- coding:utf-8 -*-
# @Time  : 2019/4/18 22:56
# @Author: xiaoxiao
# @File  : addLoan_testcase.py

from class_0416.common.http_requests import http_requests
from class_0416.common.do_excel import do_excel
from class_0416.common.constants import excel_name, addloan_sheet
from ddt import ddt, data
import unittest
import json


@ddt
class addLoanTestcase(unittest.TestCase):
    case = do_excel(excel_name, addloan_sheet)
    cases = case.read()
    case.close()

    @classmethod
    def setUpClass(cls):
        cls.session = http_requests()

    @data(*cases)
    def test_addLoan(self, case):
        resp = self.session.Session(case.method, case.url, case.data)
        datafill = do_excel(excel_name, addloan_sheet)
        datafill.write(resp.text, case.caseid + 1, 7)
        try:
            self.assertEqual((json.loads(case.expected)["status"]),
                             resp.json()["status"])

예제 #3

# -*- coding:utf-8 -*-
# @Time  : 2019/4/18 22:56
# @Author: xiaoxiao
# @File  : audit_testcase.py

from class_0416.common.http_requests import http_requests
from class_0416.common.do_excel import do_excel
from class_0416.common.constants import excel_name, audit_sheet
from ddt import ddt, data
import unittest
import json


@ddt
class auditTestcase(unittest.TestCase):
    case = do_excel(excel_name, audit_sheet)
    cases = case.read()
    case.close()

    @classmethod
    def setUpClass(cls):
        cls.session = http_requests()

    @data(*cases)
    def test_audit(self, case):
        resp = self.session.Session(case.method, case.url, case.data)
        datafill = do_excel(excel_name, audit_sheet)
        datafill.write(resp.text, case.caseid + 1, 7)
        try:
            self.assertEqual((json.loads(case.expected)["status"]),
                             resp.json()["status"])

예제 #4

파일: recharge_testcase.py 프로젝트: cxx839113797/future

# -*- coding:utf-8 -*-
# @Time  : 2019/4/15 18:58
# @Author: xiaoxiao
# @File  : recharge_case.py

from class_0416.common.http_requests import http_requests
from class_0416.common.do_excel import do_excel
from class_0416.common.constants import excel_name,recharge_sheet
from ddt import ddt,data
import unittest
import json
@ddt
class rechargeTestcase(unittest.TestCase):
    case = do_excel(excel_name,recharge_sheet)
    cases=case.read()
    case.close()
    @classmethod
    def setUpClass(cls):
        cls.session=http_requests()
    @data(*cases)
    def test_recharge(self,case):
        resp=self.session.Session(case.method,case.url,case.data)
        datafill=do_excel(excel_name,recharge_sheet)
        datafill.write(resp.text,case.caseid + 1, 7)
        try:
            self.assertEqual((json.loads(case.expected)["status"]),resp.json()["status"])
            self.assertEqual((json.loads(case.expected)["code"]), resp.json()["code"])
            self.assertEqual((json.loads(case.expected)["msg"]), resp.json()["msg"])
        except AssertionError as e:
            datafill.write("FAIL",case.caseid+1,8)
            raise e

예제 #5

# -*- coding:utf-8 -*-
# @Time  : 2019/4/13 23:57
# @Author: xiaoxiao
# @File  : login_testcase.py

from class_0416.common.http_requests import http_requests
from class_0416.common.do_excel import do_excel
from class_0416.common.constants import excel_name, login_sheet
from ddt import ddt, data
import unittest
import json


@ddt
class loginTestcase(unittest.TestCase):
    case = do_excel(excel_name, login_sheet)
    cases = case.read()
    case.close()

    @classmethod
    def setUpClass(cls):
        cls.session = http_requests()

    @data(*cases)
    def test_login(self, case):
        resp = self.session.Session(case.method, case.url, case.data)
        datafill = do_excel(excel_name, login_sheet)
        datafill.write(resp.text, case.caseid + 1, 7)
        try:
            self.assertEqual((json.loads(case.expected)["status"]),
                             resp.json()["status"])