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;