Share page

swagger 참고

이번주 Top10 일기 조회

1. request URL

/api/shared/diaries/popular

---

최신순 일기 조회

1. request URL

ex. /api/shared/diaries/latest

• 공개, 비공개 포함 일기 데이터이므로 공개된 일기의 데이터만 조회
• cursorId보다 작은 ID 값을 가진 Diary를 최신순으로 페이지네이션

DB 데이터

-- 컬러코드
INSERT INTO color_code(color_code_id, color_name, rgb) VALUES (1, 'GREEN', '0,255,0');


-- 1번 멤버가 일기 15개 작성(공개/비공개 + 좋아요 수 추가)
INSERT INTO diary (member_id, content, created_at, condition_level) VALUES (1, 'testContent', '2024-01-01 23:21:15', 'LEVEL_3');
INSERT INTO diary (member_id, content, created_at, condition_level) VALUES (1, 'Content2', '2024-01-07 23:21:15', 'LEVEL_3');
INSERT INTO diary (member_id, content, created_at, condition_level) VALUES (1, 'Content3', '2024-01-24 23:21:15', 'LEVEL_3');
INSERT INTO diary (member_id, content, created_at, condition_level) VALUES (1, '테스트1', '2024-01-30 23:21:15', 'LEVEL_5');
INSERT INTO diary (member_id, content, created_at, condition_level) VALUES (1, '테스트2', '2024-02-01 23:21:15', 'LEVEL_2');
INSERT INTO diary (member_id, content, created_at, condition_level) VALUES (1, '테스트3', '2024-02-04 23:21:15', 'LEVEL_3');
INSERT INTO diary (member_id, content, created_at, condition_level) VALUES (1, 'testContent', '2024-02-26 23:21:15', 'LEVEL_3');
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, 'Content2', '2024-02-27 23:21:15', 'LEVEL_3', false, 10);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, 'Content3', '2024-03-11 23:21:15', 'LEVEL_3', false, 24);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '테스트1', '2024-03-12 15:21:15', 'LEVEL_5', false, 13);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '테스트2', '2024-03-12 20:21:15', 'LEVEL_2', false, 45);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '테스트3', '2024-03-13 21:21:15', 'LEVEL_3', false, 56);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '내용1', '2024-03-14 22:21:15', 'LEVEL_9', false, 1);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '내용2', '2024-03-15 23:21:15', 'LEVEL_7', false, 2);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '내용3', '2024-03-16 23:21:15', 'LEVEL_5', false, 40);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '내용3', '2024-03-16 23:25:15', 'LEVEL_4', false, 5);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '내용3', '2024-03-16 23:37:15', 'LEVEL_6', false, 5);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '내용3', '2024-03-16 23:37:15', 'LEVEL_1', false, 9);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private, like_count) VALUES (1, '내용3', '2024-03-16 23:40:15', 'LEVEL_1', false, 10);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private) VALUES (1, '내용3', '2024-03-16 23:40:35', 'LEVEL_8', false);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private) VALUES (1, '내용3', '2024-03-16 23:41:15', 'LEVEL_9', false);
INSERT INTO diary (member_id, content, created_at, condition_level, is_private) VALUES (1, '내용3', '2024-03-16 23:45:15', 'LEVEL_7', false);

-- 태그 추가
INSERT INTO tag_list (tag) VALUES ('공부');
INSERT INTO tag_list (tag) VALUES ('운동');
INSERT INTO tag_list (tag) VALUES ('여행');
-- 1번 다이어리에 1번, 2번 태그 추가
INSERT INTO member_tags (tag_id, member_id) VALUES (1, 1);
INSERT INTO diary_tag (diary_id, member_tags_id) VALUES (3, 1);
INSERT INTO member_tags (tag_id, member_id) VALUES (2, 1);
INSERT INTO diary_tag (diary_id, member_tags_id) VALUES (3, 2);
-- 3번 다이어리에 3번 태그 추가
INSERT INTO member_tags (tag_id, member_id) VALUES (3, 1);
INSERT INTO diary_tag (diary_id, member_tags_id) VALUES (3, 3);