def setup_class(self):
self.base = loginAdmin(usr=Config().adminuser, pwd=Config().adminpwd) # 用同一个登录成功后的session
addDeleteSql = readYaml(self.yamlfilepath)['data']['savecontNumRule']['deleteSql'] # 删除添加的“自动化新增”规则
self.db.excute(addDeleteSql)
# 修改接口数据重置到初始状态
selectSql = readYaml(self.yamlfilepath)['data']['insertOrUpdateContNum']['resetSql']['selectSql']
insertSql = readYaml(self.yamlfilepath)['data']['insertOrUpdateContNum']['resetSql']['insertSql']
updateSql1 = readYaml(self.yamlfilepath)['data']['insertOrUpdateContNum']['resetSql']['updateSql1']
updateSql2 = readYaml(self.yamlfilepath)['data']['insertOrUpdateContNum']['resetSql']['updateSql2']
deleteSql = readYaml(self.yamlfilepath)['data']['insertOrUpdateContNum']['resetSql']['deleteSql']
# 插入数据前先查询数据库里是否有该条记录
self.db.excute(selectSql)
if self.db.get_one() == None: # 没有查到记录时，执行插入
self.db.excute(insertSql)
self.db.excute(updateSql1)
self.db.excute(updateSql2)
self.db.excute(deleteSql)
# 修改公司及部门中的编码为null
resetDeptmentSql = readYaml(self.yamlfilepath)['data']['setupsql']['resetDeptmentSql']
self.db.excute(resetDeptmentSql)
# 修改合作车商的编码为null
resetSpSql = readYaml(self.yamlfilepath)['data']['setupsql']['resetSpSql']
self.db.excute(resetSpSql)
# 修改业务类型的编码为null
resrtProductTypeSql = readYaml(self.yamlfilepath)['data']['setupsql']['resrtProductTypeSql']
self.db.excute(resrtProductTypeSql)
# 修改业务来源直客的编码为null
resrtProductFromSql = readYaml(self.yamlfilepath)['data']['setupsql']['resrtProductFromSql']
self.db.excute(resrtProductFromSql)
def setup_class(self):
self.base = loginAdmin(usr=Config().adminuser,
pwd=Config().adminpwd) # 用同一个登录成功后的session
# 删除添加的“自动化新增-按日计息”还款方式
delteAlreadyExistSql = readYaml(
self.yamlfilepath)['data']['setupsql']['delteAlreadyExistSql']
self.db.excute(delteAlreadyExistSql)
# 修改id=10的还款方式字段值到初始值
resetStartSQL = readYaml(
self.yamlfilepath)['data']['setupsql']['resetStartSQL']
self.db.excute(resetStartSQL)
def setup_class(self):
self.base = loginAdmin(usr=Config().adminuser,
pwd=Config().adminpwd) # 用同一个登录成功后的session
self.uploadFixtureData[0]['base'] = self.base
def setup_class(self):
self.base = loginAdmin(usr=Config().adminuser,
pwd=Config().adminpwd) # 用同一个登录成功后的session
def setup_class(self):
self.base = loginAdmin(usr=Config().adminuser,
pwd=Config().adminpwd) # 用同一个登录成功后的session
for i in self.fixtureData:
i['base'] = self.base
def setup_class(self):
self.base = loginAdmin(usr=Config().adminuser,
pwd=Config().adminpwd) # 用同一个登录成功后的session
sql = "DELETE FROM tbl_coupon WHERE `name`='接口自动化优惠券' " # 数据清理后再执行用例
self.db.excute(sql)
