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)