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;