def _initialize(self):
"""
Sub PJT 1에서 만든 Dataframe을 이용하여 DB를 초기화합니다.
"""
print("[*] Loading data...")
dataframes = self._load_dataframes()
print("[*] Initializing stores...")
models.Store.objects.all().delete() # 일단 지금 있는 모든 Store 데이터 지우기
stores = dataframes["stores"]
stores_bulk = [
models.Store(
id=store.id,
store_name=store.store_name,
branch=store.branch,
area=store.area,
tel=store.tel,
address=store.address,
latitude=store.latitude,
longitude=store.longitude,
category=store.category,
) for store in stores.itertuples()
]
models.Store.objects.bulk_create(stores_bulk)
print("[+] Done")
def _initialize(self):
"""
Sub PJT 1에서 만든 Dataframe을 이용하여 DB를 초기화합니다.
"""
print("[*] Loading data...")
dataframes = self._load_dataframes()
print("[*] Initializing stores...")
models.Store.objects.all().delete()
# stores = dataframes["stores"]
stores_bulk = [
models.Store(id=store.id,
name=store.name,
address=store.address,
tel=store.tel,
category=store.category,
main_mn=store.main_mn,
price=store.price,
menu=store.menu,
opng_tm=store.opng_tm,
rating=store.rating,
rvw_cnt=store.rvw_cnt,
tags=store.tags,
img=store.img) for store in dataframes.itertuples()
]
models.Store.objects.bulk_create(stores_bulk)
print("[+] Done")
def _initialize(self):
"""
Sub PJT 1에서 만든 Dataframe을 이용하여 DB를 초기화합니다.
"""
print("[*] Loading data...")
dataframes = self._load_dataframes()
print("[*] Initializing stores...")
models.Store.objects.all().delete()
# models.User.objects.all().delete()
models.Menu.objects.all().delete()
models.Bhour.objects.all().delete()
models.Review.objects.all().delete()
stores = dataframes["stores"]
stores_bulk = [
models.Store(
store_id=store.id,
store_name=store.store_name,
branch=store.branch,
area=store.area,
tel=store.tel,
address=store.address,
latitude=store.latitude,
longitude=store.longitude,
category=store.category,
) for store in stores.itertuples()
]
models.Store.objects.bulk_create(stores_bulk)
# users = dataframes["users"]
# users_bulk = [
# models.User(
# user_id=user.id,
# gender=user.gender,
# age=user.age
# )
# for user in users.itertuples()
# ]
# models.User.objects.bulk_create(users_bulk)
menus = dataframes["menus"]
menus_bulk = [
models.Menu(store_id=menu.store,
menu=menu.menu_name,
price=menu.price) for menu in menus.itertuples()
]
models.Menu.objects.bulk_create(menus_bulk)
reviews = dataframes["reviews"]
reviews_bulk = [
models.Review(
review_id=review.id,
store_id=review.store,
# user_id=review.user,
total_score=review.score,
content=review.content,
reg_time=review.reg_time) for review in reviews.itertuples()
]
models.Review.objects.bulk_create(reviews_bulk)
print("[+] Done")
def _initialize(self):
"""
Sub PJT 1에서 만든 Dataframe을 이용하여 DB를 초기화합니다.
"""
print("[*] Loading data...")
df = self._load_dataframes()
print("[*] Initializing stores...")
models.Store.objects.all().delete()
stores = df["stores"]
stores_bulk = [
models.Store(id=store.id,
store_name=store.store_name,
area=store.area,
tel=store.tel,
address=store.address,
latitude=store.latitude,
longitude=store.longitude,
category=store.category,
classification=store.classification,
price_mean=store.price_mean)
for store in stores.itertuples()
]
models.Store.objects.bulk_create(stores_bulk)
print("[+] Stores Complete")
print("[*] Initializing users...")
models.User.objects.all().delete()
users = df['users']
users_bulk = [
models.User(id=user.id,
gender=user.gender,
age=user.age,
grade=user.grade,
vendor=user.vendor,
refresh_token=user.refresh_token)
for user in users.itertuples()
]
models.User.objects.bulk_create(users_bulk)
print("[+] Users Complete")
print("[*] Initializing reviews...")
models.Review.objects.all().delete()
reviews = df['reviews']
reviews_bulk = [
models.Review(id=review.id,
store=models.Store.objects.get(id=review.store),
user=models.User.objects.get(id=review.user),
score=review.score,
content=review.content,
reg_time=review.reg_time,
taste=review.taste,
service=review.service,
price_satisfaction=review.price_satisfaction,
interior=review.interior)
for review in reviews.itertuples()
]
models.Review.objects.bulk_create(reviews_bulk)
print("[+] Reviews Complete")
print("[*] Initializing Menu...")
models.Menu.objects.all().delete()
menu = df['menu']
menu_bulk = [
models.Menu(id=m.id,
store=models.Store.objects.get(id=m.store),
menu_name=m.menu_name,
price=m.price) for m in menu.itertuples()
]
models.Menu.objects.bulk_create(menu_bulk)
print("[+] Menu Complete")
print("[*] Initializing BHour...")
models.BHour.objects.all().delete()
b_hours = df['bhours']
bhour_bulk = [
models.BHour(id=b_hour.id,
store=models.Store.objects.get(id=b_hour.store),
type=b_hour.type,
week_type=b_hour.week_type,
mon=b_hour.mon,
tue=b_hour.tue,
wed=b_hour.wed,
thu=b_hour.thu,
fri=b_hour.fri,
sat=b_hour.sat,
sun=b_hour.sun,
start_time=b_hour.start_time,
end_time=b_hour.end_time,
etc=b_hour.etc) for b_hour in b_hours.itertuples()
]
models.BHour.objects.bulk_create(bhour_bulk)
print("[+] BHour Complete")
print("[+] Done")
def _initialize(self):
"""
Sub PJT 1에서 만든 Dataframe을 이용하여 DB를 초기화합니다.
"""
print("[*] Loading data...")
dataframes = self._load_dataframes()
print("[*] Initializing stores...")
models.Store.objects.all().delete()
stores = dataframes["stores"]
stores_bulk = [
models.Store(
id=store.id,
store_name=store.store_name,
branch=store.branch,
area=store.area,
tel=store.tel,
address=store.address,
latitude=store.latitude,
longitude=store.longitude,
category=store.category,
menu=store.menu,
bhour=store.bhour,
) for store in stores.itertuples()
]
models.Store.objects.bulk_create(stores_bulk)
print("[*] Initializing reviews...")
models.Review.objects.all().delete()
reviews = dataframes["reviews"]
reviews_bulk = [
models.Review(
storeid=review.store,
userid=review.user,
score=review.score,
content=review.content,
regtime=review.reg_time,
gender=review.gender,
bornyear=review.born_year,
) for review in reviews.itertuples()
]
models.Review.objects.bulk_create(reviews_bulk)
print("[*] Initializing tourspot...")
models.TourSpot.objects.all().delete()
print(dataframes)
tourspots = dataframes["tourspot"]
tourspots_bulk = [
models.TourSpot(
addr1=tourspot.addr1,
addr2=tourspot.addr2,
areacode=tourspot.areacode,
cat1=tourspot.cat1,
cat2=tourspot.cat2,
cat3=tourspot.cat3,
content_id=tourspot.content_id,
content_type_id=tourspot.content_type_id,
first_image=tourspot.first_image,
first_image2=tourspot.first_image2,
mapx=tourspot.mapx,
mapy=tourspot.mapy,
sigungucode=tourspot.sigungucode,
tel=tourspot.tel,
title=tourspot.title,
readcount=tourspot.readcount,
) for tourspot in tourspots.itertuples()
]
models.TourSpot.objects.bulk_create(tourspots_bulk)
print("[+] Done")
print("[*] Initializing Course...")
models.Course.objects.all().delete()
print(dataframes)
course = dataframes["course"]
course_bulk = [
models.Course(
addr1=course.addr1,
addr2=course.addr2,
areacode=course.areacode,
cat1=course.cat1,
cat2=course.cat2,
cat3=course.cat3,
content_id=course.content_id,
content_type_id=course.content_type_id,
first_image=course.first_image,
first_image2=course.first_image2,
mapx=course.mapx,
mapy=course.mapy,
sigungucode=course.sigungucode,
tel=course.tel,
title=course.title,
readcount=course.readcount,
) for course in course.itertuples()
]
models.Course.objects.bulk_create(course_bulk)
print("[+] Done")
print("[*] Initializing Recommand...")
models.Recommand.objects.all().delete()
print(dataframes)
recommandspots = dataframes["recommandspot"]
recommandspot_bulk = [
models.Recommand(
contentid=recommandspots.contentid,
contenttypeid=recommandspots.contenttypeid,
subcontentid=recommandspots.subcontentid,
subdetailalt=recommandspots.subdetailalt,
subdetailimg=recommandspots.subdetailimg,
subdetailoverview=recommandspots.subdetailoverview,
subname=recommandspots.subname,
subnum=recommandspots.subnum,
) for recommandspots in recommandspots.itertuples()
]
models.Recommand.objects.bulk_create(recommandspot_bulk)
print("[+] Done")
print("[*] Initializing Overview...")
models.Overview.objects.all().delete()
print(dataframes)
overviews = dataframes["overviews"]
overviews_bulk = [
models.Overview(
contentid=overviews.contentid,
contenttypeid=overviews.contenttypeid,
homepage=overviews.homepage,
overview=overviews.overview,
tel=overviews.tel,
title=overviews.title,
) for overviews in overviews.itertuples()
]
models.Overview.objects.bulk_create(overviews_bulk)
print("[+] Done")