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;