def checkResult(cls, response, setparam): """检查结果 check test result :return: """ common.show_return_msg(response) cls.assertEqual(response.status_code, int(setparam.code1), msg='Response code error,this time responsed code is:' + str('断言code为:%s' % setparam.code1 + ' 响应code为:%s' % response.status_code)) total = response.json()['data']['total'] if setparam.result == '0': # 先断言是否存在查询数据 cls.assertNotEqual(total, 0, msg='Response error,' + str('断言查询数据条数不为:0 响应结果为:%s' % total)) print('断言查询数据条数不为:0 响应结果为:%s' % total) for i in range(total): #最后两行是小计合总计,所以不需要遍历 #断言出库类型 info0 = response.json( )['data']['rows'][i]['ml_bill_type#bill_type_name'] cls.assertEqual( info0, setparam.code2, msg='Response error,' + str('断言出库类型为:%s' % setparam.code2 + ' 响应结果为:%s' % info0)) print('断言出库类型为:%s' % setparam.code2 + ' 响应结果为:%s' % info0)
def test_lease_community_addonefloor(self): """ test body :return: """ # 给get或者post方法配置Http地址 self.localConfigHttp = configHttp_new.ConfigHttp() # 接口地址存储在excel文件里,读取出来 self.localConfigHttp.set_url(self.service_id) # set params data = json.loads(self.data) # 判断是否需要token if self.token == 1: f = open(token_fiel_path, 'r') token_tmp = f.readline() data['access_token'] = token_tmp print '获取到的最新token:', data['access_token'] # 判断是否需要获取验证码 if 'sms_code' in data: sql = localReadConfig.get_sql('sql_yzm') yzm = configDB.MyDB().zhiyu_yzm(sql) data['sms_code'] = yzm # 获取house_id,如果excel表格里house_id为空,则取ini文件里的house_id,否则取excel里的house_id if 'house_id' in data: if data['house_id'] == '': house_id = localReadConfig.get_ini('PARAMS', 'house_id') data['house_id'] = house_id # 获取时间戳 time_now = common.get_time_now() data['timestamp'] = time_now # 查找楼栋 sql = "SELECT * FROM lp_building WHERE community_id = '12873' ORDER BY id DESC;" building_id = configDB.MyDB().zhiyu_getone(sql) data['building_id'] = building_id sql1 = "SELECT * FROM lp_unit WHERE community_id = '12873' ORDER BY id DESC;" unit_id = configDB.MyDB().zhiyu_getone(sql1) data['unit_id'] = unit_id # AES加密 params_miwen = encryptLib.zhiyu_aes_encode(data) # 真正的入参 params = {'param': params_miwen} self.localConfigHttp.set_params(params) # 获取响应结果信息 if self.method.lower() == 'get': self.response = self.localConfigHttp.get() print 'get' elif self.method.lower() == 'post': self.response = self.localConfigHttp.post() print 'post' # 显示响应结果信息 common.show_return_msg(self.response) self.info = self.response.text # Json响应信息转成字典格式 self.info = json.loads(self.info) # 断言返回状态码 self.assertEqual(self.info['err_no'], self.expect_state) # 断言返回message mes_reponse = self.info['err_msg'].encode('utf-8') self.assertEqual(mes_reponse, self.expect_msg)
def interfaceTest(self): # set url self.url = common.get_url_from_xml('dataPlatformUser_loadChartData') localConfigHttp.set_url(self.url) # set header cookie = localReadConfig.get_headers("cookie") contentType = localReadConfig.get_headers("contentType") header = {"Content-Type": contentType, "Cookie": cookie} localConfigHttp.set_headers(header) # 不稳定,暂不用 # if str(self.startTime) == str('today'): # self.start = str(time.strftime('%Y-%m-%d',time.localtime(time.time()))) # else: # self.start = self.startTime # set data data = { 'startTime': self.startTime, 'endTime': self.endTime, 'stats': self.stats, 'type': self.type, 'name': self.name } localConfigHttp.set_data(data) # test interface self.response = localConfigHttp.postWithJson() self.info = self.response.json() common.show_return_msg(self.response) common.get_value_from_return_json(self.info, "series", data)
def test_guanjia_repair_info(self): """ test body :return: """ # 给get或者post方法配置Http地址 self.localConfigHttp = configHttp_new.ConfigHttp(env_old_new='old') # 接口地址存储在excel文件里,读取出来 self.localConfigHttp.set_url(self.service_id) # set params data = json.loads(self.data) # 判断是否需要token if self.token == 1: f = open(token_fiel_path, 'r') token_tmp = f.readline() data['access_token'] = token_tmp print '获取到的最新token:', data['access_token'] # 判断是否需要获取验证码 if 'sms_code' in data: sql = localReadConfig.get_sql('sql_yzm') yzm = configDB.MyDB().zhiyu_yzm(sql) data['sms_code'] = yzm # 获取house_id,如果excel表格里house_id为空,则取ini文件里的house_id,否则取excel里的house_id if 'house_id' in data: if data['house_id'] == '': house_id = localReadConfig.get_ini('PARAMS', 'house_id') data['house_id'] = house_id # # 获取时间戳 # time_now = common.get_time_now() # data['timestamp'] = time_now # AES加密 params_miwen = encryptLib.zhiyu_des_encode(data) # 真正的入参 params = { 'client_id': '1fobqa5ofzixluyjlum7icdufabjfo25', 'param': params_miwen } self.localConfigHttp.set_params(params) # 获取响应结果信息 if self.method.lower() == 'get': self.response = self.localConfigHttp.get() print 'get' elif self.method.lower() == 'post': self.response = self.localConfigHttp.post() print 'post' # 显示响应结果信息 common.show_return_msg(self.response) self.info = self.response.text # Json响应信息转成字典格式 self.info = json.loads(self.info) # 存储token,只有正确登录的时候才有token if 'access_token' in self.info['data']: token_temp = self.info['data']['access_token'] localReadConfig.set_headers('token_temp', token_temp) # 断言返回状态码 self.assertEqual(self.info['err_no'], self.expect_state) # 断言返回message mes_reponse = self.info['err_msg'].encode('utf-8') self.assertEqual(mes_reponse, self.expect_msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() common.show_return_msg(self.return_json) # 显示返回信息 # if self.result == '0': # email = common.get_value_from_return_json(self.info, 'member', 'email') # self.assertEqual(self.info['code'], self.code) # self.assertEqual(self.info['msg'], self.msg) # self.assertEqual(email, self.email) # # if self.result == '1': # self.assertEqual(self.info['code'], self.code) # self.assertEqual(self.info['msg'], self.msg) self.assertEqual(self.return_json.status_code, 200) try: if self.success != None and self.success != '': self.assertEqual(self.info['success'], self.success) except KeyError: pass try: if self.code != None and self.code != '': self.assertEqual(self.info['code'], self.code) except KeyError: pass
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() # show return message common.show_return_msg(self.return_json) if self.info['code'] == 0: self.log.build_sql_line(self.case_name) with open('E:/XYRGInterface/testCase/user/sql_value.txt', 'r') as f: sql_value = f.readline() print("开始连接数据库......") self.logger.info("开始连接数据库......") sql_testid = common.get_sql('ygf_xlcp_20171208', 'user', 'test_id') cursor_sql_value_testid = configDB.executeSQL_all(sql_testid, (self.student_name,sql_value)) number = len(cursor_sql_value_testid) if self.type == '学生': for i in range(number): testid = cursor_sql_value_testid[i] if testid =='623': stem_no = 63 quest_id = 20 self.executeSQL(testid,stem_no,quest_id) if testid == '523': stem_no = 63 quest_id = 25 self.executeSQL(testid,stem_no,quest_id) if self.type == '家长': for i in range(number): testid = cursor_sql_value_testid[i] if testid =='624': stem_no = 47 quest_id = 22 self.executeSQL(testid,stem_no,quest_id) if testid == '524': stem_no = 47 quest_id = 23 self.executeSQL(testid,stem_no,quest_id) # with open('E:/XYRGInterface/testCase/user/test_id.txt', 'w')as f: # str = '' # # print(cursor_sql_value_testid) # number = len(cursor_sql_value_testid) # for i in range(number): # str +=cursor_sql_value_testid[i]+' ' # f.writelines(str) # else: # return 0 # print(54968453156841324896132129681325) # print(sql_testid) # self.logger.info(sql_testid) if self.result == '0': common.get_value_from_return_json_assertEqual(self.info, 'code', 'msg',self.case_name) self.assertEqual(self.info['code'], self.code,"code值验证不成功") self.assertEqual(self.info['msg'], self.msg,"msg值验证不成功") if self.result == '1': self.assertEqual(self.info['code'], self.code,"code值验证不成功") self.assertEqual(self.info['msg'], self.msg,"msg值验证不成功")
def checkResult(self): # 获取json格式值 self.info = self.respon.json() common.show_return_msg(self.respon) # 判断状态是否是200 # 断言返回值errno, cityname,error是否成功 self.assertEqual(self.info['status'], 404) self.assertEqual(self.info['error'], self.error) self.assertEqual(self.info['message'], "No message available")
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() common.show_return_msg(self.return_json) self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() # show return message common.show_return_msg(self.return_json) self.assertEqual(self.code, str(self.info['code'])) self.assertEqual(self.msg, str(self.info['message']))
def checkResult(self): self.info = self.response.json() common.show_return_msg(self.response) if self.result == '0': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg) goods_id = common.get_value_from_return_json(self.info, "Product", "goods_id") self.assertEqual(goods_id, self.goodsId) if self.result == '1': self.assertEqual(self.info['code'], self.info['code']) self.assertEqual(self.info['msg'], self.msg)
def checkResult(self): # 获取json格式值 self.info = self.respon.json() common.show_return_msg(self.respon) self.info = self.respon.json() # 判断状态是否是200 if self.respon.status_code == 200 and self.resultType == 0: print(self.info['error']) # 断言返回值errno, cityname,error是否成功 self.assertEqual(self.info['errno'], int(self.errno)) self.assertEqual(self.info['data']['cityName'], self.cityName) self.assertEqual(self.info['error'], "操作成功")
def checkResult(self): self.info = self.response.json() common.show_return_msg(self.response) if self.result == '0': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg) result = self.info['info'].get('result') self.assertEqual(result, 1) if self.result == '1': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg)
def interfaceTest(self): # set url self.url = common.get_url_from_xml('dataPlatformUser_overview') localConfigHttp.set_url(self.url) # set header cookie = localReadConfig.get_headers("cookie") contentType = localReadConfig.get_headers("contentType") header = {"Content-Type": contentType, "Cookie": cookie} localConfigHttp.set_headers(header) # test interface self.response = localConfigHttp.post() self.info = self.response.json() common.show_return_msg(self.response)
def checkResult(self): # 显示响应信息 common.show_return_msg(self.response) self.info = self.response.text # Json响应信息转成字典格式 self.info = json.loads(self.info) # 断言返回状态码 self.assertEqual(self.info['err_no'], self.expect_state) # 断言返回message mes_reponse = self.info['err_msg'].encode('utf-8') self.assertEqual(mes_reponse, self.expect_msg)
def checkResult(self): """ check test reslt :return: """ self.info = self.response.json() common.show_return_msg(self.response) if self.result == '1': self.assertEqual(str(self.info['resultCode']), str(self.resultCode)) self.assertEqual(str(self.info['resultMessage']), str(self.resultMessage))
def checkResult(self): """ check test result :return: """ self.info = self.response.json() common.show_return_msg(self.response) self.assertEqual(self.info['code'], self.code) if self.info['code'] == self.code: self.assertEqual(self.info['msg'], self.msg) self.log.build_OK_line(self.case_name, self.code, self.msg) else: self.log.build_NG_line(self.case_name, self.info['code'], self.info['msg'])
def checkResult(self): # 获取json格式值 self.info = self.respon.json() common.show_return_msg(self.respon) # 判断状态是否是200 if self.resultType == '0' and self.respon.status_code == 200: self.assertEqual(self.info['errno'], int(self.errno)) self.assertEqual(self.info['error'], "操作成功") elif self.resultType == '1' and self.respon.status_code == 200: self.assertEqual(self.info['errno'], int(self.errno)) self.assertEqual(self.info['error'], self.error) elif self.resultType == '2' and self.respon.status_code == 200: self.assertEqual(self.info['errno'], int(self.errno)) self.assertEqual(self.info['error'], self.error)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() common.show_return_msg(self.return_json) if self.result == '0': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg) self.assertEqual( self.sex, common.get_value_from_return_json(self.info, 'address', 'sex')) self.assertEqual( self.fname, common.get_value_from_return_json(self.info, 'address', 'fname')) self.assertEqual( self.lname, common.get_value_from_return_json(self.info, 'address', 'lname')) self.assertEqual( self.tel, common.get_value_from_return_json(self.info, 'address', 'tel')) self.assertEqual( self.address1, common.get_value_from_return_json(self.info, 'address', 'address1')) self.assertEqual( self.city, common.get_value_from_return_json(self.info, 'address', 'city')) self.assertEqual( self.state, common.get_value_from_return_json(self.info, 'address', 'state')) self.assertEqual( self.postcode, common.get_value_from_return_json(self.info, 'address', 'postcode')) self.assertEqual( self.country_id, common.get_value_from_return_json(self.info, 'address', 'countryId')) if self.result == '1': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg)
def checkResult(self): """ check test result :return: """ self.info = self.response.json() common.show_return_msg(self.response) if self.result == '0': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg) self.assertEqual(self.info['info'], 1) if self.result == '1': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() # show return message common.show_return_msg(self.return_json) if self.result == '0': self.assertEqual(self.info["statusCode"], self.code) self.assertEqual(self.info['ads'][0]['adType'], self.msg) if self.result == '1': self.assertEqual(self.info['statusCode'], self.code) self.assertEqual(self.info['ads'][0]['adType'], self.msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() common.show_return_msg(self.return_json) if self.result == '0': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg) self.assertIsNotNone(self.info['info']['address']) if self.result == '1': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg)
def checkResult(self): # 显示响应信息 common.show_return_msg(self.response) self.info = self.response.text # Json响应信息转成字典格式 self.info = json.loads(self.info) # 存储token,只有正确登录的时候才有token if 'access_token' in self.info['data']: token_temp = self.info['data']['access_token'] localReadConfig.set_headers('token_temp', token_temp) # 断言返回状态码 self.assertEqual(self.info['err_no'], self.expect_state) # 断言返回message mes_reponse = self.info['err_msg'].encode('utf-8') self.assertEqual(mes_reponse, self.expect_msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() # show return message print(self.info) common.show_return_msg(self.return_json) common.get_value_from_return_json_assertEqual(self.info, 'code', 'msg', self.case_name) if self.result == '0': # common.get_value_from_return_json_assertEqual(self.info, 'code', 'msg',self.case_name) self.assertEqual(self.info['code'], self.code,"code值验证不成功") self.assertEqual(self.info['msg'], self.msg,"msg值验证不成功") if self.result == '1': self.assertEqual(self.info['code'], self.code,"code值验证不成功") self.assertEqual(self.info['msg'], self.msg,"msg值验证不成功")
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() common.show_return_msg(self.return_json) if self.result == '0': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg) value = self.info['info']['result'] self.assertEqual(str(value), 1) if self.result == '1': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() # print(self.info) # {'code': 0, 'message': 'success', 'data': {'resultcode': '101'}} # show return message common.show_return_msg(self.return_json) if self.resultcode == '100': # email = common.get_value_from_return_json(self.info, 'member', 'email') self.assertEqual(str(self.info['code']), self.code) self.assertEqual(self.info['message'], self.msg) # self.assertEqual(email, self.email) if self.resultcode != '100': self.assertEqual(str(self.info['code']), self.code) self.assertEqual(self.info['message'], self.msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() # show return message common.show_return_msg(self.return_json) if self.result == '0': # email = common.get_value_from_return_json(self.info, 'member', 'email') self.assertEqual(self.info['result_code'], int(self.code)) self.assertEqual(self.info['message'], self.msg) # self.assertEqual(email, self.email) if self.result == '1': self.assertEqual(self.info['result_code'], self.code) self.assertEqual(self.info['message'], self.msg)
def checkResult(self): """ :return: """ self.info = self.return_json.json() common.show_return_msg(self.return_json) if self.result == '0': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg) self.assertIsNotNone(self.info['info']['address']) value = common.get_value_from_return_json(self.info, "address", "addressId") self.assertEqual(value, self.address_id) if self.result == '1': self.assertEqual(self.info['code'], self.code) self.assertEqual(self.info['msg'], self.msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() common.show_return_msg(self.return_json) # 显示返回信息 self.assertEqual(self.return_json.status_code, 200) try: if self.success != None and self.success != '': self.assertEqual(self.info['success'], self.success) except KeyError: pass try: if self.code != None and self.code != '': self.assertEqual(self.info['code'], self.code) except KeyError: pass
def checkResult(self): # 显示响应信息 common.show_return_msg(self.response) self.info = self.response.text # Json响应信息转成字典格式 self.info = json.loads(self.info) # 存储token,只有正确登录的时候才存储token if 'access_token' in self.info['data'] and self.info['err_msg'] == 'success': token_temp = self.info['data']['access_token'] # localReadConfig.set_headers('token_temp', token_temp) f = open(token_fiel_path, 'w') f.write(token_temp) print '最新token存储完成...', token_temp # 断言返回状态码 self.assertEqual(self.info['err_no'], self.expect_state) # 断言返回message mes_reponse = self.info['err_msg'].encode('utf-8') self.assertEqual(mes_reponse, self.expect_msg)
def checkResult(self): """ check test result :return: """ self.info = self.return_json.json() data_value = self.info['data'] common.show_return_msg(self.return_json) if self.info['code'] == 0: self.log.build_sql_line(self.case_name) with open('E:/XYRGInterface/testCase/user/sql_value.txt', 'r') as f: sql_value = f.readline() print("开始连接数据库......") self.logger.info("开始连接数据库......") sql_testid = common.get_sql('ygf_xlcp_20171208', 'user', 'test_id') # 根据学校和学号 cursor_sql_value_testid = configDB.executeSQL_all(sql_testid, (self.student_name,sql_value)) number = len(cursor_sql_value_testid) if self.type == '学生': for i in range(number): testid = cursor_sql_value_testid[i] # print(testid) if testid =='623': stem_no = 63 quest_id = 20 self.executeSQL(testid,stem_no,quest_id) if testid == '523': stem_no = 63 quest_id = 25 self.executeSQL(testid,stem_no,quest_id) if self.type == '家长': for i in range(number): testid = cursor_sql_value_testid[i] if testid =='624': stem_no = 47 quest_id = 22 self.executeSQL(testid,stem_no,quest_id) if testid == '524': stem_no = 47 quest_id = 23 self.executeSQL(testid,stem_no,quest_id) common.get_value_from_return_json_assertEqual(self.info, 'code', 'msg', self.case_name)