transceiver-db/sql/052-nokia-images-direct.sql
Rene Fichtmueller e2061c6c4d data: direct image injection for Nokia, F5, Delta Networks, Siemens, TP-Link
Migration 051: TP-Link TL-SG3452XP + TL-SX3016F via static.tp-link.com CDN
Migration 052: Nokia 6/6 — 7220 IXR-D3L/H4 (docs.nokia.com graphics),
  7250 IXR-10 + 7750 SR-1 (tempestns.com), SR-14s (telecomcauliffe.com),
  SR-1e (docs hardwareBanner — no standalone public image available)
Migration 053: F5 BIG-IP i5800/i10800 (wtit.com), i15800 (blueally CDN)
Migration 054: Delta Networks 4/4 (hardwarenation.com + manualslib),
  Siemens SCALANCE 4/4 — X-200/X-300/X-500 via images.sw.cdn.siemens.com

All 14 URLs verified HTTP 200 with correct image content-type (2026-04-21).
CHANGELOG_PENDING.md updated for all 4 migrations.
2026-04-21 08:42:14 +02:00

61 lines
3.2 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- Migration 052 — Nokia product images (direct URL injection)
--
-- Sources:
-- 7220 IXR-D3L: documentation.nokia.com SR Linux Product_Overview (D-series graphic)
-- 7220 IXR-H4: documentation.nokia.com SR Linux Product_Overview (H2/H3 composite)
-- 7250 IXR-10: tempestns.com (Tempest Telecom Solutions reseller CDN)
-- 7750 SR-1: tempestns.com (Tempest Telecom Solutions reseller CDN)
-- 7750 SR-14s: telecomcauliffe.com (reseller CDN)
-- 7750 SR-1e: documentation.nokia.com/sr (no standalone public photo found;
-- official hardware banner is best available source)
--
-- All URLs verified HTTP 200 image/png or image/jpeg (2026-04-21).
-- 7220 IXR-D3L — SR Linux 48×25G leaf switch
UPDATE switches
SET image_url = 'https://documentation.nokia.com/srlinux/SR_Linux_HTML_R21-11/Product_Overview/graphics/DL.png',
product_page_url = COALESCE(product_page_url, 'https://www.nokia.com/data-center-networks/data-center-fabric/7220-interconnect-router/'),
assets_scraped_at = NOW()
WHERE model = '7220 IXR-D3L'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'nokia');
-- 7220 IXR-H4 — SR Linux 32×400G spine (H2/H3 composite is closest public image)
UPDATE switches
SET image_url = 'https://documentation.nokia.com/srlinux/SR_Linux_HTML_R21-11/Product_Overview/graphics/h2h3graphic.png',
product_page_url = COALESCE(product_page_url, 'https://www.nokia.com/data-center-networks/data-center-fabric/7220-interconnect-router/'),
assets_scraped_at = NOW()
WHERE model = '7220 IXR-H4'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'nokia');
-- 7250 IXR-10 — Spine/IXP router (model-specific reseller image)
UPDATE switches
SET image_url = 'https://www.tempestns.com/wp-content/uploads/2020/05/nokia-7250_IXR-10.jpg',
product_page_url = COALESCE(product_page_url, 'https://documentation.nokia.com/ixr/7250-IXR/index.html'),
assets_scraped_at = NOW()
WHERE model = '7250 IXR-10'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'nokia');
-- 7750 SR-1 — Metro edge service router
UPDATE switches
SET image_url = 'https://www.tempestns.com/wp-content/uploads/2020/05/nokia-7750SR-1.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.nokia.com/networks/products/7750-service-router/'),
assets_scraped_at = NOW()
WHERE model = '7750 SR-1'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'nokia');
-- 7750 SR-14s — Modular core SP router
UPDATE switches
SET image_url = 'https://telecomcauliffe.com/wp-content/uploads/2025/02/Nokia_7750_SR_14s_TM.png',
product_page_url = COALESCE(product_page_url, 'https://www.nokia.com/networks/products/7750-service-router/'),
assets_scraped_at = NOW()
WHERE model = '7750 SR-14s'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'nokia');
-- 7750 SR-1e — Compact SP router (no standalone public image; official docs banner used)
UPDATE switches
SET image_url = 'https://documentation.nokia.com/sr/7750-SR/resources/hardwareBanner.png',
product_page_url = COALESCE(product_page_url, 'https://www.nokia.com/networks/products/7750-service-router/'),
assets_scraped_at = NOW()
WHERE model = '7750 SR-1e'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'nokia');