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,
  b.is_approved,
  b.name,
  b.description,
  b.total_price,
FROM builds b
WHERE b.id = $1
  AND b.user_id = $2
LIMIT 1;

SELECT
  bc.component_id
FROM build_components bc
WHERE bc.build_id = $1;

COMMIT;