def dzdpbusinessreviewsToSql():
data,businessid = dzdp_GetRecentReviews.get_recent_reviews()
reviewsnumber = data["count"]
for i in range(0,reviewsnumber):
reviewsid = data["reviews"][i]["review_id"]
business_id = businessid
created_time = data["reviews"][i]["created_time"]
text_excerpt = data["reviews"][i]["text_excerpt"]
review_rating = data["reviews"][i]["review_rating"]
product_rating = data["reviews"][i]["product_rating"]
decoration_rating = data["reviews"][i]["decoration_rating"]
service_rating = data["reviews"][i]["service_rating"]
writeDzdpData.dzdpwriteToSql(reviewsid,business_id,created_time,text_excerpt
,review_rating,product_rating,decoration_rating,service_rating)
def dzdptosql():
data = dzdp_FindBusiness.find_business()
dznumber = data["count"]
for i in range(0,dznumber):
business_id = data["businesses"][i]["business_id"]
business_name = data["businesses"][i]["name"]
address = data["businesses"][i]["address"]
telephone = data["businesses"][i]["telephone"].encode('utf8')
categories = data["businesses"][i]["categories"][0]
lat = data["businesses"][i]["latitude"]
lon = data["businesses"][i]["longitude"]
avg_rating = data["businesses"][i]["avg_rating"]
product_grade = data["businesses"][i]["product_grade"]
decoration_grade = data["businesses"][i]["decoration_grade"]
service_grade = data["businesses"][i]["service_grade"]
product_score = data["businesses"][i]["product_score"]
decoration_score = data["businesses"][i]["decoration_score"]
service_score = data["businesses"][i]["service_score"]
writeDzdpData.dzdpwriteToSql(business_id,business_name,address,telephone,categories,lat,lon,avg_rating,product_grade,decoration_grade,service_grade,product_score,decoration_score,service_score)
