Exemple #1
0
 def replace_phone(self):
     # 创建正则表达式,一定要加r,有特殊字符需要在字符串前方加\
     # match方法,传入正则表达式,待查询字符串
     # match只能从头开始匹配,匹配不到返回None
     # 匹配上后会返回match对象,用group获取结果
     try:
         # 替换生成的手机号
         do_mysql = HandleMysql()
         real_existed_phone = do_mysql.create_not_existed_mobile()
         data_str = re.sub(r"{not_existed_phone}", real_existed_phone,
                           self.one_str)
         do_mysql.close()
         return data_str
     except AttributeError as e:
         data_str = self.one_str
         return data_str
Exemple #2
0
def user_init():
    # 获取请求头
    headers = do_yaml.read_yaml('api', 'version')
    # 创建请求对象
    do_request = HandleRequests()
    # 添加公共请求头
    do_request.add_headers(headers)
    # url
    url = 'http://api.lemonban.com/futureloan/member/register'

    # 用户数据
    user_datas = [{
        'mobile_phone': '',
        'pwd': '12345678',
        'type': 0,
        'reg_name': '管理员'
    }, {
        'mobile_phone': '',
        'pwd': '12345678',
        'type': 1,
        'reg_name': '借款人'
    }, {
        'mobile_phone': '',
        'pwd': '12345678',
        'type': 1,
        'reg_name': '投资人'
    }]

    write_yaml = HandleYaml(USER_FILE_DIR)
    # 连接数据库
    do_mysql = HandleMysql()
    user_info = {}
    # 生成手机号并注册
    for user in user_datas:
        user['mobile_phone'] = do_mysql.create_not_existed_mobile()
        # 请求注册接口,返回数据转换成字典并存入字典
        res = do_request.send(url, data=user).json()
        # 获取用户id、密码等信息(区域名为昵称,选项名为data里的字段名以及密码)
        user_info['{}'.format(user['reg_name'])] = res['data']
        user_info['{}'.format(user['reg_name'])]['pwd'] = user['pwd']
    # 写入用户文件
    write_yaml.write_yaml(USER_FILE_DIR, user_info)
    # 断开数据库
    do_mysql.close()
    # 断开请求
    do_request.close()
Exemple #3
0
 def handle_para(cls, data):
     hl = HandleYaml(PHONE_PATH)
     hm = HandleMysql()
     if re.search(r'{no_exist_phone}', data):
         phone = hm.no_exsit_phone_mysql()
         re_data = re.sub(r'{no_exist_phone}', phone, data)
         HandleMysql().close()
         return re_data
     if re.search(r'{invest_phone}', data):
         re_data = re.sub(r'{invest_phone}',
                          hl.read_yaml('investor', 'mobile_phone'), data)
         return re_data
     if re.search(r'{user_id_re}', data):
         re_data = re.sub(r'{user_id_re}',
                          str(hl.read_yaml('investor', 'id')), data)
         return re_data
     if re.search(r'{member_id_re}', data):
         re_data = re.sub(r'{member_id_re}',
                          str(hl.read_yaml('borrower', 'id')), data)
         return re_data
     if re.search(r'{borrow_phone}', data):
         re_data = re.sub(r'{borrow_phone}',
                          hl.read_yaml('borrower', 'mobile_phone'), data)
         return re_data
     if re.search(r'{no_exist_num}', data):
         re_data = re.sub(
             r'{no_exist_num}',
             str(
                 hm.get_mysql_result(hy.read_yaml('mysql', 'id_sql'))
                 ['maxId'] + 1), data)
         return re_data
     if re.search(r'{admin_phone}', data):
         re_data = re.sub(r'{admin_phone}',
                          hl.read_yaml('admin', 'mobile_phone'), data)
         return re_data
     if re.search(r'{load_id}', data):
         re_data = re.sub(r'{load_id}', str(getattr(cls, 'program_id')),
                          data)
         return re_data
     if re.search(r'{user_id}', data):
         my_data = re.sub(r'{user_id}', str(hl.read_yaml('investor', 'id')),
                          data)
         re_data = re.sub(r'{loan_id_re}', str(getattr(cls, 'program_id')),
                          my_data)
         return re_data
     return data
