Changes between Version 3 and Version 4 of ImportantUseCase1

Timestamp:

01/21/22 22:12:32 (3 years ago)

Author:

191151

Comment:

--

ImportantUseCase1

@@ -24 +24 @@
 
 {{{
-UPDATE project.users
-        SET email_verified_at = now(),updated_at = now()
-        WHERE id=6;
+update project.artists
+        set admin_verified_at  = now()
+        where user_id = (
+                select u.id from users u
+                        where u.email = 'test_artist@mail.com'
+        );
 
 INSERT INTO project.artists (user_id,birth_date,city,country,artist_type_id)
-        VALUES (6,'2000-01-01','Skopje','North Macedonia',1);
+        VALUES ((
+                select u.id from users u
+                        where u.email = 'test_artist@mail.com'
+        ),'2000-01-01','Skopje','North Macedonia',1);
 }}}
 
@@ -39 +45 @@
 UPDATE project.artists
         SET admin_verified_at = now()
-        WHERE user_id = 6;
+        WHERE user_id = (
+                select u.id from users u
+                        where u.email = 'test_artist@mail.com'
+        );
 }}}