-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtwitterjs-seed.sql
23 lines (21 loc) · 2.64 KB
/
twitterjs-seed.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
TRUNCATE TABLE users, tweets;
INSERT INTO users (name, picture_url) VALUES ('Tom Hanks', 'http://i.imgur.com/XDjBjfu.jpg');
INSERT INTO users (name, picture_url) VALUES ('Beyonce', 'http://i.imgur.com/1uTV9v2.jpg');
INSERT INTO users (name, picture_url) VALUES ('Justin Bieber', 'http://i.imgur.com/bI1zf2b.jpg');
INSERT INTO users (name, picture_url) VALUES ('Ash Ketchum', 'http://i.imgur.com/n7VJIua.jpg');
INSERT INTO users (name, picture_url) VALUES ('E.T.', 'http://i.imgur.com/Rs7b2FA.jpg');
INSERT INTO users (name, picture_url) VALUES ('William Shakespeare', 'http://i.imgur.com/7d10la4.jpg');
INSERT INTO users (name, picture_url) VALUES ('Grace Hopper', 'http://i.imgur.com/fHmZW3G.jpg');
INSERT INTO users (name, picture_url) VALUES ('Kanye West', 'http://i.imgur.com/MItGWVS.jpg');
INSERT INTO users (name, picture_url) VALUES ('Taylor Swift', 'http://i.imgur.com/JKInSVz.jpg');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Tom Hanks'), 'Life is like an array of chocolates.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Beyonce'), 'If you liked it then you should have put a Promise on it.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Justin Bieber'), 'Is it too late now to say sorry? Cuz I''m missing more than just your <body></body>.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Ash Ketchum'), 'char mander, I choose you!');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='E.T.'), 'E.T. Slack Home.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='William Shakespeare'), 'to.be or to.not.be, that is the question.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Grace Hopper'), 'It''s easier to ask forgiveness than it is to get permission.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Kanye West'), 'I''ma let you finish coding, but…');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Taylor Swift'), 'I knew you were trouble when you logged in.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Kanye West'), 'I think what Kanye West is going to mean is something similar to what Steve Jobs means.');
INSERT INTO tweets (user_id, content) VALUES ((SELECT id from users where name='Taylor Swift'), 'I''ve got some whitespace baby — and I''ll write your `.name`');