Changes between Version 2 and Version 3 of UseCase008

Timestamp:

05/21/26 18:26:53 (6 days ago)

Author:

232012

Comment:

--

UseCase008

@@ -16 +16 @@
 {{{
 SELECT release_id, title 
-FROM Release;
+FROM RELEASES;
 }}}
 }}}
@@ -27 +27 @@
 {{{
 SELECT COUNT(*) 
-FROM Product 
-WHERE product_id = @new_product_id;
+FROM PRODUCTS 
+WHERE product_id = :new_product_id;
 }}}
 }}}
@@ -36 +36 @@
 {{{#!div style="margin-left: 20px;"
 {{{
-INSERT INTO Product (release_id, format, price, description, stock) 
-VALUES (@selected_release_id, 'Vinyl', 3059, '180g Black Vinyl', 50);
+INSERT INTO PRODUCTS (product_id, release_id, format, price, product_description, stock) 
+VALUES (:new_product_id, :selected_release_id, 'VINYL', 30.59, '180g Black Vinyl', 50);
 }}}
 }}}
@@ -45 +45 @@
 {{{#!div style="margin-left: 20px;"
 {{{
-SELECT * 
-FROM Product 
-WHERE release_id = @selected_release_id;
+SELECT * FROM PRODUCTS 
+WHERE release_id = :selected_release_id;
 }}}
 }}}