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)
