Editing the user's build

Actors

User, Admin

Scenario

1. In their dashboard, the user clicks on the desired build, and in the details popup on "EDIT"
2. They are redirected to the forge where they can proceed with editing their build

SELECT id
FROM build
WHERE id = $buildId
  AND user_id = $userId
  AND is_approved = false
LIMIT 1;

BEGIN;

SELECT
  b.id,
  b.user_id      AS "userId",
  b.is_approved  AS "isApproved",
  b.name,
  b.description,
  b.total_price  AS "totalPrice"
FROM builds b
WHERE b.id = $1        -- buildId
  AND b.user_id = $2   -- userId
LIMIT 1;

SELECT
  bc.component_id AS "componentId"
FROM build_components bc
WHERE bc.build_id = $1;  -- buildId

COMMIT;