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的结果为字典类型
