Skip to content

DB 더미데이터 쿼리문

Jump to bottom
Kwon soon won edited this page Dec 11, 2020 · 3 revisions

insert Emoji

INSERT INTO emoji (name, url) VALUES ('thumbsup', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f44d.png');
INSERT INTO emoji (name, url) VALUES ('party-blob', 'https://emoji.slack-edge.com/T019JFET9H7/party-blob/8d60acb47866b650.gif');
INSERT INTO emoji (name, url) VALUES ('clapping-all', 'https://emoji.slack-edge.com/T019JFET9H7/clapping-all/a2cf33ed57ed94f4.gif');
INSERT INTO emoji (name, url) VALUES ('amaze', 'https://emoji.slack-edge.com/T019JFET9H7/amaze/33525d6e1ba0cee0.gif');
INSERT INTO emoji (name, url) VALUES ('joy', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-small/1f602.png');
INSERT INTO emoji (name, url) VALUES ('man-gesturing-ok', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-small/1f646-200d-2642-fe0f.png');
INSERT INTO emoji (name, url) VALUES ('cat-typing', 'https://emoji.slack-edge.com/T019JFET9H7/cat-typing/9baadf562345cd14.gif');
INSERT INTO emoji (name, url) VALUES ('heavy-check-mark', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/2714-fe0f.png');
INSERT INTO emoji (name, url) VALUES ('pray', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f64f.png');
INSERT INTO emoji (name, url) VALUES ('heart', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/2764-fe0f.png');
INSERT INTO emoji (name, url) VALUES ('sob', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f62d.png');
INSERT INTO emoji (name, url) VALUES ('slightly_smiling_face', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f642.png');
INSERT INTO emoji (name, url) VALUES ('dancey-doge', 'https://emoji.slack-edge.com/T019JFET9H7/dancey-doge/3d51739899828252.gif');
INSERT INTO emoji (name, url) VALUES ('grinning', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f600.png');
INSERT INTO emoji (name, url) VALUES ('muscle', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f4aa.png');
INSERT INTO emoji (name, url) VALUES ('heart_eyes', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f60d.png');
INSERT INTO emoji (name, url) VALUES ('airplane', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/2708-fe0f.png');
INSERT INTO emoji (name, url) VALUES ('beers', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f37b.png');
INSERT INTO emoji (name, url) VALUES ('kissing_smiling_eyes', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f619.png');
INSERT INTO emoji (name, url) VALUES ('scream', 'https://a.slack-edge.com/production-standard-emoji-assets/10.2/google-medium/1f631.png');

insert Thread

INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (1, 1, null, 'thread content 1', 'url/test/', True, True,  '[{"id": 1, "userList": [1, 2]}, {"id": 2, "userList": [1]}, {"id": 4, "userList": [1]}]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (1, 1, null, 'thread content 2', 'url/test/', False, False, '[{"id": 1, "userList": [1]},{"id": 2, "userList": [2]},{"id": 3, "userList": [1,3]}]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (2, 1, null, 'thread content 3', 'url/test/', False, False, '[{"id": 3, "userList": [1,2,3]}]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (2, 1, null, '쓰레드 컨텐츠 4', 'url/test/', True, False, '[]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (2, 1, null, '쓰레드 컨텐츠 5', 'url/test/', False, False, '[]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (1, 1, null, 'thread content 6', 'url/test/', False, False, '[]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (3, 1, null, '쓰레드 컨텐츠 7쓰레드 컨텐츠 7쓰레드 컨텐츠 7\r\n쓰레드 컨텐츠 7쓰레드 컨텐츠 7쓰레드 컨텐츠 7', 'url/test/', False, False, '[{"id": 1, "userList": [1,2,3]},{"id": 2, "userList": [1]}]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (1, 1, 1, 'thread content 8', 'url/test/', False, True, '[{"id": 1, "userList": [1,2]},{"id": 2, "userList": [1]}]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (2, 1, 1, '쓰레드 컨텐츠 9', 'url/test/', True, False, '[]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (3, 1, 1, 'thread content 10', 'url/test/', True, False, '[{"id": 1, "userList": [1,2]},{"id": 2, "userList": [1,2,3]},{"id": 3, "userList": [2,3]}]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (2, 1, 2, 'thread content 11', 'url/test/', True, False, '[]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (4, 1, 1, 'thread content 12', 'url/test/', True, False, '[]');

UPDATE thread SET sub_count=4, sub_thread_user_id_1=1, sub_thread_user_id_2=2, sub_thread_user_id_3=3 WHERE id=1;
UPDATE thread SET sub_count=1, sub_thread_user_id_1=2 WHERE id=2;

INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (1, 2, null, 'thread content 13', 'url/test/', True, False, '[{"id": 1, "userList": [1,2]},{"id": 2, "userList": [1]}]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (2, 2, null, 'thread content 14', 'url/test/', True, False, '[]');
INSERT INTO thread (user_id, channel_id, parent_id, content, url, is_edited, is_pinned, emoji) VALUES (3, 2, null, 'thread content 15', 'url/test/', True, False, '[{"id": 1, "userList": [1,2]},{"id": 2, "userList": [1,2,3]},{"id": 3, "userList": [2,3]}]');

insert Channel

INSERT INTO channel (channel_type, is_public, owner_id, `name`, member_count) VALUES (1, 1, 1, '채널 이름1', 4);
INSERT INTO channel (channel_type, is_public, owner_id, `name`, member_count) VALUES (2, 0, 2, '채널 이름2', 2);
INSERT INTO channel (channel_type, is_public, owner_id, `name`, member_count) VALUES (1, 1, 1, '채널 이름3', 3);
INSERT INTO channel (channel_type, is_public, owner_id, `name`, member_count) VALUES (1, 1, 3, '채널 이름4', 2);

insert User

INSERT INTO user (email, pw, display_name) VALUES ('a@a', '$2b$10$.EJDgyR2jYOLtCgHRY5D9ewJoUCTGqQtkrZJoX04th6scZjZ/BE8C', 'my-display-name aaa');
INSERT INTO user (email, pw, display_name) VALUES ('b@b', '$2b$10$.EJDgyR2jYOLtCgHRY5D9ewJoUCTGqQtkrZJoX04th6scZjZ/BE8C', 'my-display-b');
INSERT INTO user (email, pw, display_name) VALUES ('c@c', '$2b$10$.EJDgyR2jYOLtCgHRY5D9ewJoUCTGqQtkrZJoX04th6scZjZ/BE8C', 'ccc');
INSERT INTO user (email, pw, display_name) VALUES ('d@a', '$2b$10$.EJDgyR2jYOLtCgHRY5D9ewJoUCTGqQtkrZJoX04th6scZjZ/BE8C', 'ddd');

Project06-A-Slack 위키

Home

📒 Rules

📄 Plan

✍️ History

🛠 DevLog

Clone this wiki locally