Excel表格case编写
"""
课程回顾:
日志处理:
from loguru import logger
logger.add(sink= '项目日志.log', encoding='utf-8',level='INFO',rotation='10 B')-超出后重新创建.log文件;文件隔离
logger.add(sink= '项目日志.log', encoding='utf-8',level='INFO',rotation='1 week')-1个星期创建一次;文件隔离
"""
import logging
logging.basicConfig(level="INFO")
logging.info("这是标准日志")
logging.warning("这是警告日志")
logging.error("这是错误日志")
"""
1、日志收集器logger
2、日志收集器级别level
3、日志处理器准备handler
4、日志处理器级别设置
5、设置日志格式format
6、添加日志处理器
"""
logger = logging.getLogger("py53")
logger.setLevel("INFO")
handler = logging.StreamHandler()
handler.setLevel("INFO")
logger.addHandler(handler)
file_handler = logging.FileHandler(filename= '项目日志.log', encoding='utf-8')
file_handler.setLevel("DEBUG")
logger.addHandler(file_handler)
fmt = logging.Formatter("%(asctime)s" | "%(levelname)s" |"%(filename)s:%(lineno)d"- "%(message)s" )
handler.setFormatter(fmt)
file_handler.setFormatter(fmt)
logger.info("这是标准日志")
logger.warning("这是警告日志")
logger.error("这是错误日志")
import logging
def get_logger(name="root",level="INFO", filename=None,
form="%(asctime)s" | "%(levelname)s" |"%(filename)s:%(lineno)d"- "%(message)s"):
logger = logging.getLogger(root)
logger.setLevel(level)
handler = logging.StreamHandler()
handler.setLevel(level)
logger.addHandler(handler)
fmt = logging.Formatter(from )
handler.setFormatter(fmt)
if filename != None:
file_handler = logging.FileHandler(filename = filename, encoding='utf-8')
file_handler.setLevel(level)
logger.addHandler(file_handler)
file_handler.setFormatter(fmt)
fmt = logging.Formatter(from )
handler.setFormatter(fmt)
return logger
from py-53.day15_excel操作 d3_logging封装 import get_logger
logger = get_logger()
print(logger)
excel操作:
- Excel /CSV
- coding
- xmind
- 飞书文档
"""
手工测试用例 ----> 自动化测试
# 代码操作 Excel
- openpyxl
- xlrd
- pandas
# 创建一条用例:case.xlsx
格式:sheet 表格改名字:比如登录login
id title data expectd
1 失败 a 通过
2 失败 b 通过
3 成功 c 不通过
# 安装openpyxl
pip install openpyxl
"""
import openpyxl
from openpyxl.worksheet.worksheet import Worksheet
workbook = openpyxl.load_workbook("case.xlsx")
sheet:Worksheet = workbook.['login']
print(sheet)
cell = sheet.cell(row=2, column=3)
print(cell)
values = sheet.values()
rows = sheet.values
for row in rows:
print(row)
print(list(rows[1:3])
import openpyxl
from openpyxl.worksheet.worksheet import Worksheet
def read_excel(file, sheet_name="sheet1"):
"""读取excel"""
workbook = openpyxl.load_workbook(file)
sheet:Worksheet = workbook.[sheet_name]
cell = sheet.cell(row=2, column=3)
values = sheet.values()
rows = sheet.values
for row in rows:
print(row)
rows = list(rows[1:]
print(rows)
return rows
print(read_excel(case.xlsx))
def read_excel_dict(file, sheet_name="sheet1"):
"""读取excel"""
workbook = openpyxl.load_workbook(file)
sheet:Worksheet = workbook.[sheet_name]
data = sheet.values()
title = data[0]
rows = data[1:]
print(title)
data = [daict(zip(title,row)) for row in rows]
data = []
return data
print(read_excel_dict('case.xlsx'))