Exemple #4
0
 def setUpClass(cls) -> None:  # setUpClass是unittest框架的方法,会被unittest框架自动调用
     """
     在当前类中所有实例方法执行之前会被调用一次
     重写父类的类方法
     :return:
     """
     cls.send_request = HandleRequest()
     cls.handle_mysql = HandleMysql()
     do_log.info("\n\n{:=^40s}".format("开始执行投资功能用例"))
Exemple #5
0
    def setUpClass(cls):
        # 构造请求参数
        cls.do_request = HandleRequest()  # 创建HandleRequest对象
        cls.do_request.add_headers(do_yaml.get_data(
            "api", "api_version"))  # 添加请求头到公共请求头

        cls.do_mysql = HandleMysql()  # 创建HandleMysql对象
        # cls.do_mysql.create_not_existed_mobile()
        do_log.info("开始执行用例")
Exemple #6
0
    def user_init(cls):
        # 获取请求头
        headers = {"X-Lemonban-Media-Type": "lemonban.v2"}
        # 创建请求对象
        do_request = HandleRequest()
        # 添加请求头
        do_request.add_headers(headers)
        # url
        url = 'http://api.lemonban.com/futureloan/member/register'

        # 创建初始三个用户,如果已经创建过则不用再创
        user = [{
            'mobile_phone': '',
            'pwd': '12345678',
            'type': 0,
            'reg_name': '管理员'
        }, {
            'mobile_phone': '',
            'pwd': '12345678',
            'type': 1,
            'reg_name': '借款人'
        }, {
            'mobile_phone': '',
            'pwd': '12345678',
            'type': 1,
            'reg_name': '投资人'
        }]

        do_yaml = HandleYaml(USER_ACCOUNTS_FILE_DIR)
        number = HandleMysql()
        new_user = {}
        for i in user:
            i["mobile_phone"] = number.create_not_existed_mobile()
            # 发起请求
            res = do_request.send(url=url, data=i).json()
            # 获取用户id
            new_user['{}'.format(i['reg_name'])] = res['data']
            new_user['{}'.format(i['reg_name'])]['pwd'] = i['pwd']
        # 写入配置文件
        do_yaml.write_yaml(USER_ACCOUNTS_FILE_DIR, new_user)
        # 关闭请求
        do_request.close()
        # 关闭数据库连接
        number.close()
Exemple #7
0
 def get_data(cls, data):
     hl = HandleYaml(PERSONPHONE_PATH)
     if re.search("{no_exist_phone}", data):
         hm = HandleMysql()
         result_value = re.sub("{no_exist_phone}", hm.get_no_exist_phone(),
                               data)
         hm.close()
         return result_value
     if re.search("{invest_phone}", data):
         result_value = re.sub("{invest_phone}",
                               hl.read_yaml('investor', 'mobile_phone'),
                               data)
         return result_value
     if re.search("{user_id_re}", data):
         result_value = re.sub("{user_id_re}",
                               str(hl.read_yaml('investor', 'id')), data)
         return result_value
     if re.search('{member_id_re}', data):
         result_value = re.sub("{member_id_re}",
                               str(hl.read_yaml('browser', 'id')), data)
         return result_value
     if re.search("{borrow_phone}", data):
         result_value = re.sub("{borrow_phone}",
                               hl.read_yaml('browser', 'mobile_phone'),
                               data)
         return result_value
     if re.search("{admin_phone}", data):
         result_value = re.sub("{admin_phone}",
                               hl.read_yaml('admin', 'mobile_phone'), data)
         return result_value
     if re.search("{load_id}", data):
         result_value = re.sub("{load_id}", str(getattr(cls, 'item_id')),
                               data)
         return result_value
     if re.search(r"{loan_id_re}", data):
         loan_id_str = str(getattr(HandleRe, 'verify_loan_id'))
         my_value = re.sub('{loan_id_re}', loan_id_str, data)
         result_value = re.sub(r"{user_id}",
                               str(hl.read_yaml('investor', 'id')),
                               my_value)
         return result_value
     return data
    def exists_mobile_replace(cls, data):
        """
        替换存在的手机号
        :param data:
        :return:
        """
        if re.search(cls.exists_mobile_pattern, data):
            mobile_phone = HandleMysql().get_exists_mobile()
            data = re.sub(cls.exists_mobile_pattern, mobile_phone, data)

        return data
