def __init__(self): self.conn = pymysql.connect( host=do_config.get_value('mysql', 'host'), user=do_config.get_value('mysql', 'user'), password=do_config.get_value('mysql', 'password'), db=do_config.get_value('mysql', 'db'), port=do_config.get_int('mysql', 'port'), charset=do_config.get_value('mysql', 'charset'), cursorclass=pymysql.cursors.DictCursor) self.cursor = self.conn.cursor()
def excel_suite1(): not_existed_tel = do_mysql.not_existed_tel( do_config.get_value('mysql', 'not_existed_tel')) register_excel = HandleExcel(do_config.get_value('file path', 'case_path'), 'login') register_excel_cases = register_excel.get_case() register_excel_re = re.sub(r'\${not_existed_tel}', not_existed_tel, str(register_excel_cases)) existed_tel = do_mysql.existed_tel( do_config.get_value('mysql', 'existed_tel'), do_config.get_int('mysql', 'existed_tel_type')) register_cases = re.sub(r'\${existed_tel}', existed_tel, str(register_excel_re)) register_cases = eval(register_cases) wb, ws = register_excel.load_excel() wb.close() return register_cases
def test_register(self, case_list): self.my_HandleExcel = HandleExcel(file, 'register') request_result = do_request.send_request( case_list['method'], do_config.get_value('request', 'default_address') + case_list['url_path'], case_list['data']) actual_text = request_result.text actual_value = json.loads(actual_text)['code'] actual = 'code: "{}",'.format(actual_value) result = case_list['expected'] msg = case_list['title'] try: self.assertEqual(result, actual, msg) print('{},执行结果为:{}'.format(msg, true_result)) self.my_HandleExcel.write_result(case_list['case_id'] + 1, actual, true_result) do_logger.error("{}, 执行结果为: {}".format(msg, true_result)) except AssertionError as e: print('具体异常为{}'.format(e)) self.my_HandleExcel.write_result(case_list['case_id'] + 1, actual, fail_result) do_logger.error("{}, 执行结果为: {},具体异常为{}".format( msg, fail_result, e)) raise e
do_request = HttpRequest() if __name__ == '__main__': # url = 'http://test.lemonban.com:8080/futureloan/mvc/api/member/register' # params = { # 'mobilephone': 13798288888, # 'pwd': 123456, # 'regname': '刀刀' # } # my_httprequest = HttpRequest() # my_httprequest.send_request(method='GET', url=url, data=params) case_list = { 'case_id': 1, 'title': '使用不存在的手机号进行注册', 'url_path': '/member/register', 'data': '{"mobilephone": "13786245301", "pwd": 123456, "regname": "刀刀"}', 'method': 'POST', 'expected': 'code: "10001",', 'actual': None, 'result': None } actual = do_request.send_request( method=case_list['method'], url=do_config.get_value('request', 'default_address') + case_list['url_path'], data=eval(case_list['data']))
#!/usr/bin/env python # coding=UTF-8 """ @Author: Jomer @Contact: [email protected] @Project: Jomer @File: test_cw0629_log.py @Time: 2019-07-05 00:11 @Desc: Jungle old monster """ import logging from interface_automation.class_0709_mysql.cw_0709_config import do_config logger_name = do_config.get_value('log', 'logger_name') logger_level = do_config.get_value('log', 'logger_level') log_filename = do_config.get_value('log', 'log_filename') console_leves = do_config.get_value('log', 'console_leves') file_level = do_config.get_value('log', 'file_level') simple_formatter_confing = do_config.get_value('log', 'simple_formatter') verbose_formatter_config = do_config.get_value('log', 'verbose_formatter') class HandleLog: def __init__(self): self.case_logger = logging.getLogger(logger_name) self.case_logger.setLevel(logger_level) console_handle = logging.StreamHandler() file_handle = logging.FileHandler(log_filename, encoding='utf-8')
# register_cases = re.sub(r'\${existed_tel}', existed_tel, str(register_excel_re)) # # register_cases = list(register_cases) # wb, ws = register_excel.load_excel() # wb.close() # # return register_cases # # # cases_list = splice() # cases_list = eval(cases_list) case_list = {'case_id': 1, 'title': '使用不存在的手机号进行注册', 'url_path': '/member/register', 'data': '{"mobilephone": "13786245301", "pwd": 123456, "regname": "刀刀"}', 'method': 'POST', 'expected': 'code: "10001",', 'actual': None, 'result': None} # print(type(case_list),case_list) method = case_list['method'] url = do_config.get_value('request', 'default_address') + case_list['url_path'] datas = case_list['data'] datas = eval(datas) # actual = do_request.send_request(case_list['method'], # do_config.get_value('request', 'default_address') + case_list['url_path'], # eval(case_list['data'])) print(type(method), method) print(type(url), url) print(type(datas), datas) # print(actual) request_result = do_request.send_request(case_list['method'], do_config.get_value('request', 'default_address') + case_list['url_path'],
@Desc: Jungle old monster """ import json import re import unittest from ddt import ddt, data from interface_automation.class_0709_mysql.cw_0709_config import do_config from interface_automation.class_0709_mysql.cw_0709_excel import HandleExcel from interface_automation.class_0709_mysql.cw_0709_log import do_logger from interface_automation.class_0709_mysql.cw_0709_mysql import do_mysql from interface_automation.class_0709_mysql.cw_0709_request import do_request # file = config['file path']['case_path'] file = do_config.get_value('file path', 'case_path') true_result = do_config.get_value('msg', 'true_result') fail_result = do_config.get_value('msg', 'fail_result') def excel_suite(): not_existed_tel = do_mysql.not_existed_tel( do_config.get_value('mysql', 'not_existed_tel')) register_excel = HandleExcel(do_config.get_value('file path', 'case_path'), 'register') register_excel_cases = register_excel.get_case() register_excel_re = re.sub(r'\${not_existed_tel}', not_existed_tel, str(register_excel_cases)) existed_tel = do_mysql.existed_tel( do_config.get_value('mysql', 'existed_tel'), do_config.get_int('mysql', 'existed_tel_type'))
#!/usr/bin/env python # coding=UTF-8 """ @Author: Jomer @Contact: [email protected] @Project: Jomer @File: cw_0709_mysql.py @Time: 2019-07-11 00:26 @Desc: Jungle old monster """ import pymysql from interface_automation.class_0709_mysql.cw_0709_config import do_config host = do_config.get_value('mysql', 'host') user = do_config.get_value('mysql', 'user') password = do_config.get_value('mysql', 'password') db = do_config.get_value('mysql', 'db') port = do_config.get_int('mysql', 'port') charset = do_config.get_value('mysql', 'charset') # 链接数据库 conn = pymysql.connect( host=host, user=user, password=password, db=db, port=port, charset=charset, # 编码只能写utf8 cursorclass=pymysql.cursors.DictCursor # 执行SQL的结果为字典类型