Changes between Initial Version and Version 1 of UserDashboard

Timestamp:

12/28/25 22:42:39 (11 hours ago)

Author:

233051

Comment:

--

UserDashboard

@@ +1 @@
+== 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;
+}}}