Exemple #9
0
def create_user(reg_name, password=12345678, type=1):
    """
    创建用户并将用户信息,添加至全局数据池中
    :param reg_name: 用户昵称
    :param password: 用户密码,默认为12345678
    :param type: 用户类型,默认为1,普通用户
    :return:
    """
    do_request = HandleRequest()
    do_mysql = HandleMysql()

    # 获取未注册手机号
    mobile_phone = do_mysql.create_not_existed_mobile()
    # 构造请求参数
    param = {
        "mobile_phone": mobile_phone,
        "pwd": password,
        "reg_name": reg_name,
        "type": type
    }
    # 构造请求url路径
    url = "http://api.lemonban.com/futureloan/member/register"
    # 获取api头信息
    do_request.add_headers(do_yaml.get_data("api", "api_version"))

    # 进行注册
    res = do_request.send("POST", url, json=param)

    # sql = do_yaml.get_data("mysql", "select_user_sql")
    # do_mysql.get_values(sql, )
    # 从响应报文中获取用户id
    user_id = res.json()["data"]["id"]

    # 关闭相关连接
    do_request.close()
    do_mysql.close()

    # 将用户信息添加至全局数据池中
    setattr(GlobalData, "${" + reg_name + "_user_tel}", mobile_phone)
    setattr(GlobalData, "${" + reg_name + "_user_pwd}", password)
    setattr(GlobalData, "${" + reg_name + "_user_id}", user_id)
Exemple #10
0
    def setUpClass(cls):
        # 创建HandleRequest对象
        cls.do_request = HandleRequest()
        # 获取url版本请求头数据并添加至请求头中
        cls.do_request.add_headers(do_yaml.get_data("api", "api_version"))
        # 创建HandleMysql对象
        cls.do_mysql = HandleMysql()

        # 创建一个不存在的用户id,并加入到全局数据池中
        setattr(GlobalData, "${not_existed_id}", cls.do_mysql.get_not_existed_user_id())

        do_log.info("开始执行用例")
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()
Exemple #12
0
def create_new_user(regname, pwd='123456'):
    '''
        新建用户的封装类
    '''
    do_config = HandleConfig(CONFIG_REQUEST)
    do_request = HandleRequest()
    do_mysql = HandleMysql()
    register_url = do_config.get_value('url', 'register_url')
    sql = "SELECT Id FROM member WHERE MobilePhone = %s"
    while True:
        mobile = do_mysql.create_not_existed_mobile()
        data = {"regname": regname, "mobilephone": mobile, "pwd": pwd}
        do_request.send_request(url=register_url, data=data, method='post')
        result = do_mysql.do_execute(sql, args=(mobile, ))
        if result:
            user_id = result['Id']
            break

    user_dict = {
        regname: {
            "user_id": user_id,
            "mobile": mobile,
            "pwd": pwd,
            "regname": regname
        }
    }
    do_mysql.close()
    do_request.close_request()
    return user_dict
Exemple #13
0
 def get_phone(cls, username, password='******', type=1):
     hr = HandleRequest()
     hm = HandleMysql()
     base_url = hy.read_yaml('api', 'load')
     register_url = hy.read_yaml('api', 'register')
     all_url = ''.join((base_url, register_url))
     while True:
         phone = hm.get_non_existent()
         data = {
             "mobile_phone": phone,
             "pwd": password,
             "type": type,
             "reg_name": username
         }
         hr.common_head(hy.read_yaml('api', 'header'))
         result = hr.send(url=all_url, data=data)
         if result.json()['code'] == 0 and result.json()['msg'] == 'OK':
             break
     user_id = hm.get_mysql_result(sql=hy.read_yaml('mysql', 'user_id'),
                                   args=phone)
     result_data = {
         username: {
             "mobilephone": phone,
             "pwd": password,
             "user_id": user_id[0]['id'],
             "reg_name": username
         }
     }
     hr.close()
     hm.close()
     return result_data
