Changes between Initial Version and Version 1 of AddComponentToBuild

Timestamp:

12/29/25 01:11:21 (23 hours ago)

Author:

233051

Comment:

--

AddComponentToBuild

@@ +1 @@
+== Add component to build ==
+
+=== Actors ===
+User, Admin
+
+=== Scenario ===
+1. In the forge, after the user chooses the desired compatible component they click on "ADD"
+2. The server adds the component to the build
+
+{{{
+BEGIN;
+
+SELECT *
+FROM build
+WHERE id = $buildId
+  AND user_id = $userId
+LIMIT 1;
+
+SELECT *
+FROM build_component
+WHERE build_id = $buildId
+  AND component_id = $componentId
+LIMIT 1;
+
+INSERT INTO build_component (build_id, component_id)
+VALUES ($buildId, $componentId);
+
+SELECT c.price
+FROM build_component bc
+JOIN components c ON c.id = bc.component_id
+WHERE bc.build_id = $buildId;
+
+UPDATE build
+SET total_price = (
+  SELECT COALESCE(ROUND(SUM(c.price), 2), 0)
+  FROM build_component bc
+  JOIN components c ON c.id = bc.component_id
+  WHERE bc.build_id = $buildId
+)
+WHERE id = $buildId;
+
+COMMIT;
+}}}