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