-
-
Notifications
You must be signed in to change notification settings - Fork 126
Expand file tree
/
Copy path999_data.sql
More file actions
59 lines (54 loc) · 2.21 KB
/
Copy path999_data.sql
File metadata and controls
59 lines (54 loc) · 2.21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
select app_private.link_or_register_user(
null,
'github',
'6413628',
'{}'::json,
'{}'::json
);
select app_private.link_or_register_user(
null,
'github',
'222222',
'{"name":"Chad F"}'::json,
'{}'::json
);
select app_private.link_or_register_user(
null,
'github',
'333333',
'{"name":"Bradley A"}'::json,
'{}'::json
);
select app_private.link_or_register_user(
null,
'github',
'444444',
'{"name":"Sam L"}'::json,
'{}'::json
);
select app_private.link_or_register_user(
null,
'github',
'555555',
'{"name":"Max D"}'::json,
'{}'::json
);
insert into app_public.user_emails(user_id, email, is_verified) values
(1, 'benjie@example.com', true);
insert into app_public.forums(slug, name, description) values
('testimonials', 'Testimonials', 'How do you rate PostGraphile?'),
('feedback', 'Feedback', 'How are you finding PostGraphile?'),
('cat-life', 'Cat Life', 'A forum all about cats and how fluffy they are and how they completely ignore their owners unless there is food. Or yarn.'),
('cat-help', 'Cat Help', 'A forum to seek advice if your cat is becoming troublesome.');
insert into app_public.topics(forum_id, author_id, title, body) values
(1, 2, 'Thank you!', '500-1500 requests per second on a single server is pretty awesome.'),
(1, 4, 'PostGraphile is powerful', 'PostGraphile is a powerful, idomatic, and elegant tool.'),
(1, 5, 'Recently launched', 'At this point, it’s quite hard for me to come back and enjoy working with REST.'),
(3, 1, 'I love cats!', 'They''re the best!');
insert into app_public.posts(topic_id, author_id, body) values
(1, 1, 'I''m super pleased with the performance - thanks!'),
(2, 1, 'Thanks so much!'),
(3, 1, 'Tell me about it - GraphQL is awesome!'),
(4, 1, 'Dont you just love cats? Cats cats cats cats cats cats cats cats cats cats cats cats Cats cats cats cats cats cats cats cats cats cats cats cats'),
(4, 2, 'Yeah cats are really fluffy I enjoy squising their fur they are so goregous and fluffy and squishy and fluffy and gorgeous and squishy and goregous and fluffy and squishy and fluffy and gorgeous and squishy'),
(4, 3, 'I love it when they completely ignore you until they want something. So much better than dogs am I rite?');