Forge a new build

Actors

User, Admin

Scenario

1. The user clicks on the "FORGE" button

2. A new build is created and a new forge page is displayed

   INSERT INTO build (user_id, name, created_at, description, total_price, is_approved)
   VALUES ($userId, $name, CURRENT_DATE, $description, 0.00, false)
   

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;