from testcases.base_case import BaseCase
from common.basic_data import DoRegex, Context
from common.http_requests_api import HttpRequest
from common import contants
from common.do_excel import DoExcel
from common.do_mysql_tool import MysqlTool
import json
from common.read_config import ReadConfig
from ddt import ddt, data
from common.mylogger1 import MyLog
# 取现
do_excel = DoExcel(contants.data_dir)
cases = do_excel.get_case('withdraw')
my_logger = MyLog()
@ddt
class TestWithDraw(BaseCase):
def setUp(self):
self.mysql = MysqlTool()
# 取现前用户可用余额
self.seek_leaveamount_sql = 'SELECT LeaveAmount FROM future.member where MobilePhone={0};'.format(
Context.normal_phone)
self.before_amount = self.mysql.fetch_one(
self.seek_leaveamount_sql)['LeaveAmount'] # 取现前用户可用余额
@data(*cases)
def test_withdraw(self, case):
my_logger.info('正在执行第{0}条用例{1}'.format(case.case_id, case.title))
import unittest
from common.http_requests_api import HttpRequest
from common import contants
from common.do_excel import DoExcel
import json
from common.do_mysql_tool import MysqlTool
from common.read_config import ReadConfig
from common.basic_data import DoRegex, Context
from ddt import ddt, data
from common.mylogger1 import MyLog
# 读取配置文件基础数据--->放在context--->regex正则匹配替换---->request---拿到cookie放context cookie
# recharge接口---调用context数据--->充值完数据库校验
do_excel = DoExcel(contants.data_dir)
cases = do_excel.get_case('recharge')
mylogger = MyLog()
@ddt
class TestRecharge(unittest.TestCase):
def setUp(self): #获取期望结果放在setUp,充值前先取出leavemount
sql = ReadConfig().get('SQL', 'LeaveAmount')
global leavemount1
global mysql
mysql = MysqlTool()
leavemount1 = mysql.fetch_one(sql)['LeaveAmount']
mylogger.info('充值前账户余额:{0}'.format(leavemount1))
return leavemount1
@data(*cases)
def test_recharge(self, case):