86 lines
2.4 KiB
Markdown
86 lines
2.4 KiB
Markdown
# Copper DAC Reach Details And API Semantics
|
|
|
|
Date: 2026-05-09
|
|
Actor: Codex
|
|
Scope: Copper/DAC/Twinax rows, ATGBICS parser, comparable-product API
|
|
Mode: DB-only correction plus tiny API/scraper deploy
|
|
|
|
## Why
|
|
|
|
Many remaining highspeed "missing wavelength" and detail gaps were not optical transceiver gaps. They were Copper/DAC/Twinax cable rows. These products do not have optical wavelengths and should be represented with `wavelengths=N/A`, concrete cable length, and cable category.
|
|
|
|
## DB Correction
|
|
|
|
Precheck:
|
|
|
|
- Copper rows missing reach label: `464`
|
|
- Copper rows missing reach meters: `467`
|
|
- Copper rows missing details: `498`
|
|
|
|
Found deterministic length evidence in part number or product URL for `342` rows.
|
|
|
|
Updated those rows:
|
|
|
|
- `reach_label`
|
|
- `reach_meters`
|
|
- `wavelengths=N/A`
|
|
- cable category
|
|
- `details_verified=true` when a product source URL existed
|
|
|
|
Corrected `78` ATGBICS OSFP cable rows parsed as `SFP`.
|
|
|
|
Postcheck:
|
|
|
|
- Copper rows missing reach label: `122`
|
|
- Copper rows missing reach meters: `125`
|
|
- Copper rows missing details: `158`
|
|
|
|
## Code Changes
|
|
|
|
`packages/scraper/src/scrapers/atgbics.ts`:
|
|
|
|
- detect `OSFP` before `SFP`
|
|
- parse decimal meter/kilometer reach such as `0.5m`, `1.5m`, `2.5m`, `30m`, `2km`
|
|
- keep Copper/DAC/Twinax/Base-T/RJ45 `wavelengths=N/A`
|
|
|
|
`packages/api/src/routes/transceivers.ts`:
|
|
|
|
- allow Copper/DAC/CU comparable products to match each other with `wavelengths=N/A`
|
|
- keep numeric wavelength requirement for optical comparable products
|
|
|
|
## Deployment
|
|
|
|
- synced scraper to active `/opt/tip`
|
|
- `pnpm -C packages/scraper build` passed
|
|
- synced API route to active `/opt/tip`
|
|
- `pnpm -C packages/api build` passed
|
|
- restarted `tip-api`
|
|
|
|
## Result
|
|
|
|
Global counters:
|
|
|
|
- `details_verified`: `11085` -> `11425`
|
|
- `fully_verified`: `9861` -> `10170`
|
|
|
|
Selected vendors:
|
|
|
|
- ATGBICS: details `7656/8269`, fully `7646/8269`
|
|
- NADDOD: details `726/748`, fully `726/748`
|
|
- QSFPTEK: details `165/201`, fully `140/201`
|
|
- FS.COM: details `373/383`, fully `300/383`
|
|
- Flexoptix: details `626/744`, fully `622/744`
|
|
- GAO Tek: details `127/414`, fully `2/414`
|
|
|
|
## Health
|
|
|
|
Public TIP health after restart:
|
|
|
|
- status: `healthy`
|
|
- load status: `ok`
|
|
- memory used: `13%`
|
|
|
|
## Training Note
|
|
|
|
TIPLLM should treat Copper/DAC/Twinax products as cable products. They need length, endpoints/form factor, speed, price/image/source evidence, and `wavelengths=N/A`; they must not be forced into optical wavelength rules.
|