7cc910ce16
8 models: 7800R4-36D2-LC, 8101-32FH, 8111-32EH, C9300X-24Y, C9500-48Y4C, N9K-C93108TC-FX3P, PTX10001-36MR, PTX10004. Coverage: 601 → 609 (89.6% → 90.8%).
120 lines
7.5 KiB
SQL
120 lines
7.5 KiB
SQL
-- Migration 089 — Arista 7800R4, Cisco 8000/Catalyst/Nexus, Juniper PTX
|
||
--
|
||
-- All URLs verified HTTP 200 (2026-04-21).
|
||
--
|
||
-- Sources:
|
||
-- 7800R4-36D2-LC: arista.com official product CDN (15KB PNG). Arista uses
|
||
-- `7800R3A-36P-LC-150-v2.png` as the canonical LC image for ALL 7800R4
|
||
-- line card variants on their product page; no dedicated 36D2-LC image
|
||
-- exists (7800R4-36D2-LC announced Oct 2025, not yet in reseller catalogs).
|
||
-- Same official CDN origin as other Arista images in this project.
|
||
-- 8101-32FH: router-switch.com Magento CDN (57KB JPEG), cisco-8101-32fh.jpg.
|
||
-- Cisco.com returns 403 for direct asset fetches on 8000-series images.
|
||
-- NetworkTigers does not carry the Cisco 8000 series (0 search results).
|
||
-- router-switch.com (an authorised Cisco reseller/reseller) hosts per-SKU
|
||
-- product images using the naming convention c/i/cisco-{model}.jpg.
|
||
-- 8111-32EH: stack-systems.com Magento CDN (9.6KB JPEG). Cisco 8000-series
|
||
-- images are not publicly accessible on Cisco.com or NetworkTigers. The
|
||
-- stack-systems.com image is the only available verified CDN image for this
|
||
-- model across authorised resellers (Magento cache, confirmed image/jpeg,
|
||
-- verified HTTP 200).
|
||
-- C9300X-24Y: networktigers.com Shopify CDN (64KB JPEG), cisco-C9300X-24Y-A.
|
||
-- Standard NetworkTigers per-SKU CDN pattern used throughout this project.
|
||
-- C9500-48Y4C: networktigers.com Shopify CDN (50KB JPEG), C9500-48Y4C-E with
|
||
-- UUID suffix (Shopify multi-image dedup pattern).
|
||
-- N9K-C93108TC-FX3P: networktigers.com Shopify CDN (78KB JPEG), full-res
|
||
-- (not progressive 463x version). Same Shopify CDN pattern as other Nexus
|
||
-- 9000-series images in previous migrations.
|
||
-- PTX10001-36MR: juniper.net official image library Azure CDN (112KB JPEG).
|
||
-- Juniper maintains a dedicated per-model image library at
|
||
-- juniper.net/content/dam/www/assets/images/us/en/image-library/ptx-series/.
|
||
-- PTX10004: juniper.net official image library Azure CDN (138KB JPEG),
|
||
-- lbox-ptx10004-front.jpg. The full-res ptx10004-front-high.jpg is 1.26MB
|
||
-- (impractical for web display); the lbox variant provides equivalent
|
||
-- front-panel clarity at 138KB.
|
||
|
||
-- ── Arista Networks ───────────────────────────────────────────────────────────
|
||
|
||
-- 7800R4-36D2-LC — Arista 7800R4 36-port 400G line card
|
||
-- Image: arista.com official CDN (15KB PNG); Arista's canonical LC image for
|
||
-- all 7800R4 line card variants — no dedicated 36D2-LC image published
|
||
UPDATE switches
|
||
SET image_url = 'https://www.arista.com/assets/images/product/7800R3A-36P-LC-150-v2.png',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.arista.com/en/products/7800r4-series'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = '7800R4-36D2-LC'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'arista');
|
||
|
||
-- ── Cisco Systems — 8000 Series Routers ──────────────────────────────────────
|
||
|
||
-- 8101-32FH — Cisco 8101-32FH 32×400G QSFP-DD fixed router
|
||
-- Image: router-switch.com Magento CDN (57KB JPEG); c/i naming convention
|
||
UPDATE switches
|
||
SET image_url = 'https://img.router-switch.com/media/catalog/product/c/i/cisco-8101-32fh.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/routers/8000-series-routers/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = '8101-32FH'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- 8111-32EH — Cisco 8111-32EH 32×100G QSFP28 fixed router
|
||
-- Image: stack-systems.com Magento CDN (9.6KB JPEG), only verified CDN image
|
||
-- for this SKU across all checked authorised resellers
|
||
UPDATE switches
|
||
SET image_url = 'https://stack-systems.com/media/catalog/product/cache/4ccf3122b2d4a5eb47d88ec1c5d09b3d/s/c/screenshot_94_3.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/routers/8000-series-routers/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = '8111-32EH'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- ── Cisco Systems — Catalyst Switches ─────────────────────────────────────────
|
||
|
||
-- C9300X-24Y — Cisco Catalyst 9300X 24×25G SFP28 compact switch
|
||
-- Image: networktigers.com Shopify CDN (64KB JPEG), C9300X-24Y-A variant
|
||
UPDATE switches
|
||
SET image_url = 'https://www.networktigers.com/cdn/shop/files/cisco-C9300X-24Y-A.jpg?v=1712651741',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/catalyst-9300x-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'C9300X-24Y'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- C9500-48Y4C — Cisco Catalyst 9500 48×25G + 4×100G aggregation switch
|
||
-- Image: networktigers.com Shopify CDN (50KB JPEG), C9500-48Y4C-E with UUID
|
||
UPDATE switches
|
||
SET image_url = 'https://www.networktigers.com/cdn/shop/products/cisco-C9500-48Y4C-E_1252c94e-bb07-43a6-a72b-3213bf99b3f7.jpg?v=1681154375',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/catalyst-9500-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'C9500-48Y4C'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- ── Cisco Systems — Nexus Switches ───────────────────────────────────────────
|
||
|
||
-- N9K-C93108TC-FX3P — Cisco Nexus 9300 48×10GBase-T + 6×100G switch
|
||
-- Image: networktigers.com Shopify CDN (78KB JPEG), full-res (not progressive)
|
||
UPDATE switches
|
||
SET image_url = 'https://www.networktigers.com/cdn/shop/products/cisco-N9K-C93108TC-FX3P.jpg?v=1698313034',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9K-C93108TC-FX3P'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- ── Juniper Networks — PTX Series ─────────────────────────────────────────────
|
||
|
||
-- PTX10001-36MR — Juniper PTX10001-36MR fixed 36-port packet transport router
|
||
-- Image: juniper.net official image library Azure CDN (112KB JPEG, front view)
|
||
UPDATE switches
|
||
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/ptx-series/ptx10001-36mr/ptx10001-36mr-front-high.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/routers/ptx-series/ptx10001-36mr.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'PTX10001-36MR'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
|
||
|
||
-- PTX10004 — Juniper PTX10004 4-slot modular packet transport router
|
||
-- Image: juniper.net official image library Azure CDN (138KB JPEG, lbox front
|
||
-- view). Full-res ptx10004-front-high.jpg is 1.26MB; lbox variant used.
|
||
UPDATE switches
|
||
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/ptx-series/ptx10004/lbox-ptx10004-front.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/routers/ptx-series/ptx10004-packet-transport-router.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'PTX10004'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
|