def create_new_user(regname, pwd='123456'):
handle_mysql = HandleMysql()
send_request = HttpRequests()
do_config = HandleConfig(CONFIGS_FILE_TESTCASE1)
url = do_config.get_value('requests', 'url_head') + '/member/register'
print(url)
sql = "select Id from member where MobilePhone = %s;"
while True:
mobilephone = handle_mysql.create_not_existed_mobile()
print(mobilephone)
print(pwd)
print(regname)
data = {"mobilephone": mobilephone, "pwd": pwd, "regname": regname}
#new_data = json.dumps(data)
res = send_request.to_request(method="post", url=url, data=data)
print(res.text)
result = handle_mysql.run_mysql(sql, (mobilephone, ))
print('ddddddd{}'.format(result))
#result为空，说明注册没成功，则执行for循环下一次，直到成功
if result:
user_id = result['Id']
break
user_dict = {
regname: {
"Id": user_id,
"regname": regname,
"mobilephone": mobilephone,
"pwd": pwd
}
}
return user_dict
handle_mysql.close()
class RegisterAccount:
sql = "SELECT Id,Pwd,MobilePhone FROM member WHERE MobilePhone = %s"
data = '{"mobilephone":"${not_existed_tel}","pwd":"123456","regname":"jason_loan"}'
url = 'http://tj.lemonban.com/futureloan/mvc/api/member/register'
def __init__(self):
self.handle_mysql = HandleMysql()
self.do_config = HandleConfig(CONFIGS_FILE_TESTCASE2)
def register(self):
not_existed_mobile = self.handle_mysql.create_not_existed_mobile()
new_data = re.sub(r'\$\{not_existed_tel\}', not_existed_mobile,
self.data)
do_http_requests.to_request('post', url=self.url, data=new_data)
sql_result = self.handle_mysql.run_mysql(self.sql,
args=(not_existed_mobile, ))
return sql_result
def close(self):
self.handle_mysql.close()
def write_data(self):
content = self.register()
datas = {"account": content}
self.do_config.write_config(datas, CONFIGS_FILE_TESTCASE2)