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;