sample_products.sql

delete
from products;
INSERT INTO PRODUCTS (id, category, image_url, name, price, stock)
VALUES (1, 'Laptops', 'https://cdn.aqua.hu/1836/tn_1-1673983.jpg', 'HP 250 G8 laptop', 194690.00, 5),
       (2, 'Software', 'https://miro.medium.com/v2/resize:fit:1085/1*Q7bOeukT7Ll3egoTVqk8Tg.jpeg', 'Cursor AI Pro Licence', 10000.00, 120),
       (3, 'Laptops', 'https://cdn.aqua.hu/1816/1-1661484.jpg', 'Asus VivoBook 15 laptop', 167890.00, 6),
       (4, 'Main Components',
        'https://cdn.aqua.hu/1107/tn_32gb-3200mhz-ddr4-ram-kingston-fury-beast-black-cl16-2x16gb-kf432c16bb1k232-1210861.jpg',
        'Kingston 16GB DDR4 RAM', 25290.00, 15),
       (5, 'Accessories', 'https://cdn.aqua.hu/1211/WDS100T3X0E-1296859.jpg', '1TB WD Black SN770 M.2 SSD meghajtó',
        29000.00, 20),
       (6, 'Peripherals', 'https://cdn.aqua.hu/1207/tn_1-1284291.jpg',
        'Logitech M185 vezeték nélküli optikai USB egér szürke', 4330.00, 30),
       (7, 'Peripherals', 'https://cdn.aqua.hu/2014/tn_3G651F-1773767.jpg', 'HP LaserJet Pro nyomtató', 48290.00, 10),
       (8, 'Networking', 'https://cdn.aqua.hu/1090/tp-link-archer-c64-ac1200-router-fekete-1195292.jpg',
        'TP-Link Archer C6 router', 13490.00, 12),
       (9, 'Software', 'https://cdn.aqua.hu/1323/tn_79G-05388-1422848.jpg', 'Microsoft Office 365 szoftver', 58490.00,
        25),
       (10, 'PC Cases & Builds', 'https://cdn.aqua.hu/1180/tn_MB600L2-KNNN-S00-1265135.jpg', 'Cooler Master MasterBox',
        23590.00, 7),
       (11, 'Prompters', 'https://www.shiwaforce.com/wp-content/uploads/2024/11/image-48.png', 'Róka Prompter', 10000.00, 1),
       (57, 'Peripherals', 'https://cdn.aqua.hu/1140/tn_LS24A400UJUXEN-1239026.jpg', 'Samsung 27"" LED monitor',
        70400.00, 9),
       (12, 'Peripherals', 'https://cdn.aqua.hu/73/tn_pg545-179444.jpg', 'Canon PG-545 Black', 6790.00, 5),
       (13, 'Main Components', 'https://cdn.aqua.hu/1816/1-1661721.jpg', '500GB Kingston SSD', 15990.00, 14),
       (14, 'Networking', 'https://cdn.aqua.hu/754/RT-AC1200%20V2-878171.jpg', 'Asus RT-AC1200G+ router', 11300.00, 11),
       (15, 'Peripherals', 'https://cdn.aqua.hu/1564/tn_1-1547345.jpg', 'Logitech K380', 16480.00, 18),
       (16, 'Accessories', 'https://cdn.aqua.hu/471/tn_ST2000DM008-620032.jpg',
        '2TB Seagate BarraCuda 3.5"" winchester', 29900.00, 22),
       (17, 'Accessories', 'https://cdn.aqua.hu/1012/HP145-1133529.jpg',
        'Green Cell akkumulátor HP Pavilion 11.55V 3400mAH', 22900.00, 4),
       (18, 'Laptops', 'https://cdn.aqua.hu/1790/1-1649838.jpg', 'Lenovo ThinkPad E14 notebook', 528790.00, 6),
       (19, 'Laptops', 'https://cdn.aqua.hu/828/ROG%20STRIX%20B550-F%20GAMING-944693.jpg',
        'ASUS ROG STRIX B550-F GAMING alaplap', 57190.00, 3),
       (20, 'Main Components', 'https://cdn.aqua.hu/1123/tn_CT8G4SFRA32A-1216991.jpg',
        '8GB 3200MHz DDR4 Notebook RAM Crucial CL22', 14900.00, 20),
       (21, 'Main Components', 'https://cdn.aqua.hu/1199/tn_MZ-77E500B_EU-1116012.jpg', 'Samsung 500GB SSD', 23290.00,
        15),
       (22, 'Peripherals', 'https://cdn.aqua.hu/1223/tn_1-1304856.jpg', 'Logitech WebCam C920S full HD Pro webkamera',
        29900.00, 10),
       (23, 'Peripherals', 'https://cdn.aqua.hu/1637/1-1581179.jpg',
        'HP DeskJet 4222e színes többfunkciós tintasugaras nyomtató', 19900.00, 8),
       (24, 'Networking', 'https://cdn.aqua.hu/364/tp-link-re305-ac1200-wifi-range-extender-534239.jpg',
        'TP-Link RE305 AC1200 WiFi Range Extender', 12900.00, 12),
       (25, 'Software', 'https://cdn.aqua.hu/1111/FQC-10537-1214955.jpg',
        'Microsoft Windows 11 Professional 64-bit HUN DSP OEI DVD', 30990.00, 5),
       (26, 'PC Cases & Builds', 'https://cdn.aqua.hu/1244/tn_FD-C-MES2A-06-1319075.jpg',
        'Fractal Design Meshify 2 RGB Black TG Light tint táp nélküli ablakos ház fekete', 87040.00, 7),
       (27, 'Peripherals', 'https://cdn.aqua.hu/1599/24-acer-cb243ybemipruzx-led-monitor-umqb3ee001-1563474.jpg',
        'Acer 24"" LED monitor', 54220.00, 9),
       (28, 'Peripherals', 'https://cdn.aqua.hu/1323/1-1422803.jpg',
        'Logitech G PRO X zajszűrős Gaming headset vezetékes fekete', 39990.00, 5),
       (29, 'Accessories', 'https://cdn.aqua.hu/1666/1-1592043.jpg',
        '500GB ADATA külső SSD meghajtó SC610 fekete-piros', 17520.00, 10),
       (30, 'Main Components', 'https://cdn.aqua.hu/2008/1-1770768.jpg', 'AMD Wraith Prism AM4 CPU hűtő', 21050.00, 6);