Exemple #14
0
    def get_phone(cls, user, password="******", type_num=1):
        hr = HandleRequest()
        hm = HandleMysql()
        hr.common_head({'X-Lemonban-Media-Type': 'lemonban.v2'})
        base_url = hy.read_yaml('api', 'load')
        register_url = hy.read_yaml('api', 'register')
        all_url = ''.join((base_url, register_url))
        while True:
            # 获取在数据库中不存在的电话号码
            phone = hm.get_right_phone()
            data = {
                "mobile_phone": phone,
                "pwd": password,
                "type": type_num,
                "reg_name": user
            }
            result = hr.send(url=all_url, data=data)
            if result.json()['code'] == 0 and result.json()["msg"] == "OK":
                break

        my_result = hm.get_mysql_result(hy.read_yaml('mysql', 'user_id'),
                                        args=phone)
        user_id = my_result[0]['id']

        result_data = {
            user: {
                "user_phone": phone,
                "pwd": password,
                "user_id": user_id,
                "reg_name": user
            }
        }
        hm.close()
        hr.close()
        return result_data
Exemple #15
0
def create_new_user(regname, pwd='123456'):
	'''创建一个账户'''
	handle_mysql = HandleMysql()
	send_request = HttpRequest()
	url = do_config.get_value('api', 'prefix_url') + '/member/register'
	sql = 'select id from member where MobilePhone=%s;'
	while True:
		mobilephone = handle_mysql.create_not_existed_mobile()
		data = {'mobilephone':mobilephone, 'pwd':pwd, 'regname':regname}
		send_request.to_request(method='post',
								url=url,
								data=data)
		result = handle_mysql.to_run(sql=sql, args=(mobilephone,))
		if result:
			user_id = result['id']
			break

	user_dict = {
		regname: {
			'Id': user_id,
			'regname': regname,
			'mobilephone': mobilephone,
			'pwd': pwd
		}
	}
	handle_mysql.close()
	send_request.close()

	return user_dict
Exemple #16
0
    def loan_id_replace(cls, data):
        """
        替换参数化的loan_id
        :param data:
        :return:
        """
        # 替换存在的loan_id
        if re.search(cls.loan_id_pattern, data):
            # getattr(对象, 字符类型的属性名)
            # setattr(对象, 字符类型的属性名, 属性值)
            # 类似java中的反射概念
            loan_id = getattr(cls, "loan_id")
            data = re.sub(cls.loan_id_pattern, str(loan_id), data)

        # 替换不存在的loan_id
        if re.search(cls.not_existed_loan_id_pattern, data):
            handle_mysql = HandleMysql()
            sql = "SELECT MAX(Id) AS max_loan_id FROM loan;"  # 获取loan表中最大的Id,并重命名为max_loan_id
            cls.not_existed_loan_id = str(handle_mysql(sql)["max_loan_id"]+1000)
            data = re.sub(cls.not_existed_loan_id_pattern, cls.not_existed_loan_id, data)
            handle_mysql.close()

        return data
