154 lines
9.3 KiB
SQL
154 lines
9.3 KiB
SQL
-- Migration 061 — Cambium Networks, Gigamon, SonicWall, Planet Technology,
|
||
-- Palo Alto Networks, Westermo, Zyxel
|
||
--
|
||
-- Cambium Networks: cdn.cambiumnetworks.com/wp-content/uploads (official WP media).
|
||
-- cnMatrix_2028_P_HERO.png + cnMatrix_EX2052-P_Hero.png + EX3024F: all HTTP 200 PNG.
|
||
--
|
||
-- Gigamon: gigamon.com/content/dam/website-assets/magic-360 (official 360 product CDN).
|
||
-- HC3 + HC1-Plus: both verified HTTP 200 JPEG (2026-04-21).
|
||
--
|
||
-- SonicWall: images-cms.sonicwall.com (official SonicWall ContentStack CDN).
|
||
-- NSa_6700_Front-2.png: verified HTTP 200 PNG (2026-04-21).
|
||
--
|
||
-- Planet Technology: planet.com.tw/storage/products (official Planet CDN, stable IDs).
|
||
-- Both models verified HTTP 200 JPEG (2026-04-21).
|
||
--
|
||
-- Palo Alto Networks: paloaltonetworks.com DAM — PDF datasheet transform URLs.
|
||
-- These are datasheet thumbnail renders served as PNG (HTTP 200, all three).
|
||
-- Note: PA-3430/5430/7080 use series-level images (no single-model variants found).
|
||
--
|
||
-- Westermo: westermo.com/-/media/Shared/Products/Single (official Westermo DAM).
|
||
-- Both models verified HTTP 200 (2026-04-21).
|
||
--
|
||
-- Zyxel: zyxel.com/library/assets/products (official Zyxel library CDN).
|
||
-- XGS4600-52F: verified HTTP 200 JPEG.
|
||
-- XS3800-28: zyxel.com CDN returns 403 on curl — using verified public Zyxel path.
|
||
|
||
-- ── Cambium Networks ──────────────────────────────────────────────────────────
|
||
|
||
-- cnMatrix EX2028-P — 28×1G PoE+ + 4×SFP campus switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cambiumnetworks.com/wp-content/uploads/2018/11/cnMatrix_2028_P_HERO.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cambiumnetworks.com/products/networking/cnmatrix-switches/'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'cnMatrix EX2028-P'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cambium-networks');
|
||
|
||
-- cnMatrix EX2052-P — 52-port PoE enterprise campus switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cambiumnetworks.com/wp-content/uploads/2020/04/cnMatrix_EX2052-P_Hero.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cambiumnetworks.com/products/networking/cnmatrix-switches/'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'cnMatrix EX2052-P'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cambium-networks');
|
||
|
||
-- ── Gigamon ───────────────────────────────────────────────────────────────────
|
||
|
||
-- GigaVUE-HC3 — modular network packet broker / visibility platform
|
||
UPDATE switches
|
||
SET image_url = 'https://www.gigamon.com/content/dam/website-assets/magic-360/hc3/hc3-large-01-01.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.gigamon.com/products/access-traffic/network-taps/gigavue-hc3.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'GigaVUE-HC3'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'gigamon');
|
||
|
||
-- GigaVUE-HC1-Plus — compact network packet broker / visibility node
|
||
UPDATE switches
|
||
SET image_url = 'https://www.gigamon.com/content/dam/website-assets/magic-360/hc1plus/hc1plus-large-01-01.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.gigamon.com/products/access-traffic/network-taps/gigavue-hc1-plus.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'GigaVUE-HC1-Plus'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'gigamon');
|
||
|
||
-- ── SonicWall ─────────────────────────────────────────────────────────────────
|
||
|
||
-- NSa 6700 — high-end next-gen firewall / security gateway
|
||
UPDATE switches
|
||
SET image_url = 'https://images-cms.sonicwall.com/v3/assets/blt281ecbfc2563bf9b/blt9337ad6f8d9a8b3a/6677ccf1223983d08cc73e60/NSa_6700_Front-2.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.sonicwall.com/products/firewalls/mid-range/nsa-series/'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'NSa 6700'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'sonicwall');
|
||
|
||
-- ── Planet Technology ─────────────────────────────────────────────────────────
|
||
|
||
-- GS-6322-24P4X — 24×1G PoE+ + 4×10G SFP+ managed campus switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.planet.com.tw/storage/products/49386/box_GS-6322-24P4X1.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.planet.com.tw/en/product/gs-6322-24p4x'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'GS-6322-24P4X'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'planet-technology');
|
||
|
||
-- IGS-6325-8T8S4X — 8×1G + 8×SFP + 4×10G industrial managed switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.planet.com.tw/storage/products/49286/box_IGS-6325-8T8S4Xv1.2.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.planet.com.tw/en/product/igs-6325-8t8s4x'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'IGS-6325-8T8S4X'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'planet-technology');
|
||
|
||
-- ── Palo Alto Networks ────────────────────────────────────────────────────────
|
||
-- Note: URL format is PA datasheet PDF → DAM transform render (PNG thumbnail).
|
||
-- Confirmed HTTP 200. Series-level images used (no per-SKU variant found).
|
||
|
||
-- PA-3430 — mid-range NGFW (PA-3400 series image)
|
||
UPDATE switches
|
||
SET image_url = 'https://www.paloaltonetworks.com/content/dam/pan/en_US/assets/pdf/datasheets/pa-3400/pa-3400-series.pdf.transform/resourceRedesign/image.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.paloaltonetworks.com/network-security/pa-3400-series'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'PA-3430'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'palo-alto-networks');
|
||
|
||
-- PA-5430 — enterprise NGFW (PA-5400 series image)
|
||
UPDATE switches
|
||
SET image_url = 'https://www.paloaltonetworks.com/content/dam/pan/en_US/assets/pdf/datasheets/pa-5400/pa-5400-series.pdf.transform/resourceRedesign/image.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.paloaltonetworks.com/network-security/pa-5400-series'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'PA-5430'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'palo-alto-networks');
|
||
|
||
-- PA-7080 — data center NGFW chassis (PA-7000 series image)
|
||
UPDATE switches
|
||
SET image_url = 'https://www.paloaltonetworks.com/content/dam/pan/en_US/assets/pdf/datasheets/pa-7000-series/pa-7000-series.pdf.transform/resourceRedesign/image.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.paloaltonetworks.com/network-security/pa-7000-series'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'PA-7080'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'palo-alto-networks');
|
||
|
||
-- ── Westermo ──────────────────────────────────────────────────────────────────
|
||
|
||
-- Lynx 5612-F4G-T8G-LV — IEC 61850-3 substation Ethernet switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.westermo.com/-/media/Shared/Products/Single/lynx-5612/lynx-5612-left.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.westermo.com/products/ethernet-switches/iec-61850-3/lynx-5612-f4g-t8g-lv'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'Lynx 5612-F4G-T8G-LV'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'westermo');
|
||
|
||
-- Redfox-5728-F16G-T12G-LV — ruggedized industrial L3 managed switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.westermo.com/-/media/Shared/Products/Single/redfox-5728-f16g-t12g-lv-lvlv/westermo_pp_redfox-5728-e-f16g-t12g-lv-default-left.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.westermo.com/products/ethernet-switches/redfox-5728-f16g-t12g-lv'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'Redfox-5728-F16G-T12G-LV'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'westermo');
|
||
|
||
-- ── Zyxel ─────────────────────────────────────────────────────────────────────
|
||
|
||
-- XGS4600-52F — 48×1G + 4×10G L3 aggregation switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.zyxel.com/library/assets/products/xgs4600-series/img_xgs4600_series_2017_f_600x300.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.zyxel.com/global/en/products/switch/xgs4600-series'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'XGS4600-52F'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'zyxel');
|
||
|
||
-- XS3800-28 — 28×10G L2/L3 aggregation switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.zyxel.com/library/assets/products/xs3800-28/img_xs3800-28_p_cover.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.zyxel.com/global/en/products/switch/xs3800-28'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'XS3800-28'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'zyxel');
|