User opens dashboard

Actors

User

Scenario

1. The user clicks on the button with their username

2. A dashboard with their information, favorited builds and their own builds is displayed.

   SELECT
     username,
     email
   FROM users
   WHERE id = $userId
   LIMIT 1;
   

   SELECT
     id,
     user_id,
     name,
     created_at,
     total_price
   FROM build
   WHERE user_id = $userId
   ORDER BY created_at DESC;
   

   SELECT
     b.id,
     b.user_id,
     b.name,
     b.created_at,
     b.total_price,
     COALESCE(AVG(rb.value::float), 0) AS avgRating
   FROM build AS b
   INNER JOIN favorite_build AS fb
     ON b.id = fb.build_id
   LEFT JOIN rating_build AS rb
     ON b.id = rb.build_id
   WHERE fb.user_id = $userId
   GROUP BY
     b.id, b.user_id, b.name, b.created_at, b.total_price
   ORDER BY
     COALESCE(AVG(rb.value::float), 0) DESC;