Exemple #17
0
def create_new_user(reg_name, pwd='12345678', type=1):
    """
    创建一个新用户
    :param reg_name:
    :param pwd:
    :param type:
    :return:
    """
    # 创建session会话对象,用来发起请求
    do_request = HandleRequest()
    # 创建mysql对象
    do_mysql = HandleMysql()
    # 添加公共请求头
    do_request.add_headers(do_yaml.read_yaml('api', 'version'))

    # 注册请求的url
    register_url = do_yaml.read_yaml('api', 'prefix') + '/member/register'
    while True:
        # 随机生成一个未注册的手机号
        mobile_phone = do_mysql.create_not_exsited_mobile()
        # 创建一个请求体参数
        data = {
            'mobile_phone': mobile_phone,
            'pwd': pwd,
            'type': type,
            'reg_name': reg_name
        }
        # 调用注册接口,发起请求
        do_request.send(register_url, data=data)

        # 查询数据库用户ID的sql,同时进行了数据校验
        sql = do_yaml.read_yaml('mysql', 'select_user_id_sql')
        # 查询数据库,获取用户ID
        result = do_mysql.run(sql, args=[mobile_phone], is_more=False)
        # 判断是否存在,如果result为None,则用户不存在,if语句为真,用户创建成功,跳出循环
        if result:
            user_id = result['id']
            break

    # 构建用户信息为嵌套字典的字典
    user_info = {
        reg_name: {
            'user_id': user_id,
            'mobile_phone': mobile_phone,
            'pwd': pwd,
            'reg_name': reg_name}
    }

    # 关闭mysql对象
    do_mysql.close()
    # 关闭session会话对象
    do_request.close()

    return user_info
Exemple #18
0
    def invest_user_id_replace(cls, data):
        """
        替换参数化的投资用户id
        :param data:
        :return:
        """
        do_config = HandleConfig(USER_ACCOUNTS_FILE_PATH)
        invest_user_id = do_config("invest_user", "id")
        if re.search(cls.invest_user_id_pattern, data):
            data = re.sub(cls.invest_user_id_pattern, str(invest_user_id), data)

        if re.search(cls.not_existed_invest_user_id_pattern, data):
            handle_mysql = HandleMysql()
            sql = "SELECT MAX(Id) AS max_id FROM member;"
            cls.not_existed_user_id = str(handle_mysql(sql)["Id"]+1000)
            data = re.sub(cls.not_existed_invest_user_id_pattern,
                          cls.not_existed_user_id,
                          data)
        return data
Exemple #19
0
def create_new_user(reg_name, pwd="aaa123", user_type=1):
    """
    创建一个用户
    :param reg_name: 用户名
    :param pwd: 密码
    :param user_type: 用户类型
    :return: 存储一个用户信息, 嵌套字典的字典(以用户名为key, 以用户信息所在字典为value)
    """
    # 建立连接
    do_mysql = HandleMysql()
    do_request = HandleRequest()
    # 添加公共请求头
    do_request.add_headers(do_yaml.read('api', 'version'))

    url = do_yaml.read('api', 'prefix') + '/member/register'
    sql = do_yaml.read('mysql', 'select_userid_sql')
    while True:
        mobile_phone = do_mysql.create_not_existed_mobile()
        data = {
            "mobile_phone": mobile_phone,
            "pwd": pwd,
            "reg_name": reg_name,
            "type": user_type
        }
        # 先注册接口发起请求
        do_request.send(url, data=data)

        # 查询数据库, 获取用户id
        result = do_mysql.run(sql=sql, args=(mobile_phone, ))
        if result:
            user_id = result["id"]
            break

    # 构造用户信息字典
    user_dict = {
        reg_name: {
            "id": user_id,
            "reg_name": reg_name,
            "mobile_phone": mobile_phone,
            "pwd": pwd
        }
    }

    # 关闭连接
    do_mysql.close()
    do_request.close()

    return user_dict
