Changes between Version 2 and Version 3 of UseCase05

Timestamp:

01/25/26 14:59:49 (2 weeks ago)

Author:

231035

Comment:

--

UseCase05

@@ -16 +16 @@
   a.located_name
 FROM animals a
-WHERE a.owner_id = $1
+WHERE a.owner_id = (SELECT user_id FROM users WHERE username = 'client.mila')
 ORDER BY a.animal_id DESC;
 }}}
 2. Owner clicks on a specific animal.
+{{{
+SELECT
+  a.animal_id,
+  a.owner_id,
+  a.name,
+  a.sex,
+  a.date_of_birth,
+  a.photo_url,
+  a.type,
+  a.species,
+  a.breed,
+  a.located_name
+FROM animals a
+WHERE a.animal_id = 2
+  AND a.owner_id = (SELECT user_id FROM users WHERE username = 'client.mila');
+}}}
 3. Clicks on the "Create Listing" button.
 4. Owner enters listing information and submits it.
@@ -25 +41 @@
 {{{
 INSERT INTO listings (owner_id, animal_id, status, price, description, created_at)
-VALUES ($1, $2, 'ACTIVE', $3, $4, NOW())
+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's already vaccinated.',
+  NOW()
+)
 RETURNING listing_id;
 }}}