Changes between Version 5 and Version 6 of CloneBuild

Timestamp:

12/29/25 11:43:48 (37 hours ago)

Author:

233051

Comment:

--

CloneBuild

@@ -20 +20 @@
 BEGIN;
 
-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 b.id
+  b.id,
+  b.name,
+  b.description,
+  b.total_price,
+  b.is_approved
+FROM builds b
+WHERE id = $buildId
+LIMIT 1;
+
+INSERT INTO builds (user_id, name, created_at, description, total_price, is_approved)
+VALUES (
+  $userId,
+  $buildToClone_name || ' (copy)',
+  CURRENT_TIMESTAMP,
+  $buildToClone.description,
+  $buildToClone.total_price,
+  false
 )
+RETURNING id AS $new_build_id;
+
+SELECT component_id
+FROM build_components
+WHERE build_id = $buildId;
+
+INSERT INTO build_components (build_id, component_id)
+VALUES ($new_build_id, $existing_component_id);
 
 COMMIT;