Exemple #20
0
def create_new_user(reg_name, pwd="12345678", user_type=1):
    '''
    创建用户
    reg_name:用户昵称
    pwd:密码
    user_type:用户类型
    返回一个用户信息,嵌套字典的字典,用户昵称为key,用户信息为value
    '''
    # 建立连接 后面要关闭连接
    do_mysql = HandleMysql()
    do_request = HandleRequest()
    # 添加公共请求头
    do_request.add_headers(do_yaml.read('api', 'version'))
    url = do_yaml.read('api', 'prefix') + '/member/register'
    sql = do_yaml.read(
        'api', 'select_user_id')  # 虽然响应报文中会返回用户ID,但是从数据库中取出,进一步数据校验了注册接口
    while True:  # 因为存在数据库中找不到手机号的可能,所以直接死循环创建一个未注册的手机号确保万无一失
        mobile_phone = do_mysql.create_not_existed_mobile()
        data = {
            "mobile_phone": mobile_phone,
            "pwd": pwd,
            "reg_name": reg_name,
            "type": user_type
        }
        # 向注册接口发起请求
        do_request.send(url, data=data)
        # 查询数据库,获取用户id
        result = do_mysql.run(sql=sql, args=(mobile_phone, ))
        if result:  # 如果查询结果不为空,则获取id
            user_id = result['id']
            break
        # 构造用户信息字典
    user_dict = {
        reg_name: {
            "id": user_id,
            "mobile_phone": mobile_phone,
            "pwd": pwd,
            "reg_name": reg_name,
        }
    }

    # 关闭连接
    do_request.close()
    do_mysql.close()
    return user_dict
    def not_existed_replace(cls, data):
        do_mysql = HandleMysql()
        # 不存在手机号的参数化
        if cls.not_existed_tel_pattern in data:  # 使用成员运算
            data = re.sub(cls.not_existed_tel_pattern, do_mysql.create_not_existed_mobile(), data)

        # 不存在的用户id替换
        if re.search(cls.not_existed_id_pattern, data):
            sql = "SELECT id FROM member ORDER BY id DESC limit 0, 1;"
            not_existed_id = do_mysql.run(sql).get('id') + 1  # 获取最 大的id加1
            data = re.sub(cls.not_existed_id_pattern, str(not_existed_id), data)

            # loan_id 替换
        if re.search(cls.loan_id_pattern, data):
            loan_id = getattr(cls, 'loan_id')
            data = re.sub(cls.loan_id_pattern, str(loan_id), data)
        do_mysql.close()
        return data
    def not_existed_replace(cls, data):
        cls.do_mysql = HandleMysql()
        # 不存在的手机号替换
        if cls.not_existed_phone_pattern in data:  # 这里成员运算效率较高
            data = re.sub(cls.not_existed_phone_pattern, \
                          cls.do_mysql.create_not_existed_mobile(), data)

        # 替换不存在的用户id
        if re.search(cls.not_existed_id, data):
            # 从数据库中取出最大id,然后加1即为不存在的id
            sql = "SELECT id FROM member ORDER BY id DESC LIMIT 0,1;"
            max_id = cls.do_mysql.run(sql)
            data = re.sub(cls.not_existed_id, str(max_id['id'] + 1), data)

        # 不存在的load_id替换
        if cls.not_existed_loan_id_pattern in data:
            sql = "SELECT id FROM loan ORDER BY id DESC LIMIT 0, 1;"
            not_existed_load_id = cls.do_mysql.run(sql).get(
                'id') + 1  # 获取最大的用户id + 1
            data = re.sub(cls.not_existed_loan_id_pattern,
                          str(not_existed_load_id), data)

        cls.do_mysql.close()
        return data
Exemple #23
0
def create_new_user(regname, pwd="123456"):
    """
    生成一个用户
    :param regname:
    :param pwd:
    :return:
    """
    handle_mysql = HandleMysql()
    handle_request = HandleRequest()

    url = cf.get_value("api", "prefix_url") + "/member/register"

    sql = "select Id from member where mobilephone=%s;"

    while True:
        mobile = handle_mysql.get_not_exists_mobile()

        data = {"mobilephone": mobile, "pwd": pwd, "regname": regname}

        handle_request.send_request("post", url, data)

        ret = handle_mysql.select(sql, args=(mobile, ))
        if ret:
            user_id = ret["Id"]
            break

    user_dict = {
        regname: {
            "Id": user_id,
            "regname": regname,
            "mobilephone": mobile,
            "pwd": pwd
        }
    }

    handle_mysql.close()
    handle_request.close()

    return user_dict
