2022-oidc-coco / backend

0 stars 0 forks source link

[Docs] 핵심 API responce 형태 #9

Open Koeunseooooo opened 1 year ago

Koeunseooooo commented 1 year ago

목적 현재 backend에서 핵심 API responce 형태가 어떤지 알아보고자 함

주요 사항

ETC 주요사항에 있는 조건을 충족하는 상태에서, 어떤식으로 나오는지 댓글 달아주세요 ! 참고할만한 스크린샷 첨부합니다.

image
skm0626 commented 1 year ago

일단 터미널에는 스크린샷, 2022-07-28 04-14-13 이렇게 뜨는 상태야! "데이터 전처리 결과" 가 youtube,kakao api들로 돌린 전처리 코드 결과고 "DB"가 DB에 저장된 데이터 출력해보려고 한건데 저렇게만 표시돼서 일단 AWS RDS랑 연동해서 어떻게 나오는지 빨리 확인해보고 댓글 다시 달아둘게!!!

Koeunseooooo commented 1 year ago

우왁 언니 혹시 pprint 사용해서 조금 더 가독성 좋게 스크린샷 캡처 다시 가능할까요 ..? 🥲🥲

skm0626 commented 1 year ago

우선 출력 결과는

검색어 : 전주 -----------------데이터 전처리 결과----------------- [{'author': 'JTBC Voyage', 'category': '문화,예술', 'place_name': ['전주로이재즈아트홀'], 'place_url': 'http://place.map.kakao.com/131257035', 'publishTime': Timestamp('2020-11-27 00:00:00'), 'video_id': 'g_FtlFk2T60', 'viewCount': 32453090, 'x': ['127.152018996523'], 'y': ['35.8471459120024']}, {'author': 'tzuyang쯔양', 'category': '음식점', 'place_name': ['금암소바'], 'place_url': 'http://place.map.kakao.com/16779100', 'publishTime': Timestamp('2021-07-07 00:00:00'), 'video_id': '1O5vTQR8EO8', 'viewCount': 7382110, 'x': ['127.1332005894921'], 'y': ['35.838493649647525']}, {'author': 'JTBC Voyage', 'category': '음식점', 'place_name': ['원조전원집'], 'place_url': 'http://place.map.kakao.com/10092183', 'publishTime': Timestamp('2020-11-27 00:00:00'), 'video_id': 'g_FtlFk2T60', 'viewCount': 32453090, 'x': ['127.159909899002'], 'y': ['35.8617233769381']}, {'author': 'JTBC Voyage', 'category': '음식점', 'place_name': ['팀'], 'place_url': 'http://place.map.kakao.com/8621991', 'publishTime': Timestamp('2020-11-27 00:00:00'), 'video_id': 'g_FtlFk2T60', 'viewCount': 32453090, 'x': ['127.14445916235'], 'y': ['35.8182266572511']}, {'author': 'JTBC Voyage', 'category': '음식점', 'place_name': ['삼번집'], 'place_url': 'http://place.map.kakao.com/26423918', 'publishTime': Timestamp('2020-11-27 00:00:00'), 'video_id': 'g_FtlFk2T60', 'viewCount': 32453090, 'x': ['127.147962883601'], 'y': ['35.8124543277284']}, {'author': 'JTBC Voyage', 'category': '카페', 'place_name': ['월요일아침'], 'place_url': 'http://place.map.kakao.com/1415786133', 'publishTime': Timestamp('2020-11-27 00:00:00'), 'video_id': 'g_FtlFk2T60', 'viewCount': 32453090, 'x': ['127.128324268114'], 'y': ['35.7954322178631']}, {'author': 'Imagine your Korea', 'category': '숙박', 'place_name': ['전주의봄펜션'], 'place_url': 'http://place.map.kakao.com/1909131314', 'publishTime': Timestamp('2021-11-03 00:00:00'), 'video_id': 'QEXPYsaWRZA', 'viewCount': 31163026, 'x': ['127.17856982177166'], 'y': ['35.7954365910972']}, {'author': 'Imagine your Korea', 'category': '음식점', 'place_name': ['엄마모습'], 'place_url': 'http://place.map.kakao.com/10570399', 'publishTime': Timestamp('2021-11-03 00:00:00'), 'video_id': 'QEXPYsaWRZA', 'viewCount': 31163026, 'x': ['127.137122275451'], 'y': ['35.7935334572701']}, {'author': 'Imagine your Korea', 'category': '가정,생활', 'place_name': ['일상애한복'], 'place_url': 'http://place.map.kakao.com/1670747147', 'publishTime': Timestamp('2021-11-03 00:00:00'), 'video_id': 'QEXPYsaWRZA', 'viewCount': 31163026, 'x': ['127.15202938922508'], 'y': ['35.816620288200355']}, {'author': 'tzuyang쯔양', 'category': '관광,명소', 'place_name': ['전주동물원'], 'place_url': 'http://place.map.kakao.com/8536416', 'publishTime': Timestamp('2021-07-07 00:00:00'), 'video_id': '1O5vTQR8EO8', 'viewCount': 7382110, 'x': ['127.144388934126'], 'y': ['35.8552035317834']}] -----------------DB----------------- <QuerySet [<locationInfo: locationInfo object (1)>, <locationInfo: locationInfo object (2)>, <locationInfo: locationInfo object (3)>, <locationInfo: locationInfo object (4)>, <locationInfo: locationInfo object (5)>, <locationInfo: locationInfo object (6)>, <locationInfo: locationInfo object (7)>, <locationInfo: locationInfo object (8)>, <locationInfo: locationInfo object (9)>, <locationInfo: locationInfo object (10)>, <locationInfo: locationInfo object (11)>, <locationInfo: locationInfo object (12)>, <locationInfo: locationInfo object (13)>, <locationInfo: locationInfo object (14)>, <locationInfo: locationInfo object (15)>, <locationInfo: locationInfo object (16)>, <locationInfo: locationInfo object (17)>, <locationInfo: locationInfo object (18)>, <locationInfo: locationInfo object (19)>, <locationInfo: locationInfo object (20)>, '...(remaining elements truncated)...']> [29/Jul/2022 14:49:54] "POST /insert HTTP/1.1" 200 21

이미지 캡처도 첨부할게!

스크린샷, 2022-07-29 23-51-15 스크린샷, 2022-07-29 23-51-18