Changes between Version 2 and Version 3 of UseCase09PrototypeImplementation

Timestamp:

02/07/26 20:04:46 (18 hours ago)

Author:

231035

Comment:

--

UseCase09PrototypeImplementation

@@ -13 +13 @@
 [[Image(addpet2.png)]]
 {{{
+SELECT * FROM user WHERE user_id = ?
 
-INSERT INTO owners (user_id)
-SELECT user_id
-FROM users
-WHERE username = 'client.viktor';
+SELECT * FROM owner WHERE user_id = ?
 
-INSERT INTO animals (
-  owner_id,
-  name,
-  sex,
-  date_of_birth,
-  photo_url,
-  type,
-  species,
-  breed,
-  located_name
-)
-VALUES (
-  (SELECT user_id FROM users WHERE username = 'client.viktor'),
-  'Bella',
-  'FEMALE',
-  '2022-04-15',
-  'https://cdn.petify.com/pets/bella.jpg',
-  'PET',
-  'Dog',
-  'Golden Retriever',
-  'Skopje'
-);
+INSERT INTO owner (user_id) VALUES (?)
+
+INSERT INTO pet (name, sex, date_of_birth, photo_url, type, species, breed, located_name, owner_id) 
+VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
+
 }}}
 [[Image(addpet3.png)]]