def qj_sql_value(self,quest_id,wu_name,avg_value):
# 查询全局维度分
sql_dim_jq_info = common.get_sql('ygf_xlcp_20171208', 'quest_history_info_dimension', 'dimension_info')
dimension_info = configDB.executeSQL(sql_dim_jq_info, quest_id)
# [{'维度名': '自主学习意识', '平均分': '3.7802', '标准差': '0.7009'},
# {'维度名': '自主学习情绪', '平均分': '3.4144', '标准差': '0.76397'},
# {'维度名': '自主学习倾向', '平均分': '3.0944', '标准差': '0.62917'},
# {'维度名': '自主学习效能感', '平均分': '3.2014', '标准差': '0.79273'},
# {'维度名': '自主学习习惯', '平均分': '3.2221', '标准差': '0.75463'},
# {'维度名': '学习环境控制', '平均分': '3.1834', '标准差': '0.80796'}]
# 计算个维度百分位数
# 将列表形式的str转化为list
dimension_info = eval(dimension_info) # <class 'list'>
dim_info_len = len(dimension_info) # 6
for i in range(dim_info_len):
dic_num = len(dimension_info[i]) # 3
list_values = dimension_info[i] #<class 'dict'>
if list_values['维度名'] == wu_name:
vd_avg = float('%.4f' % (float(list_values['平均分'])))
vd_bzc = float('%.4f' % (float(list_values['标准差'])))
vd_zp_zf = round((float(avg_value) - vd_avg) / vd_bzc, 2)
print("----------数据库查询%s全局相关数据----------" % wu_name)
print("查询出%s全局平均分:%s" % (wu_name, vd_avg))
print("查询出%s全局标准差:%s" % (wu_name, vd_bzc))
if quest_id == 20 or quest_id == 23:
self.zp_zf = vd_zp_zf
if quest_id == 25 or quest_id == 22:
self.tp_zf = vd_zp_zf
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 testOverview_totalUv(self):
self.interfaceTest()
self.totalUv = self.info['data']['totalUv']
self.sqltotalUv = common.get_sql('shop-v2', 't_pv', 'Overview',
'totalUv')
self.expect = localConfigDB.get_all(
localConfigDB.executeSQLNoParam(self.sqltotalUv))[0][0]
# check result
self.assertEqual(self.totalUv, self.expect)
def testOverview_todayTurnoverUsers(self):
self.interfaceTest()
self.todayTurnoverUsers = self.info['data']['todayTurnoverUsers']
sqltodayTurnoverUsers = common.get_sql('shop-v2', 't_pv', 'Overview',
'todayTurnoverUsers')
self.expect = localConfigDB.get_all(
localConfigDB.executeSQLNoParam(sqltodayTurnoverUsers))[0][0]
# check result
self.assertEqual(self.todayTurnoverUsers, self.expect)
def testOverview_turnoverUsersRate(self):
self.interfaceTest()
self.turnoverUsersRate = self.info['data']['turnoverUsersRate']
self.sqlturnoverUsersRate = common.get_sql('shop-v2', 't_pv',
'Overview',
'turnoverUsersRate')
self.expect = localConfigDB.get_all(
localConfigDB.executeSQLNoParam(self.sqlturnoverUsersRate))[0][0]
# check result
self.assertEqual(self.turnoverUsersRate, self.expect)
def testDB(self):
self.select_member = common.get_sql("newsitetest",
"rs_member_wallet_bill",
"select_member")
self.cursor = local_db.executeSQL(self.select_member, '1933546')
self.list = local_db.get_all(self.cursor)
# get result list
for l in self.list:
self.select_list.append(l)
print(l[2])
print(self.select_list[4][8])
def tearDown(self):
self.sql = raed_configmysql.query_one(
common.get_sql("user", "div_del", "div_del"))
if self.sql == 1:
self.log.build_case_line(self.case_name, str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_pass_line(self.case_name)
else:
self.log.build_case_line(self.case_name, str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_fail_line(self.case_name)
def tearDown(self):
self.sql = raed_configmysql.query_one(
common.get_sql("caller", "caller_code", "caller_code"))
if str(self.sql) == str(self.phone):
self.log.build_case_line(self.case_name, str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_pass_line(self.case_name)
else:
self.log.build_case_line(self.case_name, str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_fail_line(self.case_name)
def testDB(self):
mysql = "SELECT COUNT(activity_type) FROM `rs_member_winner` WHERE email='*****@*****.**'"
self.select_member = common.get_sql("newsitetest",
"rs_member_wallet_bill",
"select_member")
self.cursor = local_db.executeSQL(self.select_member, '1933546')
self.list = local_db.get_all(self.cursor)
# get result list
for l in self.list:
self.select_list.append(l)
print(l[2])
print(self.select_list[4][8])
def tearDown(self):
if self.info['msg'] == '操作成功':
self.sql = raed_configmysql.query_one(
common.get_sql("user", "div_info", "div_info"))
if str(self.sql) == self.departmentName:
self.log.build_case_line(self.case_name,
str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_pass_line(self.case_name)
else:
self.log.build_case_line(self.case_name,
str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_fail_line(self.case_name)
def testLogin(self):
"""
test body
:return:
"""
# set url
self.url = common.get_url_from_xml('login')
configHttp.set_url(self.url)
self.log.build_start_line(self.case_name)
print("第一步：设置url " + self.url)
self.logger.info("第一步：设置url " + self.url)
# get visitor token
# if self.token == '0':
# token = localReadConfig.get_headers("token_v")
# elif self.token == '1':
# token = None
# set headers
# header = {"token": str(token)}
# configHttp.set_header(header)
print("第二步：设置openid")
self.logger.info("第二步：设置openid")
sql_openid = common.get_sql("ygf_xlcp_20171208", "user_openid",
"openid")
openid = configDB.executeSQL(sql_openid,
(self.student_name, self.school_name))
# print(openid)
#
#
# print(configHttp.set_header(header))
# self.logger.info(configHttp.set_header(header))
# if self.method == 'post':
# set params
#data = {"email": self.email, "password": self.password}
#configHttp.set_data(data)
if self.method == 'get':
params = {"openid": openid}
configHttp.set_params(params)
print("第三步：设置发送请求的参数")
self.logger.info("第三步：设置发送请求的参数")
print(configHttp.set_params(params))
self.logger.info(configHttp.set_params(params))
# test interface
self.return_json = configHttp.get()
method = str(self.return_json.request
)[int(str(self.return_json.request).find('[')) +
1:int(str(self.return_json.request).find(']'))]
print("第四步：发送请求\n\t\t请求方式：" + method)
self.logger.info("第四步：发送请求\n\t\t请求方式：" + method)
self.checkResult()
def test2_caller_add(self):
#set_url
url = raed_xml
raed_configHttp.set_url(url)
print(raed_configHttp.set_url(url))
#set_head
#'Content-Type':raed_config.get_headers('Content-Type')去掉，否则报500
header = {'token': raed_config.get_headers('token')}
raed_configHttp.set_headers(header)
print(raed_configHttp.set_headers(header))
#set_data
data = {
"visitorPhone":
self.visitorPhone,
"workerName":
self.workerName,
"note":
self.note,
"idCardNumber":
self.idCardNumber,
"checkCode":
str(
raed_configmysql.query_one(
common.get_sql("caller", "caller_code_verify",
"caller_code_verify"))),
"subContractorId":
raed_config.get_headers('subContractorId')
}
raed_configHttp.set_data(data)
print(raed_configHttp.set_data(data))
#ste_file
files = {
'headImage':
('6.jpg', open(str(raed_path.get_imsg_pash('6.jpg')),
'rb'), 'image/jpeg')
}
raed_configHttp.set_files(files)
print(raed_configHttp.set_files(files))
#请求接口
self.response = raed_configHttp.HttpMethod(self.method)
print(self.response.text)
self.add_result()
def tearDown(self):
self.info = self.response.json()
self.sql = raed_configmysql.query_one(
common.get_sql("user", "info", "user_info"))
self.username = self.info["data"]["username"]
if self.sql == self.username:
raed_config.set_headers("myDepartmentId",
self.info['data']['departmentId'])
raed_config.set_headers("subContractorId",
str(self.info['data']['subContractorId']))
self.log.build_case_line(self.case_name, str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_pass_line(self.case_name)
else:
self.log.build_case_line(self.case_name, str(self.info["code"]),
str(self.info['msg']))
self.log.build__sql_fail_line(self.case_name)
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)
def checkResult(self):
"""
:return:
"""
self.info = self.response.json()
common.show_return_msg(self.response)
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)
if self.case_name == 'registerQuick_EmailExist':
sql = common.get_sql('newsitetest', 'rs_member', 'delete_user')
localConfigDB.executeSQL(sql, self.email)
localConfigDB.closeDB()
def executeSQL(self, testid, stem_no, quest_id):
cand_no_path = os.path.join(proDir, "sql_value.txt")
with open(cand_no_path, 'r') as f:
sql_value = f.readline()
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))
sql_zong_avgscore = common.get_sql('ygf_xlcp_20171208', 'answer',
'avgscore')
V_zong_avgscore = configDB.executeSQL_all(
sql_zong_avgscore, (testid, sql_value, quest_id, stem_no))
a = "".join(V_zong_avgscore)
v_zpzong_avgscore = float(a[int(a.find('(') + 2):int(a.find(')') - 1)])
sql_history_avg = common.get_sql('ygf_xlcp_20171208',
'quest_history_info', 'history_avg')
V_history_avg = configDB.executeSQL_all(sql_history_avg, quest_id)
b = "".join(V_history_avg)
len_b = len(b)
history_avg = float(b[(int(b.find('.') - 1)):int(b.find(','))])
history_standard_deviation = float(b[(int(b.find(',') + 2)):len_b])
v_zp_zf = (v_zpzong_avgscore -
history_avg) / history_standard_deviation
dic_zp_zf = Decimal(v_zp_zf)
dic_zp_zf = round(dic_zp_zf, 2)
sql_zp_bfs = common.get_sql('ygf_xlcp_20171208',
'standard_normal_info', 'results_value')
V_zp_bfs = configDB.executeSQL_all(sql_zp_bfs, dic_zp_zf)
v_zp_bfs = float("".join(V_zp_bfs))
v_zp_zhpf = (v_zp_bfs * 60) + 35
v_zp_cufen = v_zpzong_avgscore * 20
dic_v_zp_cufen = Decimal(v_zp_cufen)
dic_v_zp_cufen = round(dic_v_zp_cufen, 3)
if quest_id == 20:
print("**************** A-JS ****************")
print("学生日常行为量表（A-JS） quest_id:%s 学生:%s" %
(quest_id, self.student_name))
print('查询个人总维度平均分sql语句：', sql_zong_avgscore)
print('查询量表总维度平均分sql语句：', sql_history_avg)
print('个人总维度平均分：', v_zpzong_avgscore)
print('自评总体百分位数：', v_zp_bfs)
print('自评总粗分：', dic_v_zp_cufen)
print('自评个人总Z分：', v_zp_zf)
print('自评个人总评分', v_zp_zhpf)
print('全局总维度平均分：', history_avg)
print('全局标准差：', history_standard_deviation)
ziping_data = self.info['data'][0]
ziping = ziping_data['ziping']
zp_avg = ziping['zp_avg']
zp_bfs = ziping['zp_bfs']
zp_cufen = ziping['zp_cufen']
zp_zhpf = ziping['zp_zhpf']
zp_zf = ziping['zp_zf']
dic_zp_cufen = Decimal(zp_cufen)
dic_zp_cufen = round(dic_zp_cufen, 3)
self.assertEqual(zp_avg, v_zpzong_avgscore, '自评个人总维度平均分zp_avg校验失败')
self.assertEqual(zp_bfs, v_zp_bfs, '自评总体百分位数zp_bfs校验失败')
self.assertEqual(dic_zp_cufen, dic_v_zp_cufen, '自评总粗分zp_cufen校验失败')
self.assertEqual(zp_zf, v_zp_zf, '自评个人总Z分数zp_zf校验失败')
self.assertEqual(zp_zhpf, v_zp_zhpf, '自评总评分zp_zhpf校验失败')
if zp_avg == v_zpzong_avgscore:
print("自评个人总平均分zp_avg验证成功！")
else:
print("自评个人总平均分zp_avg验证失败！")
if zp_bfs == v_zp_bfs:
print('自评总体百分位数zp_bfs验证成功！')
else:
print('自评总体百分位数zp_bfs验证失败！')
if dic_zp_cufen == dic_v_zp_cufen:
print('自评总粗分zp_cufen验证成功！')
else:
print('自评总粗分zp_cufen验证失败！')
if zp_zf == v_zp_zf:
print('自评个人总Z分数zp_zf验证成功！')
else:
print('自评个人总Z分数zp_zf验证失败！')
if zp_zhpf == v_zp_zhpf:
print('自评总评分zp_zhpf验证成功！')
else:
print('自评总评分zp_zhpf验证失败！')
if quest_id == 25:
print("**************** H-JS ****************")
print("初中生日常行为家长评定量表（H-JS） quest_id:%s 学生:%s" %
(quest_id, self.student_name))
print('查询个人总维度平均分sql语句：', sql_zong_avgscore)
print('查询量表总维度平均分sql语句：', sql_history_avg)
print('个人总维度平均分：', v_zpzong_avgscore)
print('他评总体百分位数：', v_zp_bfs)
print('他评总粗分：', dic_v_zp_cufen)
print('他评个人总Z分：', v_zp_zf)
print('他评个人总评分', v_zp_zhpf)
print('他评全局总维度平均分：', history_avg)
print('他评全局标准差：', history_standard_deviation)
taping_data = self.info['data'][1]
taping = taping_data['taping']
tp_avg = taping['tp_avg']
tp_bfs = taping['tp_bfs']
tp_cufen = taping['tp_cufen']
tp_zhpf = taping['tp_zhpf']
tp_zf = taping['tp_zf']
dic_tp_cufen = Decimal(tp_cufen)
dic_tp_cufen = round(dic_tp_cufen, 3)
self.assertEqual(tp_avg, v_zpzong_avgscore, '他评个人总维度平均分tp_avg校验失败')
self.assertEqual(tp_bfs, v_zp_bfs, '他评总体百分位数tp_bfs校验失败')
self.assertEqual(dic_tp_cufen, dic_v_zp_cufen, '他评总粗分tp_cufen校验失败')
self.assertEqual(tp_zf, v_zp_zf, '他评个人总Z分数tp_zf校验失败')
self.assertEqual(tp_zhpf, v_zp_zhpf, '他评总评分tp_zhpf校验失败')
if tp_avg == v_zpzong_avgscore:
print("他评个人总平均分zp_avg验证成功！")
else:
print("他评个人总平均分zp_avg验证失败！")
if tp_bfs == v_zp_bfs:
print('他评总体百分位数zp_bfs验证成功！')
else:
print('他评总体百分位数zp_bfs验证失败！')
if dic_tp_cufen == dic_v_zp_cufen:
print('他评总粗分zp_cufen验证成功！')
else:
print('他评总粗分zp_cufen验证失败！')
if tp_zf == v_zp_zf:
print('他评个人总Z分数zp_zf验证成功！')
else:
print('他评个人总Z分数zp_zf验证失败！')
if tp_zhpf == v_zp_zhpf:
print('他评总评分zp_zhpf验证成功！')
else:
print('他评总评分zp_zhpf验证失败！')
if quest_id == 22:
print("**************** C-JS ****************")
print("初中家长教育行为学生感知量表（C - JS） quest_id:%s 学生:%s" %
(quest_id, self.student_name))
print('查询个人总维度平均分sql语句：', sql_zong_avgscore)
print('查询量表总维度平均分sql语句：', sql_history_avg)
print('个人总维度平均分：', v_zpzong_avgscore)
print('他评总体百分位数：', v_zp_bfs)
print('他评总粗分：', dic_v_zp_cufen)
print('他评个人总Z分：', v_zp_zf)
print('他评个人总评分', v_zp_zhpf)
print('他评全局总维度平均分：', history_avg)
print('他评全局标准差：', history_standard_deviation)
taping_data = self.info['data'][1]
taping = taping_data['taping']
tp_avg = taping['tp_avg']
tp_bfs = taping['tp_bfs']
tp_cufen = taping['tp_cufen']
tp_zhpf = taping['tp_zhpf']
tp_zf = taping['tp_zf']
dic_tp_cufen = Decimal(tp_cufen)
dic_tp_cufen = round(dic_tp_cufen, 3)
self.assertEqual(tp_avg, v_zpzong_avgscore, '他评个人总维度平均分tp_avg校验失败')
self.assertEqual(tp_bfs, v_zp_bfs, '他评总体百分位数tp_bfs校验失败')
self.assertEqual(dic_tp_cufen, dic_v_zp_cufen, '他评总粗分tp_cufen校验失败')
self.assertEqual(tp_zf, v_zp_zf, '他评个人总Z分数tp_zf校验失败')
self.assertEqual(tp_zhpf, v_zp_zhpf, '他评总评分tp_zhpf校验失败')
if tp_avg == v_zpzong_avgscore:
print("他评个人总平均分zp_avg验证成功！")
else:
print("他评个人总平均分zp_avg验证失败！")
if tp_bfs == v_zp_bfs:
print('他评总体百分位数zp_bfs验证成功！')
else:
print('他评总体百分位数zp_bfs验证失败！')
if dic_tp_cufen == dic_v_zp_cufen:
print('他评总粗分zp_cufen验证成功！')
else:
print('他评总粗分zp_cufen验证失败！')
if tp_zf == v_zp_zf:
print('他评个人总Z分数zp_zf验证成功！')
else:
print('他评个人总Z分数zp_zf验证失败！')
if tp_zhpf == v_zp_zhpf:
print('他评总评分zp_zhpf验证成功！')
else:
print('他评总评分zp_zhpf验证失败！')
if quest_id == 23:
print("**************** F-JS ****************")
print("初中家长教育行为量表（F - JS） quest_id:%s 学生:%s" %
(quest_id, self.student_name))
print('查询个人总维度平均分sql语句：', sql_zong_avgscore)
print('查询量表总维度平均分sql语句：', sql_history_avg)
print('个人总维度平均分：', v_zpzong_avgscore)
print('自评总体百分位数：', v_zp_bfs)
print('自评总粗分：', dic_v_zp_cufen)
print('自评个人总Z分：', v_zp_zf)
print('自评个人总评分', v_zp_zhpf)
print('全局总维度平均分：', history_avg)
print('全局标准差：', history_standard_deviation)
ziping_data = self.info['data'][0]
ziping = ziping_data['ziping']
zp_avg = ziping['zp_avg']
zp_bfs = ziping['zp_bfs']
zp_cufen = ziping['zp_cufen']
zp_zhpf = round(ziping['zp_zhpf'], 2)
zp_zf = ziping['zp_zf']
dic_zp_cufen = Decimal(zp_cufen)
dic_zp_cufen = round(dic_zp_cufen, 3)
self.assertEqual(zp_avg, v_zpzong_avgscore, '自评个人总维度平均分zp_avg校验失败')
self.assertEqual(zp_bfs, v_zp_bfs, '自评总体百分位数zp_bfs校验失败')
self.assertEqual(dic_zp_cufen, dic_v_zp_cufen, '自评总粗分zp_cufen校验失败')
self.assertEqual(zp_zf, v_zp_zf, '自评个人总Z分数zp_zf校验失败')
self.assertEqual(zp_zhpf, v_zp_zhpf, '自评总评分zp_zhpf校验失败')
if zp_avg == v_zpzong_avgscore:
print("自评个人总平均分zp_avg验证成功！")
else:
print("自评个人总平均分zp_avg验证失败！")
if zp_bfs == v_zp_bfs:
print('自评总体百分位数zp_bfs验证成功！')
else:
print('自评总体百分位数zp_bfs验证失败！')
if dic_zp_cufen == dic_v_zp_cufen:
print('自评总粗分zp_cufen验证成功！')
else:
print('自评总粗分zp_cufen验证失败！')
if zp_zf == v_zp_zf:
print('自评个人总Z分数zp_zf验证成功！')
else:
print('自评个人总Z分数zp_zf验证失败！')
if zp_zhpf == v_zp_zhpf:
print('自评总评分zp_zhpf验证成功！')
else:
print('自评总评分zp_zhpf验证失败！')
def checkResult(self):
"""
check test result
:return:
"""
self.info = self.return_json.json()
print("\t\t验证程序返回code值:", self.info['code'])
if self.info['code'] == 0:
# print(self.info['data']['stu']['student_no'])
# 生成cookie文件路径
# print(cookie_path_p)
cookie_path = os.path.join(cookie_path_p, "cookie.txt")
# print(os.path.isfile(cookie_path))
# 截取cookie值
cookie_value = str(
self.return_json.cookies
)[int(str(self.return_json.cookies).find('=')) +
1:int(str(self.return_json.cookies).find('f')) - 1]
with open(cookie_path, 'w') as f:
f.write(cookie_value)
print("\t\tcookie值写入成功:", cookie_value)
# self.logger.info("\t\tcookie值写入成功:",s)
else:
print("\t\t不传入cookie值")
self.logger.info("\t\t不传入cookie值")
common.show_return_msg(self.return_json)
print("第五步：检查结果")
# print(os.path.realpath(__file__))
# print(os.getcwd())
self.logger.info("第五步：检查结果")
info = self.info
if info['code'] == 0:
info1 = info['data']
info2 = info1['stu']
info3 = info2['school']
info4 = info2['grade']
info5 = info2['class_name']
info6 = info2['student_name']
common.get_value_from_return_json_get(info, info3, info4, info5,
info6, self.case_name)
self.log.build_sql_line(self.case_name)
print("开始连接数据库......")
self.logger.info("开始连接数据库......")
sql = common.get_sql('ygf_xlcp_20171208', 'user_student_relation',
'select_member')
cursor_sql_value = configDB.executeSQL(sql, self.student_name)
print(sql)
self.logger.info(sql)
sql_stu_test_code = str(
str(self.info['data']['stu']['stu_test_code']))
with open('E:/XYRGInterface/testCase/user/sql_value.txt',
'w') as f:
f.write(sql_stu_test_code)
print("stu_test_code值写入成功:", sql_stu_test_code)
print("数据库查询出学生%s学号:%s" % (self.student_name, cursor_sql_value))
self.logger.info("数据库查询出学生%s学号:%s" %
(self.student_name, cursor_sql_value))
print("接口返回学生%s学号:%s" %
(self.student_name, self.info['data']['stu']['student_no']))
self.logger.info(
"接口返回学生%s学号:%s" %
(self.student_name, self.info['data']['stu']['student_no']))
self.assertEqual(str(self.info['data']['stu']['student_no']),
cursor_sql_value, "学生学号验证不成功")
if cursor_sql_value == self.info['data']['stu']['student_no']:
print("学生学号验证成功！！！！")
configHttp.set_stu_test_code(
self.info['data']['stu']['stu_test_code'])
# print(configHttp.set_stu_test_code(self.info['data']['stu']['stu_test_code']))
self.logger.info("学生学号验证成功！！！！")
else:
print("学生学号验证失败！！！！")
self.logger.info("学生学号验证失败！！！！")
else:
common.get_value_from_return_json_code(info, self.case_name)
if self.result == '0':
# email = common.get_value_from_return_json_assertEqual(self.info,self.case_name)
self.assertEqual(str(self.info['code']), self.code, "code值验证不成功")
self.assertEqual(str(self.info['msg']), self.msg, "msg信息验证不成功")
if self.result == '1':
self.assertEqual(str(self.info['code']), self.code, "code值验证不成功")
self.assertEqual(str(self.info['msg']), self.msg, "msg信息验证不成功")
def executeSQL(self,testid,stem_no,quest_id):
cand_no_path = os.path.join(proDir, "sql_value.txt")
with open(cand_no_path, 'r') as f:
sql_value = f.readline()
# 查表计算各维度百分位数
sql_zp_bfs = common.get_sql('ygf_xlcp_20171208', 'standard_normal_info', 'results_value')
#计算当前量表各维度平均分
sql_dim_zp_info = common.get_sql('ygf_xlcp_20171208','scr_dimensiongoals','avggoals')
#各维度的dim_info
dim_zp_info = configDB.executeSQL_all(sql_dim_zp_info,(sql_value,testid)) #<class 'list'>
dim_len = len(dim_zp_info)
#["'自主学习习惯', Decimal('2.00'), 972, 523, 25, Decimal('30.00'), 15", "'学习环境控制', Decimal('2.78'), 972, 523, 25, Decimal('25.00'), 9", "'自主学习倾向', Decimal('3.22'), 972, 523, 25, Decimal('29.00'), 9", "'自主学习情绪', Decimal('2.54'), 972, 523, 25, Decimal('33.00'), 13", "'自主学习效能感', Decimal('2.86'), 972, 523, 25, Decimal('20.00'), 7", "'自主学习意识', Decimal('2.00'), 972, 523, 25, Decimal('16.00'), 8"]
sql_testid = common.get_sql('ygf_xlcp_20171208', 'user', 'test_id')
data_value = self.info['data']
if quest_id == 20:#自评
print("**************** A-JS ****************")
print("学生日常行为量表（A-JS） quest_id:%s 学生:%s" % (quest_id, self.student_name))
print('查询个人各维度平均分sql语句：', sql_dim_zp_info)
for i in range(dim_len):
dim_info = eval(dim_zp_info[i])
# print("****************test_id=%s quest_id=%s*******************" % (testid, quest_id))
for j in range(dim_len):
if data_value[j]['dim_name'] == dim_info[0] == "自主学习意识":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id,dim_info[0],dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0],sql_zp_bfs,self.zp_zf,dim_info[1],quest_id) #<class 'list'>
cx_zp_value = self.cx_weidu_value(data_value,j,dim_info[0],quest_id) #<class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习情绪":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习倾向":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习效能感":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习习惯":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "学习环境控制":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if quest_id ==25:#他评
print("**************** H-JS ****************")
print("初中生日常行为家长评定量表（H-JS） quest_id:%s 学生:%s" % (quest_id, self.student_name))
print('查询个人总维度平均分sql语句：', sql_dim_zp_info)
for i in range(dim_len):
dim_info = eval(dim_zp_info[i])
# print("****************test_id=%s quest_id=%s*******************" % (testid, quest_id))
for j in range(dim_len):
if data_value[j]['dim_name'] == dim_info[0] == "自主学习意识":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id,dim_info[0],dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0],sql_zp_bfs,self.tp_zf,dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value,j,dim_info[0],quest_id)
self.value_asser(sql_tp_js_value,cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^"%dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习情绪":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习倾向":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习效能感":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "自主学习习惯":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "学习环境控制":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if quest_id == 22:#他评
print("**************** C-JS ****************")
print("初中家长教育行为学生感知量表（C - JS） quest_id:%s 学生:%s" % (quest_id, self.student_name))
print('查询个人各维度平均分sql语句：', sql_dim_zp_info)
for i in range(dim_len):
dim_info = eval(dim_zp_info[i])
# print("****************test_id=%s quest_id=%s*******************" % (testid, quest_id))
for j in range(dim_len):
if data_value[j]['dim_name'] == dim_info[0] == "支持态度":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id,dim_info[0],dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0],sql_zp_bfs,self.tp_zf,dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value,j,dim_info[0],quest_id)
self.value_asser(sql_tp_js_value,cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^"%dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "行为支持":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "情感支持":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "认知支持":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_tp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.tp_zf, dim_info[1],quest_id)
cx_tp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id)
self.value_asser(sql_tp_js_value, cx_tp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if quest_id == 23:#自评
print("**************** F-JS ****************")
print("初中家长教育行为量表（F - JS） quest_id:%s 学生:%s" % (quest_id, self.student_name))
print('查询个人各维度平均分sql语句：', sql_dim_zp_info)
for i in range(dim_len):
dim_info = eval(dim_zp_info[i])
# print("****************test_id=%s quest_id=%s*******************" % (testid, quest_id))
for j in range(dim_len):
if data_value[j]['dim_name'] == dim_info[0] == "支持态度":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id,dim_info[0],dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0],sql_zp_bfs,self.zp_zf,dim_info[1],quest_id) #<class 'list'>
cx_zp_value = self.cx_weidu_value(data_value,j,dim_info[0],quest_id) #<class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "行为支持":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "情感支持":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
if data_value[j]['dim_name'] == dim_info[0] == "认知支持":
print("^^^^^^^^^^^^^begin %s^^^^^^^^^^^^^" % dim_info[0])
self.qj_sql_value(quest_id, dim_info[0], dim_info[1])
sql_zp_js_value = self.sql_weidu_value(dim_info[0], sql_zp_bfs, self.zp_zf, dim_info[1],quest_id) # <class 'list'>
cx_zp_value = self.cx_weidu_value(data_value, j, dim_info[0], quest_id) # <class 'list'>
self.value_asser(sql_zp_js_value, cx_zp_value)
print("^^^^^^^^^^^^^end %s^^^^^^^^^^^^^" % dim_info[0])
import time
import unittest
import paramunittest
import readConfig as readConfig
from common import common
from common import configHttp
from common.Log import MyLog
import hashlib
import json
from common import configDB as configDB
#发送申请额度时，先删除原有已生成的额度信息
#连接mysql数据库
localsql_update = common.get_sql("loanquota", "t_lq_user_scene_base_info","02")#获取sql
localsql = common.get_sql("loanquota", "t_lq_user_scene_base_info","01")#获取sql
databasenumber = common.get_database_from_xml("loanquota")#获取loanquota数据库连接地址
print(localsql_update)
print(localsql)
print(databasenumber)
#修改额度状态为失效！
data2 = configDB.MyDB.query(localsql,databasenumber)
data1 = configDB.MyDB.delete(localsql_update,databasenumber)
data = configDB.MyDB.query(localsql,databasenumber)
for i in range(len(data)):
print (data[i])
print ("变更后的状态VALIDATE_STATE:"+ data[i][0])
localReadConfig = readConfig.ReadConfig()
localConfigHttp = configHttp.ConfigHttp()
local000001_xls = common.get_xls("test000001.xlsx", "Application_quota_APP")
#H5前端发起额度申请到大数据-接口LB01063
@paramunittest.parametrized(*local000001_xls)
from common import configDB as configDB
from common import common
import json
#连接mysql数据库
localsql = common.get_sql("loancore", "t_ba_iou", "01")
localsql_update = common.get_sql("loancore", "t_ba_iou", "02")
databasenumber = common.get_database_from_xml("loancore")
print(localsql_update)
print(localsql)
print(databasenumber)
#修改借据状态为7008
data1 = configDB.MyDB.update(localsql_update, databasenumber)
#查询借据状态
data = configDB.MyDB.query(localsql, databasenumber)
for i in range(len(data)):
print(data[i])
print("变更后的借据状态IOU_STATE:" + data[i][5])
'''
localsql_update = common.get_sql("loanquota", "t_lq_user_scene_base_info","02")
localsql = common.get_sql("loanquota", "t_lq_user_scene_base_info","01")
databasenumber = common.get_database_from_xml("loanquota")
print(localsql_update)
print(localsql)
print(databasenumber)
#修改借据状态为7008
data2 = configDB.MyDB.query(localsql,databasenumber)
data1 = configDB.MyDB.update(localsql_update,databasenumber)
#data1 = configDB.MyDB.update(localsql_update)
#查询借据状态
