Python do_excel示例

示例#1

文件： test_addloan.py 项目： cxx839113797/future

from class_0423.common.http_requests import http_requests
from class_0423.common.do_excel import do_excel
from class_0423.common.constants import excel_name, addloan_sheet
from class_0423.common.regulax import regulax
from class_0423.common.do_mysql import DoMysql
from class_0423.common.log_config import log_config
from ddt import ddt, data
import unittest
import json
log = log_config(__name__)


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

    @classmethod
    def setUpClass(cls):
        cls.session = http_requests()
        cls.mysql = DoMysql()
        cls.datafill = do_excel(excel_name, addloan_sheet)

    @data(*cases)
    def test_addLoan(self, case):
        log.info("测试标题：{}".format(case.title))
        if case.data.find("$(memberId)") > -1:
            sql = "SELECT MAX(id) FROM future.member "
            data = self.mysql.fetch_One(sql)["MAX(id)"] + 1
            case.data = case.data.replace("$(memberId)", str(data))

示例#2

文件： test_addloan.py 项目： cxx839113797/future

 def setUpClass(cls):
     cls.session = http_requests()
     cls.mysql = DoMysql()
     cls.datafill = do_excel(excel_name, addloan_sheet)

示例#3

文件： test_register.py 项目： cxx839113797/future

from class_0423.common.http_requests import http_requests
from class_0423.common.do_excel import do_excel
from class_0423.common.constants import excel_name, register_sheet
from class_0423.common.do_mysql import DoMysql
from class_0423.common.regulax import regulax
from class_0423.common.log_config import log_config
from ddt import ddt, data
import unittest
import json
log = log_config(__name__)


@ddt
class registerTestcase(unittest.TestCase):
    case = do_excel(excel_name, register_sheet)
    cases = case.read()

    @classmethod
    def setUpClass(cls):
        cls.session = http_requests()
        cls.mysql = DoMysql()
        cls.datafill = do_excel(excel_name, register_sheet)

    @data(*cases)
    def test_register(self, case):
        log.info("测试标题：{}".format(case.title))
        if case.check_sql:
            case.check_sql = regulax(case.check_sql)
            before = self.mysql.fetch_One(case.check_sql)["MAX(id)"]
        if case.data.find("136$(mobilephone)") > -1:

示例#4

 def setUpClass(cls):
     cls.session = http_requests()
     cls.datafill = do_excel(excel_name, login_sheet)

示例#5

# @File  : login_testcase.py

from class_0423.common.http_requests import http_requests
from class_0423.common.do_excel import do_excel
from class_0423.common.constants import excel_name, login_sheet
from class_0423.common.log_config import log_config
from ddt import ddt, data
from class_0423.common.regulax import regulax
import unittest
import json
log = log_config(__name__)


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

    @classmethod
    def setUpClass(cls):
        cls.session = http_requests()
        cls.datafill = do_excel(excel_name, login_sheet)

    @data(*cases)
    def test_login(self, case):
        log.info("测试标题：{}".format(case.title))
        case.data = regulax(case.data)
        resp = self.session.Session(case.method, case.url, case.data)
        self.datafill.write(resp.text, case.caseid + 1, 7)
        try:
            self.assertEqual((json.loads(case.expected)["status"]),

示例#6

# @Author: xiaoxiao
# @File  : recharge_case.py

from class_0423.common.http_requests import http_requests
from class_0423.common.do_excel import do_excel
from class_0423.common.constants import excel_name,recharge_sheet
from class_0423.common.regulax import regulax
from class_0423.common.do_mysql import DoMysql
from class_0423.common.log_config import log_config
from ddt import ddt,data
import unittest
import json
log=log_config(__name__)
@ddt
class rechargeTestcase(unittest.TestCase):
    case = do_excel(excel_name,recharge_sheet)
    cases=case.read()
    @classmethod
    def setUpClass(cls):
        cls.session=http_requests()
        cls.mysql=DoMysql()
        cls.datafill = do_excel(excel_name, recharge_sheet)
    @data(*cases)
    def test_recharge(self,case):
        log.info("测试标题：{}".format(case.title))
        case.data = regulax(case.data)
        if case.check_sql:
            case.check_sql = regulax(case.check_sql)
            before=self.mysql.fetch_One(case.check_sql)["leaveamount"]
        resp=self.session.Session(case.method,case.url,case.data)
        self.datafill.write(resp.text,case.caseid + 1, 7)

示例#7

文件： test_audit.py 项目： cxx839113797/future

# @File  : audit_testcase.py

from class_0423.common.http_requests import http_requests
from class_0423.common.do_excel import do_excel
from class_0423.common.constants import excel_name,audit_sheet
from class_0423.common.log_config import log_config
from class_0423.common.regulax import regulax,Regulax
from class_0423.common.do_mysql import DoMysql
from ddt import ddt,data
import unittest
import json

log=log_config(__name__)
@ddt
class auditTestcase(unittest.TestCase):
    case = do_excel(excel_name,audit_sheet)
    cases=case.read()
    @classmethod
    def setUpClass(cls):
        cls.session=http_requests()
        cls.mysql=DoMysql()
        cls.datafill=do_excel(excel_name,audit_sheet)
    @data(*cases)
    def test_audit(self,case):
        log.info("测试标题：{}".format(case.title))
        if case.data.find("$(memberId)") > -1:
            sql = "SELECT MAX(id) FROM future.member "
            data = self.mysql.fetch_One(sql)["MAX(id)"] + 1
            case.data = case.data.replace("$(memberId)", str(data))
        if case.data.find("$(loanId)")>-1:
            sql="SELECT MAX(id) FROM future.loan"