测试策略最佳实践

单元测试

import pytest
from symphra_excel import Workbook

def test_create_workbook():
    wb = Workbook()
    assert wb is not None

def test_create_worksheet():
    wb = Workbook()
    sheet = wb.create_worksheet("测试")
    assert sheet.title == "测试"

集成测试

def test_full_workflow():
    with Workbook() as wb:
        sheet = wb.create_worksheet("数据")
        sheet.set_cell_value("A1", "测试")
        wb.save("test_output.xlsx")

    assert os.path.exists("test_output.xlsx")

性能测试

import time

def test_performance():
    start = time.time()

    with Workbook() as wb:
        sheet = wb.create_worksheet("性能测试")
        for row in range(10000):
            sheet.set_cell_value(f"A{row}", row)
        wb.save("perf_test.xlsx")

    duration = time.time() - start
    assert duration < 10

相关文档

• 测试指南