insert into PRODUCTS (id, category, image_url, name, price, stock)
values (31, 'Processor', 'https://cdn.aqua.hu/864/100-100000063WOF-975612.jpg',
        'AMD Ryzen 7 5800X 3.8GHz Socket AM4 dobozos (100-100000063WOF)', 66490.00, 10),
       (32, 'Processor', 'https://cdn.aqua.hu/2026/100-100000910WOF-1779523.jpg',
        'AMD Ryzen 7 7800X3D 4.2GHz Socket AM5 dobozos (100-100000910WOF)', 202890.00, 1),
       (33, 'Videocard', 'https://cdn.aqua.hu/1965/1-1750620.jpg',
        'ASUS GeForce RTX 5070 12GB PRIME OC Edition videokártya', 324990.00, 5),
       (34, 'Videocard', 'https://cdn.aqua.hu/2006/1-1769834.jpg',
        'PowerColor Radeon RX 9070 16GB Reaper videokártya (RX9070 16G-A)', 309990.00, 15),
       (35, 'Memory', 'https://cdn.aqua.hu/725/F4-3600C16D-32GTZNC-851923.jpg',
        '32GB 3600MHz DDR4 RAM G.Skill Trident Z Neo CL16 (2X16GB) (F4-3600C16D-32GTZNC)', 36990.00, 5),
       (36, 'storage', 'https://cdn.aqua.hu/424/SA400S37_960G-576811.jpg',
        '960GB Kingston SSD SATA3 2,5" A400 meghajtó (SA400S37/960G)', 21690.00, 60),
       (37, 'motherboard', 'https://cdn.aqua.hu/828/ROG%20STRIX%20B550-F%20GAMING-944693.jpg',
        'ASUS ROG STRIX B550-F GAMING alaplap', 57190.00, 5),
       (38, 'motherboard', 'https://cdn.aqua.hu/2024/TUF%20GAMING%20X670E-PLUS-1778696.jpg',
        'ASUS TUF GAMING X670E-PLUS alaplap', 109660.00, 0);
COMMIT;