Changes between Version 3 and Version 4 of UseCase05PrototypeImplementation

Timestamp:

02/07/26 21:03:39 (17 hours ago)

Author:

231035

Comment:

--

UseCase05PrototypeImplementation

@@ -7 +7 @@
 [[Image(mypets.png)]]
 {{{
-SELECT
-  a.animal_id,
-  a.name,
-  a.sex,
-  a.date_of_birth,
-  a.type,
-  a.species,
-  a.breed,
-  a.located_name
-FROM animals a
-WHERE a.owner_id = (SELECT user_id FROM users WHERE username = 'client.mila')
-ORDER BY a.animal_id DESC;
+SELECT * FROM pet WHERE owner_id = ?
 }}}
 2. Clicks on the "Create Listing" button.
@@ -26 +15 @@
 4. System creates the lisitng.
 {{{
-INSERT INTO listings (owner_id, animal_id, status, price, description, created_at)
-VALUES (
-  (SELECT user_id FROM users WHERE username = 'client.mila'),
-  (SELECT animal_id
-   FROM animals
-   WHERE name = 'Max'
-     AND owner_id = (SELECT user_id FROM users WHERE username = 'client.mila')
-   LIMIT 1),
-  'ACTIVE',
-  45.00,
-  'A cute male puppy that it is already vaccinated.',
-  NOW()
-)
-RETURNING listing_id;
+SELECT * FROM owner WHERE user_id = ?
+
+INSERT INTO listing (owner_id, animal_id, description, price, status, created_at) 
+VALUES (?, ?, ?, ?, 'ACTIVE', NOW())
 }}}
 [[Image(listing3.png)]]