Changes between Version 3 and Version 4 of AddComponent

Timestamp:

12/29/25 11:48:42 (12 hours ago)

Author:

233051

Comment:

--

AddComponent

@@ -29 +29 @@
 RETURNING id AS new_component_id
 
--- if type == 'cpu'
+-- if type == 'cpu':
 INSERT INTO cpu (component_id, socket, cores, threads, base_clock, boost_clock, tdp)
 VALUES ($new_component_id, $socket, $cores, $threads, $base_clock, $boost_clock, $tdp);
@@ -36 +36 @@
 VALUES ($new_component_id, $socket);
 
--- if type == 'gpu'
+-- if type == 'gpu':
 INSERT INTO gpu (component_id, vram, tdp, base_clock, boost_clock, chipset, length)
 VALUES ($new_component_id, $vram, $tdp, $base_clock, $boost_clock, $chipset, $length);
 
--- if type == 'memory'
+-- if type == 'memory':
 INSERT INTO memory (component_id, type, speed, capacity, modules)
 VALUES ($new_component_id, $memory_type, $speed, $capacity, $modules);
 
--- if type == 'storage'
+-- if type == 'storage':
 INSERT INTO storage (component_id, type, capacity, form_factor)
 VALUES ($new_component_id, $storage_type, $capacity, $form_factor);
 
--- if type == 'power_supply'
+-- if type == 'power_supply':
 INSERT INTO power_supply (component_id, type, wattage, form_factor)
 VALUES ($new_component_id, $psu_type, $wattage, $form_factor);
 
--- if type == 'motherboard'
+-- if type == 'motherboard':
 INSERT INTO motherboard (component_id, socket, chipset, form_factor, ram_type, num_ram_slots, max_ram_capacity, pci_express_slots)
 VALUES ($new_component_id, $socket, $chipset, $form_factor, $ram_type, $num_ram_slots, $max_ram_capacity, $pci_express_slots);
 
--- if type == 'case'
+-- if type == 'case':
 INSERT INTO pc_case (component_id, cooler_max_height, gpu_max_length)
 VALUES ($new_component_id, $cooler_max_height, $gpu_max_length);
@@ -69 +69 @@
 VALUES ($new_component_id, $mf_form_factor);
 
--- if type == 'cooler'
+-- if type == 'cooler':
 INSERT INTO cooler (component_id, type, height, max_tdp_supported)
 VALUES ($new_component_id, $cooler_type, $height, $max_tdp_supported);
 
--- if type == 'memory_card'
+-- if type == 'memory_card':
 INSERT INTO memory_card (component_id, num_slots, interface)
 VALUES ($new_component_id, $num_slots, $interface);
 
--- if type == 'optical_drive'
+-- if type == 'optical_drive':
 INSERT INTO optical_drive (component_id, form_factor, type, interface, write_speed, read_speed)
 VALUES ($new_component_id, $form_factor, $optical_type, $interface, $write_speed, $read_speed);
 
--- if type == 'sound_card'
+-- if type == 'sound_card':
 INSERT INTO sound_card (component_id, sample_rate, bit_depth, chipset, interface, channel)
 VALUES ($new_component_id, $sample_rate, $bit_depth, $chipset, $interface, $channel);
 
--- if$type == 'cables'
+-- if$type == 'cables':
 INSERT INTO cables (component_id, length_cm, type)
 VALUES ($new_component_id, $length_cm, $cable_type);
 
--- if type == 'network_adapter'
+-- if type == 'network_adapter':
 INSERT INTO network_adapter (component_id, wifi_version, interface, num_antennas)
 VALUES ($new_component_id, $wifi_version, $interface, $num_antennas);
 
--- if type == 'network_card'
+-- if type == 'network_card':
 INSERT INTO network_card (component_id, num_ports, speed, interface)
 VALUES ($new_component_id, $num_ports, $speed, $interface);