Changes between Version 14 and Version 15 of ImportantUseCase3

Timestamp:

03/10/22 17:14:11 (3 years ago)

Author:

191151

Comment:

--

ImportantUseCase3

@@ -11 +11 @@
 
 {{{#!sql
-select u.email, u.username, u.full_name, u.profile_picture, u.type, 
+select u.email, u.username, u.name, u.profile_picture, u.type, 
         coalesce (a.*) as artist,
         coalesce (o.*) as organizer,
@@ -26 +26 @@
                 and u."type" = 'MANAGER'::project."user_type" 
         where 
-                u.email = 'test_artist@mail.com'
+                u.email = 'v_artist@mail.com'
                 and u.password = 'password';
 }}}
@@ -35 +35 @@
 
 {{{#!sql
-select u.full_name, u.email 
+select u.name, u.email 
         from artists a
         join managers m 
@@ -44 +44 @@
                 a.user_id = (
                         select u.id from users u
-                        where u.email = 'test_artist@mail.com'
+                        where u.email = 'v_artist@mail.com'
                 );
 }}}
@@ -53 +53 @@
 
 {{{#!sql
-INSERT INTO project.manager_invites (email,name,invitation_token,created_at,artist_id)
-        VALUES ('test_manager@mail.com','Manager','$2y$10$mTOpvSVqKzGDHpUC5lyrPOfwcYgU7kz9Gbuc22dske4I2g4I.QZ6i',now(),(
+INSERT INTO project.manager_invites (email,invitation_token,created_at,artist_id)
+        VALUES ('v_manager@mail.com','$2y$10$mTOpvSVqKzGDHpUC5lyrPOfwcYgU7kz9Gbuc22dske4I2g4I.QZ6i',now(),(
                 select u.id from users u
-                where u.email = 'test_artist@mail.com'
+                where u.email = 'v_artist@mail.com'
                 and u.type = 'ARTIST'::project."user_type"      
         ));
@@ -70 +70 @@
 join users u on u.id = m.user_id 
 where 
-        u.email = 'test_manager@mail.com'
+        u.email = 'v_manager@mail.com'
         
 -- доколку нема менаџер со внесената мејл адреса се регистрира нов корисник од тип менаџер
-insert into project.users (email,username,password,full_name,created_at,profile_picture,type)
-        values ('test_manager@mail.com','test_manager','password','Test Manager', now(),'manager.jpg','MANAGER'::project."user_type");
+insert into project.users (email,username,password,name,created_at,profile_picture,type)
+        values ('v_manager@mail.com','v_manager','password','V Manager', now(),'manager.jpg','MANAGER'::project."user_type");
 
 
@@ -81 +81 @@
         set manager_id  = (
                 select u.id from users u
-                where u.email = 'test_manager@mail.com'
+                where u.email = 'v_manager@mail.com'
         )
         where user_id = (
                 select u.id from users u
-                where u.email = 'test_artist@mail.com'
+                where u.email = 'v_artist@mail.com'
         );
 }}}