Changes between Version 6 and Version 7 of ImportantUseCase4

Timestamp:

03/10/22 17:19:08 (3 years ago)

Author:

191151

Comment:

--

ImportantUseCase4

@@ -10 +10 @@
 
 {{{#!sql
-select u.email, u.username, u.full_name, u.created_at, u.type,
-        a.*, at2.name as artist_type_name, u2.full_name as manager_full_name
+select u.email, u.username, u.name, u.created_at, u.type,
+        a.*, at2.name as artist_type_name, u2.name as manager_full_name
         from users u 
         inner join artists a
@@ -21 +21 @@
         inner join users u2 
                 on u2.id = m.user_id
-        where u.username = 'artist';
+        where u.username like '%taylor-swift%';
 
 select g.name as genre_name
@@ -31 +31 @@
         inner join genres g 
                 on g.id = asg.genre_id 
-        where u.username = 'artist';
+        where u.username like '%taylor-swift%';
 
 select ai.path as image_path
@@ -39 +39 @@
         inner join artist_images ai 
                 on a.user_id = ai.artist_id 
-        where u.username = 'artist';
+        where u.username like '%taylor-swift%';
 }}}
 
@@ -51 +51 @@
         where e.organizer_id = (
                 select u.id from users u 
-                where u.email = 'test_organizer_1@mail.com'
+                where u.email = 'v_organizer@mail.com'
         );
 
@@ -60 +60 @@
         'It''s my birthday!', (select e.id from event_types e where e.name = 'Birthday'), (
                 select u.id from users u 
-                where u.email = 'test_organizer_1@mail.com'
+                where u.email = 'v_organizer@mail.com'
         ), NOW());
 
 -- kreira ponuda so prethodno vneseniot nastan
 INSERT INTO project.offers (slug,payment_type,status,created_at,artist_id,event_id)
-        VALUES ('offer-igors-birthday-jkASHDhASD',1,1,now(),(select u.id from users u where u.email = 'test_artist@mail.com'), (select e.id from events e where e.slug = 'igors-birthday'));
+        VALUES ('offer-igors-birthday-jkASHDhASD',1,1,now(),(select u.id from users u where u.email = 'v_artist@mail.com'), (select e.id from events e where e.slug = 'igors-birthday'));
 }}}
 
 == Чекор 3
-За да се испрати барање до Артистот, Организаторот потребно е да плати $1. \\
+Плаќање на артистот за одреден настан. \\
 [[Image(Request Proposal_ Musion.jpg)]]
 
 {{{#!sql
-INSERT INTO project.transactions ("name",stripe_id,stripe_status,stripe_price,quantity,trial_ends_at,created_at,offer_id)
-        VALUES ('t-init-iH3NAezVs23ytMB8dLx8pxTOIQZPLnLceVFUHTMJa1lvVkiJkMYhpFSfJtMNLLQIjcaSKKVKA5ELmnjySYYwTIXz7J0RlihS9FUfXXP2dcG2ROeLPN0ndhYL','1234','1','1',1,now(),now(),(select o.id from offers o where o.slug = 'offer-igors-birthday-jkASHDhASD'))
+INSERT INTO project.transactions ("name",stripe_id,stripe_price,created_at,offer_id)
+        VALUES ('t-init-iH3NAezVs23ytMB8dLx8pxTOIQZPLnLceVFUHTMJa1lvVkiJkMYhpFSfJtMNLLQIjcaSKKVKA5ELmnjySYYwTIXz7J0RlihS9FUfXXP2dcG2ROeLPN0ndhYL','1234','1',now(),(select o.id from offers o where o.slug = 'offer-igors-birthday-jkASHDhASD'))
 }}}