def test_102_query_apply_result(self):
"""进件结果查询"""
Assert.check_column("wxjk_project", self.env,
self.r.get('kkd_6_periods_projectId'))
GetSqlData.change_project_audit_status(
project_id=self.r.get('kkd_6_periods_projectId'),
environment=self.env)
data = excel_table_byname(self.file, 'query_apply_result')
param = json.loads(data[0]['param'])
param.update({
"sourceProjectId":
self.r.get('kkd_6_periods_sourceProjectId'),
"projectId":
self.r.get('kkd_6_periods_projectId')
})
if len(data[0]['headers']) == 0:
headers = None
else:
headers = json.loads(data[0]['headers'])
rep = Common.response(faceaddr=data[0]['url'],
headers=headers,
data=json.dumps(param, ensure_ascii=False),
product="cloudloan",
environment=self.env)
self.assertEqual(rep['resultCode'], int(data[0]['resultCode']))
self.assertEqual(rep['content']['auditStatus'], 2)
def test_1_loan_notice(self, env, r):
"""拿去花放款通知接口"""
data = excel_table_byname(self.file, 'loan_notice')
print("接口名称:%s" % data[0]['casename'])
GetSqlData.change_project_audit_status(
project_id=r["nqh_one_period_same_day_return_projectId"],
environment=env)
param = json.loads(data[0]['param'])
r.set("nqh_one_period_same_day_return_loan_time", Common.get_time("-"))
param.update({
"sourceProjectId":
r.get("nqh_one_period_same_day_return_sourceProjectId"),
"sourceUserId":
r.get("nqh_one_period_same_day_return_sourceUserId"),
"projectId":
r.get("nqh_one_period_same_day_return_projectId"),
"serviceSn":
"SaasL-" + Common.get_random("serviceSn"),
"id":
r.get("nqh_one_period_same_day_return_cardNum"),
"bankPhone":
r.get("nqh_one_period_same_day_return_phone"),
'loanTime':
r.get("nqh_one_period_same_day_return_loan_time")
})
if len(data[0]['headers']) == 0:
headers = None
else:
headers = json.loads(data[0]['headers'])
rep = Common.response(faceaddr=data[0]['url'],
headers=headers,
data=json.dumps(param, ensure_ascii=False),
environment=env,
product="pintic")
assert rep['resultCode'] == int(data[0]['msgCode'])
def test_102_query_apply_result(self, r, env, red):
"""进件结果查询"""
GetSqlData.change_project_audit_status(
project_id=r.get(red["project_id"]),
environment=env
)
data = excel_table_byname(self.file, 'query_apply_result')
param = json.loads(data[0]['param'])
param.update(
{
"sourceProjectId": r.get(red["source_project_id"]),
"projectId": r.get(red["project_id"])
}
)
if len(data[0]['headers']) == 0:
headers = None
else:
headers = json.loads(data[0]['headers'])
rep = Common.response(
faceaddr=data[0]['url'],
headers=headers,
data=json.dumps(param, ensure_ascii=False),
product="cloudloan",
environment=env
)
assert rep['resultCode'] == int(data[0]['resultCode'])
assert rep['content']['auditStatus'] == 2
def test_100_approved(self):
"""橙分期进件同意接口"""
data = excel_table_byname(self.file, 'approved')
param = json.loads(data[0]['param'])
Common.p2p_get_userinfo("cfq_12_periods_return", self.env)
self.r.mset(
{
"cfq_12_periods_return_sourceProjectId": Common.get_random("sourceProjectId"),
"cfq_12_periods_return_sourceUserId": Common.get_random("userid"),
"cfq_12_periods_return_transactionId": "Apollo" + Common.get_random("transactionId"),
"cfq_12_periods_return_phone": Common.get_random("phone")
}
)
param.update(
{
"sourceProjectId": self.r.get("cfq_12_periods_return_sourceProjectId"),
"sourceUserId": self.r.get("cfq_12_periods_return_sourceUserId"),
"transactionId": self.r.get("cfq_12_periods_return_transactionId")
}
)
param['applyInfo'].update(
{
"applyTime": Common.get_time("-"),
}
)
param['personalInfo'].update(
{
"cardNum": self.r.get("cfq_12_periods_return_cardNum"),
"custName": self.r.get("cfq_12_periods_return_custName"),
"phone": self.r.get("cfq_12_periods_return_phone")
}
)
param['cardInfo'].update({"bankPhone": self.r.get("cfq_12_periods_return_phone")})
if len(data[0]['headers']) == 0:
headers = None
else:
headers = json.loads(data[0]['headers'])
rep = Common.response(
faceaddr=data[0]['url'],
headers=headers,
data=json.dumps(param, ensure_ascii=False),
environment=self.env,
product="pintic"
)
self.r.set("cfq_12_periods_return_projectId", rep['content']['projectId'])
self.assertEqual(rep['resultCode'], int(data[0]['msgCode']))
# 修改进件审核状态
GetSqlData.change_project_audit_status(
project_id=self.r.get("cfq_12_periods_return_projectId"),
environment=self.env
)
def test_100_approved(self, r, env):
"""随意借V2进件同意接口"""
data = excel_table_byname(self.file, 'approved')
print("接口名称:%s" % data[0]['casename'])
Common.p2p_get_userinfo('syjv2', env)
param = json.loads(data[0]['param'])
r.mset(
{
"syjv2_sourceUserId": Common.get_random('userid'),
"syjv2_transactionId": Common.get_random('transactionId'),
"syjv2_phone": Common.get_random('phone'),
"syjv2_sourceProjectId": Common.get_random('sourceProjectId')
}
)
param.update(
{
"sourceProjectId": r.get('syjv2_sourceProjectId'),
"sourceUserId": r.get('syjv2_sourceUserId'),
"transactionId": r.get('syjv2_transactionId')
}
)
param['riskSuggestion']['secondSugStrategy'] = 'R'
param['applyInfo'].update({"applyTime": Common.get_time("-")})
param['personalInfo'].update(
{
"cardNum": r.get('syjv2_cardNum'),
"custName": r.get('syjv2_custName'),
"phone": r.get('syjv2_phone')
}
)
param['cardInfo'].update({"bankPhone": r.get('syjv2_phone')})
if len(data[0]['headers']) == 0:
headers = None
else:
headers = json.loads(data[0]['headers'])
rep = Common.response(
faceaddr=data[0]['url'],
headers=headers,
data=json.dumps(param, ensure_ascii=False),
environment=env,
product="pintic"
)
r.set('syjv2_projectId', rep['content']['projectId'])
assert int(data[0]['msgCode']) == rep['resultCode']
assert "交易成功" == rep['content']['message']
GetSqlData.change_project_audit_status(
project_id=r.get('syjv2_projectId'),
environment=env
)
def test_0_approved(self, r, env):
"""借去花进件同意接口"""
data = excel_table_byname(self.file, 'approved')
print("接口名称:%s" % data[0]['casename'])
param = json.loads(data[0]['param'])
Common.p2p_get_userinfo("jqh", env)
r.mset(
{
"jqh_sourceProjectId": Common.get_random("sourceProjectId"),
"jqh_sourceUserId": Common.get_random("userid"),
"jqh_transactionId": "Apollo" + Common.get_random("transactionId"),
"jqh_phone": Common.get_random("phone")
}
)
param.update(
{
"sourceProjectId": r.get("jqh_sourceProjectId"),
"sourceUserId": r.get("jqh_sourceUserId"),
"transactionId": r.get("jqh_transactionId")
}
)
param['applyInfo'].update({"applyTime": Common.get_time("-")})
param['personalInfo'].update(
{
"cardNum": r.get("jqh_cardNum"),
"custName": r.get("jqh_custName"),
"phone": r.get("jqh_phone")
}
)
param['cardInfo'].update({"bankPhone": r.get("jqh_phone")})
if len(data[0]['headers']) == 0:
headers = None
else:
headers = json.loads(data[0]['headers'])
rep = Common.response(
faceaddr=data[0]['url'],
headers=headers,
data=json.dumps(param, ensure_ascii=False),
environment=env,
product="pintic"
)
r.set("jqh_projectId", rep['content']['projectId'])
assert (int(data[0]['msgCode']), rep['resultCode'])
assert (rep['content']['message'], "交易成功")
GetSqlData.change_project_audit_status(
project_id=r.get('jqh_projectId'),
environment=env
)
def test_101_query_audit_status(self, r, env):
"""橙分期进件审核结果查询"""
GetSqlData.change_project_audit_status(
project_id=r.get("cfq_12_periods_projectId"), environment=env)
data = excel_table_byname(self.file, 'query_audit_status')
param = json.loads(data[0]['param'])
param.update({
"sourceProjectId": r.get("cfq_12_periods_sourceProjectId"),
"projectId": r.get("cfq_12_periods_projectId")
})
if len(data[0]['headers']) == 0:
headers = None
else:
headers = json.loads(data[0]['headers'])
rep = Common.response(faceaddr=data[0]['url'],
headers=headers,
data=json.dumps(param, ensure_ascii=False),
environment=env,
product="pintec")
assert rep['resultCode'], int(data[0]['msgCode'])
