def register(reg_name='linux超', pwd='123456'):
"""注册帐号"""
do_mysql = HandleMysql()
request = HttpRequests()
register_url = do_conf('URL', 'Host_Url') + '/member/register'
while 1:
phone = do_mysql.get_not_exist_phone()
request_data = {"mobilephone": phone, "pwd": pwd, "regname": reg_name}
request(method='post',
url=register_url,
data=request_data
)
sql = 'select Id from member where MobilePhone=%s;'
member = do_mysql(sql=sql, args=(phone,))
if member:
member_id = member['Id']
break
user_dic = {
reg_name: {
'MemberId': member_id,
'pwd': pwd,
'MobilePhone': phone,
'RegName': reg_name
}
}
do_mysql.close()
request.close_session()
log.info('注册{}帐号成功\n帐号信息-userId{},userName{},mobilePhone{}'.
format(reg_name, member_id, reg_name, phone))
return user_dic
def is_exist_db(phone):
mysql = HandleMysql()
sql = 'SELECT Fmobile_no FROM sms_db_46.t_mvcode_info_8 where Fmobile_no=%s;'
exist = mysql(sql=sql, args=(phone,))
mysql.close()
if exist:
return True
else:
return False
def setUpClass(cls):
logger.info('---开始加载[{}]测试用例---'.format(cls.__doc__))
cls.mysql = HandleMysql()
# 执行认证接口之前先删除表中已经认证的身份证号
cls.mysql(
sql=
'delete FROM user_db.t_user_auth_info where Ftrue_name in ("超哥", "张亮");'
)
cls.verify_unregistered_phone = CreateData.get_unregistered_phone()
setattr(DataReplace, 'verify_unregistered_phone',
cls.verify_unregistered_phone)
def setUpClass(cls):
logger.info('---开始加载[{}]测试用例---'.format(cls.__doc__))
cls.mysql = HandleMysql()
# 执行认证接口之前先删除表中已经认证的身份证号
cls.mysql(
sql='delete FROM user_db.t_user_auth_info where Ftrue_name = "张亮";'
)
cls.verify_unregistered_phone = CreateData.get_unregistered_phone()
setattr(DataReplace, 'verify_unregistered_phone',
cls.verify_unregistered_phone)
# 取一个未实名的uid
untrue_register_uid = \
str(cls.mysql('SELECT Fuid FROM user_db.t_user_info where Ftrue_name is Null limit 1;')["Fuid"])
setattr(DataReplace, "untrue_register_uid", untrue_register_uid)
def setUpClass(cls):
cls.mysql = HandleMysql()
# 管理人员登录
login.login_api(method='post',
url=do_conf('URL', 'Host_Url') + '/member/login',
data={
"mobilephone": str(do_user('Admin',
'mobilephone')),
"pwd": (do_user('Admin', 'pwd'))
})
# 管理人加标
add.add_loan_api(method='post',
url=do_conf('URL', 'Host_Url') + '/loan/add',
data={
"memberId": str(do_user('Invest', 'memberid')),
"title": "超哥专属标的",
"amount": 1000000,
"loanRate": 10,
"loanTerm": 3,
"loanDateType": 0,
"repaymemtWay": 4,
"biddingDays": 5
})
sql = 'SELECT Id FROM loan WHERE MemberID={0} ORDER BY CreateTime DESC LIMIT 1;'.format(
str(do_user('Invest', 'memberid')))
loan_id = str(cls.mysql(sql=sql)['Id'])
setattr(DataReplace, 'loan_id', loan_id)
# 管理人审核
audit.audit_loan_api(method='post',
url=do_conf('URL', 'Host_Url') + '/loan/audit',
data={
"id": loan_id,
"status": 4
})
# 投资人登录
login.login_api(method='post',
url=do_conf('URL', 'Host_Url') + '/member/login',
data={
"mobilephone": str(do_user('Invest',
'mobilephone')),
"pwd": (('Invest', 'pwd'))
})
def setUpClass(cls):
cls.request = HttpRequests()
cls.mysql = HandleMysql()
log.info('------开始执行{}测试用例------'.format(cls.__doc__))
def setUpClass(cls):
logger.info('---开始加载[{}]测试用例---'.format(cls.__doc__))
cls.mysql = HandleMysql()
cls.verify_unregistered_phone = CreateData.get_unregistered_phone()
setattr(DataReplace, 'verify_unregistered_phone',
cls.verify_unregistered_phone)