Files

207 lines
8.7 KiB
Python

#!/usr/bin/env python3
"""Сводная матрица v2: метрические единицы, больше атрибутов, вкладка совместимости.
Изменения:
- единицы приводятся к метрическим (ft->m, in->mm, lb->kg, °F->°C)
- добавлены габариты, питание, напряжение
- отдельная вкладка «Совместимость» (882 ребра из матрицы Yealink)
"""
import glob
import os
import re
import sys
SRC = os.environ.get("DS_BASE", "/opt/work-hub/datasheets-src/Datasheet/Yealink")
OUT = "/opt/work-hub/compat"
# ── конвертация в метрическую систему ───────────────────────────────
CONV = {
"ft": ("m", 0.3048), "feet": ("m", 0.3048), "foot": ("m", 0.3048),
"in": ("mm", 25.4), "inch": ("mm", 25.4), "inches": ("mm", 25.4),
"lb": ("kg", 0.453592), "lbs": ("kg", 0.453592), "pound": ("kg", 0.453592),
}
def to_metric(value, unit):
u = unit.lower().strip(".")
if u in CONV:
new_u, k = CONV[u]
return round(value * k, 2), new_u
return value, unit
def strip_marks(t):
"""Убирает √/×/• из начала заметки."""
return re.sub(r"^[\u221a\u2713\u2714\u00d7\u2717\u2718\u2022\s]+", "",
str(t or "")).strip()
def metric_pair(text):
"""Ищет '10ft (3m)' -> берёт метрическое; '10ft' -> переводит."""
m = re.search(r"(\d+(?:\.\d+)?)\s*(ft|feet|in|inch|inches|lb|lbs)\b"
r"(?:\s*\((\d+(?:\.\d+)?)\s*(mm|cm|m|kg)\))?", text, re.I)
if not m:
return None
val, unit = float(m.group(1)), m.group(2)
if m.group(3): # есть метрический эквивалент в скобках — берём его
v = float(m.group(3))
u = m.group(4)
return (round(v * 100, 1) if u == "m" else round(v, 1)), ("mm" if u == "m" else u)
return to_metric(val, unit)
# ── дополнительные атрибуты ────────────────────────────────────────
EXTRA = {
"physical.width_mm": ("Физика", "Ширина", "мм", "number",
[r"(?:width|dimension)[:\s]*(\d+(?:\.\d+)?)\s*mm",
r"(\d+(?:\.\d+)?)\s*x\s*\d+(?:\.\d+)?\s*x\s*\d+(?:\.\d+)?\s*mm"]),
"physical.height_mm": ("Физика", "Высота", "мм", "number",
[r"height[:\s]*(\d+(?:\.\d+)?)\s*mm"]),
"physical.weight_kg": ("Физика", "Вес", "кг", "number",
[r"weight[:\s]*(\d+(?:\.\d+)?)\s*(?:kg|g)\b"]),
"power.consumption_w": ("Питание", "Потребление", "Вт", "number",
[r"power\s*consumption[:\s]*(\d+(?:\.\d+)?)\s*W",
r"(\d+(?:\.\d+)?)\s*W\s*(?:max|typical)"]),
"power.poe_class": ("Питание", "PoE-класс", "—", "text",
[r"(802\.3(?:af|at|bt))"]),
}
def main():
import yaml
import openpyxl
from openpyxl.styles import Font, PatternFill
# реестр атрибутов (из build_attributes2)
sys.path.insert(0, "/root/buryan-infra/ops/work/tools")
from build_attributes2 import ATTRS, PLAUSIBLE, load_datasheets
all_attrs = dict(ATTRS)
all_attrs.update(EXTRA)
ds = load_datasheets()
print("даташитов:", len(ds))
vals = {}
for model, lines in ds.items():
name = re.sub(r"\s*\(\d+\)?\s*$", "", model).strip()
blob = "\n".join(lines)
got = {}
for aid, (g, n, u, typ, pats) in all_attrs.items():
for pat in pats:
m = re.search(pat, blob, re.I)
if not m:
continue
if typ == "bool":
got[aid] = True
elif typ == "number":
try:
v = float(m.group(1))
except (ValueError, IndexError):
continue
if aid == "physical.weight_kg" and "weight" in pat.lower():
# если в граммах — переводим
if re.search(r"weight[:\s]*\d+(?:\.\d+)?\s*g\b", blob, re.I) and v > 50:
v = round(v / 1000, 2)
lo, hi = PLAUSIBLE.get(aid, (0, 1e9))
if aid.startswith("physical.") and aid != "physical.temp_min":
lo, hi = (1, 5000)
if not (lo <= v <= hi):
continue
got[aid] = v
else:
got[aid] = m.group(1) if m.groups() else m.group(0)
break
# метрические значения из пар «ft (m)»
for key, pat in (("audio.pickup_m", r"pickup"), ("physical.weight_kg", r"weight")):
mp = metric_pair(blob)
if mp and key not in got:
v, u = mp
if key == "audio.pickup_m" and u == "m":
got[key] = round(v / 1000, 2) if v > 100 else v
if got:
if name in vals:
for k, v in got.items():
vals[name].setdefault(k, v)
else:
vals[name] = got
keep = {d: v for d, v in vals.items() if len(v) >= 2}
print("устройств в матрице:", len(keep), "| атрибутов:", len(all_attrs))
# ── XLSX ──
wb = openpyxl.Workbook()
hdr_fill = PatternFill("solid", fgColor="1F4E78")
hdr_font = Font(color="FFFFFF", bold=True)
def head(ws, row):
ws.append(row)
for c in ws[1]:
c.fill = hdr_fill
c.font = hdr_font
ws.freeze_panes = "B2"
for col in ws.columns:
ws.column_dimensions[col[0].column_letter].width = 20
ws = wb.active
ws.title = "Сводка"
head(ws, ["Устройство"] + [a[1] for a in all_attrs.values()] + ["Заполнено"])
for d in sorted(keep):
ws.append([d] + [keep[d].get(a, "") for a in all_attrs] + [len(keep[d])])
groups = {}
for aid, (g, n, u, t, _) in all_attrs.items():
groups.setdefault(g, []).append(aid)
for g in ["Камера", "Аудио", "Сеть", "Интерфейсы", "Физика", "Питание"]:
aids = groups.get(g) or []
if not aids:
continue
w = wb.create_sheet(g)
head(w, ["Устройство"] + ["%s, %s" % (all_attrs[a][1], all_attrs[a][2])
if all_attrs[a][2] != "—" else all_attrs[a][1]
for a in aids])
for d in sorted(keep):
w.append([d] + [keep[d].get(a, "") for a in aids])
# ── вкладка совместимости ──
wc = wb.create_sheet("Совместимость")
head(wc, ["Хост", "Аксессуар", "Поддержка", "Макс. кол-во", "Условие", "Пригодно"])
n_edges = 0
# источник 2: rooms-accessories-compatibility-lists (A40/A50 и др.)
ab = os.path.join(OUT, "accessories_by_host.yaml")
if os.path.exists(ab):
d2 = yaml.safe_load(open(ab, encoding="utf-8")) or {}
for e in d2.get("edges") or []:
wc.append([e.get("host"), e.get("item"),
"да" if e.get("supported") else "нет",
e.get("max_qty") or "",
strip_marks(e.get("condition"))[:120],
"да"])
n_edges += 1
for f in sorted(glob.glob(os.path.join(OUT, "matrix", "*.yaml"))):
if os.path.basename(f).startswith("_"):
continue
c = (yaml.safe_load(open(f, encoding="utf-8")) or {}).get("compatibility") or {}
host = c.get("device")
for a in c.get("accessories") or []:
wc.append([host, a.get("model"),
"да" if a.get("supported") else "нет",
a.get("max_qty") or "",
strip_marks(a.get("note"))[:120],
"да" if a.get("usable", True) else "КОНФЛИКТ"])
n_edges += 1
print("рёбер совместимости на вкладке:", n_edges)
wsrc = wb.create_sheet("Источники")
head(wsrc, ["Устройство", "Источник", "Значений"])
for d in sorted(keep):
wsrc.append([d, "Work/Datasheet/Yealink/*.pdf (pdfplumber)", len(keep[d])])
path = os.path.join(OUT, "yealink-attributes-matrix.xlsx")
wb.save(path)
print("XLSX:", path)
print("листы:", wb.sheetnames)
return 0
if __name__ == "__main__":
sys.exit(main())