Changes between Version 2 and Version 3 of EditBuild

Timestamp:

12/29/25 02:17:48 (3 hours ago)

Author:

233051

Comment:

--

EditBuild

@@ -16 +16 @@
 LIMIT 1;
 }}}
+
+{{{
+BEGIN;
+
+SELECT
+  b.id,
+  b.user_id      AS "userId",
+  b.is_approved  AS "isApproved",
+  b.name,
+  b.description,
+  b.total_price  AS "totalPrice"
+FROM builds b
+WHERE b.id = $1        -- buildId
+  AND b.user_id = $2   -- userId
+LIMIT 1;
+
+SELECT
+  bc.component_id AS "componentId"
+FROM build_components bc
+WHERE bc.build_id = $1;  -- buildId
+
+COMMIT;
+}}}