Python DoExcel Examples

Example #1

File: A_10_Repayments_Test_case.py Project: 9914/Python12-api-test_9913

from common.regular_expression import Regular
from common.basic_data import Context
from common.mysql import MysqlUtill
import unittest
import json
from common.common_user import Login
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE', 'button')
#读取配置文件里面的URL地址
config_url = con.get('URL', 'url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path, config)
#充值
excel_date_generateRepayments = excel_date.get_case('generateRepayments')


@ddt
class HttpCase(Login):
    #class HttpCase(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        Login().test_login()  #固定投资用户登录

    def setUp(self):
        global sql, back_plan, Money_back_plan
        sql = con.get("SQL", "Money_back_plan")
        Money_back_plan = MysqlUtill().get_fetch_one(sql=sql)

Example #2

from common.regular_expression import Regular
from common.basic_data import Context
from common.mysql import MysqlUtill
import unittest
import json
from common.common_user import Login
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE','button')
#读取配置文件里面的URL地址
config_url = con.get('URL','url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path,config)
#充值
excel_date_recharge = excel_date.get_case('recharge2')

@ddt
class HttpCase(Login):
#class HttpCase(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        Login().test_login()    #固定投资用户登录
    def setUp(self):
        self.sql = con.get('SQL', 'Income_LeaveAmount')
        #充值之前的账户余额
        self.LeaveAmount = MysqlUtill().get_fetch_one(sql=self.sql)
        my_log.info("初始化数据-->充值前账户余额:{}".format(self.LeaveAmount["LeaveAmount"]))
        # 借款人充值流水记录

Example #3

File: A_09_Bidloan_test_case.py Project: 9914/Python12-api-test_9913

from common.regular_expression import Regular
from common.basic_data import Context
from common.mysql import MysqlUtill
import unittest
import json
from common.common_user import Login
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE', 'button')
#读取配置文件里面的URL地址
config_url = con.get('URL', 'url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path, config)
#竞标
excel_date_bidLoan = excel_date.get_case('bidLoan')


@ddt
class HttpCase(Login):
    #class HttpCase(unittest.TestCase):
    #金额：购买用户减少，项目账户增加
    #购买用户的流水记录
    #投资记录
    #项目金额减少
    @classmethod
    def setUpClass(cls):
        Login().test_login()  #固定投资用户登录

Example #4

File: A_08_Audit_test_case.py Project: 9914/Python12-api-test_9913

from common.http_log import HttpLog
from common.regular_expression import Regular
from common.basic_data import Context
from common.mysql import MysqlUtill
import unittest
import json
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE', 'button')
#读取配置文件里面的URL地址
config_url = con.get('URL', 'url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path, config)
#充值
excel_date_audit = excel_date.get_case('audit')


@ddt
class HttpCase(unittest.TestCase):
    def setUp(self):
        global status, sql
        sql = con.get('SQL', 'Status')
        status = MysqlUtill().get_fetch_one(sql=sql)
        setattr(Context, 'status', status['Status'])  #把状态写入到到反射里面
        my_log.info("初始化数据--》审核之前的状态为：{}".format(status))

    # 加 * 号，去掉一层外套
    @data(*excel_date_audit)

Example #5

from common.regular_expression import Regular
from common.basic_data import Context
from common.mysql import MysqlUtill
import unittest
import json
from common.common_user import Login
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE','button')
#读取配置文件里面的URL地址
config_url = con.get('URL','url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path,config)
#充值
excel_date_geneInvestsByMemberId = excel_date.get_case('geneInvestsByMemberId')

cookies=None
@ddt
class HttpCase(Login):
#class HttpCase(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        Login().test_login()    #固定投资用户登录
    def setUp(self):
        #用户最新一条投资记录
        global sql,Investment_all
        sql =con.get("SQL","Investment_all")
        Investment_all = MysqlUtill().get_fetch_one(sql)

Example #6

from common.http_log import HttpLog
from common.regular_expression import Regular
from common.basic_data import Context
from common.mysql import MysqlUtill
import unittest
import json
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE', 'button')
#读取配置文件里面的URL地址
config_url = con.get('URL', 'url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path, config)
#提现
excel_date_withdarw = excel_date.get_case('withdarw')


@ddt
class HttpCase(unittest.TestCase):
    def setUp(self):
        self.sql = con.get('SQL', 'Pay_LeaveAmount')
        #充值之前的账户余额
        self.LeaveAmount = MysqlUtill().get_fetch_one(sql=self.sql)
        try:
            if self.LeaveAmount["LeaveAmount"] == 0:
                my_log.info("初始化数据--》账户余额为0 ，不允许提现，请先充值！")
            else:
                my_log.info("初始化数据--》提现前账户余额:{}".format(

Example #7

from common.http_log import HttpLog
from common.regular_expression import Regular
from common.basic_data import Context
from common.mysql import MysqlUtill
import unittest
import json
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE','button')
#读取配置文件里面的URL地址
config_url = con.get('URL','url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path,config)
#提现
excel_date_add = excel_date.get_case('add')


@ddt
class HttpCase(unittest.TestCase):
    def setUp(self):
        #获取用户所有的项目id
        self.sql = con.get("SQL","sql_LoanId")
        self.ID = MysqlUtill().get_fetch_one(sql=self.sql)

    @data(*excel_date_add)      # 加 * 号，去掉一层外套
    def test_http_case(self,i):
        #对excel里面的正则进行替换
        date = Regular().regular(i.request_data)  # 正则参数替换

Example #8

from common.http_log import HttpLog
from common.regular_expression import Regular
from common.mysql import MysqlUtill
import unittest
import json
from common.common_user import Login
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE', 'button')
#读取配置文件里面的URL地址
config_url = con.get('URL', 'url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path, config)
#充值
excel_date_getFinanceLogList = excel_date.get_case('getFinanceLogList')

cookies = None


@ddt
class HttpCase(Login):
    #class HttpCase(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        Login().test_login()  #固定投资用户登录

    def setUp(self):
        global sql, Income_record

Example #9

from common import http_path
from common.Http_config import Reading
from common.http_log import HttpLog
from common.regular_expression import Regular
import unittest
import json
#创建日志对象，装载日志
my_log = HttpLog()
#创建取配置对象
con = Reading(http_path.config_path_control)
#获取需要的执行的测试用例ID
config = con.get('CASE','button')
#读取配置文件里面的URL地址
config_url = con.get('URL','url_date')
#读取测试数据,实例化测试数据对象
excel_date = DoExcel(http_path.case_path,config)
#登录
excel_date_login = excel_date.get_case('login')

@ddt
class HttpCase(unittest.TestCase):
    # 加 * 号，去掉一层外套
    @data(*excel_date_login)
    #@unpack
    def test_http_case(self,i):
        date = Regular().regular(i.request_data)  # 正则参数替换
        my_log.info('正在执行地{0}条用例; 用例名称:{1}; 用例说明:{2}; 用例接口:{3}'.
                    format(i.case_id, i.case_name, i.case_rept, i.api_name))
        my_log.info('================检查url====================')
        my_log.info('url:{}'.format(config_url+i.url))
        my_log.info('================检查request_data====================')