Exemple #24
0
    def to_param(cls, data):
        if re.search(cls.not_existed_tel_pattern, data):
            do_mysql = HandleMysql()
            data = re.sub(cls.not_existed_tel_pattern,
                          do_mysql.create_not_existed_mobile(), data)
            do_mysql.close()

        if re.search(cls.existed_tel_pattern, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.existed_tel_pattern,
                          cls.doyaml.read("investor", "mobile_phone"), data)

        if re.search(cls.existed_tel_pattern_pwd, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.existed_tel_pattern_pwd,
                          cls.doyaml.read("investor", "pwd"), data)

        if re.search(cls.error_user_pwd, data):
            do_mysql = HandleMysql()
            data = re.sub(cls.error_user_pwd,
                          do_mysql.create_not_existed_mobile(), data)
            do_mysql.close()

        if re.search(cls.invest_user_id, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.invest_user_id,
                          str(cls.doyaml.read("investor", "id")), data)

        if re.search(cls.invest_user_tel, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.invest_user_tel,
                          cls.doyaml.read("investor", "mobile_phone"), data)

        if re.search(cls.invest_user_pwd, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.invest_user_pwd,
                          cls.doyaml.read("investor", "pwd"), data)

        if re.search(cls.not_existed_id, data):
            do_mysql = HandleMysql()
            sql = "select max(id) from member;"
            max_id = do_mysql.run(sql)
            data = re.sub(cls.not_existed_id, str(max_id["max(id)"] + 1), data)
            do_mysql.close()

        if re.search(cls.borrow_user_id, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.borrow_user_id,
                          str(cls.doyaml.read("borrower", "id")), data)

        if re.search(cls.borrow_user_tel, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.borrow_user_tel,
                          cls.doyaml.read("borrower", "mobile_phone"), data)

        if re.search(cls.borrow_user_pwd, data):
            # doyaml = HandleYaml(CONFIGS_USER_FILE_PATH)
            data = re.sub(cls.borrow_user_pwd,
                          cls.doyaml.read("borrower", "pwd"), data)

        if re.search(cls.admin_user_tel, data):
            data = re.sub(cls.admin_user_tel,
                          cls.doyaml.read("admin", "mobile_phone"), data)

        if re.search(cls.admin_user_pwd, data):
            data = re.sub(cls.admin_user_pwd, cls.doyaml.read("admin", "pwd"),
                          data)

        if re.search(cls.loan_id_pattern, data):
            # loan_id = getattr(Parameterize ,"loan_id")
            loan_id = getattr(cls, "loan_id")
            data = re.sub(cls.loan_id_pattern, str(loan_id), data)

        if re.search(cls.not_existed_loan_id, data):
            loan_id = getattr(cls, "loan_id")
            data = re.sub(cls.not_existed_loan_id, str(loan_id + 1), data)

        return data
 def setUpClass(cls):
     cls.handle_mysql = HandleMysql()
     do_logger.debug('{}'.format('开始执行投资接口用例。。。。'))
Exemple #26
0
 def setUpClass(cls):
     cls.do_mysql = HandleMysql()
     cls.one_file = open(REPORTS_ALL_PATH, mode='a+', encoding='utf-8')
     cls.one_file.write('{:=^40s}\n'.format('开始执行投资接口用例'))
    def setUpClass(cls):
        cls.do_request = HandleRequest()
        cls.do_request.add_headers(do_yaml.read('api', 'version'))

        cls.do_mysql = HandleMysql()
Exemple #28
0
 def setUpClass(cls) -> None:
     cls.request = HandleRequest()
     cls.handler_mysql = HandleMysql()
     logger.debug("\n{:=^40s}".format("开始执行测试"))
Exemple #29
0
 def setUpClass(cls):
     cls.do_requests = HandleRequests()
     cls.do_requests.add_headers(do_yaml.read_yaml('api', 'version'))
     # 创建数据库处理对象
     cls.do_mysql = HandleMysql()
Exemple #30
0
 def setUpClass(cls):
     cls.do_request = HandleRequest()
     api_version = do_yaml.read("api", "version")
     cls.do_request.add_headers(api_version)
     cls.do_mysql = HandleMysql()