Changes between Version 2 and Version 3 of UseCase07

Timestamp:

01/25/26 15:12:25 (2 weeks ago)

Author:

231035

Comment:

--

UseCase07

@@ -14 +14 @@
   phone
 FROM vet_clinics
-WHERE clinic_id = $1;
+WHERE clinic_id = (SELECT clinic_id FROM vet_clinics WHERE name = 'Happy Paws Clinic');
 }}}
 2. Owner clicks "Create an appointment"(In the form there are all the animals of that owner, so he can choose witch animal is the appointment for).
@@ -24 +24 @@
   a.breed
 FROM animals a
-WHERE a.owner_id = $1
+WHERE a.owner_id = (SELECT user_id FROM users WHERE username = 'client.mila')
 ORDER BY a.name;
 }}}
@@ -31 +31 @@
 {{{
 BEGIN;
-
 SELECT 1
 FROM appointments ap
-WHERE ap.clinic_id = $1
-  AND ap.date_time = $2
+WHERE ap.clinic_id = (SELECT clinic_id FROM vet_clinics WHERE name = 'Happy Paws Clinic')
+  AND ap.date_time = (NOW() + INTERVAL '3 days')
   AND ap.status = 'CONFIRMED'
 FOR UPDATE;
@@ -48 +47 @@
 )
 VALUES (
-  $1,
-  $3,
-  $4,
+  (SELECT clinic_id FROM vet_clinics WHERE name = 'Happy Paws Clinic'),
+  (SELECT animal_id
+   FROM animals
+   WHERE name = 'Max'
+     AND owner_id = (SELECT user_id FROM users WHERE username = 'client.mila')
+   LIMIT 1),
+  (SELECT user_id FROM users WHERE username = 'client.mila'),
   'CONFIRMED',
-  $2,
-  $5
+  (NOW() + INTERVAL '3 days'),
+  'Regular check-up'
 )
 RETURNING appointment_id;