Changes between Version 1 and Version 2 of CloneBuild

Timestamp:

12/29/25 00:15:13 (5 hours ago)

Author:

233051

Comment:

--

CloneBuild

@@ -12 +12 @@
 BEGIN;
 
-SELECT *
-FROM build
-WHERE id = $buildId
-LIMIT 1;
-
-INSERT INTO build (user_id, name, created_at, description, total_price, is_approved)
-SELECT
-  $userId,
-  (b.name || ' (copy)'),
-  CURRENT_DATE,
-  b.description,
-  b.total_price,
-  false
-FROM build AS b
-WHERE b.id = $buildId
-RETURNING id;
-
-SELECT component_id
-FROM build_component
-WHERE build_id = $buildId;
-
-INSERT INTO build_component (build_id, component_id)
-SELECT
-  $newBuildId,
-  bc.component_id
-FROM build_component AS bc
-WHERE bc.build_id = $buildId;
+WITH build_to_clone AS (
+  SELECT name, description, total_price
+  FROM build
+  WHERE id = $buildId
+  LIMIT 1
+),
+new_build AS (
+  INSERT INTO build (user_id, name, created_at, description, total_price, is_approved)
+  SELECT
+    $userId,
+    build_to_clone.name || ' (copy)',
+    CURRENT_DATE,
+    build_to_clone.description,
+    build_to_clone.total_price,
+    false
+  FROM build_to_clone
+  RETURNING id
+),
+copied_components AS (
+  INSERT INTO build_component (build_id, component_id)
+  SELECT
+    new_build.id,
+    bc.component_id
+  FROM new_build
+  JOIN build_component AS bc
+    ON bc.build_id = $buildId
+  RETURNING 1
+)
+SELECT id
+FROM new_build;
 
 COMMIT;