Changes between Version 2 and Version 3 of UseCase009

Timestamp:

05/21/26 18:31:25 (6 days ago)

Author:

232012

Comment:

--

UseCase009

@@ -17 +17 @@
 {{{#!div style="margin-left: 20px;"
 {{{
-SELECT product_id, format, price, stock, description, release_id
-FROM Product
-WHERE product_id = @selected_product_id;
+SELECT product_id, format, price, stock, product_description, release_id
+FROM PRODUCTS
+WHERE product_id = :selected_product_id;
 }}}
 }}}
@@ -31 +31 @@
 {{{#!div style="margin-left: 20px;"
 {{{
-UPDATE Product
+UPDATE PRODUCTS
 SET 
-    price = @new_price,
-    stock = @new_stock,
-    description = @new_description,
-    format = @new_format
-WHERE product_id = @selected_product_id;
+    price = :new_price,
+    stock = :new_stock,
+    product_description = :new_description,
+    format = :new_format
+WHERE product_id = :selected_product_id;
 }}}
 }}}
 
-6. System confirms the successful modification to the admin and updates the product information across the public catalog immediately.
+6. System logs the modification
 
 {{{#!div style="margin-left: 20px;"
 {{{
-SELECT * 
-FROM Product 
-WHERE product_id = @selected_product_id;
+INSERT INTO MODIFICATIONS (modification_id, admin_id, date_modified, type_of_modification, discount)
+VALUES (:new_modification_id, :authenticated_admin_id, CURRENT_DATE, 'UPDATE', NULL);
+
+INSERT INTO MODIFICATION_PRODUCTS (modification_id, product_id)
+VALUES (:new_modification_id, :selected_product_id);
+}}}
+}}}
+
+7. System confirms the successful modification to the admin and updates the product information across the public catalog immediately.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT * FROM PRODUCTS 
+WHERE product_id = :selected_product_id;
 }}}
 }}}