Changes between Version 1 and Version 2 of UseCase04PrototypeImplementation

Timestamp:

02/08/26 13:31:48 (2 hours ago)

Author:

231035

Comment:

--

UseCase04PrototypeImplementation

@@ -5 +5 @@
 == Scenario
 1. Client clicks a listing from the lisiting page.
-{{{#!comment
-SELECT
-  l.listing_id,
-  l.status,
-  l.price,
-  l.description,
-  l.created_at,
-  a.animal_id,
-  a.name AS animal_name,
-  a.species,
-  a.breed,
-  a.located_name,
-  l.owner_id
-FROM listings l
-JOIN animals a ON a.animal_id = l.animal_id
-WHERE l.listing_id = $1;
+[[Image(save.png)]]
+{{{
+select 
+l1_0.listing_id,
+l1_0.owner_id,
+l1_0.animal_id,
+l1_0.description,
+l1_0.price,l1_0.status,
+l1_0.created_at
+ from favorite_listings fl1_0
+ join listings l1_0 on l1_0.listing_id=fl1_0.listing_id
+ where fl1_0.client_id=? 
+order by l1_0.created_at desc
 
 }}}
-2. Client clicks "Save Listing".
+2. Client clicks "Save Listing" or the heart.
+[[Image(save2.png)]]
+[[Image(save3.png)]]
+[[Image(save4.png)]]
+{{{
+insert into favorite_listings (client_id,listing_id) values (?,?)
+}}}
 3. The system saves the listing to favorites to the client.
-{{{#!comment
-INSERT INTO favourite_listings (user_id, listing_id)
-VALUES ($1, $2);
-}}}
+[[Image(save5.png)]]