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)