Changes between Version 1 and Version 2 of ImportantUseCase4

Timestamp:

01/21/22 23:14:40 (4 years ago)

Author:

191151

Comment:

--

ImportantUseCase4

@@ -9 +9 @@
 [SLIKA]
 
-{{{
+{{{#!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
+        from users u 
+        inner join artists a
+                on u.id = a.user_id 
+        inner join artist_types at2 
+                on a.artist_type_id = at2.id 
+        inner join managers m 
+                on a.manager_id = m.user_id 
+        inner join users u2 
+                on u2.id = m.user_id
+        where u.username = 'artist';
 
+select g.name as genre_name
+        from users u 
+        inner join artists a
+                on u.id = a.user_id 
+        inner join artist_sings_genres asg 
+                on a.user_id = asg.artist_id
+        inner join genres g 
+                on g.id = asg.genre_id 
+        where u.username = 'artist';
+
+select ai.path as image_path
+        from users u 
+        inner join artists a
+                on u.id = a.user_id 
+        inner join artist_images ai 
+                on a.user_id = ai.artist_id 
+        where u.username = 'artist';
 }}}
 
@@ -17 +46 @@
 [SLIKA]
 
-{{{
+{{{#!sql
+select * from events e
+        where e.organizer_id = (
+                select u.id from users u 
+                where u.email = 'test_organizer_1@mail.com'
+        );
 
+
+INSERT INTO project.events (title, slug, start_time, end_time, event_date, city, country, description,
+                            event_type_id, organizer_id, created_at)
+VALUES ('Igor''s Birthday', 'igors-birthday', '21:00:00', '23:30:00', '2022-09-15', 'Belgrade', 'Serbia',
+        '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'
+        ), NOW());
+
+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'));
 }}}
 
@@ -25 +70 @@
 [SLIKA]
 
-{{{
+{{{#!sql
 
 }}}