Changes between Initial Version and Version 1 of UseCase05PrototypeImplementation

Timestamp:

02/07/26 20:06:26 (20 hours ago)

Author:

231035

Comment:

--

UseCase05PrototypeImplementation

@@ +1 @@
+= UseCase05 - Create a Listing
+** Initiating actor: Owner **
+== Description
+An owner creates a listing for an animal they own. After creation, the system shows the created listing.
+== Scenario
+1. Owner opens "My Animals" page.
+{{{
+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;
+}}}
+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.
+5. 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;
+}}}
+
+
+
+
+