def write_result(self, row, actual, result):
wb, ws = self.load_excel()
if isinstance(row, int) and (2 <= row <= ws.max_row):
ws.cell(row=row, column=do_config.get_int('excel', 'actual_col'), value=actual)
ws.cell(row=row, column=do_config.get_int('excel', 'result_col'), value=result)
wb.save(self.filename)
wb.close()
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
@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的结果为字典类型 ) # 创建游标 cursor = conn.cursor()