chatbot_setup_advanced.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# chatbot \"Korean Trip Planner\"\n",
    "\"**Korean Trip Planner**\" sets up a day-by-day trip to Korea"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "from chatbot.chatbot import Chatbot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "import uuid\n",
    "import time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Read korea tourist information csv file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "def read_tourism_spots(csv_file_path):\n",
    "    with open(csv_file_path, 'r', encoding='utf-8') as file:\n",
    "        csv_string = file.read()\n",
    "    return csv_string\n",
    "\n",
    "csv_file_path = './data/test_set.csv'\n",
    "\n",
    "test_set_locations = read_tourism_spots(csv_file_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'POI_ID,POI_NM,CTPRVN_NM,SIGNGU_NM,LC_LO,LC_LA\\n20868054,용리단길,서울특별시,용산구,126.9715184,37.53140714\\n16497619,오이도포구해양관광단지,경기도,시흥시,126.6882923,37.34802011\\n16984778,송우가구거리,경기도,포천시,127.1263588,37.79171158\\n11178201,족발골목,부산광역시,중구,129.0268061,35.09945931\\n20868111,대신동꽃마을,부산광역시,서구,129.0071313,35.12755173\\n21085600,녹산수문아울렛패션거리,부산광역시,강서구,128.8903692,35.11842346\\n21085542,엄상마을문화거리,경기도,양주시,127.0682909,37.83117656\\n16589482,모래내시장먹자골목,서울특별시,서대문구,126.9161613,37.56900814\\n21085521,수원남문시장푸드트레일러,경기도,수원시 팔달구,127.0190164,37.27763653\\n21086085,백운호수음식마을,경기도,의왕시,127.0006,37.38130249\\n20988095,전포카페거리,부산광역시,부산진구,129.0634863,35.15539778\\n21085896,오이도포장마차촌,경기도,시흥시,126.6862772,37.34549407\\n17001477,동두천시외국인관광특구,경기도,동두천시,127.0561696,37.91326724\\n16731257,세종마을음식문화거리,서울특별시,종로구,126.9720196,37.5765362\\n18275764,송리단길,서울특별시,송파구,127.1093999,37.50986671\\n17398983,솔밭예술마을,부산광역시,해운대구,129.1622703,35.16466929\\n8292244,BIFF,부산광역시,중구,129.0280458,35.09828051\\n6323554,불광동먹자골목,서울특별시,은평구,126.9305302,37.61032714\\n21085614,백년송도골목,부산광역시,서구,129.021345,35.07812661\\n16812577,대부해솔길3코스,경기도,안산시 단원구,126.5441355,37.22607112\\n16509772,화서역먹거리촌,경기도,수원시 팔달구,126.9891965,37.28717362\\n21086195,서울숲은행나무길,서울특별시,성동구,127.0418776,37.5450298\\n21085602,정거마을문화거리,부산광역시,강서구,128.8520153,35.06890828\\n20868053,쌍리단길,서울특별시,도봉구,127.0350911,37.64748468\\n20908693,성수동갈비골목,서울특별시,성동구,127.0442403,37.54699434\\n21086189,염천교수제화거리,서울특별시,중구,126.9700036,37.55932578\\n17432689,팥빙수단팥죽골목,부산광역시,중구,129.0281584,35.10132476\\n21086022,가리봉연변거리,서울특별시,구로구,126.8887536,37.48210768\\n16393012,나혜석거리,경기도,수원시 팔달구,127.0346676,37.26385747\\n21085702,흑리단길,서울특별시,동작구,126.964515,37.50765404\\n21085515,광교카페거리,경기도,수원시 영통구,127.0518748,37.29338066\\n21085881,제부도음식문화시범거리,경기도,화성시,126.6177122,37.17092418\\n20868115,수원로데오거리,경기도,수원시 팔달구,127.0017244,37.26763131\\n6430914,기찻길고기골목,서울특별시,마포구,126.9318929,37.55456539\\n7231370,궁평리해수욕장,경기도,화성시,126.6830849,37.12635244\\n21085954,서울중앙시장쌈밥골목,서울특별시,중구,127.0197856,37.56679597\\n21085696,유네스코길,서울특별시,중구,126.9823116,37.56364602\\n21085606,친구의거리,부산광역시,동구,129.0570486,35.14210029\\n10317011,홍대피카소거리,서울특별시,마포구,126.9221214,37.55099866\\n7231144,광안리해수욕장,부산광역시,수영구,129.1180151,35.15262396\\n16390121,정자동카페골목,경기도,성남시 분당구,127.1061946,37.37096033\\n16994604,북창동먹자골목,서울특별시,중구,126.9781091,37.56279567\\n21085680,충무로애견거리,서울특별시,중구,126.9967496,37.56202924\\n4930685,일산애니골까페촌,경기도,고양시 일산동구,126.7901046,37.6690295\\n20868076,운정카페거리,경기도,파주시,126.7377103,37.71031461\\n21086139,신장쇼핑몰,경기도,평택시,127.05105,37.08070156\\n16716379,조명골목,부산광역시,중구,129.0281709,35.09950369\\n21050879,차이나타운,부산광역시,동구,129.0385585,35.11349784\\n22113460,금광호수로,경기도,안성시,127.3738345,36.96601941\\n5963047,신천먹자골목,서울특별시,송파구,127.0821234,37.51032229\\n7231400,송도해수욕장,부산광역시,서구,129.017431,35.07629641\\n21086178,만물의거리,부산광역시,중구,129.0284709,35.10135156\\n21085547,대능4리벽화마을,경기도,파주시,126.8768141,37.84803477\\n18264390,서촌한옥마을,서울특별시,종로구,126.9734091,37.57929764\\n22112761,환상의드라이브코스,경기도,가평군,127.4995069,37.73895663\\n21085882,물왕동토속음식마을,경기도,시흥시,126.8386474,37.384917\\n6329968,향남동오타운,경기도,화성시,126.9483608,37.13071331\\n20590846,마포전골목,서울특별시,마포구,126.9538361,37.54497141\\n21085919,남포동먹자골목,부산광역시,중구,129.0307812,35.09723248\\n11286458,미음나루,경기도,남양주시,127.170844,37.5861942\\n16396470,미사리카페촌,경기도,하남시,127.2025784,37.57125163\\n21085660,락희거리,서울특별시,종로구,126.9882727,37.57221336\\n1239294,남산공원남산케이블카,서울특별시,중구,126.9839744,37.55664812\\n21085654,화곡동도매유통단지,서울특별시,강서구,126.8557781,37.52978484\\n22438024,서해랑제부도해상케이블카,경기도,화성시,126.6501007,37.18391467\\n21085541,일산원마운트카페거리,경기도,고양시 일산서구,126.7545221,37.66455113\\n20921763,상수동카페거리,서울특별시,마포구,126.9214311,37.54843329\\n8292667,임진각관광지,경기도,파주시,126.7401093,37.88931006\\n22026146,영동리토속음식마을,경기도,광주시,127.3807942,37.47286932\\n7232771,헤이리아트밸리,경기도,파주시,126.6990371,37.78830377\\n21085639,안다미로,부산광역시,북구,129.0309972,35.20593812\\n20868049,신동카페거리,경기도,수원시 영통구,127.0432184,37.24771801\\n7231288,송정해수욕장,부산광역시,해운대구,129.1979149,35.17664807\\n16716554,안경골목,부산광역시,중구,129.0284521,35.10087989\\n20868079,장진우거리,서울특별시,용산구,126.9915166,37.54098617\\n6430854,남대문시장갈치조림골목,서울특별시,중구,126.9770212,37.55948958\\n21085922,부산대학교젊음의거리,부산광역시,금정구,129.0879823,35.23105554\\n5963030,사주카페골목,서울특별시,서대문구,126.9454027,37.55802896\\n7218688,청계천,서울특별시,종로구,126.9908326,37.56826517\\n16925045,수원벽화마을,경기도,수원시 팔달구,127.0166987,37.28601896\\n17050169,의정부부대찌개거리,경기도,의정부시,127.0495913,37.74447442\\n5967010,빌라촌음식골목,서울특별시,용산구,127.0091903,37.53433497\\n7218860,공룡알화석지,경기도,화성시,126.750399,37.26158386\\n16902325,걷고싶은문화의거리,서울특별시,관악구,126.9285708,37.48758442\\n21085869,닭죽촌민속마을,경기도,성남시 수정구,127.1559764,37.46191771\\n17413282,마포음식문화거리,서울특별시,마포구,126.9410123,37.54172586\\n16392153,보정동카페거리,경기도,용인시 기흥구,127.1100984,37.32161272\\n21085903,의정부떡볶이골목,경기도,의정부시,127.0503921,37.73976734\\n16584531,방배역먹자골목,서울특별시,서초구,126.9967609,37.48213262\\n21085948,마포갈매기골목,서울특별시,마포구,126.9506756,37.54180383\\n21085905,용문산토속음식마을,경기도,양평군,127.583934,37.54533387\\n6460652,온천장곰장어골목,부산광역시,동래구,129.0825566,35.21968529\\n21086181,텍사스거리,부산광역시,동구,129.038996,35.11537756\\n5967602,돼지국밥거리,부산광역시,부산진구,129.0621025,35.14208653\\n21071786,오이도음식문화거리,경기도,시흥시,126.6875471,37.34464479\\n16355778,젊음의거리,경기도,의정부시,127.0499392,37.74162649\\n5966058,북창동먹자골목,서울특별시,중구,126.9773264,37.56253568\\n20868125,신해철거리,경기도,성남시 분당구,127.126955,37.3657084\\n17703855,녹두거리,서울특별시,관악구,126.9377243,37.46922214\\n4930669,신림동순대골목,서울특별시,관악구,126.928485,37.48341514\\n21086087,고모리카페촌,경기도,포천시,127.1643301,37.78325687\\n21085536,백운호수카페촌,경기도,의왕시,127.0060509,37.37400062\\n18083271,소금길,서울특별시,마포구,126.9476897,37.5544771\\n16713755,공덕역전골목,서울특별시,마포구,126.9534543,37.54471466\\n21086093,서종면한식마을,경기도,양평군,127.362636,37.63233732\\n21085529,문화의거리,경기도,오산시,127.0687686,37.14575293\\n21050880,망양로산복도로,부산광역시,중구,129.0329818,35.11493617\\n22456113,신림동별빛거리,서울특별시,관악구,126.9284603,37.48754504\\n16865991,행운동먹자골목,서울특별시,관악구,126.9543533,37.4820227\\n7232858,부천영상문화단지,경기도,부천시,126.7458098,37.50846477\\n16824221,댕이골전통음식거리,경기도,안산시 상록구,126.8424483,37.29381726\\n20868052,온천천카페거리,부산광역시,동래구,129.1021706,35.19156662\\n17622106,회기역파전골목,서울특별시,동대문구,127.0562071,37.58939874\\n21086179,구둣방골목,부산광역시,중구,129.0298899,35.09896321\\n16846833,광안리해변테마거리,부산광역시,수영구,129.1218868,35.1554151\\n21085878,신봉동먹자골목,경기도,용인시 수지구,127.0535667,37.33302522\\n5966758,효자촌먹자골목,경기도,성남시 분당구,127.1429029,37.37479028\\n21085868,일월먹거리촌,경기도,수원시 권선구,126.973326,37.28305511\\n10252153,금강산랜드,경기도,파주시,126.8001616,37.79163861\\n21085920,태종대자갈마당,부산광역시,영도구,129.0779311,35.06025033\\n6376544,예술거리,서울특별시,마포구,126.9242558,37.55286406\\n22112744,서울랜드드라이브코스,경기도,과천시,127.0190996,37.43589723\\n20868026,광교카페거리,경기도,수원시 영통구,127.0539668,37.29466682\\n21085876,안산곱창골목,경기도,안산시 단원구,126.8397312,37.31763751\\n21086176,남포동포장마차거리,부산광역시,중구,129.02651,35.09797076\\n17459230,청량리먹자골목,서울특별시,동대문구,127.0462182,37.58125378\\n21086092,양수리카페촌,경기도,가평군,127.3806944,37.66450662\\n20934499,서림길,서울특별시,관악구,126.9389146,37.47302478\\n5614171,여주도예촌,경기도,여주시,127.6484458,37.30290342\\n21085630,금수현음악의거리,부산광역시,강서구,128.9802541,35.21390817\\n21086110,콩나물해장국골목,부산광역시,수영구,129.1240967,35.15591392\\n21086183,명동거리,서울특별시,중구,126.9848971,37.56207862\\n10614686,평택호관광지,경기도,평택시,126.909275,36.91584764\\n7232772,공릉국민관광지,경기도,파주시,126.8357793,37.75041771\\n5968779,교대곱창골목,서울특별시,서초구,127.0142478,37.48885956\\n16925743,안산다문화마을특구,경기도,안산시 단원구,126.7910155,37.33078813\\n21085938,공덕시장족발골목,서울특별시,마포구,126.9534706,37.54486472\\n21085666,재미로,서울특별시,중구,126.9858485,37.5592136\\n17931967,민락동상업구역,부산광역시,수영구,129.1316871,35.1550799\\n21086088,대부도방아머리먹거리타운,경기도,안산시 단원구,126.5762212,37.28842867\\n5497747,한국인삼주마을,경기도,안성시,127.2858378,37.01885016\\n21085537,가평벚꽃길,경기도,가평군,127.3983405,37.70734887\\n21085910,소요산토속음식마을,경기도,동두천시,127.0612375,37.94740139\\n21085694,방학천문화예술거리,서울특별시,도봉구,127.0412018,37.66179378\\n16922713,포천이동갈비마을,경기도,포천시,127.3662595,38.03384866\\n6430871,고가구골목,서울특별시,용산구,126.9943014,37.53332429\\n17691726,부산명륜동가구거리,부산광역시,동래구,129.0831064,35.21372856\\n21085923,해운대곰장어골목,부산광역시,해운대구,129.16185,35.16102443\\n5962599,종로아구찜골목,서울특별시,종로구,126.9882386,37.5731233\\n21085522,범박동카페거리,경기도,부천시,126.8118373,37.47424621\\n21085634,약초골목,부산광역시,북구,129.0032742,35.20890491\\n21085934,남대문갈치조림골목,서울특별시,중구,126.9769208,37.559695\\n20942227,안양예술공원음식문화거리,경기도,안양시 만안구,126.9193675,37.41829207\\n21085649,한류스타거리,서울특별시,강남구,127.0421985,37.52764411\\n21085711,현충로,서울특별시,동작구,126.9735728,37.50546174\\n21085544,생글생글희망골목길,경기도,시흥시,126.7803677,37.4362268\\n21085518,안산중앙역로데오거리,경기도,안산시 단원구,126.83859,37.31741607\\n17459246,동대문생선구이골목,서울특별시,종로구,127.0064871,37.5703531\\n17209994,남대문칼국수골목,서울특별시,중구,126.9771046,37.55824176\\n22112759,국립수목원진입도로,경기도,포천시,127.1713561,37.75029126\\n21085697,연인의거리,서울특별시,서초구,127.0419546,37.47810008\\n21085631,서면문화로,부산광역시,부산진구,129.0572687,35.15887261\\n21085871,행주산성먹거리촌,경기도,고양시 덕양구,126.8256573,37.60025366\\n21085932,청사포회거리,부산광역시,해운대구,129.1938527,35.16105118\\n21086184,경춘선숲길,서울특별시,노원구,127.0786999,37.62069418\\n21086185,성수동수제화거리,서울특별시,성동구,127.057185,37.54444328\\n16701140,감지해수욕장,부산광역시,영도구,129.0763055,35.06082227\\n20868022,경의선책거리,서울특별시,마포구,126.9247919,37.55952933\\n21086101,남한산성보양거리,경기도,광주시,127.1832174,37.48083614\\n21085693,장미길,서울특별시,중랑구,127.0727304,37.61354418\\n21085520,오이도해양단지,경기도,시흥시,126.6899027,37.34426389\\n21085682,사당가구거리,서울특별시,서초구,126.9826245,37.48998072\\n21085621,천지인골목,부산광역시,중구,129.0332468,35.10379847\\n8292776,청평호반,경기도,가평군,127.4460709,37.71084247\\n10620405,대학천책방거리,서울특별시,종로구,127.0064234,37.57066073\\n21086142,분당로데오거리,경기도,성남시 분당구,127.1213723,37.38353763\\n21085540,위례서일로거리,경기도,성남시 수정구,127.138724,37.46728019\\n21085677,서리풀푸드트럭존,서울특별시,서초구,127.0268752,37.49799479\\n8292330,누리천문대,경기도,군포시,126.91535,37.33029417\\n4930678,가리봉로데오거리,서울특별시,금천구,126.8874081,37.47775068\\n8292243,40계단거리,부산광역시,중구,129.0358642,35.10395864\\n21085900,주말농장한식마을,경기도,화성시,126.9842874,37.20079238\\n21085674,수락산디자인거리,서울특별시,노원구,127.0588553,37.67454433\\n21086194,중곡동가구거리,서울특별시,광진구,127.0809921,37.55648128\\n21085548,화서문점집골목,경기도,수원시 팔달구,127.0120853,37.28510152\\n21085539,모란시장기름골목,경기도,성남시 중원구,127.1274217,37.4304813\\n17523182,이태원쇼핑거리,서울특별시,용산구,126.9914508,37.53431282\\n16441531,죽전아울렛거리,경기도,용인시 수지구,127.108726,37.33327314\\n17702239,문래창작촌,서울특별시,영등포구,126.8971793,37.51418563\\n5966983,세계음식거리,서울특별시,용산구,126.9955069,37.53436384\\n5966901,마포돼지갈비골목,서울특별시,마포구,126.9430393,37.54025623\\n7231145,해운대해수욕장,부산광역시,해운대구,129.1594775,35.15840394\\n16716384,가방골목,부산광역시,중구,129.0284653,35.10013787\\n21086141,후곡학원가,경기도,고양시 일산서구,126.7669608,37.6779253\\n21086099,신륵사매운탕촌,경기도,여주시,127.6594223,37.30154273\\n6466431,상해거리,부산광역시,동구,129.037766,35.11376053\\n4975181,초월면가구거리,경기도,광주시,127.2967783,37.37533749\\n21085672,양재천길,서울특별시,강남구,127.0455021,37.48172797\\n21086143,의정부시가구거리,경기도,의정부시,127.0501581,37.73575268\\n21086090,운암뜰한식거리,경기도,오산시,127.0757266,37.14759412\\n18095681,삼청동거리,서울특별시,종로구,126.9811939,37.58165767\\n21085533,양평해장국거리,경기도,양평군,127.5280002,37.46561402\\n17459116,안양명물순대곱창골목,경기도,안양시 만안구,126.9203645,37.39784672\\n21086148,사가연문화거리,경기도,남양주시,127.2466304,37.65496146\\n21085947,공덕소담길,서울특별시,마포구,126.9539262,37.54728307\\n'"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_set_locations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "POI_ID,POI_NM,CTPRVN_NM,SIGNGU_NM,LC_LO,LC_LA\n",
      "20868054,용리단길,서울특별시,용산구,126.9715184,37.53140714\n",
      "16497619,오이도포구해양관광단지,경기도,시흥시,126.6882923,37.34802011\n",
      "16984778,송우가구거리,경기도,포천시,127.1263588,37.79171158\n",
      "11178201,족발골목,부산광역시,중구,129.0268061,35.09945931\n",
      "20868111,대신동꽃마을,부산광역시,서구,129.0071313,35.12755173\n",
      "21085600,녹산수문아울렛패션거리,부산광역시,강서구,128.8903692,35.11842346\n",
      "21085542,엄상마을문화거리,경기도,양주시,127.0682909,37.83117656\n",
      "16589482,모래내시장먹자골목,서울특별시,서대문구,126.9161613,37.56900814\n",
      "21085521,수원남문시장푸드트레일러,경기도,수원시 팔달구,127.0190164,37.27763653\n",
      "21086085,백운호수음식마을,경기도,의왕시,127.0006,37.38130249\n",
      "20988095,전포카페거리,부산광역시,부산진구,129.0634863,35.15539778\n",
      "21085896,오이도포장마차촌,경기도,시흥시,126.6862772,37.34549407\n",
      "17001477,동두천시외국인관광특구,경기도,동두천시,127.0561696,37.91326724\n",
      "16731257,세종마을음식문화거리,서울특별시,종로구,126.9720196,37.5765362\n",
      "18275764,송리단길,서울특별시,송파구,127.1093999,37.50986671\n",
      "17398983,솔밭예술마을,부산광역시,해운대구,129.1622703,35.16466929\n",
      "8292244,BIFF,부산광역시,중구,129.0280458,35.09828051\n",
      "6323554,불광동먹자골목,서울특별시,은평구,126.9305302,37.61032714\n",
      "21085614,백년송도골목,부산광역시,서구,129.021345,35.07812661\n",
      "16812577,대부해솔길3코스,경기도,안산시 단원구,126.5441355,37.22607112\n",
      "16509772,화서역먹거리촌,경기도,수원시 팔달구,126.9891965,37.28717362\n",
      "21086195,서울숲은행나무길,서울특별시,성동구,127.0418776,37.5450298\n",
      "21085602,정거마을문화거리,부산광역시,강서구,128.8520153,35.06890828\n",
      "20868053,쌍리단길,서울특별시,도봉구,127.0350911,37.64748468\n",
      "20908693,성수동갈비골목,서울특별시,성동구,127.0442403,37.54699434\n",
      "21086189,염천교수제화거리,서울특별시,중구,126.9700036,37.55932578\n",
      "17432689,팥빙수단팥죽골목,부산광역시,중구,129.0281584,35.10132476\n",
      "21086022,가리봉연변거리,서울특별시,구로구,126.8887536,37.48210768\n",
      "16393012,나혜석거리,경기도,수원시 팔달구,127.0346676,37.26385747\n",
      "21085702,흑리단길,서울특별시,동작구,126.964515,37.50765404\n",
      "21085515,광교카페거리,경기도,수원시 영통구,127.0518748,37.29338066\n",
      "21085881,제부도음식문화시범거리,경기도,화성시,126.6177122,37.17092418\n",
      "20868115,수원로데오거리,경기도,수원시 팔달구,127.0017244,37.26763131\n",
      "6430914,기찻길고기골목,서울특별시,마포구,126.9318929,37.55456539\n",
      "7231370,궁평리해수욕장,경기도,화성시,126.6830849,37.12635244\n",
      "21085954,서울중앙시장쌈밥골목,서울특별시,중구,127.0197856,37.56679597\n",
      "21085696,유네스코길,서울특별시,중구,126.9823116,37.56364602\n",
      "21085606,친구의거리,부산광역시,동구,129.0570486,35.14210029\n",
      "10317011,홍대피카소거리,서울특별시,마포구,126.9221214,37.55099866\n",
      "7231144,광안리해수욕장,부산광역시,수영구,129.1180151,35.15262396\n",
      "16390121,정자동카페골목,경기도,성남시 분당구,127.1061946,37.37096033\n",
      "16994604,북창동먹자골목,서울특별시,중구,126.9781091,37.56279567\n",
      "21085680,충무로애견거리,서울특별시,중구,126.9967496,37.56202924\n",
      "4930685,일산애니골까페촌,경기도,고양시 일산동구,126.7901046,37.6690295\n",
      "20868076,운정카페거리,경기도,파주시,126.7377103,37.71031461\n",
      "21086139,신장쇼핑몰,경기도,평택시,127.05105,37.08070156\n",
      "16716379,조명골목,부산광역시,중구,129.0281709,35.09950369\n",
      "21050879,차이나타운,부산광역시,동구,129.0385585,35.11349784\n",
      "22113460,금광호수로,경기도,안성시,127.3738345,36.96601941\n",
      "5963047,신천먹자골목,서울특별시,송파구,127.0821234,37.51032229\n",
      "7231400,송도해수욕장,부산광역시,서구,129.017431,35.07629641\n",
      "21086178,만물의거리,부산광역시,중구,129.0284709,35.10135156\n",
      "21085547,대능4리벽화마을,경기도,파주시,126.8768141,37.84803477\n",
      "18264390,서촌한옥마을,서울특별시,종로구,126.9734091,37.57929764\n",
      "22112761,환상의드라이브코스,경기도,가평군,127.4995069,37.73895663\n",
      "21085882,물왕동토속음식마을,경기도,시흥시,126.8386474,37.384917\n",
      "6329968,향남동오타운,경기도,화성시,126.9483608,37.13071331\n",
      "20590846,마포전골목,서울특별시,마포구,126.9538361,37.54497141\n",
      "21085919,남포동먹자골목,부산광역시,중구,129.0307812,35.09723248\n",
      "11286458,미음나루,경기도,남양주시,127.170844,37.5861942\n",
      "16396470,미사리카페촌,경기도,하남시,127.2025784,37.57125163\n",
      "21085660,락희거리,서울특별시,종로구,126.9882727,37.57221336\n",
      "1239294,남산공원남산케이블카,서울특별시,중구,126.9839744,37.55664812\n",
      "21085654,화곡동도매유통단지,서울특별시,강서구,126.8557781,37.52978484\n",
      "22438024,서해랑제부도해상케이블카,경기도,화성시,126.6501007,37.18391467\n",
      "21085541,일산원마운트카페거리,경기도,고양시 일산서구,126.7545221,37.66455113\n",
      "20921763,상수동카페거리,서울특별시,마포구,126.9214311,37.54843329\n",
      "8292667,임진각관광지,경기도,파주시,126.7401093,37.88931006\n",
      "22026146,영동리토속음식마을,경기도,광주시,127.3807942,37.47286932\n",
      "7232771,헤이리아트밸리,경기도,파주시,126.6990371,37.78830377\n",
      "21085639,안다미로,부산광역시,북구,129.0309972,35.20593812\n",
      "20868049,신동카페거리,경기도,수원시 영통구,127.0432184,37.24771801\n",
      "7231288,송정해수욕장,부산광역시,해운대구,129.1979149,35.17664807\n",
      "16716554,안경골목,부산광역시,중구,129.0284521,35.10087989\n",
      "20868079,장진우거리,서울특별시,용산구,126.9915166,37.54098617\n",
      "6430854,남대문시장갈치조림골목,서울특별시,중구,126.9770212,37.55948958\n",
      "21085922,부산대학교젊음의거리,부산광역시,금정구,129.0879823,35.23105554\n",
      "5963030,사주카페골목,서울특별시,서대문구,126.9454027,37.55802896\n",
      "7218688,청계천,서울특별시,종로구,126.9908326,37.56826517\n",
      "16925045,수원벽화마을,경기도,수원시 팔달구,127.0166987,37.28601896\n",
      "17050169,의정부부대찌개거리,경기도,의정부시,127.0495913,37.74447442\n",
      "5967010,빌라촌음식골목,서울특별시,용산구,127.0091903,37.53433497\n",
      "7218860,공룡알화석지,경기도,화성시,126.750399,37.26158386\n",
      "16902325,걷고싶은문화의거리,서울특별시,관악구,126.9285708,37.48758442\n",
      "21085869,닭죽촌민속마을,경기도,성남시 수정구,127.1559764,37.46191771\n",
      "17413282,마포음식문화거리,서울특별시,마포구,126.9410123,37.54172586\n",
      "16392153,보정동카페거리,경기도,용인시 기흥구,127.1100984,37.32161272\n",
      "21085903,의정부떡볶이골목,경기도,의정부시,127.0503921,37.73976734\n",
      "16584531,방배역먹자골목,서울특별시,서초구,126.9967609,37.48213262\n",
      "21085948,마포갈매기골목,서울특별시,마포구,126.9506756,37.54180383\n",
      "21085905,용문산토속음식마을,경기도,양평군,127.583934,37.54533387\n",
      "6460652,온천장곰장어골목,부산광역시,동래구,129.0825566,35.21968529\n",
      "21086181,텍사스거리,부산광역시,동구,129.038996,35.11537756\n",
      "5967602,돼지국밥거리,부산광역시,부산진구,129.0621025,35.14208653\n",
      "21071786,오이도음식문화거리,경기도,시흥시,126.6875471,37.34464479\n",
      "16355778,젊음의거리,경기도,의정부시,127.0499392,37.74162649\n",
      "5966058,북창동먹자골목,서울특별시,중구,126.9773264,37.56253568\n",
      "20868125,신해철거리,경기도,성남시 분당구,127.126955,37.3657084\n",
      "17703855,녹두거리,서울특별시,관악구,126.9377243,37.46922214\n",
      "4930669,신림동순대골목,서울특별시,관악구,126.928485,37.48341514\n",
      "21086087,고모리카페촌,경기도,포천시,127.1643301,37.78325687\n",
      "21085536,백운호수카페촌,경기도,의왕시,127.0060509,37.37400062\n",
      "18083271,소금길,서울특별시,마포구,126.9476897,37.5544771\n",
      "16713755,공덕역전골목,서울특별시,마포구,126.9534543,37.54471466\n",
      "21086093,서종면한식마을,경기도,양평군,127.362636,37.63233732\n",
      "21085529,문화의거리,경기도,오산시,127.0687686,37.14575293\n",
      "21050880,망양로산복도로,부산광역시,중구,129.0329818,35.11493617\n",
      "22456113,신림동별빛거리,서울특별시,관악구,126.9284603,37.48754504\n",
      "16865991,행운동먹자골목,서울특별시,관악구,126.9543533,37.4820227\n",
      "7232858,부천영상문화단지,경기도,부천시,126.7458098,37.50846477\n",
      "16824221,댕이골전통음식거리,경기도,안산시 상록구,126.8424483,37.29381726\n",
      "20868052,온천천카페거리,부산광역시,동래구,129.1021706,35.19156662\n",
      "17622106,회기역파전골목,서울특별시,동대문구,127.0562071,37.58939874\n",
      "21086179,구둣방골목,부산광역시,중구,129.0298899,35.09896321\n",
      "16846833,광안리해변테마거리,부산광역시,수영구,129.1218868,35.1554151\n",
      "21085878,신봉동먹자골목,경기도,용인시 수지구,127.0535667,37.33302522\n",
      "5966758,효자촌먹자골목,경기도,성남시 분당구,127.1429029,37.37479028\n",
      "21085868,일월먹거리촌,경기도,수원시 권선구,126.973326,37.28305511\n",
      "10252153,금강산랜드,경기도,파주시,126.8001616,37.79163861\n",
      "21085920,태종대자갈마당,부산광역시,영도구,129.0779311,35.06025033\n",
      "6376544,예술거리,서울특별시,마포구,126.9242558,37.55286406\n",
      "22112744,서울랜드드라이브코스,경기도,과천시,127.0190996,37.43589723\n",
      "20868026,광교카페거리,경기도,수원시 영통구,127.0539668,37.29466682\n",
      "21085876,안산곱창골목,경기도,안산시 단원구,126.8397312,37.31763751\n",
      "21086176,남포동포장마차거리,부산광역시,중구,129.02651,35.09797076\n",
      "17459230,청량리먹자골목,서울특별시,동대문구,127.0462182,37.58125378\n",
      "21086092,양수리카페촌,경기도,가평군,127.3806944,37.66450662\n",
      "20934499,서림길,서울특별시,관악구,126.9389146,37.47302478\n",
      "5614171,여주도예촌,경기도,여주시,127.6484458,37.30290342\n",
      "21085630,금수현음악의거리,부산광역시,강서구,128.9802541,35.21390817\n",
      "21086110,콩나물해장국골목,부산광역시,수영구,129.1240967,35.15591392\n",
      "21086183,명동거리,서울특별시,중구,126.9848971,37.56207862\n",
      "10614686,평택호관광지,경기도,평택시,126.909275,36.91584764\n",
      "7232772,공릉국민관광지,경기도,파주시,126.8357793,37.75041771\n",
      "5968779,교대곱창골목,서울특별시,서초구,127.0142478,37.48885956\n",
      "16925743,안산다문화마을특구,경기도,안산시 단원구,126.7910155,37.33078813\n",
      "21085938,공덕시장족발골목,서울특별시,마포구,126.9534706,37.54486472\n",
      "21085666,재미로,서울특별시,중구,126.9858485,37.5592136\n",
      "17931967,민락동상업구역,부산광역시,수영구,129.1316871,35.1550799\n",
      "21086088,대부도방아머리먹거리타운,경기도,안산시 단원구,126.5762212,37.28842867\n",
      "5497747,한국인삼주마을,경기도,안성시,127.2858378,37.01885016\n",
      "21085537,가평벚꽃길,경기도,가평군,127.3983405,37.70734887\n",
      "21085910,소요산토속음식마을,경기도,동두천시,127.0612375,37.94740139\n",
      "21085694,방학천문화예술거리,서울특별시,도봉구,127.0412018,37.66179378\n",
      "16922713,포천이동갈비마을,경기도,포천시,127.3662595,38.03384866\n",
      "6430871,고가구골목,서울특별시,용산구,126.9943014,37.53332429\n",
      "17691726,부산명륜동가구거리,부산광역시,동래구,129.0831064,35.21372856\n",
      "21085923,해운대곰장어골목,부산광역시,해운대구,129.16185,35.16102443\n",
      "5962599,종로아구찜골목,서울특별시,종로구,126.9882386,37.5731233\n",
      "21085522,범박동카페거리,경기도,부천시,126.8118373,37.47424621\n",
      "21085634,약초골목,부산광역시,북구,129.0032742,35.20890491\n",
      "21085934,남대문갈치조림골목,서울특별시,중구,126.9769208,37.559695\n",
      "20942227,안양예술공원음식문화거리,경기도,안양시 만안구,126.9193675,37.41829207\n",
      "21085649,한류스타거리,서울특별시,강남구,127.0421985,37.52764411\n",
      "21085711,현충로,서울특별시,동작구,126.9735728,37.50546174\n",
      "21085544,생글생글희망골목길,경기도,시흥시,126.7803677,37.4362268\n",
      "21085518,안산중앙역로데오거리,경기도,안산시 단원구,126.83859,37.31741607\n",
      "17459246,동대문생선구이골목,서울특별시,종로구,127.0064871,37.5703531\n",
      "17209994,남대문칼국수골목,서울특별시,중구,126.9771046,37.55824176\n",
      "22112759,국립수목원진입도로,경기도,포천시,127.1713561,37.75029126\n",
      "21085697,연인의거리,서울특별시,서초구,127.0419546,37.47810008\n",
      "21085631,서면문화로,부산광역시,부산진구,129.0572687,35.15887261\n",
      "21085871,행주산성먹거리촌,경기도,고양시 덕양구,126.8256573,37.60025366\n",
      "21085932,청사포회거리,부산광역시,해운대구,129.1938527,35.16105118\n",
      "21086184,경춘선숲길,서울특별시,노원구,127.0786999,37.62069418\n",
      "21086185,성수동수제화거리,서울특별시,성동구,127.057185,37.54444328\n",
      "16701140,감지해수욕장,부산광역시,영도구,129.0763055,35.06082227\n",
      "20868022,경의선책거리,서울특별시,마포구,126.9247919,37.55952933\n",
      "21086101,남한산성보양거리,경기도,광주시,127.1832174,37.48083614\n",
      "21085693,장미길,서울특별시,중랑구,127.0727304,37.61354418\n",
      "21085520,오이도해양단지,경기도,시흥시,126.6899027,37.34426389\n",
      "21085682,사당가구거리,서울특별시,서초구,126.9826245,37.48998072\n",
      "21085621,천지인골목,부산광역시,중구,129.0332468,35.10379847\n",
      "8292776,청평호반,경기도,가평군,127.4460709,37.71084247\n",
      "10620405,대학천책방거리,서울특별시,종로구,127.0064234,37.57066073\n",
      "21086142,분당로데오거리,경기도,성남시 분당구,127.1213723,37.38353763\n",
      "21085540,위례서일로거리,경기도,성남시 수정구,127.138724,37.46728019\n",
      "21085677,서리풀푸드트럭존,서울특별시,서초구,127.0268752,37.49799479\n",
      "8292330,누리천문대,경기도,군포시,126.91535,37.33029417\n",
      "4930678,가리봉로데오거리,서울특별시,금천구,126.8874081,37.47775068\n",
      "8292243,40계단거리,부산광역시,중구,129.0358642,35.10395864\n",
      "21085900,주말농장한식마을,경기도,화성시,126.9842874,37.20079238\n",
      "21085674,수락산디자인거리,서울특별시,노원구,127.0588553,37.67454433\n",
      "21086194,중곡동가구거리,서울특별시,광진구,127.0809921,37.55648128\n",
      "21085548,화서문점집골목,경기도,수원시 팔달구,127.0120853,37.28510152\n",
      "21085539,모란시장기름골목,경기도,성남시 중원구,127.1274217,37.4304813\n",
      "17523182,이태원쇼핑거리,서울특별시,용산구,126.9914508,37.53431282\n",
      "16441531,죽전아울렛거리,경기도,용인시 수지구,127.108726,37.33327314\n",
      "17702239,문래창작촌,서울특별시,영등포구,126.8971793,37.51418563\n",
      "5966983,세계음식거리,서울특별시,용산구,126.9955069,37.53436384\n",
      "5966901,마포돼지갈비골목,서울특별시,마포구,126.9430393,37.54025623\n",
      "7231145,해운대해수욕장,부산광역시,해운대구,129.1594775,35.15840394\n",
      "16716384,가방골목,부산광역시,중구,129.0284653,35.10013787\n",
      "21086141,후곡학원가,경기도,고양시 일산서구,126.7669608,37.6779253\n",
      "21086099,신륵사매운탕촌,경기도,여주시,127.6594223,37.30154273\n",
      "6466431,상해거리,부산광역시,동구,129.037766,35.11376053\n",
      "4975181,초월면가구거리,경기도,광주시,127.2967783,37.37533749\n",
      "21085672,양재천길,서울특별시,강남구,127.0455021,37.48172797\n",
      "21086143,의정부시가구거리,경기도,의정부시,127.0501581,37.73575268\n",
      "21086090,운암뜰한식거리,경기도,오산시,127.0757266,37.14759412\n",
      "18095681,삼청동거리,서울특별시,종로구,126.9811939,37.58165767\n",
      "21085533,양평해장국거리,경기도,양평군,127.5280002,37.46561402\n",
      "17459116,안양명물순대곱창골목,경기도,안양시 만안구,126.9203645,37.39784672\n",
      "21086148,사가연문화거리,경기도,남양주시,127.2466304,37.65496146\n",
      "21085947,공덕소담길,서울특별시,마포구,126.9539262,37.54728307\n",
      "\n"
     ]
    }
   ],
   "source": [
    "print(test_set_locations)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# role - system instance_context\n",
    "type_role = \"You are the best travel planner who can make efficient travel plans. You make plans that are more efficient and readable than anyone else.\"\n",
    "\n",
    "# ? - system type_role\n",
    "instance_context = \"\"\"\n",
    "See this desciption:\\n{}.\\nPlease write based on the description.\n",
    "You are the best travel planner who can make efficient travel plans.\n",
    "<p>When responding:</p>\n",
    "<ul>\n",
    "    <li>Please provide information on the travel route, tourist destination (POI_NM), and province (CTPRVN_NM).</li>\n",
    "    <li>When planning the order of my travel destinations, avoid backtracking between cities. For example, It's better to visit places in Seoul, then move on to destinations in Gyeonggi-do, and finally visit attractions in Busan.</li>\n",
    "    <li>Please fill out three tourist attractions in Korean and English per day.</li>\n",
    "    <li>Always incorporate emojis when apt. 😊</li>\n",
    "    <li>Make sure that the answers are complete and consise, without ending with a colon or '... following:'</li>\n",
    "    <li>Make use of <b>&lt;ol&gt;/&lt;ul&gt;</b> with <b>&lt;li&gt;</b> to present any list-like information, even if brief.</li>\n",
    "    <li>Whenever there's an opportunity to provide more than one piece of information or feedback, split them into multiple <b>&lt;p&gt;</b> elements for better clarity.</li>\n",
    "    <li>Always format responses using valid HTML: e.g., <b>&lt;p&gt;</b> for paragraphs, <b>&lt;ul&gt;/&lt;ol&gt;</b> with <b>&lt;li&gt;</b> for lists, and <b>&lt;b&gt;</b> for emphasis or tourist attractions.</li>\n",
    "    <li>Maintain a nihilistic humorous tone. Keep it brief, but don't sacrifice clarity for brevity.</li>\n",
    "    <li>Please organize your travel route efficiently considering latitude (LC_LA) longitude (LC_LO) and order the same CTPRVN_NM value.</li>\n",
    "</ul>\n",
    "<p>Example response</p>\n",
    "Day 1:<br />\n",
    "<ul>\n",
    "    <li><b>서울숲은행나무길 (Seoul Forest Ginkgo Tree Road)</b> in Seoul</li>\n",
    "    <li><b>청계천 (Cheonggyecheon Stream)</b> in Seoul</li>\n",
    "    <li><b>명동거리 (Myeongdong Street)</b> in Seoul</li>\n",
    "</ul>\n",
    "\n",
    "Day 2:<br />\n",
    "<ul>\n",
    "    <li><b>남산공원남산케이블카 (Namsan Park Namsan Cable Car)</b> in Seoul</li>\n",
    "    <li><b>북창동먹자골목 (Bukchang-dong Food Alley)</b> in Seoul</li>\n",
    "    <li><b>한국인삼주마을 (Korean Ginseng Village)</b> in Gyeonggi Province</li>\n",
    "</ul>\n",
    "\n",
    "Day 3:<br />\n",
    "<ul>\n",
    "    <li><b>안성다문화마을특구 (Anseong Damunhwa Village Special District)</b> in Gyeonggi Province</li>\n",
    "    <li><b>의정부부대찌개거리 (Uijeongbu Army Stew Alley)</b> in Gyeonggi Province</li>\n",
    "    <li><b>용문산토속음식마을 (Yongmun Mountain Traditional Food Village)</b> in Gyeonggi Province</li>\n",
    "</ul>\n",
    "Enjoy your trip and make wonderful memories in Korea! 😊🇰🇷\n",
    "\n",
    "Don't forget always using valid HTML tags espacially, avoid backtracking and make efficient movements<br />\n",
    "\"\"\".format(test_set_locations)\n",
    "\n",
    "# user\n",
    "# instance_starter = \"Make a plan for a trip in Korea.\"\n",
    "instance_starter = \"As a Korean trip planner, write one very short message to use at the beginning of the conversation in English\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[\"Welcome to South Korea! Let's plan an unforgettable trip together. 🇰🇷✈️\"]\n",
      "successful: 1, failed: 0\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# Amount of instances to be created\n",
    "number_of_instances = 1\n",
    "\n",
    "# Change the following to a list of hardcoded instance IDs if you want to use existing users.\n",
    "user_ids = [str(uuid.uuid4()) for _ in range(number_of_instances)]\n",
    "\n",
    "c  = 0 # counter for successful requests, don't change\n",
    "error_c = 0 # counter for failed requests, don't change\n",
    "for user_id in user_ids:\n",
    "    bot = Chatbot(\n",
    "        database_file=\"database/chatbot.db\", \n",
    "        type_id=\"zhfldk82\", # Korean Trip Planner\n",
    "        user_id=user_id,\n",
    "        type_name=\"Korean Trip Planner\",\n",
    "        type_role=type_role,\n",
    "        instance_context=instance_context,\n",
    "        instance_starter=instance_starter\n",
    "    )\n",
    "    try:\n",
    "        # each bot should have a first message to the user\n",
    "        print(bot.start())\n",
    "    except:\n",
    "        error_c += 1\n",
    "        continue\n",
    "    c+=1\n",
    "    time.sleep(15) #openai seems to produce more errors if we send the requests too fast.\n",
    "    \n",
    "print(\"successful: {}, failed: {}\".format(c, error_c))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Obtain URLs of all instances of a type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://sonahskku.pythonanywhere.com/zhfldk82/c5c57b73-2c5f-42e0-b325-c66ab72091e3/chat\n"
     ]
    }
   ],
   "source": [
    "pythonanywhere_username = \"sonahskku\"\n",
    "type_id = \"zhfldk82\" # Korean Trip Planner\n",
    "bot = Chatbot(\n",
    "    database_file=\"database/chatbot.db\", \n",
    "    type_id=type_id,\n",
    "    user_id=user_ids[0]\n",
    ")\n",
    "\n",
    "for user_id in bot.type_instances():\n",
    "    print(\"https://{}.pythonanywhere.com/{}/{}/chat\".format(pythonanywhere_username, type_id, user_id))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### local backend"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['c5c57b73-2c5f-42e0-b325-c66ab72091e3']\n"
     ]
    }
   ],
   "source": [
    "import sqlite3\n",
    "\n",
    "# Connect to the SQLite database\n",
    "conn = sqlite3.connect('./database/chatbot.db')\n",
    "cursor = conn.cursor()\n",
    "\n",
    "# Execute the query to select all values from the user column\n",
    "cursor.execute('SELECT user FROM chatbot_instances')\n",
    "\n",
    "# Fetch all results\n",
    "users_ids = cursor.fetchall()\n",
    "\n",
    "# Close the connection\n",
    "conn.close()\n",
    "\n",
    "# Check if users_ids is not empty before further processing\n",
    "if users_ids:\n",
    "    # Extract user IDs from the list of tuples\n",
    "    users_ids = [user_id[0] for user_id in users_ids]\n",
    "    print(users_ids)\n",
    "else:\n",
    "    print(\"No user IDs found.\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://127.0.0.1:5000/zhfldk82/c5c57b73-2c5f-42e0-b325-c66ab72091e3/chat\n"
     ]
    }
   ],
   "source": [
    "DEFAULT_URL = \"127.0.0.1:5000\"\n",
    "type_id = \"zhfldk82\" # Korean Trip Planner\n",
    "for user_id in users_ids:\n",
    "    print(\"http://{}/{}/{}/chat\".format(DEFAULT_URL, type_id, user_id))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.5"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}