99 lines
7.5 KiB
Python
99 lines
7.5 KiB
Python
|
#!/usr/bin/env python3
|
|||
|
|
"""
|
|||
|
|
调试报告生成过程，找出卡住的具体位置
|
|||
|
|
"""
|
|||
|
|
|
|||
|
|
import json
|
|||
|
|
import sys
|
|||
|
|
from pathlib import Path
|
|||
|
|
|
|||
|
|
def analyze_script_data():
|
|||
|
|
"""分析脚本返回的数据结构"""
|
|||
|
|
script_data_json = '''{"tables": [{"token": "scriptTable1", "startRow": 0, "startCol": 0, "cells": [{"row": 4, "col": 0, "value": ""}, {"row": 4, "col": 1, "value": ""}, {"row": 4, "col": 2, "value": ""}, {"row": 4, "col": 3, "value": ""}, {"row": 4, "col": 4, "value": ""}, {"row": 4, "col": 5, "value": ""}, {"row": 4, "col": 6, "value": ""}, {"row": 5, "col": 0, "value": ""}, {"row": 5, "col": 1, "value": ""}, {"row": 5, "col": 2, "value": ""}, {"row": 5, "col": 3, "value": ""}, {"row": 5, "col": 4, "value": ""}, {"row": 5, "col": 5, "value": ""}, {"row": 5, "col": 6, "value": ""}, {"row": 6, "col": 0, "value": ""}, {"row": 6, "col": 1, "value": ""}, {"row": 6, "col": 2, "value": ""}, {"row": 6, "col": 3, "value": ""}, {"row": 6, "col": 4, "value": ""}, {"row": 6, "col": 5, "value": ""}, {"row": 6, "col": 6, "value": ""}, {"row": 7, "col": 0, "value": ""}, {"row": 7, "col": 1, "value": ""}, {"row": 7, "col": 2, "value": ""}, {"row": 7, "col": 3, "value": ""}, {"row": 7, "col": 4, "value": ""}, {"row": 7, "col": 5, "value": ""}, {"row": 7, "col": 6, "value": ""}, {"row": 8, "col": 0, "value": ""}, {"row": 8, "col": 1, "value": ""}, {"row": 8, "col": 2, "value": ""}, {"row": 8, "col": 3, "value": ""}, {"row": 8, "col": 4, "value": ""}, {"row": 8, "col": 5, "value": ""}, {"row": 8, "col": 6, "value": ""}, {"row": 9, "col": 0, "value": ""}, {"row": 9, "col": 1, "value": ""}, {"row": 9, "col": 2, "value": ""}, {"row": 9, "col": 3, "value": ""}, {"row": 9, "col": 4, "value": ""}, {"row": 9, "col": 5, "value": ""}, {"row": 9, "col": 6, "value": ""}, {"row": 10, "col": 0, "value": ""}, {"row": 10, "col": 1, "value": ""}, {"row": 10, "col": 2, "value": ""}, {"row": 10, "col": 3, "value": ""}, {"row": 10, "col": 4, "value": ""}, {"row": 10, "col": 5, "value": ""}, {"row": 10, "col": 6, "value": ""}, {"row": 11, "col": 0, "value": ""}, {"row": 11, "col": 1, "value": ""}, {"row": 11, "col": 2, "value": ""}, {"row": 11, "col": 3, "value": ""}, {"row": 11, "col": 4, "value": ""}, {"row": 11, "col": 5, "value": ""}, {"row": 11, "col": 6, "value": ""}, {"row": 12, "col": 0, "value": ""}, {"row": 12, "col": 1, "value": ""}, {"row": 12, "col": 2, "value": ""}, {"row": 12, "col": 3, "value": ""}, {"row": 12, "col": 4, "value": ""}, {"row": 12, "col": 5, "value": ""}, {"row": 12, "col": 6, "value": ""}, {"row": 13, "col": 0, "value": ""}, {"row": 13, "col": 1, "value": ""}, {"row": 13, "col": 2, "value": ""}, {"row": 13, "col": 3, "value": ""}, {"row": 13, "col": 4, "value": ""}, {"row": 13, "col": 5, "value": ""}, {"row": 13, "col": 6, "value": ""}, {"row": 14, "col": 0, "value": ""}, {"row": 14, "col": 1, "value": ""}, {"row": 14, "col": 2, "value": ""}, {"row": 14, "col": 3, "value": ""}, {"row": 14, "col": 4, "value": ""}, {"row": 14, "col": 5, "value": ""}, {"row": 14, "col": 6, "value": ""}, {"row": 15, "col": 0, "value": ""}, {"row": 15, "col": 1, "value": ""}, {"row": 15, "col": 2, "value": ""}, {"row": 15, "col": 3, "value": ""}, {"row": 15, "col": 4, "value": ""}, {"row": 15, "col": 5, "value": ""}, {"row": 15, "col": 6, "value": ""}, {"row": 16, "col": 0, "value": ""}, {"row": 16, "col": 1, "value": ""}, {"row": 16, "col": 2, "value": ""}, {"row": 16, "col": 3, "value": ""}, {"row": 16, "col": 4, "value": ""}, {"row": 16, "col": 5, "value": ""}, {"row": 16, "col": 6, "value": ""}, {"row": 17, "col": 0, "value": ""}, {"row": 17, "col": 1, "value": ""}, {"row": 17, "col": 2, "value": ""}, {"row": 17, "col": 3, "value": ""}, {"row": 17, "col": 4, "value": ""}, {"row": 17, "col": 5, "value": ""}, {"row": 17, "col": 6, "value": ""}, {"row": 18, "col": 0, "value": ""}, {"row": 18, "col": 1, "value": ""}, {"row": 18, "col": 2, "value": ""}, {"row": 18, "col": 3, "value": ""}, {"row": 18, "col": 4, "value": ""}, {"row": 18, "col": 5, "value": ""}, {"row": 18, "col": 6, "value": ""}, {"row": 19, "col": 0, "value": ""}, {"row": 19, "col": 1, "value": ""}, {"row": 19, "col": 2, "value": ""}, {"row": 19, "col": 3, "value": ""}, {"row": 19, "col": 4, "value": ""}, {"row": 19, "col": 5, "value": ""}, {"row": 19, "col": 6, "value": ""}, {
|
|||
|
|
|
|||
|
|
data = json.loads(script_data_json)
|
|||
|
|
|
|||
|
|
print("=== 脚本数据分析 ===")
|
|||
|
|
print(f"数据结构: {type(data)}")
|
|||
|
|
if "tables" in data:
|
|||
|
|
print(f"表格数量: {len(data['tables'])}")
|
|||
|
|
for i, table in enumerate(data["tables"]):
|
|||
|
|
print(f"\n表格 {i+1}:")
|
|||
|
|
print(f" token: {table.get('token')}")
|
|||
|
|
print(f" startRow: {table.get('startRow')}")
|
|||
|
|
print(f" startCol: {table.get('startCol')}")
|
|||
|
|
print(f" cells数量: {len(table.get('cells', []))}")
|
|||
|
|
|
|||
|
|
cells = table.get('cells', [])
|
|||
|
|
|
|||
|
|
# 统计单元格类型
|
|||
|
|
empty_cells = 0
|
|||
|
|
null_cells = 0
|
|||
|
|
valid_cells = 0
|
|||
|
|
|
|||
|
|
for cell in cells:
|
|||
|
|
value = cell.get('value')
|
|||
|
|
if value is None:
|
|||
|
|
null_cells += 1
|
|||
|
|
print(f" NULL单元格: row={cell.get('row')}, col={cell.get('col')}")
|
|||
|
|
elif str(value).strip() == "":
|
|||
|
|
empty_cells += 1
|
|||
|
|
else:
|
|||
|
|
valid_cells += 1
|
|||
|
|
print(f" 有效单元格: row={cell.get('row')}, col={cell.get('col')}, value='{value}'")
|
|||
|
|
|
|||
|
|
print(f" 统计: 有效={valid_cells}, 空白={empty_cells}, NULL={null_cells}")
|
|||
|
|
|
|||
|
|
# 检查行列范围
|
|||
|
|
if cells:
|
|||
|
|
max_row = max(cell.get('row', 0) for cell in cells)
|
|||
|
|
max_col = max(cell.get('col', 0) for cell in cells)
|
|||
|
|
print(f" 范围: 最大行={max_row}, 最大列={max_col}")
|
|||
|
|
|
|||
|
|
def check_potential_issues():
|
|||
|
|
"""检查可能导致卡住的问题"""
|
|||
|
|
print("\n=== 潜在问题检查 ===")
|
|||
|
|
|
|||
|
|
issues = []
|
|||
|
|
|
|||
|
|
# 1. NULL值问题
|
|||
|
|
issues.append("1. 存在NULL值的单元格，可能导致Word COM操作异常")
|
|||
|
|
|
|||
|
|
# 2. 大量空单元格
|
|||
|
|
issues.append("2. 存在大量空单元格（119个），可能导致处理缓慢")
|
|||
|
|
|
|||
|
|
# 3. 行列索引问题
|
|||
|
|
issues.append("3. 单元格行索引从0-20，可能超出模板表格范围")
|
|||
|
|
|
|||
|
|
# 4. Word COM性能问题
|
|||
|
|
issues.append("4. Word COM操作可能因为大量单元格操作而卡住")
|
|||
|
|
|
|||
|
|
for issue in issues:
|
|||
|
|
print(f" {issue}")
|
|||
|
|
|
|||
|
|
def suggest_solutions():
|
|||
|
|
"""建议解决方案"""
|
|||
|
|
print("\n=== 建议解决方案 ===")
|
|||
|
|
|
|||
|
|
solutions = [
|
|||
|
|
"1. 修复temperature_table.py中的NULL值问题",
|
|||
|
|
"2. 过滤掉空白单元格，只处理有数据的单元格",
|
|||
|
|
"3. 添加更多调试日志到report_generator.py",
|
|||
|
|
"4. 增加Word COM操作的超时和错误处理",
|
|||
|
|
"5. 考虑批量操作而不是逐个单元格操作"
|
|||
|
|
]
|
|||
|
|
|
|||
|
|
for solution in solutions:
|
|||
|
|
print(f" {solution}")
|
|||
|
|
|
|||
|
|
def main():
|
|||
|
|
print("调试报告生成卡住问题")
|
|||
|
|
print("=" * 50)
|
|||
|
|
|
|||
|
|
analyze_script_data()
|
|||
|
|
check_potential_issues()
|
|||
|
|
suggest_solutions()
|
|||
|
|
|
|||
|
|
if __name__ == "__main__":
|
|||
|
|
main()
|