#!/usr/bin/sh
source .venv/bin/activate

path=$1
python -c "
from bom_assistant.ingestion.parser import parse_bom
from bom_assistant.ingestion.column_mapper import map_columns
from bom_assistant.ingestion.normalizer import normalize
import pathlib, json

f = pathlib.Path('$path')
raw = parse_bom(f.read_bytes(), f.name)
mapped = map_columns(raw)
rows = normalize(mapped)

for r in rows:
    p = r.normalized_params
    print(f'{r.state.value:8} [{r.category.value:10}] {str(r.designators):30} val={p.value_str!r:10} pkg={p.package!r} V={p.voltage_rating}')
"